From: | Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com> |
---|---|
To: | Ian Harding <iharding(at)pakrat(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: Loading optimization |
Date: | 2001-01-09 12:16:46 |
Message-ID: | 3A5B012E.749AF623@cupid.suninternet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ian Harding wrote:
>
> 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.
But does postgres actually use the fact that the data is clustered? I
keep thinking that here I could cluster all our data such that a
sequential
search is almost always a bad idea but I have no idea how to relate that
fact to postgres...
--
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Gubis | 2001-01-09 12:35:05 | connection timeout |
Previous Message | Ken Corey | 2001-01-09 12:01:02 | Re: Advice on stored proc error handling versus Sybase? |