2009/9/29 tomrevam <tomer@xxxxxxxxx>: > > > > Brian Modra-2 wrote: >> >> When did you last do an analyse and re-create indexes? >> Is the table UPDATEd to or DELETEd from, or just INSERTed ? >> Is your DB auto vacuuming? >> > > My DB is auto-vacuuming all the time. The specific table I'm talking about > gets vacuumed at least every 2 hours (usually a little more frequently than > that). > Deletes are happening on the table at about the same rate as inserts (there > are also some updates). The index quite likely is in a poor state. You could try this: analyse .... create index ... (same parameters as existing index) delete the old index. rename the new index to the same name as the old one repeat this for all indexes. > -- > View this message in context: http://www.nabble.com/query-is-taking-longer-time-after-a-while-tp25661219p25661758.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa http://www.zwartberg.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general