Sterpu Victor <victor@ambra.ro> writes:
> I use postgresql 7.4.8.
> I need te delete and recreate a database very ofent, because I do some
> tests in it.
> After a few months the command createdb becamed very slow.
> How can I make it go fast again?
The only explanation that comes to mind is that you haven't ever
vacuumed pg_database ... at this point you probably need a VACUUM
FULL, and maybe REINDEX too, to get it back down to a reasonable
size.
regards, tom lane