Re: Savepoints in transactions for speed?

Поиск
Список
Период
Сортировка
От Mike Blackwell
Тема Re: Savepoints in transactions for speed?
Дата
Msg-id CANPAkgsod2N+=oviHmhC0uXPAZixe4PPbMt_cx0iRLanyQdnHg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Savepoints in transactions for speed?  (Bob Lunney <bob_lunney@yahoo.com>)
Ответы Re: Savepoints in transactions for speed?  (Claudio Freire <klaussfreire@gmail.com>)
Список pgsql-performance
Steve Atkins wrote:

> Postgresql isn't going to run out of resources doing a big transaction, in the way some other databases will.

I thought I had read something at one point about keeping the transaction size on the order of a couple thousand because there were issues when it got larger.  As that apparently is not an issue I went ahead and tried the DELETE and COPY in a transaction.  The load time is quite reasonable this way.

Thanks!

Mike

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

Предыдущее
От: Dave Crooke
Дата:
Сообщение: Re: Postgres configuration for 8 CPUs, 6 GB RAM
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: Savepoints in transactions for speed?