Re: [ADMIN] [PERFORM] Postgres log(pg_logs) have lots of message

2013-04-11 Thread Jeff Janes
On Wednesday, April 10, 2013, Nik Tek wrote: > Hi Bambi, > > Thank you the prompt reply. > > This table is very volatile, lot of inserts/updates happen on this > tables(atleast 20~30 inserts/min). > That number of inserts per minute is not all that many. I suspect that you have sessions which ar

Re: [HACKERS] [ADMIN] after 9.2.4 patch vacuumdb -avz not analyzing all tables

2013-04-11 Thread Jeff Janes
On Thursday, April 11, 2013, Tom Lane wrote: > > [ pokes around ... ] You certain 9.2.3 didn't do this too? This > appears to be an intentional behavior of the 9.2.3 patch that made it > cancel truncation when there were conflicting lock requests: > > /* > * Report results to the stats