[GENERAL] Auto vacuum configuration in postgres.

2010-05-27 Thread venu madhav
Hi All, In my application we are using postgres which runs on an embedded box. I have configured autovacuum to run once for every one hour. It has 5 different databases in it. When I saw the log messages, I found that it is running autovacuum on one database every hour. As a result, on my da

[GENERAL] Re: Performance issues when the number of records are around 10 Million

2010-05-11 Thread venu madhav
On May 11, 12:03 pm, andreas.kretsch...@schollglas.com ("A. Kretschmer") wrote: > In response to venu madhav : > > > > > Hi all, > >        In my database application, I've a table whose records can > > reach 10M and insertions can happen at a faster r

[GENERAL] Performance issues when the number of records are around 10 Million

2010-05-10 Thread venu madhav
Hi all, In my database application, I've a table whose records can reach 10M and insertions can happen at a faster rate like 100 insertions per second in the peak times. I configured postgres to do auto vacuum on hourly basis. I have frontend GUI application in CGI which displays the data fr