Skip site navigation (1) Skip section navigation (2)

Re: Dynamic Partitioning using Segment Visibility Maps

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Markus Schiltknecht <markus(at)bluegap(dot)ch>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Dynamic Partitioning using Segment Visibility Maps
Date: 2008-01-07 13:12:53
Message-ID: 1199711573.5646.5.camel@PCD12478 (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, 2008-01-07 at 13:59 +0100, Markus Schiltknecht wrote:
> However, for tables which don't fit the use case of SE, people certainly 
> don't want such a fill factor to bloat their tables.

Sure, but it could be configurable and should only be enabled if the
table is marked as partitioned on some condition... I think it would be
a bad idea anyway if the DB would start partitioning on some arbitrary
criteria based on analyzing he table, so the DBA should be the one to
decide on what criteria to partition. In particular it could be a bad
idea on occasions to partition on the clustering criteria for tables
which were clustered once.

Cheers,
Csaba.



In response to

Responses

pgsql-hackers by date

Next:From: Markus SchiltknechtDate: 2008-01-07 13:20:02
Subject: Re: Dynamic Partitioning using Segment Visibility Maps
Previous:From: Doug KnightDate: 2008-01-07 13:07:32
Subject: Re: Tuning Postgresql on Windows XP Pro 32 bit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group