Re: [HACKERS] Integrated autovacuum

2005-07-27 Thread Josh Berkus
Alvaro, > Also, somebody (Rod Taylor I think) proposed changed the variable names > to > > vacuum_auto_vacuum_scale_factor > vacuum_auto_analyze_scale_factor I see what Rod's getting at, but I find that version of the option less readable ... -- --Josh Josh Berkus Aglio Database Solutions San

Re: [HACKERS] Integrated autovacuum

2005-07-27 Thread Alvaro Herrera
On Wed, Jul 27, 2005 at 06:35:31PM -0300, Martín Marqués wrote: > El Mié 27 Jul 2005 18:23, Alvaro Herrera escribió: > > On Wed, Jul 27, 2005 at 06:05:26PM -0300, Martín Marqués wrote: > > > > > > Will there be a way to ballance the amount of stats the autovacuum gets? > > > Something like the an

Re: [HACKERS] Integrated autovacuum

2005-07-27 Thread Martín Marqués
El Mié 27 Jul 2005 18:23, Alvaro Herrera escribió: > On Wed, Jul 27, 2005 at 06:05:26PM -0300, Martín Marqués wrote: > > > > Will there be a way to ballance the amount of stats the autovacuum gets? > > Something like the analyze parameters that the contrib version has, but > > integrated in post

Re: [HACKERS] Integrated autovacuum

2005-07-27 Thread Alvaro Herrera
On Wed, Jul 27, 2005 at 02:07:28PM -0700, Joshua D. Drake wrote: > Great Thanks... Could I get a better explanation of the following: > > #autovacuum_vacuum_scale_factor = 0.4 # fraction of rel size before vacuum > #autovacuum_analyze_scale_factor = 0.2 # fraction of rel size before > analyze

Re: [HACKERS] Integrated autovacuum

2005-07-27 Thread Alvaro Herrera
On Wed, Jul 27, 2005 at 06:05:26PM -0300, Martín Marqués wrote: > El Mié 27 Jul 2005 17:24, Alvaro Herrera escribió: > > On Wed, Jul 27, 2005 at 12:53:40PM -0700, Joshua D. Drake wrote: > > > > > Just for clarification, will the new integrated autovacuum require that > > > statistics are on? > >

Re: [HACKERS] Integrated autovacuum

2005-07-27 Thread Martín Marqués
El Mié 27 Jul 2005 17:24, Alvaro Herrera escribió: > On Wed, Jul 27, 2005 at 12:53:40PM -0700, Joshua D. Drake wrote: > > > Just for clarification, will the new integrated autovacuum require that > > statistics are on? > > Yes. Row-level stats too. Will there be a way to ballance the amount of

Re: [HACKERS] Integrated autovacuum

2005-07-27 Thread Joshua D. Drake
Alvaro Herrera wrote: On Wed, Jul 27, 2005 at 12:53:40PM -0700, Joshua D. Drake wrote: Just for clarification, will the new integrated autovacuum require that statistics are on? Yes. Row-level stats too. Great Thanks... Could I get a better explanation of the following: #autovacuum_vac

Re: [HACKERS] Integrated autovacuum

2005-07-27 Thread Alvaro Herrera
On Wed, Jul 27, 2005 at 12:53:40PM -0700, Joshua D. Drake wrote: > Just for clarification, will the new integrated autovacuum require that > statistics are on? Yes. Row-level stats too. -- Alvaro Herrera () "I'm always right, but sometimes I'm more right than other times."

[HACKERS] Integrated autovacuum

2005-07-27 Thread Joshua D. Drake
Hello, Just for clarification, will the new integrated autovacuum require that statistics are on? Sincerely, Joshua D. Drake -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Share