pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Aldor <an@mediaroot.de>
To: pgsql-admin@postgresql.org
Subject: How to VACUUM this table? "998994633 estimated total rows"
Date: Sat, 11 Feb 2006 04:15:31 +0100
Message-ID: <43ED56D3.7040404@mediaroot.de> (raw)

Hi,

I'm just curious about a VACUUM plan of this table:

1st) When to do VAUUM?
2nd) How often to do VACUUM?
3rd) With which postgresql.conf paremeters to set up vacuum?
4th) When to do a VACUUM FULL?
5th) Can autovacuum of 8.1 be used in this case?

I'm a little bit afraid about the size of the table, but I think
somebody should have a solution...

Here is the complete ANALYZE output of the table:

INFO:  "tbl1": scanned 300 of 27744713 pages, containing 10802 live rows
and 0 dead rows; 300 rows in sample, 998994633 estimated total rows

The size of the data is 340 GB, this are 40% of the disk-array.

Thanks is advance.

Marco



view thread (5+ messages)  latest in thread

Message-ID: <43ED56D3.7040404@mediaroot.de>
Permalink:  ../43ED56D3.7040404@mediaroot.de/
Also on:    postgresql.org/message-id/43ED56D3.7040404@mediaroot.de

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: an@mediaroot.de
  Subject: Re: How to VACUUM this table? "998994633 estimated total rows"
  In-Reply-To: <43ED56D3.7040404@mediaroot.de>
  References: <43ED56D3.7040404@mediaroot.de>

* 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