Thread: 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.
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 mailing list archive at Nabble.com.