Re: Postgresql simple query performance question

Hi
we are testing with version PostgreSQL 8.2.3. We already have a production system in Oracle and we wanted to migrate it to postgresql. If some tests are already done, are the results available for us to see?
Ill also check postgres 8.3 beta.
Thanks again
Sharmila

----- Original Message ----
From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>; pgsql-general(at)postgresql(dot)org
Sent: Wednesday, November 7, 2007 6:34:26 AM
Subject: Re: [GENERAL] Postgresql simple query performance question

On Tue, 2007-11-06 at 09:29 -0500, Bill Moran wrote:
> In response to SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>:
>
> > Hi
> > We are in the process of testing for migration of our database from
Oracle to Postgresql.
> > I hava a simple query
> >
> > Select count(*) from foo
>
> This is asked a lot. The quick answer is that PostgreSQL method of
MVCC
> makes it impossible to make this query fast. Perhaps, someday, some
> brilliant developer will come up with an optimization, but that
hasn't
> happened yet.

What release level is being tested? It may already have happened.

8.3 is substantially faster at seq scans, so the tests should be re-run
on 8.3 beta.

Also, re-run the Postgres test. It should be faster the second time,
even if the database server is restarted between tests.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

---------------------------(end of
broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com