Sterpu Victor <victor@xxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
