Re: SELECT's take a long time compared to other DBMS

From: Neil Conway <neilc(at)samurai(dot)com>
To: Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>
Cc: Relaxin <me(at)yourhouse(dot)com>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: SELECT's take a long time compared to other DBMS
Date: 2003-09-04 01:54:37
Message-ID: 1062640477.14620.7.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Conway 2003-09-04 02:01:10 Re: Query on Postgresql performance
Previous Message Rudi Starcevic 2003-09-04 01:32:38 Re: SELECT's take a long time compared to other DBMS