Re: Table Partitioning Advice Request - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: Table Partitioning Advice Request
Date
Msg-id 87eimtk4bs.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: Table Partitioning Advice Request  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Responses Re: Table Partitioning Advice Request  (Vincenzo Romano <vincenzo.romano@notorand.it>)
List pgsql-general
Vincenzo Romano <vincenzo.romano@notorand.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

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: Table Partitioning Advice Request
Next
From: Sam Mason
Date:
Subject: Re: Automatic truncation of character values & casting to the type of a column type