| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: horizontal sharding |
| Date: | 2009-06-27 05:59:24 |
| Message-ID: | dcc563d10906262259n72a2e82awacb7ff77a6c44ae7@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jun 15, 2009 at 11:36 AM, John R Pierce<pierce(at)hogranch(dot)com> wrote:
> Jim Mlodgenski wrote:
>>
>>
>> also is it possible to paritition without changing client code
>>
>> Yes, but it depends on the SQL in your client code. If you are just using
>> simple SQL with no stored functions, you should be able to slip in either
>> solution without changing the client code.
>
> what about queries that need to do joins or aggregate reporting across the
> partitions?!? I can't see how that could be done transparently short of
> something like Oracle RAC.
You could make something reasonably fast and partitioned with pl/proxy
and views.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mobiledreamers | 2009-06-27 07:17:00 | Re: horizontal sharding |
| Previous Message | Scott Marlowe | 2009-06-27 05:53:15 | Re: horizontal sharding |