Hi all,
I am using PostgresSQL 7.4 and having some serious performance issues.
Trawling through the archives and previous posts the only visible advice
I could see was either by running vacuum or setting the fsynch flag to
false.
I am using tables that only contain approx 2GB of data. However
pe
I'm currently handling a migration from an Informix system to both mySQL
and Postgres (same data in each).
Having uploaded the DB's into both systems, from Informix, I am having
some problems carrying out a query. The query, which I believe, is in
standard SQL is as follows:
SELECT field1, SUM(fi
Hi all. Thanks for your help so far. However after configuring my system
I am still getting major lag times with a couple of queries. The first,
which suffers from the '538/539'(see old email included below) bug, is
caused by running the following statement:
SELECT t1.col1, SUM(test) test_col, SU
