| From: | Robert Treat <robert(at)omniti(dot)com> |
|---|---|
| To: | Blazej <bl(dot)oleszkiewicz(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> |
| Subject: | Re: about partitioning |
| Date: | 2008-09-15 14:05:46 |
| Message-ID: | 48CE6BBA.5010203@omniti.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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:
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reg Me Please | 2008-09-15 14:18:45 | Re: Oracle and Postgresql |
| Previous Message | David Fetter | 2008-09-15 13:58:47 | Re: Oracle and Postgresql |