On Wed, Jun 26, 2013 at 05:04:11PM +0200, Markus Wanner wrote: > On 06/26/2013 04:01 PM, k...@rice.edu wrote: > > I think he is referring to the fact that with parallel query execution, > > multiple partitions can be processed simultaneously instead of serially > > as they are now with the resulting speed increase. > > Processing simultaneously is the purpose of parallel query execution, > yes. But I see no reason for that not to work equally well for > unpartitioned tables.
Well, I think by definition you are going to be able to spread lookups for a particular range across more partitions with 'hash' than with range or list partitioning. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
