From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc:
Bruce Momjian <bruce(at)momjian(dot)us>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Pg_upgrade speed for many tables
Date:
2012-11-05 21:39:27
Message-ID:
CA+TgmoZE9re47+F9m6EuuJamvCa38Yi6M7Qs4WOGdbfXBXThgw@mail.gmail.com (view raw or flat )
Thread:
2012-11-05 20:08:17 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-05 20:14:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-05 20:23:04 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-11-05 20:30:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-05 20:49:08 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-05 21:01:22 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-11-05 21:04:12 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-05 21:07:45 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-05 21:10:17 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-05 21:14:47 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-05 21:22:59 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-05 21:33:16 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-05 21:37:53 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-05 21:39:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-05 21:42:56 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-05 21:50:42 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-05 22:03:45 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-05 22:14:16 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-05 21:23:58 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-05 21:29:49 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-06 00:22:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-06 01:39:40 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-11-06 01:52:13 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-06 02:37:30 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-11-05 23:15:30 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-06 19:37:26 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-12 18:29:39 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-12 19:12:38 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-11-14 23:55:52 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-19 20:11:26 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-24 03:22:00 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-25 05:42:08 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-26 19:43:19 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-01 03:43:29 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-12-04 03:50:32 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers
On Mon, Nov 5, 2012 at 4:33 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
> AFAIR any transaction that modifies catalogs gets sync commit forcibly,
> regardless of the setting. And sync commit means you get to wait for
> all previous transactions to be flushed as well. So simply creating a
> temp table ought to do the trick ...
I don't think there's a carve-out for system tables ... but creating a
temp table with synchronous_commit=on will certainly do the trick.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
In response to
Responses
pgsql-hackers by date
Next :From: Bruce MomjianDate: 2012-11-05 21:42:56Subject : Re: Pg_upgrade speed for many tablesPrevious :From : Bruce MomjianDate : 2012-11-05 21:37:53Subject : Re: Pg_upgrade speed for many tables
