speeding up table creation

Поиск
Список
Период
Сортировка
От Rainer Mager
Тема speeding up table creation
Дата
Msg-id 000001c92e51$c42afcb0$4c80f610$@com
обсуждение исходный текст
Ответы Re: speeding up table creation
Re: speeding up table creation
Список pgsql-performance

I have an interesting performance improvement need. As part of the automatic test suite we run in our development environment, we re-initialize our test database a number of times in order to ensure it is clean before running a test. We currently do this by dropping the public schema and then recreating our tables (roughly 30 tables total). After that we do normal inserts, etc, but never with very much data. My question is, what settings can we tweak to improve performance is this scenario? Specifically, if there was a way to tell Postgres to keep all operations in memory, that would probably be ideal.

 

We actually tried running Postgres off of a RAM disk and this did help a reasonable amount, but we’re running under Windows and setting up the RAM disk is a hassle and all of our developers would need to do it.

 

 

Any tips would be appreciated.

 

 

--Rainer

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Backup strategies
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: speeding up table creation