Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT's take a long time compared to other DBMS - Mailing list pgsql-performance

From Neil Conway
Subject Re: SELECT's take a long time compared to other DBMS
Date
Msg-id 1062640477.14620.7.camel@tokyo
Whole thread Raw
In response to Re: SELECT's take a long time compared to other DBMS  (Rudi Starcevic <rudi@oasis.net.au>)
List pgsql-performance
Tree view 
On Wed, 2003-09-03 at 21:32, Rudi Starcevic wrote:
> Hmm ... Sorry I'm not sure then. I only use Linux with PG.
> Even though it's 'brand new' you still need to Analyze so that any
> Indexes etc. are built.

ANALYZE doesn't build indexes, it only updates the statistics used by
the query optimizer (and in any case, "select * from <foo>" has only one
reasonable query plan anyway).

-Neil

pgsql-performance by date:

Previous
From: "Relaxin"
Date:
Subject: Re: SELECT's take a long time compared to other DBMS
Next
From: Neil Conway
Date:
Subject: Re: Query on Postgresql performance