Re: Using COPY FREEZE in pgbench

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Using COPY FREEZE in pgbench
Дата
Msg-id CAH2-Wz=7DtyDSmvPTiUgeCPhDw4KGwVva2SygKPaiLmj8TwjXQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Using COPY FREEZE in pgbench  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Ответы Re: Using COPY FREEZE in pgbench  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Список pgsql-hackers
On Fri, Apr 2, 2021 at 4:58 PM Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
> I am not sure how many people use this kind of options while running
> pgbench -i but we could add yet another switch to fall back to none
> FREEZE COPY if you want.

I was unclear. What I meant was that your patch isn't just useful
because it speeds up "pgbench -i" for everybody. It's also useful
because having all of the tuples already frozen after bulk loading
seems like a good benchmarking practice, at least most of the time.

The patch changes the initial state of the database with "pgbench -i",
I think. But that's good.

-- 
Peter Geoghegan



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Have I found an interval arithmetic bug?
Следующее
От: Zhihong Yu
Дата:
Сообщение: Re: Have I found an interval arithmetic bug?