Aggregating results across multiple partitions

From: "Mike O'Connel" <mikeocon333(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Aggregating results across multiple partitions
Date: 2011-08-02 20:20:13
Message-ID: CAOFRuTQZcnxra3oXybvhXvUEuTmYC7EC1L-VLk_-1NMjnR5-dg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi

I see that some queries are not Order(n) where n=number of partitions.
However, if one were to run the query separately against different
partitions and aggregate the results it could be Order(n). Can such an
approach be implemented in a more generic manner in pgsql?

Thanks
Mike

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Landscheidt 2011-08-03 04:05:26 Re: Help with regexp-query
Previous Message Charlie 2011-08-02 17:06:05 Re: [SQL] Help with regexp-query