pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hervé Piedvache <herve@elma.fr>
Cc: pgsql-performance@postgresql.org
Subject: Re: Why memory is not used ? Why vacuum so slow ?
Date: Fri, 02 Jan 2004 10:51:13 -0500
Message-ID: <5930.1073058673@sss.pgh.pa.us> (raw)
In-Reply-To: <200401021618.28300.herve@elma.fr>
References: <200401021042.57714.herve@elma.fr>
	<5630.1073054548@sss.pgh.pa.us>
	<200401021618.28300.herve@elma.fr>

=?iso-8859-15?q?Herv=E9=20Piedvache?= <herve@elma.fr> writes:
> and I have also saw that the full vacuum for pg_atribute seems 
> to be so slow ... more than 1 min for 7256 tupples ? Is this is normal ?

> INFO:  --Relation pg_catalog.pg_attribute--
> INFO:  Pages 119: Changed 0, reaped 1, Empty 0, New 0; Tup 7256: Vac 0, Keep/
> VTL 0/0, UnUsed 3, MinLen 128, MaxLen 128; Re-using: Free/Avail. Space 
> 14664/504; EndEmpty/Avail. Pages 0/1.
>         CPU 0.00s/0.00u sec elapsed 0.08 sec.
> INFO:  Index pg_attribute_relid_attnam_index: Pages 21082; Tuples 7256: 
> Deleted 0.
>         CPU 0.83s/0.13u sec elapsed 59.32 sec.
> INFO:  Index pg_attribute_relid_attnum_index: Pages 5147; Tuples 7256: Deleted 
> 0.
>         CPU 0.26s/0.03u sec elapsed 8.79 sec.

You're suffering from index bloat (21000 pages in an index for a
119-page table!?).  Updating to 7.4 would probably fix this, but
if that's not practical consider reindexing pg_attribute.

			regards, tom lane



view thread (4+ messages)

Message-ID: <5930.1073058673@sss.pgh.pa.us>
Permalink:  ../5930.1073058673@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/5930.1073058673@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, herve@elma.fr
  Subject: Re: Why memory is not used ? Why vacuum so slow ?
  In-Reply-To: <5930.1073058673@sss.pgh.pa.us>

* 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