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