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
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.
-vacuum. Is there any way to achive this?
Pl clarify.
Regards, Narasimha Murthy
Cell +91 95814 98895, +91-94940 62794 | 040-2347 2025 (O) | x2025 (O)
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Friday, May 14, 2010 7:10 PM
To: Narasimha Murthy-VRFX87
Cc
not to run ANALYZE.
Regards, Narasimha Murthy
Cell +91 95814 98895, +91-94940 62794 | 040-2347 2025 (O) | x2025 (O)
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Friday, May 14, 2010 8:18 PM
To: Narasimha Murthy-VRFX87
Cc: pgsql-admin@postgresql.org
he ability to
change or tune the queries is beside the point.
- Lewis
On 5/14/2010 11:01 AM, Narasimha Murthy-VRFX87 wrote:
> Hi Kevin,
>
> Thanks again for a quick response.
>
> I am using a 3rd party application, which in turn using PostgreSQL DB.
> I can not change/tune
Hello,
Postgresql-8.2 manual has mentioned following points.
* The autovacuum daemon, when enabled, runs every autovacuum_naptime
seconds.
* autovacuum_naptime (integer): Specifies the delay between "activity
rounds" for the autovacuum daemonThe delay is measured in seconds,
and the default i
?
Regards, Narasimha Murthy
Cell +91 95814 98895, +91-94940 62794 | 040-2347 2025 (O) | x2025 (O)
-Original Message-
From: Ian Lea [mailto:ian@gmail.com]
Sent: Tuesday, May 18, 2010 3:43 PM
To: Narasimha Murthy-VRFX87
Subject: Re: [ADMIN] Clarification Needed: When does autovacuum daemon run?
lto:pgsql-admin-ow...@postgresql.org] On Behalf Of Alvaro Herrera
Sent: Thursday, May 20, 2010 2:21 AM
To: Narasimha Murthy-VRFX87
Cc: Ian Lea; Devrim GÜNDÜZ; pgsql-admin
Subject: Re: [ADMIN] Clarification Needed: When does autovacuum daemon run?
Excerpts from Narasimha Murthy-VRFX87's message of ma
