This tag is specifically for PostgreSQL version 8.3
1
vote
0answers
31 views
postgresql 8.3 possible checkpoint and memory misconfiguration
I am using postgresql 8.3 in a read/write heavy application where data are being written to the database from a background process while they are also being read/written from a web application.
At ...
3
votes
3answers
181 views
PostgreSQL 8.3: Slow GROUP BY on large table
I have a table with about 10 million records. I want to do a simple group by, but it's using a sequential scan and is slow...
select run_id, count(*) from result group by run_id;
I have an index ...
5
votes
1answer
205 views
Unexpected Seq Scan when doing query against boolean with value NULL
I have a database column called auto_review where column type is boolean.
There is an index for that field, created using the ActiveRecord ORM.
CREATE INDEX index_table_on_auto_renew ON table USING ...
3
votes
1answer
406 views
How can I create a dblink from Postgresql 8.3 to SQL Server (2000 and 2008)?
I have a Postgresql database that need to read data from two SQL Servers (one SQL Server 2000 and one SQL Server 2008).
I want to setup two dblinks to the SQL Servers.
After googling, foruming, ...
3
votes
1answer
116 views
A 'deeper' PostgreSQL autovacuum
We have a PostgreSQL 8.3.7 database suffering severe bloat after an algorithmic change. Unfortunately upgrading isn't an option at this time.
For a particular group of partitioned count roll-up ...
2
votes
1answer
383 views
Is it possible to configure PostgreSQL to automatically close idle connections?
Clients connect to our PostgreSQL 8.3 database but leave the connections opened. Is it possible to configure PostgreSQL to close those connections after a certain amount of inactivity?
2
votes
4answers
1k views
PostgreSQL import CSV File causes Syntax Error
I'm attempting to import a CSV file into a database via the "COPY" command; however, I get the (what seems common) error that I need to be a superuser and that I should use "\copy" instead. However, ...
2
votes
2answers
210 views
Bug in PL/pgSQL function creation
I don't know if this question better suits here or in SO ...
This is a script that I'd like to launch (the code of the function was copied from a question on SO):
\c mydb
create or replace function ...
