Andres Olarte <olarte(dot)andres(at)gmail(dot)com> writes:
> I need to load and drop my schema multiple times during my unit tests.
> This happens several thousand times per run of my test suite. I'm
> loading the schema from the file that's generated by pg_dump, and it
> works, but it's SLOW.
Sounds to me like you've been neglecting to vacuum the system catalogs.
regards, tom lane
In response to
pgsql-jdbc by date
|Next:||From: Alberto||Date: 2005-10-16 13:43:55|
|Previous:||From: Andres Olarte||Date: 2005-10-15 23:08:04|
|Subject: How to bulk load a schema using JDBC multiple times?|