Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Server Freezing
- From: Robert Haas <robertmhaas(at)gmail(dot)com>
- To: Waldomiro <waldomiro(at)shx(dot)com(dot)br>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Server Freezing
- Date: Mon, 30 Nov 2009 17:08:15 -0500
- Message-id: <603c8f070911301408x24697bbcif84bb69171e56d7f@mail.gmail.com> <text/plain>
On Mon, Nov 30, 2009 at 8:02 PM, Waldomiro <waldomiro(at)shx(dot)com(dot)br> wrote: > Its not a vaccum needed, becouse I do a TRUNCATE every night. But you're updating each row 20 times a day - you could very well need a vacuum. > Is It possible the checkpoint is doing that? Or the archiving? How can I > see? It seems likely to be caused by checkpoint I/O or vacuuming activity, but I'm not sure how to figure out which. ...Robert
- References:
- Server Freezing
- From: Waldomiro
- Server Freezing
- Prev by Date: Re: Server Freezing
- Next by Date: Re: Server Freezing
- Previous by thread: Re: Server Freezing
- Next by thread: Re: Server Freezing
- Indexes: