Postgres Pro
Downloads
Home   >   mailing lists

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

From Nick Fankhauser
Subject Re: SELECT's take a long time compared to other DBMS
Date
Msg-id NEBBLAAHGLEEPCGOBHDGOEBKIDAA.nickf@ontko.com
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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

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