From:
Simon Riggs <simon(at)2ndQuadrant(dot)com>
To:
Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>,
Magnus Hagander <magnus(at)hagander(dot)net>
Subject:
Re: Further pg_upgrade analysis for many tables
Date:
2013-01-09 11:55:18
Message-ID:
CA+U5nMLkGAF3be15aeG1wzu=Yt3ZXB8iLEKZOaNgPD_mhYztYA@mail.gmail.com (view raw or flat )
Thread:
2012-11-08 02:17:29 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-08 16:05:28 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-08 17:30:11 from Peter Eisentraut <peter(at)eisentraut(dot)org>
2012-11-09 03:25:23 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-10 00:06:38 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-10 22:20:55 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-10 22:48:44 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-09 23:18:53 from Andres Freund <andres(at)anarazel(dot)de>
2012-11-08 23:46:09 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-09 00:33:40 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-09 04:59:21 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-09 05:50:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-09 18:50:17 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-12 21:54:28 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2013-01-09 11:59:00 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-09 17:50:38 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2013-01-09 19:32:59 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-11-12 16:11:03 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-12 16:23:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-12 16:51:44 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-12 22:17:17 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-11-12 22:41:25 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-14 17:40:40 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-14 19:49:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-14 20:01:09 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-15 20:57:43 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-11-15 21:45:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-16 03:05:00 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-23 16:58:43 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-23 22:34:45 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-26 16:13:56 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-09 11:55:18 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-10 03:46:01 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2013-01-20 18:42:29 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-20 19:32:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-21 05:51:11 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2013-01-20 19:08:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-24 17:12:20 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-09 05:53:44 from Ants Aasma <ants(at)cybertec(dot)at>
2012-11-09 06:20:59 from Ants Aasma <ants(at)cybertec(dot)at>
2012-11-10 17:10:36 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-10 17:17:34 from Ants Aasma <ants(at)cybertec(dot)at>
2012-11-10 17:41:44 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-12 17:09:08 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-12 20:59:27 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-12 21:11:22 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-12 21:22:33 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-12 21:14:59 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-12 21:31:04 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-24 18:20:14 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-13 03:44:54 from Ants Aasma <ants(at)cybertec(dot)at>
2012-11-14 00:03:51 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-14 00:51:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-14 04:11:27 from Ants Aasma <ants(at)cybertec(dot)at>
2012-11-14 15:08:15 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-14 15:25:24 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-11-14 15:36:48 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-26 22:26:42 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-27 00:05:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-28 04:13:04 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-28 05:35:10 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-28 14:13:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-28 20:22:32 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-29 17:59:19 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-30 21:31:00 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-20 19:11:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-23 03:24:57 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-14 22:33:29 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-12 21:32:35 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-09 23:06:41 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-10 00:23:40 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-10 17:15:58 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-10 22:45:54 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-10 22:59:54 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-12 16:05:32 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-11-10 17:18:11 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers
On 23 November 2012 22:34, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> I got rid of need_eoxact_work entirely and replaced it with a short
> list that fulfills the functions of indicating that work is needed,
> and suggesting which rels might need that work. There is no attempt
> to prevent duplicates, nor to remove invalidated entries from the
> list. Invalid entries are skipped when the hash entry is not found,
> and processing is idempotent so duplicates are not a problem.
>
> Formally speaking, if MAX_EOXACT_LIST were 0, so that the list
> overflowed the first time it was accessed, then it would be identical
> to the current behavior or having only a flag. So formally all I did
> was increase the max from 0 to 10.
...
> It is not obvious what value to set the MAX list size to.
A few questions, that may help you...
Why did you pick 10, when your create temp table example needs 110?
Why does the list not grow as needed?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
In response to
Responses
pgsql-hackers by date
Next :From: Andres FreundDate: 2013-01-09 11:56:46Subject : Re: [PATCH] unified frontend support for pg_malloc et al
and palloc/pfree mulation (was xlogreader-v4)Previous :From : Heikki LinnakangasDate : 2013-01-09 11:46:53Subject : Re: [PATCH] unified frontend support for pg_malloc et al
and palloc/pfree mulation (was xlogreader-v4)
