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

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: SELECT's take a long time compared to other DBMS
Date: 2003-09-04 04:43:45
Message-ID: NEBBLAAHGLEEPCGOBHDGOEBKIDAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

This apparently wasn't the source of problem since he did an analyze anyway,
but my impression was that a fresh brand new database is exactly the
situation where an analyze is needed- ie: a batch of data has just been
loaded and stats haven't been collected yet.

Am I mistaken?

-Nick

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-09-04 05:03:08 Re: SELECT's take a long time compared to other DBMS
Previous Message Rod Taylor 2003-09-04 03:36:36 Re: PostgreSQL Reliability when fsync = false on Linux-XFS