pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Matthew T. O'Connor <matthew@zeut.net>
To: Gaetano Mendola <mendola@bigfoot.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dennis Bjorklund <db@zigo.dhs.org>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: [HACKERS] Wrong index choosen?
Date: Fri, 23 Jul 2004 21:49:38 -0400
Message-ID: <4101C032.9060409@zeut.net> (raw)
In-Reply-To: <4101A83F.2070801@bigfoot.com>
References: <Pine.LNX.4.44.0407231354520.9559-100000@zigo.dhs.org>
	<20162.1090593927@sss.pgh.pa.us>
	<41014DE1.8000007@bigfoot.com>
	<410154F9.3080500@zeut.net>
	<4101A83F.2070801@bigfoot.com>

Gaetano Mendola wrote:
> Well I think pg_autovacuum as is in 7.4 can not help me for this particular
> table.
> 
> The table have 4.8 milions rows and I have for that table almost 10252 new
> entries for day.
> 
> I'm using pg_autovacuum with -a 200 -A 0.8 this means a threashold for
> that table equal to:  3849008 and if I understod well the way pg_autovacuum
> works this means have an analyze each 375 days, and I need an analyze for
> each day, at least.
> 
> So I think is better for me put an analyze for that table in the cron.
> 
> Am I wrong ?

No, I think you are right.  You could do something like -a 1000 -A 
.00185, but that will probably for an analyze too often for most of your 
other tables.





view thread (9+ messages)

Message-ID: <4101C032.9060409@zeut.net>
Permalink:  ../4101C032.9060409@zeut.net/
Also on:    postgresql.org/message-id/4101C032.9060409@zeut.net

 · 

reply

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, mendola@bigfoot.com, tgl@sss.pgh.pa.us, db@zigo.dhs.org
  Subject: Re: [HACKERS] Wrong index choosen?
  In-Reply-To: <4101C032.9060409@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