> -----Original Message----- > From: scott.marlowe [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 08, 2003 6:30 AM > To: Dann Corbit > Cc: johnnnnnn; [EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
