Re: performace review

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: performace review
Date: 2006-10-07 20:47:10
Message-ID: FB037A60-44B9-497C-A9E6-B22BC8D9B462@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Poul Møller Hansen 2006-10-07 21:12:54 Re: Sun Java Studio Creator and PostgreSQL
Previous Message Tom Lane 2006-10-07 20:42:03 Re: increment row number function question