Re: PostgreSQL 7.4beta5 vs MySQL 4.0.16 with RT(DBIx::SearchBuilder)

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: mallah(at)trade-india(dot)com
Cc: pgsql-performance(at)postgresql(dot)org, jesse(at)fsck(dot)com
Subject: Re: PostgreSQL 7.4beta5 vs MySQL 4.0.16 with RT(DBIx::SearchBuilder)
Date: 2003-10-29 20:03:44
Message-ID: 20031029200344.GA36028@perrin.nxad.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> So its not just PostgreSQL that is suffering from the bad SQL but
> MySQL also. But the question is my does PostgreSQL suffer so badly
> ?? I think not all developers write very nice SQLs.
>
> Its really sad to see that a fine peice of work (RT) is performing
> sub-optimal becoz of malformed SQLs. [ specially on database of my
> choice ;-) ]

Post EXPLAIN ANALYZES of the queries you're running, then maybe you'll
be able to get some useful help from this list. Until then, it's very
hard to speculate as to why PostgreSQL is slower. -sc

--
Sean Chittenden

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message mallah 2003-10-29 20:18:43 Re: PostgreSQL 7.4beta5 vs MySQL 4.0.16 with RT(DBIx::SearchBuilder)
Previous Message Jesse 2003-10-29 19:51:15 Re: PostgreSQL 7.4beta5 vs MySQL 4.0.16 with RT(DBIx::SearchBuilder)