Question : We are talking about the PostgreSQL 8.3 RDBMS here. So, no pg_terminate_backend() is possible with this version. Sometimes […]
Tag: postgresql-8.3
PostgreSQL 8.3 – issues with autovacuum
Question : I posted this on StackOverflow and it was suggested this query was better suited here. I’m trying to […]
A ‘deeper’ PostgreSQL autovacuum
Question : We have a PostgreSQL 8.3.7 database suffering severe bloat after an algorithmic change. Unfortunately upgrading isn’t an option […]
Unexpected Seq Scan when doing query against boolean with value NULL
Question : I have a database column called auto_review where column type is boolean. There is an index for that […]
Unexpected Seq Scan when doing query against boolean with value NULL
Question : I have a database column called auto_review where column type is boolean. There is an index for that […]
Trying to start a newly created cluster in PostgreSQL on Windows
Question : I just created a new cluster using PostgreSQL 8.3 and looks like everything worked. What I am having […]
Is it possible to configure PostgreSQL to automatically close idle connections?
Question : Clients connect to our PostgreSQL 8.3 database but leave the connections opened. Is it possible to configure PostgreSQL […]
Passing ROWTYPE parameter to EXECUTE
Question : I am developing a function in Postgres which aims to recover for each record of a query the […]
PostgreSQL: 8.3/8.4 interface chages?
Question : I would like to upgrade a PostgreSQL 8.3 server to PostrgreSQL 8.4. There are many software components that […]