Re: Table Partitioning Advice Request

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
Cc: David Fetter <david(at)fetter(dot)org>, Sam Jas <samjas33(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Table Partitioning Advice Request
Date: 2009-12-17 15:28:23
Message-ID: 87eimtk4bs.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> writes:
> Is there any performance study for the trigger-based implementation?

Consider that if you use RULE to partition, when you DROP a partition
the INSERTs are locked out because the query depends on the table being
droped.

That alone could lead you to stop considering RULEs for partitioning.
--
dim

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincenzo Romano 2009-12-17 15:29:52 Re: Table Partitioning Advice Request
Previous Message Tom Lane 2009-12-17 15:24:28 Re: Automatic truncation of character values & casting to the type of a column type