Re: Performance with very large tables - Mailing list pgsql-general

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