Re: about partitioning

Blazej wrote:
> 8><
>> For some more info, I've given at least one presentation on the topic, which
>> seems to be missing from the omniti site, but I've uploaded it to
>> slideshare...
>> http://www.slideshare.net/xzilla/postgresql-partitioning-pgcon-2007-presentation
>>
>> HTH.
>>
> 8><
>
> Very nice presentation. I have 2 additional questions:
>
> (1) Are you testing INSERT/UPDATE performance when is only one rule
> script for all partition tables?

I've tested a number of different scenarios; I guess I'd say as a
general rule, the more rules you have, likely the worse your performance
will get; but really I would use triggers anyway

> (2) Are you using "SET constraint_exclusion = on;"?
>

yes, otherwise there isnt much point :-)

--
Robert Treat
http://www.omniti.com/
Database: Scalability: Consulting: