Home > mailing lists

Re: [GENERAL] I feel the need for speed. What am I doing - Mailing list pgsql-hackers

From	scott.marlowe
Subject	Re: [GENERAL] I feel the need for speed. What am I doing
Date	January 8, 2003 12:37:15
Msg-id	Pine.LNX.4.33.0301080729310.31321-100000@css120.ihs.com Whole thread Raw
In response to	Re: [GENERAL] I feel the need for speed. What am I doing wrong? ("Dann Corbit" <DCorbit@connx.com>)
List	pgsql-hackers

Tree view

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

pgsql-hackers by date:

From: Christopher Kings-Lynne
Date: 08 January 2003, 12:30:10
Subject: Re: psql and readline

From: Bruce Momjian
Date: 08 January 2003, 12:51:30
Subject: Re: sync()

Re: [GENERAL] I feel the need for speed. What am I doing - Mailing list pgsql-hackers

Previous

Next