Skip site navigation (1) Skip section navigation (2)

Re: How to bulk load a schema using JDBC multiple

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <olarte(dot)andres(at)gmail(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: How to bulk load a schema using JDBC multiple
Date: 2005-10-18 22:12:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Have you considered having your test suite create a template
database, and using it to drop and create the test database?

>>> Andres Olarte <olarte(dot)andres(at)gmail(dot)com>  >>>

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. My tests are taking more than 10 minutes now,
and most of the time is spent loading the schema.  If there away to do
this faster? May be using a store procedure with the whole schema?
I've tried making such a procedure, but it doesn't work do to quoting
problems. Anybody have any ideas? Thanks



pgsql-jdbc by date

Next:From: andy petrellaDate: 2005-10-18 22:45:24
Subject: Array ???
Previous:From: andy petrellaDate: 2005-10-18 19:57:48
Subject: newbie jdbc3 tiny example

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group