[PERFORM] performance using table partitions in Postgres 8.2.6

Hi. I am looking for information about using table partitions in Postgres, in particular w.r.t. performance when querying a partitioned table. I implemented table partitioning following the documentation, which is quite good and easy to follow (Chapter 5.9). I am doing some testing, so at this

Re: [PERFORM] performance using table partitions in Postgres 8.2.6

A Dilluns 07 Abril 2008, Janet Jacobsen va escriure: no. of partitions constraint_exclusion off constraint_exclusion on 2 0.597 ms0.427 ms 4 0.653 ms0.414 ms 8