Oh yes, need to have a condition first for which you have partitioned tables. Only in that case it will work with partitions.
--------------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/15/07, Richard Huxton <dev@archonet.com> wrote:
Shoaib Mir wrote: > You can also opt for partitioning the tables and this way select will only > get the data from the required partition. Not in the case of SELECT * FROM <table> though. Unless you access the specific partitioned table. > On 1/15/07, Richard Huxton <dev@archonet.com> wrote: >> >> Jan van der Weijde wrote: >> > Hello all, >> > >> > one of our customers is using PostgreSQL with tables containing >> millions >> > of records. A simple 'SELECT * FROM <table>' takes way too much >> time in >> > that case, so we have advised him to use the LIMIT and OFFSET clauses. -- Richard Huxton Archonet Ltd
