Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 'eats' all mi data partition - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Postgresql 'eats' all mi data partition
Date
Msg-id 25434.1064601068@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgresql 'eats' all mi data partition  (Tomas Szepe <szepe@pinerecords.com>)
Responses Re: Postgresql 'eats' all mi data partition  (Tomas Szepe <szepe@pinerecords.com>)
List pgsql-bugs
Tree view 
Tomas Szepe <szepe@pinerecords.com> writes:
> We have a production database that happens to receive several
> thousand row updates per minute.  We VACUUM ANALYZE every four
> hours with max_fsm_pages set to 2100000, and it's no use.

Have you spent any time determining exactly where the problem is?
I'm suspicious that it's an index-bloat issue.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Postgresql 'eats' all mi data partition
Next
From: Tomas Szepe
Date:
Subject: Re: Postgresql 'eats' all mi data partition