> -----Original Message-----
> From: scott.marlowe [mailto:scott.marlowe@ihs.com] 
> Sent: Wednesday, January 08, 2003 6:30 AM
> To: Dann Corbit
> Cc: johnnnnnn; pgsql-hackers@postgresql.org
> Subject: Re: [GENERAL] [HACKERS] I feel the need for speed. 
> What am I doing wrong?
> 
> > No analyze for 7.1.3.
> > Just ran vacuum a few minutes before the query.  No boost at all.  
> > Even with SET enable_seqscan = 0 it still does a table scan.
> 
> Dann, I can attest to 7.2 having a much better planner and 
> performance 
> than 7.1 did.  Can you upgrade?

No, not yet.  I am using a native Win32 port that we did ourselves.
Once the PostgreSQL team completes the Win32 port, I will abandon this
code base and use that code.  This is for a commercial enterprise and
Cygwin is out of the question because of the distribution problems.

Wed, 8 Jan 2003 11:02:13 -0800
"Dann Corbit" <DCorbit@connx.com>
Re: [GENERAL] I feel the need for speed. What am I doing  wrong?