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

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Dann Corbit <DCorbit(at)connx(dot)com>
Cc: johnnnnnn <john(at)phaedrusdeinus(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] I feel the need for speed. What am I doing
Date: 2003-01-08 14:30:11
Message-ID: Pine.LNX.4.33.0301080729310.31321-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-01-08 14:51:01 Re: sync()
Previous Message Christopher Kings-Lynne 2003-01-08 14:30:02 Re: psql and readline