Re: [PERFORM] database size growing continously

2009-11-02 Thread Peter Meszaros
that 'vacuum verbose ...' will issue warnings if max_fsm_pages is too small. I've never seen such messag, this command is either run and finish or goes to an endless loop as it was written in my initial e-mail. On Thu, Oct 29, 2009 at 10:59:48AM -0600, Scott Marlowe wrote: > On Thu, O

[PERFORM] database size growing continously

2009-10-29 Thread Peter Meszaros
Hi All, I use postgresql 8.3.7 as a huge queue. There is a very simple table with six columns and two indices, and about 6 million records are written into it in every day continously commited every 10 seconds from 8 clients. The table stores approximately 120 million records, because a cron job d