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 17EBF563C8 for ; Fri, 25 Feb 2005 17:54:57 +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 42624-02 for ; Fri, 25 Feb 2005 17:54:46 +0000 (GMT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by svr1.postgresql.org (Postfix) with ESMTP id AD8B1563FD for ; Fri, 25 Feb 2005 17:54:46 +0000 (GMT) Received: from mail.logi-track.com (www.logi-track.com [213.239.193.212]) by svr4.postgresql.org (Postfix) with ESMTP id 3ACC45B0239 for ; Fri, 25 Feb 2005 16:35:04 +0000 (GMT) Received: from kingfisher.intern.logi-track.com (pD95DCE36.dip0.t-ipconnect.de [217.93.206.54]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logi-track.com (Postfix) with ESMTP id 1D63B308D6; Fri, 25 Feb 2005 17:29:09 +0100 (CET) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with ESMTP id 86465AB0E1; Fri, 25 Feb 2005 17:28:59 +0100 (CET) Message-ID: <421F524A.1010804@logi-track.com> Date: Fri, 25 Feb 2005 17:28:58 +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: pgsql-performance@postgresql.org Cc: Gaetano Mendola 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> <421DC4D5.1070909@logi-track.com> <421E556E.6010202@mbigroup.it> In-Reply-To: <421E556E.6010202@mbigroup.it> 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="------------enig58BDD744D93A60C6ABB35002" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/364 X-Sequence-Number: 10693 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig58BDD744D93A60C6ABB35002 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, Gaetano, Gaetano Mendola schrieb: > Yes, I'm aware about it indeed I need the analyze because usualy I do = on that > table select regarding last 24 ours so need to analyze it in order to > collect the statistics for this period. If you tend to do lots of queries for the last 24 hours, and there is only a very small percentage of such young rows, partial indices could be helpful. You could include all rows that are not older than 24 hours, and recreate them via cron script daily, so they grow from 24 to 48 hours between recreations. To avoid a gap in recreation, you could first create the new index, and then drop the old one, using alternating names.= BTW, a small question for the gurus: does postgres make use of other indices when creating partial indices? HTH, 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 --------------enig58BDD744D93A60C6ABB35002 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 iD8DBQFCH1JKOVWsnapT9i0RA+OlAKC0M0u3V7RtWWH4gLyLOHCA78K3cACfbdww ILk2vrhd/gOXl88j2znwUhU= =cQRs -----END PGP SIGNATURE----- --------------enig58BDD744D93A60C6ABB35002--