Pg_upgrade speed for many tables
От
Bruce Momjian
Тема
Pg_upgrade speed for many tables
Дата
Msg-id
20121105200817.GA16323@momjian.us
Список
Дерево обсуждения
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>
Magnus reported that a customer with a million tables was finding pg_upgrade slow. I had never considered many table to be a problem, but decided to test it. I created a database with 2k tables like this: CREATE TABLE test1990 (x SERIAL); Running the git version of pg_upgrade on that took 203 seconds. Using synchronous_commit=off dropped the time to 78 seconds. This was tested on magnetic disks with a write-through cache. (No change on an SSD with a super-capacitor.) I don't see anything unsafe about having pg_upgrade use synchronous_commit=off. I could set it just for the pg_dump reload, but it seems safe to just use it always. We don't write to the old cluster, and if pg_upgrade fails, you have to re-initdb the new cluster anyway. Patch attached. I think it should be applied to 9.2 as well. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
В списке pgsql-hackers по дате отправления