Re: Loading optimization - Mailing list pgsql-general

From Ian Harding
Subject Re: Loading optimization
Date
Msg-id 3A58C162.FFCB98D7@pakrat.com
Whole thread Raw
In response to Loading optimization  (Gary Wesley <gary@db.stanford.edu>)
List pgsql-general
Gary Wesley wrote:

> Is there any advantage to having data sorted before populating it into a
> table?
> (In 6.5)
>
> Gary Wesley

Yes.  You have effectively loaded it with a clustered index.  If you
cluster an index on the sort column after loading it, the sort will remain
in effect and will speed queries/joins that use that column.

Ian


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index on Date_Trunc
Next
From: Ian Harding
Date:
Subject: Re: Function TOP