Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Lewis Kapell
admin@postgresql.org Subject: RE: [ADMIN] Clarification required: autovacuum and VACUUM command mode "Narasimha Murthy-VRFX87" wrote: Another query: I do not want to run Analyze. However, auto-vacuum runs both both VACUUM and ANALYZE. I do not see any option to disable running

Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Narasimha Murthy-VRFX87
] On Behalf Of Lewis Kapell Sent: Friday, May 14, 2010 8:34 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode You misunderstand the purpose of ANALYZE. Postgres needs the results in order to perform queries efficiently. Whether you have t

Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Kevin Grittner
"Narasimha Murthy-VRFX87" wrote: > I am using a 3rd party application, which in turn using PostgreSQL > DB. I can not change/tune the SQL queries, performed by the 3rd > party application. Hence, the statistics generated by ANALYZE, is of no > use to me. That is the reason, I have planned not to

Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Lewis Kapell
: autovacuum and VACUUM command mode "Narasimha Murthy-VRFX87" wrote: Another query: I do not want to run Analyze. However, auto-vacuum runs both both VACUUM and ANALYZE. I do not see any option to disable running ANALYZE during auto-vacuum. Is there any way to achive this? Usually

Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Narasimha Murthy-VRFX87
Subject: RE: [ADMIN] Clarification required: autovacuum and VACUUM command mode "Narasimha Murthy-VRFX87" wrote: > Another query: I do not want to run Analyze. However, auto-vacuum runs > both both VACUUM and ANALYZE. I do not see any option to disable > running ANALYZE dur

Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Kevin Grittner
"Narasimha Murthy-VRFX87" wrote: > Another query: I do not want to run Analyze. However, auto-vacuum > runs both both VACUUM and ANALYZE. I do not see any option to > disable running ANALYZE during auto-vacuum. Is there any way to > achive this? Usually it's best to run ANALYZE more often than

Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Scott Marlowe
On Fri, May 14, 2010 at 8:20 AM, Narasimha Murthy-VRFX87 wrote: > Hi Kevin, > > Thanks for the clarification. > > I have planned to schedule Lazy Vacuum (, not FULL Vacuum) using auto-vacuum > daemon. > > Another query: I do not want to run Analyze. However, auto-vacuum runs both > both VACUUM a

Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Narasimha Murthy-VRFX87
: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode "Narasimha Murthy-VRFX87" wrote: > Guillaume Lelarge wrote: >> Le 14/05/2010 14:52, Narasimha Murthy-VRFX87 a écrit : >>> VACUUM command works either in plai

Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Kevin Grittner
"Narasimha Murthy-VRFX87" wrote: > Guillaume Lelarge wrote: >> Le 14/05/2010 14:52, Narasimha Murthy-VRFX87 a écrit : >>> VACUUM command works either in plain mode (if we do not specify >>> FULL) or in FULL mode. When autovacuum is enabled, what mode >>> does it run the VACUUM command (in plain

Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Narasimha Murthy-VRFX87
To: Narasimha Murthy-VRFX87 Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode Hi, Le 14/05/2010 14:52, Narasimha Murthy-VRFX87 a écrit : > [...] > I need a clarification on auto-vacuum. Appreciate any > clarification/help.

Re: [ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Guillaume Lelarge
Hi, Le 14/05/2010 14:52, Narasimha Murthy-VRFX87 a écrit : > [...] > I need a clarification on auto-vacuum. Appreciate any > clarification/help. > > As explained in page 1093 of postgresql-8.2-US.pdf, VACUUM command works > either in plain mode (if we do not specify FULL) or in FULL mode. When >

[ADMIN] Clarification required: autovacuum and VACUUM command mode

2010-05-14 Thread Narasimha Murthy-VRFX87
Hello, I need a clarification on auto-vacuum. Appreciate any clarification/help. As explained in page 1093 of postgresql-8.2-US.pdf, VACUUM command works either in plain mode (if we do not specify FULL) or in FULL mode. When autovacuum is enabled, what mode does it run the VACUUM command (in pl