Re: plan time of MASSIVE partitioning ...
From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
PostgreSQL - Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
Cc:
pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: plan time of MASSIVE partitioning ...
Date:
2010-09-03 13:27:15
Message-ID:
AANLkTik9=wjvnG7VPbPHuC9FXacvFge3U=UppmqSOocF@mail.gmail.com (view raw or flat )
Thread:
2010-09-03 09:40:37 from PostgreSQL - Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
2010-09-03 12:04:42 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-09-03 12:16:21 from PostgreSQL - Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
2010-09-03 12:27:36 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-09-03 13:27:15 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-08 13:54:11 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-08 14:14:29 from Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
2010-09-08 14:18:02 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-09-08 14:26:43 from Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
2010-09-08 15:42:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-08 14:57:12 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-09-08 15:09:11 from Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
2010-09-08 15:26:55 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-09-08 15:39:35 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-09-08 15:58:09 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-09-08 16:08:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-08 17:05:59 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-09-08 17:19:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-08 18:49:03 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-09-08 19:27:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-10 09:14:41 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-10-19 13:32:12 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-10-19 19:50:55 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-10-19 20:14:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-26 15:34:56 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-10-27 15:41:00 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-10-28 09:33:22 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-10-28 09:40:28 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-10-28 10:54:59 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-10-28 11:29:30 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-10-28 13:36:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-28 17:11:13 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-10-28 22:56:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-29 06:08:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-29 08:00:29 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-10-29 08:48:59 from Leonardo Francalanci <m_lists(at)yahoo(dot)it>
2010-10-29 08:57:20 from Leonardo Francalanci <m_lists(at)yahoo(dot)it>
2010-10-29 15:23:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-29 15:41:18 from Leonardo Francalanci <m_lists(at)yahoo(dot)it>
2010-10-29 17:15:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-29 17:22:12 from Leonardo Francalanci <m_lists(at)yahoo(dot)it>
2010-10-29 17:31:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-29 20:08:57 from Leonardo Francalanci <m_lists(at)yahoo(dot)it>
2010-10-29 20:23:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-13 03:47:02 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-11-13 03:55:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-13 22:26:34 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-29 19:11:50 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-10-29 19:37:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-01 14:18:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-05 02:59:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-29 16:53:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-29 17:16:44 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-29 17:44:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-28 11:35:23 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-10-28 13:49:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-08 16:26:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-08 17:08:24 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-09-08 15:33:26 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-08 15:37:30 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-09-08 15:57:47 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2010-09-08 16:03:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-03 14:40:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-03 14:46:26 from PostgreSQL - Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
Lists:
pgsql-hackers
2010/9/3 PostgreSQL - Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>:
> i tried this one with 5000 unindexed tables (just one col):
>
> test=# \timing
> Timing is on.
> test=# prepare x(int4) AS select * from t_data order by id desc;
> PREPARE
> Time: 361.552 ms
>
> you will see similar or higher runtimes in case of 500 partitions and a handful of indexes.
I'd like to see (1) a script to reproduce your test environment (as
Stephen also requested) and (2) gprof or oprofile results.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2010-09-03 13:29:43Subject : Re: Streaming a base backup from masterPrevious :From : Dave PageDate : 2010-09-03 13:26:49Subject : Re: Streaming a base backup from master
