From: | viraj <mayuraviraj(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How does the PostgreSQL partition pruning happens ? |
Date: | 2014-07-01 04:08:14 |
Message-ID: | 1404187694733-5809921.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi ,
I'm new to postgres and going through it's documentation. I have problem
about partition pruning in postgres.
In postgres partition is done by child tables. My problem are,
1. when we issue a query to master table , does the query optimizer do
partition pruning ? i.e select appropriate child table rather than going
through all the child tables.
2. How does the query optimizer do the partition pruning ? My concern is
unlike other databases we don't give partition column in postgres
partitioning process. So how does the query optimizer knows what is the
partition column ?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-does-the-PostgreSQL-partition-pruning-happens-tp5809921.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | viraj | 2014-07-01 04:50:36 | Re: How does the PostgreSQL partition pruning happens ? |
Previous Message | John R Pierce | 2014-07-01 02:59:21 | Re: how to create multiple databases running in different dirs |