Re: Pg_upgrade speed for many tables

Поиск
Список
Период
Сортировка
Искать
От
Magnus Hagander
Тема
Re: Pg_upgrade speed for many tables
Дата
Msg-id
CABUevEzyaL2iiJqqa4BQHYbiScN3+H7JA_mduQm+mbMSYAXOqA@mail.gmail.com
Ответ на
Re: Pg_upgrade speed for many tables (Tom Lane)
Список
Дерево обсуждения
Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Pg_upgrade speed for many tables Tom Lane <tgl@sss.pgh.pa.us>
Re: Pg_upgrade speed for many tables Magnus Hagander <magnus@hagander.net>
Re: Pg_upgrade speed for many tables Tom Lane <tgl@sss.pgh.pa.us>
Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Pg_upgrade speed for many tables Magnus Hagander <magnus@hagander.net>
Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Pg_upgrade speed for many tables Jeff Janes <jeff.janes@gmail.com>
Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Pg_upgrade speed for many tables Robert Haas <robertmhaas@gmail.com>
Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Pg_upgrade speed for many tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Pg_upgrade speed for many tables Robert Haas <robertmhaas@gmail.com>
Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Pg_upgrade speed for many tables Andres Freund <andres@2ndquadrant.com>
Re: Pg_upgrade speed for many tables Robert Haas <robertmhaas@gmail.com>
Re: Pg_upgrade speed for many tables Jeff Janes <jeff.janes@gmail.com>
Re: Pg_upgrade speed for many tables Jeff Janes <jeff.janes@gmail.com>
Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Pg_upgrade speed for many tables Tom Lane <tgl@sss.pgh.pa.us>
Re: Pg_upgrade speed for many tables Josh Berkus <josh@agliodbs.com>
Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Pg_upgrade speed for many tables Andrew Dunstan <andrew@dunslane.net>
Re: Pg_upgrade speed for many tables Jeff Janes <jeff.janes@gmail.com>
Re: Pg_upgrade speed for many tables Jeff Janes <jeff.janes@gmail.com>
Re: Pg_upgrade speed for many tables Jeff Davis <pgsql@j-davis.com>
Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Pg_upgrade speed for many tables Jeff Janes <jeff.janes@gmail.com>
Use of fsync; was Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Use of fsync; was Re: Pg_upgrade speed for many tables Jeff Janes <jeff.janes@gmail.com>
Re: Use of fsync; was Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Use of fsync; was Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>
Re: Use of fsync; was Re: Pg_upgrade speed for many tables Bruce Momjian <bruce@momjian.us>

On Mon, Nov 5, 2012 at 9:14 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Bruce Momjian <bruce@momjian.us> writes:
> Magnus reported that a customer with a million tables was finding
> pg_upgrade slow.

You sure there's not an O(N^2) issue in there somewhere? 

> I don't see anything unsafe about having pg_upgrade use
> synchronous_commit=off.

No objection, but this seems unlikely to be better than linear speedup,
with a not-terribly-large constant factor.

BTW, does pg_upgrade run pg_restore in --single-transaction mode?
That would probably make synchronous_commit moot, at least for that
step.

 
It doesn't use pg_restore at all - it uses the dump from pg_dumpall, which you can't reload with pg_restore. 


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/
В списке pgsql-hackers по дате отправления
Предыдущее
От: Robert Haas
Дата:
Следующее
От: Tom Lane
Дата:
FAQ