From: | "Claudio Lapidus" <clapidus(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Vacuum (table performance) |
Date: | 2003-06-25 22:38:51 |
Message-ID: | BAY7-F53HXsprw0m25q00018907@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
Here we have a couple of tables with very high rotation: on one of them,
rows get inserted all the time from 2 up to 15 per second, depending on
application level of activity. Each row has a mean life of about 3 hours,
when it gets copied to another table and deleted, along with a bunch of
similar ones. This is done by a pgpsql function which is invoked on a
regular basis. Following each execution of this function we run a vacuum on
the table. However, we are seeing increasing execution times, not for the
function but for the vacuum itself. Currently we are getting about 9 minutes
for the vacuum, with a table of 45K records. This creeped up from a few
seconds past week, when the table was reinitialized. However table size is
approximately constant all the time.
Are there other mechanisms to do online maintenance of a table? I must
stress the word 'online' since this is a real time application which must be
up all the time.
thanks in advance
cl.
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-06-25 22:43:07 | Re: Vacuum (table performance) |
Previous Message | Karsten Hilbert | 2003-06-25 21:51:26 | Re: INSERT WHERE NOT EXISTS |