Re: [PERFORM] Process in state BIND, authentication, PARSE

2013-07-09 Thread Merlin Moncure
On Mon, Jul 8, 2013 at 5:35 PM, Michael Paquier michael.paqu...@gmail.com wrote: On Tue, Jul 9, 2013 at 2:01 AM, Jeison Bedoya jeis...@audifarma.com.co wrote: max_connections = 900 work_mem = 1024MB maintenance_work_mem = 1024MB Aren't work_mem and maintenance_work_mem too high? You need to

Re: [PERFORM] Performance autovaccum

2013-07-09 Thread Josh Berkus
On 07/08/2013 09:14 AM, Jeison Bedoya wrote: Hi, i have a postgresql 9.2.2, but i don´t use autovaccum but i want to begin to use it. some recommendation about the optimal configuration? or some link to explain it. Initial configuration: autovacuum = on There, you're done. You only do

Re: [PERFORM] Performance autovaccum

2013-07-09 Thread Joshua D. Drake
On 07/09/2013 03:14 PM, Josh Berkus wrote: On 07/08/2013 09:14 AM, Jeison Bedoya wrote: Hi, i have a postgresql 9.2.2, but i don´t use autovaccum but i want to begin to use it. some recommendation about the optimal configuration? or some link to explain it. Initial configuration: