Re: performace review - Mailing list pgsql-general

From Jonathan Vanasco
Subject Re: performace review
Date
Msg-id FB037A60-44B9-497C-A9E6-B22BC8D9B462@2xlp.com
Whole thread Raw
In response to Re: performace review  (Alexander Staubo <alex@purefiction.net>)
Responses Re: performace review
List pgsql-general
On Oct 7, 2006, at 3:31 PM, Alexander Staubo wrote:

> I don't see PostgreSQL being "bashed sentence after sentence",
> however -- the two "known limitations" listed for PostgreSQL are
> "slow (even for small datasets)" and "jokes [sic] on 3-table-joins"
> -- and among the open-source databases mentioned, PostgreSQL is
> described as scaling the highest.

did you notice this line
---------------

*** Please note that we do not recommend PostgreSQL for production
use. While PostgreSQL may be fine for many settings this DBMS simply
does not deliver the performance required for openCRX (PostgreSQL
takes minutes/hours to calculate 3-table-joins even for small data
sets).

---------------

that sounds to me like someone never vacuumed and analyzed their db.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: increment row number function question
Next
From: Poul Møller Hansen
Date:
Subject: Re: Sun Java Studio Creator and PostgreSQL