Re: How to bulk load a schema using JDBC multiple times? - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: How to bulk load a schema using JDBC multiple times?
Date
Msg-id 4498.1129434042@sss.pgh.pa.us
Whole thread Raw
In response to How to bulk load a schema using JDBC multiple times?  (Andres Olarte <olarte.andres@gmail.com>)
List pgsql-jdbc
Andres Olarte <olarte.andres@gmail.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

pgsql-jdbc by date:

Previous
From: Andres Olarte
Date:
Subject: How to bulk load a schema using JDBC multiple times?
Next
From: Alberto
Date:
Subject: unsuscribe