[PERFORM] maintenance_work_mem and autovacuum_max_workers

Hi guys. I'm tuning my postgres server and I faced these 2 parameters. Today they have default values. Is default enough? How should I tune these values?

Re: [PERFORM] slow bitmap heap scans on pg 9.2

On 13-04-14 08:06 PM, Steve Singer wrote: On 13-04-13 04:54 PM, Jeff Janes wrote: If you are trying to make your own private copy of 9.2, then removing the fudge factor altogether is probably the way to go. But if you want to help improve future versions, you probably need to test with the m