From:
Markus Schiltknecht <markus(at)bluegap(dot)ch>
To:
Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc:
Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>,
Sam Mason <sam(at)samason(dot)me(dot)uk>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Dynamic Partitioning using Segment Visibility Maps
Date:
2008-01-04 12:39:42
Message-ID:
477E290E.2040100@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,
Simon Riggs wrote:
> - any Fact table where measurements/observations/events are accumulated
> e.g.
> Web Hits (any Internet events)
> Call Detail Records
> Sales
> Security Events
> Scientific Measurements
> Process Control
>
> - any Major Entity where new entities are created from a sequence
> e.g.
> Orders, OrderItems
> Invoices
> Shipments, Returns
> most SCM/DCM events
...and only changed very seldom after a while, I would add. Because
changing an old tuple would invalidate the optimization for the affected
segment.
That's why this optimization can't help for inventory tables, where an
id might correlate with time and storage location, but writing access
doesn't correlate with storage location (segment number) and time.
Regards
Markus
In response to
pgsql-hackers by date
Next :From: Markus SchiltknechtDate: 2008-01-04 12:49:27Subject : Re: Dynamic Partitioning using Segment Visibility MapsPrevious :From : Markus SchiltknechtDate : 2008-01-04 12:29:55Subject : Re: Dynamic Partitioning using Segment Visibility Maps
