Skip site navigation (1) Skip section navigation (2)

Re: I don't understand this explain output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Arts <ron(dot)arts(at)neonova(dot)nl>
Cc: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: I don't understand this explain output
Date: 2009-05-26 14:34:05
Message-ID: 11824.1243348445@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Ron Arts <ron(dot)arts(at)neonova(dot)nl> writes:
> thanks for the answer, I forgot to mention that I did
> enable autovacuum in postgresql.conf a while ago.
> (autovacuum = on). But that did not seem to help.

Once the table is bloated, autovacuum won't do much to de-bloat it.
You need a one-time cleanup to get rid of the bloat, and then
hopefully autovac will keep things under control after that.

VACUUM FULL and then REINDEX would do for cleanup.  On large
tables it would be better to use CLUSTER, but with only 23 live
rows, VACUUM FULL will be fast enough.

> I will run autovacuum full tonight. So the cost means
> the total number of records to read including deleted ones?

No, it's more like the total number of disk pages to read.  The
previous claim that it was equal to the number of dead rows is
erroneous.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Ibrahim ShaameDate: 2009-05-26 14:46:42
Subject: Re: cannot install postgres
Previous:From: Luiz Eduardo Cantanhede NeriDate: 2009-05-26 14:26:59
Subject: Re: Tool for modeling

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group