How does the PostgreSQL partition pruning happens ?

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.