Postgres Pro
Downloads
Home   >   mailing lists

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

From Rudi Starcevic
Subject Re: SELECT's take a long time compared to other DBMS
Date
Msg-id 3F569636.4090809@oasis.net.au
Whole thread Raw
In response to Re: SELECT's take a long time compared to other DBMS  ("Relaxin" <me@yourhouse.com>)
Responses Re: SELECT's take a long time compared to other DBMS
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: "Relaxin"
Date:
Subject: Re: SELECT's take a long time compared to other DBMS
Next
From: "Relaxin"
Date:
Subject: Re: SELECT's take a long time compared to other DBMS