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