> -----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.