Re: autovacuum running for a long time on a new table with 1 row - Mailing list pgsql-general

From Tom Lane
Subject Re: autovacuum running for a long time on a new table with 1 row
Date
Msg-id 366.1338576942@sss.pgh.pa.us
Whole thread Raw
In response to Re: autovacuum running for a long time on a new table with 1 row  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-general
Lonni J Friedman <netllama@gmail.com> writes:
> On Fri, Jun 1, 2012 at 10:54 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> ... if you really did drop and recreate the table, then at this point
>> it should only have a single page, I would think.  It might be worth
>> checking the actual file size.  pg_relation_size('tablename') is
>> probably the quickest way.

> Unfortunately, I've since inserted several million rows into this
> table, so I'm guessing its too late now to check the size?

Yeah, it won't prove much now.  If you see something like this happen
again, please poke into it a bit more before you damage the evidence...

            regards, tom lane

pgsql-general by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: autovacuum running for a long time on a new table with 1 row
Next
From: Jasen Betts
Date:
Subject: Re: timestamps, formatting, and internals