From:
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To:
pgsql-hackers(at)postgresql(dot)org
Cc:
Simon Riggs <simon(at)2ndquadrant(dot)com>,
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-05 03:31:14
Message-ID:
200801042231.15295.xzilla@users.sourceforge.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
On Friday 04 January 2008 17:01, Simon Riggs wrote:
> On Fri, 2008-01-04 at 22:26 +0100, Markus Schiltknecht wrote:
> > I'm still puzzled about how a DBA is expected to figure out which
> > segments to mark. Simon, are you assuming we are going to pass on
> > segment numbers to the DBA one day?
>
> No Way!
>
> That would stop Richard's idea to make the segment stride configurable,
> apart from being a generally ugly thing.
>
> > If not, a more user friendly command like "MARK READ ONLY WHERE date <=
> > 2006" would have to move tuples around between segments, so as to be
> > able to satisfy the split point exactly, right?
>
> Yes, just a simple WHERE clause that we can translate into segments
> under the covers. It would be an alter table, so we get an exclusive
> lock.
>
> ALTER TABLE foo SET READ ONLY WHERE ....
>
> possibly with a few restrictions on the WHERE clause. Anyway this is
> just futures and dreams, so far, so lets just say something like that is
> possible in the future and work out more when we pass the first few
> hurdles.
Not to be negative, but istm how this feature would be managed is as important
as the bits under the hood. Or at least we have to believe there will be
some practical way to manage this, which as of yet I am skeptical.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
In response to
Responses
pgsql-hackers by date
Next :From: Warren TurkalDate: 2008-01-05 07:23:56Subject : Re: timestamp typedefsPrevious :From : Tom LaneDate : 2008-01-05 03:09:30Subject : Re: OUTER JOIN performance regression remains in 8.3beta4
