From: | "Mike Gould" <mgould(at)allcoast(dot)net> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Partitioned tables and views |
Date: | 2008-07-31 16:54:46 |
Message-ID: | 20080731165446.3a41ac86@mail.allcoast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have several tables that we have partitioned by physical location. This seems to give us the best overall performance when doing location specific queries. I have a few questions.
1. Is the planner/optimizer intelligent enough to know when we are not doing a query based on location? For example we might have a trailer that is used by multiple locations and we need to know all of the locations where that trailer has been used. Other queries might look for a specific work order that could only be in one of the partitions.
2. How are views handled with partitioned tables? I don't find anything in the documentation that tells me how views are handled. Depending on the view will it only use the partitioned table or will it use the master table?
Best Regards
Michael Gould
From | Date | Subject | |
---|---|---|---|
Next Message | David R Robison | 2008-07-31 16:56:40 | Re: Doing an LDAP lookup from a SQL SELECT |
Previous Message | Tom Lane | 2008-07-31 16:50:50 | Re: Cursor Error |