Lonni J Friedman <netllama@xxxxxxxxx> writes:
> On Fri, Jun 1, 2012 at 10:54 AM, Tom Lane <tgl@xxxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
