On Wed, 2004-10-13 at 02:21, Robin Ericsson wrote:
Hi,
I sent this to general earlier but I was redirected to performance.
The query have been running ok for quite some time, but after I did a
vacuum on the database, it's very very slow.
Did you do a VACUUM FULL ANALYZE on the database
Robin Ericsson [EMAIL PROTECTED] writes:
I sent this to general earlier but I was redirected to performance.
Actually, I think I suggested that you consult the pgsql-performance
archives, where this type of problem has been hashed out before.
See for instance this thread:
On Wed, 2004-10-13 at 11:03 -0400, Tom Lane wrote:
Robin Ericsson [EMAIL PROTECTED] writes:
I sent this to general earlier but I was redirected to performance.
Actually, I think I suggested that you consult the pgsql-performance
archives, where this type of problem has been hashed out