From: | Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Inheritance efficiency |
Date: | 2010-05-01 10:47:36 |
Message-ID: | w2pe94e14cd1005010347wcdc0893akf35500e46918e9c3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2010/5/1 John R Pierce <pierce(at)hogranch(dot)com>:
> Greg Smith wrote:
>>
>> Enterprise grade doesn't mean anything. Partitioning designs that require
>> thousands of child tables to work right are fundamentally misdesigned
>> anyway, so there is no reason for any of the contributors to the project to
>> work on improving support for them. There are far too many obvious
>> improvements that could be made to PostgreSQL, ones that will benefit vastly
>> more people, to divert resources toward something you shouldn't be dong
>> anyway like that.
>>
>
> my sql developer, who's been doing oracle for 15+ years, says postgres'
> partitioning is flawed from his perspective because if you have a prepared
> statement like..
>
> SELECT fields FROM partitioned_table WHERE primarykey = $1;
>
> it doesn't optimize this very well and ends up looking at all the sub-table
> indicies. ir you instead execute the statement
>
> SELECT fields FROM parritioned_table WHERE primarykey = constant;
>
> he says the planner will go straight to the correct partition.
>
> i haven't confirmed this for myself.
It has nothing to do with partitionning but how the planner works.
Even if the use case remain correct....
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Cédric Villemain
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2010-05-01 10:56:38 | Re: Inheritance efficiency |
Previous Message | Vincenzo Romano | 2010-05-01 08:59:27 | Re: Inheritance efficiency |