Re: Single client performance on trivial SELECTs

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Single client performance on trivial SELECTs
Date: 2011-04-15 17:30:55
Message-ID: 4DA880CF.8020103@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 04/15/2011 09:59 AM, Joshua Berkus wrote:
> All,
>
> While it would be nice to improve our performance on this workload, let me point out that it's not a very important workload from the point of view of real performance challenges. Yes, there are folks out there with 100MB databases who only run one-liner select queries. But frankly, Valemort/Redis/Mongo are going to whip both our and MySQL's butts on that kind of workload anyway.

Yes but if we can kick MySQL's butt, that would certainly be a good
thing. There are people (lots of people) that do not like the whole
Valemort/Redis/Mongo paradigm.

> Certainly any sacrifice of functionality in order to be faster at that kind of trivial workload would be foolhardy.

Agreed.

JD

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Radosław Smogura 2011-04-15 17:36:44 Re: MMAP Buffers
Previous Message jagan 2011-04-15 17:29:27 Re: WAL, xl_heap_insert and tuple oid mystry