Re: 7.0.2 issues / Geocrawler

From: Tim Perdue <tperdue(at)valinux(dot)com>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>, pgsql-hackers(at)hub(dot)org
Subject: Re: 7.0.2 issues / Geocrawler
Date: 2000-07-12 17:54:09
Message-ID: 396CB0C1.84505FB4@valinux.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-07-12 17:56:29 Re: Serious Performance Loss in 7.0.2??
Previous Message Lamar Owen 2000-07-12 17:48:57 Re: Slashdot discussion