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

From: Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>
To: Relaxin <me(at)yourhouse(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SELECT's take a long time compared to other DBMS
Date: 2003-09-04 01:32:38
Message-ID: 3F569636.4090809@oasis.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

>Yes I Analyze also, but there was no need to because it was a fresh brand
>new database.
>

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.

I'll keep an eye on this thread - Good luck.

Regards
Rudi.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Conway 2003-09-04 01:54:37 Re: SELECT's take a long time compared to other DBMS
Previous Message Relaxin 2003-09-04 01:24:31 Re: SELECT's take a long time compared to other DBMS