[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] vacuuming strangeness
From: Tom Lane <tgl () sss ! pgh ! pa ! us>
Date: 2005-10-31 20:29:52
Message-ID: 18632.1130790592 () sss ! pgh ! pa ! us
[Download RAW message or body]
Joe Maldonado <joe.maldonado@gmail.com> writes:
> The VACUUM process does not seem to be able to exit, instead it seems to be
> stuck in some strange loop for some time.
> Is this something to be expected?
That trace looks perfectly normal. Try increasing vacuum_mem if you
want fewer tuple-removal cycles.
> INFO: "test_table": found 23357083 removable, 200037 nonremovable row
> versions in 442991 pages
> DETAIL: 200000 dead row versions cannot be removed yet.
> There were 23842917 unused item pointers.
Lessee, 37 live rows and 23.5 million dead ones ... you should consider
vacuuming this table a bit more often ;-)
And yes, you will need a VACUUM FULL to get back down to a reasonable
table size.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic