From:
tomas(at)tuxteam(dot)de
To:
Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
Cc:
tomas(at)tuxteam(dot)de, Simon Riggs <simon(at)2ndquadrant(dot)com>,Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>,pgsql-hackers(at)postgresql(dot)org,Markus Schiltknecht <markus(at)bluegap(dot)ch>,Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Subject:
Re: Dynamic Partitioning using Segment Visibility Maps
Date:
2008-01-06 05:57:36
Message-ID:
20080106055736.GB32629@www.trapp.net (view raw or flat )
Thread:
2008-01-02 17:56:14 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-03 00:41:04 from Sam Mason <sam(at)samason(dot)me(dot)uk>
2008-01-03 09:44:25 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-04 07:36:19 from "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com>
2008-01-04 09:59:05 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-04 12:39:42 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-04 10:22:40 from Richard Huxton <dev(at)archonet(dot)com>
2008-01-04 10:40:17 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-04 10:59:43 from Richard Huxton <dev(at)archonet(dot)com>
2008-01-04 12:49:27 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-04 12:29:55 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-04 13:40:03 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-04 18:06:04 from Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
2008-01-04 19:38:24 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-04 21:26:54 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-04 21:40:45 from Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
2008-01-05 10:13:12 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-04 22:01:31 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-05 03:31:14 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2008-01-05 09:33:45 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-05 12:45:47 from tomas(at)tuxteam(dot)de
2008-01-05 15:04:54 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-05 19:42:32 from "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com>
2008-01-06 05:57:36 from tomas(at)tuxteam(dot)de
2008-01-06 08:24:02 from "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com>
2008-01-06 10:39:47 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-06 11:13:47 from "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com>
2008-01-09 14:47:48 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-09 14:53:39 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-05 15:42:28 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-05 16:59:46 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2008-01-05 19:02:41 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-05 21:30:04 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2008-01-06 08:17:01 from "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com>
2008-01-06 10:48:51 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-06 17:25:55 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2008-01-09 12:56:48 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-07 15:41:46 from Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
2008-01-07 18:16:35 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-07 19:08:00 from Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
2008-01-07 20:53:31 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2008-01-11 12:40:21 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-08 00:08:52 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-08 16:27:55 from Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
2008-01-08 02:12:28 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-08 04:31:26 from Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
2008-01-08 16:38:38 from Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
2008-01-09 20:34:40 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-09 15:04:34 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-07 11:14:43 from Csaba Nagy <nagy(at)ecircle-ag(dot)com>
2008-01-07 12:59:01 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-07 13:12:53 from Csaba Nagy <nagy(at)ecircle-ag(dot)com>
2008-01-07 13:20:02 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2008-01-07 13:32:03 from Csaba Nagy <nagy(at)ecircle-ag(dot)com>
2008-01-09 14:49:49 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-09 14:34:30 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-09 06:28:59 from Gavin Sherry <swm(at)alcove(dot)com(dot)au>
2008-01-09 15:08:08 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-09 16:47:31 from Chris Browne <cbbrowne(at)acm(dot)org>
2008-01-09 18:53:47 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2008-01-09 19:38:21 from Chris Browne <cbbrowne(at)acm(dot)org>
2008-01-09 22:36:43 from Gavin Sherry <swm(at)alcove(dot)com(dot)au>
2008-01-10 17:40:05 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2008-01-09 19:03:13 from Gavin Sherry <swm(at)alcove(dot)com(dot)au>
2008-01-09 20:17:41 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-09 22:48:03 from Gavin Sherry <swm(at)alcove(dot)com(dot)au>
2008-01-10 02:06:38 from Gavin Sherry <swm(at)alcove(dot)com(dot)au>
2008-01-10 07:25:00 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-10 20:43:48 from Gavin Sherry <swm(at)alcove(dot)com(dot)au>
2008-01-10 21:30:10 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-11 01:28:53 from Gavin Sherry <swm(at)alcove(dot)com(dot)au>
2008-01-11 08:07:18 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-11 09:25:14 from Gavin Sherry <swm(at)alcove(dot)com(dot)au>
2008-01-11 11:49:50 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-11 19:03:41 from Gavin Sherry <swm(at)alcove(dot)com(dot)au>
2008-01-11 19:32:24 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-11 16:31:14 from "Zeugswetter Andreas ADI SD" <Andreas(dot)Zeugswetter(at)s-itsolutions(dot)at>
2008-01-11 17:31:30 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-10 16:51:04 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-10 20:49:03 from Gavin Sherry <swm(at)alcove(dot)com(dot)au>
2008-01-10 21:34:00 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-10 01:22:39 from Gavin Sherry <swm(at)alcove(dot)com(dot)au>
2008-01-11 09:42:59 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-12 01:53:37 from August Zajonc <augustz(at)augustz(dot)com>
Lists:
pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Sun, Jan 06, 2008 at 01:12:32AM +0530, Gokulakannan Somasundaram wrote:
> On Jan 5, 2008 6:15 PM, <tomas(at)tuxteam(dot)de> wrote:
>
> >
> > One thought I had back then, with partitioned tables was "gee -- B-tree
> > index is already doing a partition; why do a manual partition on top of
> > that?".
> Can you please explain more on what you are trying to say here?
Sure. A B-tree is just a device to partition something along some order.
If you have , say, a table of orders (to use the example upthread) and a
B-tree index on order date, this index partitions your set (at
recursively finer levels). Of course, you'd have to "sort" your data
alogn this index, but PostgreSQL knows how to do this trick: CLUSTER.
This was just a vague idea, many things were missing (for example to
separate out the more quiescent parts of the table into their own files)
which are spelled out in Simon Riggs' proposal.
This struck me when seeing people partition tables by hand -- and I was
delighted to actually watch Simon forging a real design.
Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFHgG3QBcgs9XrR2kYRAgKhAJ93KUybgMfG07ta67DiR8bgAbHPrgCeOI2V
by/xeXKrDJ5O0JZHyFurego=
=R/vC
-----END PGP SIGNATURE-----
In response to
Responses
pgsql-hackers by date
Next :From: Jari AaltoDate: 2008-01-06 08:07:10Subject : Re: [PATCH] pg_hba.conf.sample: mention www.postgresql.orgPrevious :From : Tom LaneDate : 2008-01-05 23:38:38Subject : Re: OUTER JOIN performance regression remains in 8.3beta4
