From: Matthew T. O'Connor <matthew@zeut.net>
To: Gaetano Mendola <gmendola@mbigroup.it>
Cc: Markus Schaber <schabios@logi-track.com>
Cc: Gaetano Mendola <mendola@bigfoot.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: is pg_autovacuum so effective ?
Date: Mon, 28 Feb 2005 09:30:58 -0500
Message-ID: <42232B22.4030302@zeut.net> (raw)
In-Reply-To: <421E556E.6010202@mbigroup.it>
References: <cvg29i$2l69$1@news.hub.org>
<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>
Gaetano Mendola wrote:
>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.
>Beside that I tried to partition that table, I used both tecnique on
>my knowledge
>
>1) A view with UNION ALL on all tables collecting these logs
>2) Using inheritance
>
>and both cases are working in theory but in practice are not ( the index scan
>is lost as soon you use this view/table inside others views or joining them)
>
>I heard that next version of pg_autovacuum can be instructed "per table";
>is it true ?
>
The version of pg_autovacuum that I submitted for 8.0 could be
instructed "per table" but it didn't make the cut. Aside from moved out
of contrib and integrated into the backend, per table autovacuum
settings is probably the next highest priority.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: matthew@zeut.net, gmendola@mbigroup.it, schabios@logi-track.com, mendola@bigfoot.com
Subject: Re: is pg_autovacuum so effective ?
In-Reply-To: <42232B22.4030302@zeut.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox