Re: [GENERAL] I feel the need for speed. What am I doing wrong?

> -----Original Message-----
> From: scott.marlowe [mailto:scott(dot)marlowe(at)ihs(dot)com]
> Sent: Wednesday, January 08, 2003 6:30 AM
> To: Dann Corbit
> Cc: johnnnnnn; pgsql-hackers(at)postgresql(dot)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.