Postgres Pro
Downloads
Home   >   mailing lists

Re: Single client performance on trivial SELECTs - Mailing list pgsql-hackers

From Joshua Berkus
Subject Re: Single client performance on trivial SELECTs
Date
Msg-id 1912074302.261500.1302886780524.JavaMail.root@mail-1.01.com
Whole thread Raw
In response to Re: Single client performance on trivial SELECTs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Single client performance on trivial SELECTs  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Single client performance on trivial SELECTs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
All,

While it would be nice to improve our performance on this workload, let me point out that it's not a very important
workloadfrom the point of view of real performance challenges.  Yes, there are folks out there with 100MB databases who
onlyrun one-liner select queries.  But frankly, Valemort/Redis/Mongo are going to whip both our and MySQL's butts on
thatkind of workload anyway.
 

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

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
San Francisco

pgsql-hackers by date:

Previous
From: Joshua Berkus
Date:
Subject: Re: MMAP Buffers
Next
From: jagan
Date:
Subject: Re: WAL, xl_heap_insert and tuple oid mystry