Re: Performance with very large tables

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(at)archonet(dot)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(at)archonet(dot)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
>