Re: improve performance of pg_dump with many sequences

Поиск
Список
Период
Сортировка
Искать
От
Nathan Bossart
Тема
Re: improve performance of pg_dump with many sequences
Дата
Msg-id
ZqFJspSbieuTE4X0@nathan
Ответ на
Список
Дерево обсуждения
improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences "Euler Taveira" <euler@eulerto.com>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences "Euler Taveira" <euler@eulerto.com>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Michael Paquier <michael@paquier.xyz>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
Re: improve performance of pg_dump with many sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: improve performance of pg_dump with many sequences Nathan Bossart <nathandbossart@gmail.com>
I ran Euler's tests again on the v6 patch set.

	for i in `seq 1 10000`; do psql postgres -c "CREATE SEQUENCE s$i;"; done
	time pg_dump -f - -s -d postgres > /dev/null

	HEAD:        0.607s
	0001 + 0002: 0.094s
	all patches: 0.094s

Barring additional feedback, I am planning to commit these patches early
next week.

-- 
nathan


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Muhammad Malik
Дата:
FAQ