Some Improvement

From: Tim Perdue <tperdue(at)valinux(dot)com>
To: pgsql-hackers(at)hub(dot)org
Subject: Some Improvement
Date: 2000-07-12 23:28:31
Message-ID: 396CFF1F.392F16B2@valinux.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I added the suggested index and changed my sql and the subjective tests
seem to be improved somewhat. I checked EXPLAIN and it is using the new
index.

I still think there must be sorting going on, as the result is returned
instantly if you remove the ORDER BY. I don't know - I do think it's
much better now.

Thanks for all your help - I (of course) will let you know if I have any
troubles with corruption on 7.0.2 ;-)

Tim

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-07-12 23:29:58 Re: [7.0.2] INDEX' TUPLES != HEAP' ..
Previous Message The Hermit Hacker 2000-07-12 23:17:51 Re: [7.0.2] INDEX' TUPLES != HEAP' ..