Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.0.2 issues / Geocrawler - Mailing list pgsql-hackers

From Tim Perdue
Subject Re: 7.0.2 issues / Geocrawler
Date
Msg-id 396CB0C1.84505FB4@valinux.com
Whole thread Raw
In response to Re: 7.0.2 issues / Geocrawler  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: 7.0.2 issues / Geocrawler  (The Hermit Hacker <scrappy@hub.org>)
Re: 7.0.2 issues / Geocrawler  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
The Hermit Hacker wrote:
> just curious, but what if you remove the ORDER BY, just to test ... is it
> that much faster without then with?  Just want to narrow down *if* its a
> sorting issue or not, that's all ...

Good call - it was instantaneous as it used to be.

> If it is a sorting issue, what if you raise the -S value?

-S is 32768 right now

Tim

-- 
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723

pgsql-hackers by date:

Previous
From: Tim Perdue
Date:
Subject: Re: AW: 7.0.2 issues / Geocrawler
Next
From: Tom Lane
Date:
Subject: Re: Serious Performance Loss in 7.0.2??