From: | David Mitchell <david(dot)mitchell(at)telogis(dot)com> |
---|---|
To: | weigelt(at)metux(dot)de |
Cc: | postgresql performance list <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: plain inserts and deletes very slow |
Date: | 2005-07-04 01:12:55 |
Message-ID: | 42C88D17.4080004@telogis.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Perhaps if you are doing a lot of inserts and deletes, vacuuming every 6
minutes would be closer to your mark. Try vacuuming every 15 minutes for
a start and see how that affects things (you will have to do a vacuum
full to get the tables back into shape after them slowing down as they
have).
David
Enrico Weigelt wrote:
> * David Mitchell <david(dot)mitchell(at)telogis(dot)com> wrote:
>
>>Did you vacuum full?
>>
>>When you do lots of inserts and deletes, dead tuples get left behind.
>>When you vacuum, postgres will reuse those dead tuples, but if you don't
>>vacuum for a long time these tuples will build up lots. Even when you
>>vacuum in this case, the dead tuples are still there, although they are
>>marked for reuse. Vacuuming full actually removes the dead tuples.
>
>
> I'm doing a VACUUM ANALYZE every 6 hours.
>
> vacuum'ing manually doesnt seem to have any effect on that.
>
>
> cu
--
David Mitchell
Software Engineer
Telogis
NOTICE:
This message (including any attachments) contains CONFIDENTIAL
INFORMATION intended for a specific individual and purpose, and
is protected by law. If you are not the intended recipient,
you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message, or the
taking of any action based on it, is strictly prohibited.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-07-04 02:57:09 | Re: plain inserts and deletes very slow |
Previous Message | David Mitchell | 2005-07-04 00:50:36 | Re: plain inserts and deletes very slow |