X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2658255FA7 for ; Thu, 24 Feb 2005 12:13:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00915-10 for ; Thu, 24 Feb 2005 12:13:08 +0000 (GMT) Received: from mail.logi-track.com (www.logi-track.com [213.239.193.212]) by svr1.postgresql.org (Postfix) with ESMTP id 9D2FF55C0A for ; Thu, 24 Feb 2005 12:13:04 +0000 (GMT) Received: from kingfisher.intern.logi-track.com (J1119.j.pppool.de [85.74.17.25]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logi-track.com (Postfix) with ESMTP id 35AA3303AE; Thu, 24 Feb 2005 13:13:15 +0100 (CET) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with ESMTP id DBDAAAB2E5; Thu, 24 Feb 2005 13:13:10 +0100 (CET) Message-ID: <421DC4D5.1070909@logi-track.com> Date: Thu, 24 Feb 2005 13:13:09 +0100 From: Markus Schaber User-Agent: Mozilla Thunderbird 1.0 (X11/20050116) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: Gaetano Mendola Cc: "Matthew T. O'Connor" , pgsql-performance@postgresql.org Subject: Re: is pg_autovacuum so effective ? References: <12400.1109107683@sss.pgh.pa.us> <421BD64E.30803@bigfoot.com> <60psyr265t.fsf@dba2.int.libertyrms.com> <421CD6F0.8010406@zeut.net> <421DB36B.70004@bigfoot.com> In-Reply-To: <421DB36B.70004@bigfoot.com> X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-ripemd160; protocol="application/pgp-signature"; boundary="------------enig764633B6B2515BA9B21374B6" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.052 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/349 X-Sequence-Number: 10678 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig764633B6B2515BA9B21374B6 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, Gaetano, Gaetano Mendola schrieb: > I have the same requirement too. Actually pg_autovacuum can not be > instructed "per table" so some time the global settings are not good > enough. I have a table of logs with 6 milions rows ( 3 years logs ) > I insert on that page ~ 6000 rows for day. I'm running pg_autovacuum > with setting to ANALYZE or VACUUM table if the 10% is touched. > With this setting pg_autovacuum will analyze that table each 3 months!!= ! If you have only inserts, and only so few on a large table, you do not need to vacuum such often. Not to reclaim space, only to prevent transaction ID wraparound (which is ensured by pg_autovacuum). And if the data distribution does not change, frequently calling ANALYZE does not help much, either. Markus --=20 markus schaber | dipl. informatiker logi-track ag | rennweg 14-16 | ch 8001 z=FCrich phone +41-43-888 62 52 | fax +41-43-888 62 53 mailto:schabios@logi-track.com | www.logi-track.com --------------enig764633B6B2515BA9B21374B6 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCHcTVOVWsnapT9i0RA2R7AJ4hn/9N6WgAnCRNTs4VGdOdKVNj3QCcDs9s ywpRFAfqDamv7EzTkCd5geY= =IGfj -----END PGP SIGNATURE----- --------------enig764633B6B2515BA9B21374B6--