| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
| Cc: | Brian Hurt <bhurt(at)spnz(dot)org>, Josh Berkus <josh(at)agliodbs(dot)com>, <pgsql-advocacy(at)postgresql(dot)org> |
| Subject: | Re: Probable faq: need some benchmarks of pgsql vr.s mysql |
| Date: | 2010-10-30 16:20:30 |
| Message-ID: | 7f7fc6c04bf8c90ee94e48032228cdc3@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy |
On Sat, 30 Oct 2010 15:57:39 +0200, Stefan Kaltenbrunner
<stefan(at)kaltenbrunner(dot)cc> wrote:
> On 10/29/2010 11:37 PM, Brian Hurt wrote:
>>
>> For the record, the table we're having trouble inserting into is ~100
>> rows with ~50 indexes on it. E.F Codd is spinning in his grave. The
>> reason they went with this design (instead of one that has two tables,
>> each with 3-6 columns, and about that many indexes) is that "joins are
>> slow". Which they may be on Mysql, I don't know. But this is
>> (unfortunately) a different battle.
As opposed to the slowness you are having now?
/me smacks your developers for you
JD
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2010-10-30 20:24:49 | Re: Probable faq: need some benchmarks of pgsql vr.s mysql |
| Previous Message | Stefan Kaltenbrunner | 2010-10-30 13:57:39 | Re: Probable faq: need some benchmarks of pgsql vr.s mysql |