Re: [GENERAL] How does the PostgreSQL partition pruning happens ?

Got following answer, http://dba.stackexchange.com/questions/69411/postgresql-partition-pruning/69413#69413 -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-does-the-PostgreSQL-partition-pruning-happens-tp5809921p5809923.html Sent from the PostgreSQL - general maili

[GENERAL] 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 chil