How to bulk load a schema using JDBC multiple times?

Поиск
Список
Период
Сортировка
От Andres Olarte
Тема How to bulk load a schema using JDBC multiple times?
Дата
Msg-id 3fccaa690510151608t548547bcg56e2d1927689de03@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to bulk load a schema using JDBC multiple times?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-jdbc
Hi,

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

Andres

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Currently Connection
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to bulk load a schema using JDBC multiple times?