Re: The postgres database -- necessary? If so, how to cleanse?

OK, great. Thank. And when I recreate it, should I do so from a template, or just CREATE DATABASE postgres ?

On 2011-10-26, at 4:10 PM, Tom Lane wrote:

> =?iso-8859-1?Q?Ren=E9_Fournier?= <m5(at)renefournier(dot)com> writes:
>> I accidentally imported lots of data into the postgres database via something like:
>> psql -U postgres -q -f super_massive_database_dump.sql
>
>> Now, although I've manually dropped all the tables -- and \d+ shows
>> nothing -- there are still various views, functions, etc that must
>> account for a lot of disk space. From \l+, I see that postgres still
>> occupies 65GB.
>
> [ raised eyebrow ... ] It's pretty hard to conceive of system catalogs
> occupying 65GB. You might want to look into where that number is coming
> from. (Large objects maybe?)
>
>> So my question is, what's the easiest way to reclaim
>> that space? Can I drop postgres and just recreate it?
>
> Yeah, if you want.
>
> regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general