From:
Markus Schiltknecht <markus(at)bluegap(dot)ch>
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, Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Subject:
Re: Dynamic Partitioning using Segment Visibility Maps
Date:
2008-01-06 10:39:47
Message-ID:
4780AFF3.7070904@bluegap.ch (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
Hi,
Gokulakannan Somasundaram wrote:
>
>
> On Jan 5, 2008 6:15 PM, <tomas(at)tuxteam(dot)de <mailto: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?
I think this has to do with SE not being of much use for index scans. Or
put it another way: SE is an optimization for sequential scans. For
tables where it works well, it could possibly replace the index entirely.
Without the index, you would rely on SE to always be able to exclude
enough segments, so that the seq scan is less expensive than an index
scan with the following table lookups.
With an index, the planner gets a hard time deciding between the index
scan and the (possibly SE optimized) seq scan.
Regards
Markus
In response to
Responses
pgsql-hackers by date
Next :From: Markus SchiltknechtDate: 2008-01-06 10:48:51Subject : Re: Dynamic Partitioning using Segment Visibility MapsPrevious :From : Joshua D. DrakeDate : 2008-01-06 09:50:12Subject : Re: Bug: Unreferenced temp tables disables vacuum to update
xid
