sloooow query
Marie G. Tuite <marie.tuite@edisonaffiliates.com>
From: "Marie G. Tuite" <marie.tuite@edisonaffiliates.com>
To: "Pgsql-General@Postgresql. Org" <pgsql-general@postgresql.org>, <pgsql-performance@postgresql.org>
Date: 2002-10-07T19:22:09Z
Lists: pgsql-performance, pgsql-general
Hello all, I am experiencing slow db performance. I have vacuumed, analyzed, reindexed using the force option and performance remains the same - dog-slow :( If I drop and recreate the database, performance is normal, so this suggests a problem with the indexes? I also took a look at the postgresql.conf and all appears fine. There are many instances of the same database running on different servers and not all servers are experiencing the problem. Thanks in advance for any suggestions. Marie