Re: autovacuum running for a long time on a new table with 1 row

Lonni J Friedman <netllama(at)gmail(dot)com> writes:
> On Fri, Jun 1, 2012 at 10:54 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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