From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-performance@postgresql.org
Subject: Re: MemSQL the "world's fastest database"?
Date: Mon, 25 Jun 2012 16:15:31 -0400
Message-ID: <29682.1340655331@sss.pgh.pa.us> (raw)
In-Reply-To: <201206251802.060128@ms20.lnh.mail.rcn.net>
References: <CAFwQ8rcpbZsR3Ndk8GoVsqGhc8y+M8siBmMDN1X=mom4uAO8ZQ@mail.gmail.com>
<4FE899CE.60901@optionshouse.com>
<201206251802.060128@ms20.lnh.mail.rcn.net>
<gnuoytr@rcn.com> writes:
>> Then there's this from the article:
>>
>> "The key ideas are that SQL code is translated into C++, so avoiding the
>> need to use a slow SQL interpreter, and that the data is kept in memory,
>> with disk read/writes taking place in the background."
>>
>> Besides the nonsense statement that SQL is translated to C++ (Lexical
>> scanners would circumvent even this step, and does that mean you have to
>> literally compile the resulting C++? Ridiculous.) ...
> DB2 on the mainframe (if memory serves), for one, will compile static SQL to machine code. Not that unusual.
Yeah. Actually such techniques go back at least to the fifties (look up
"sort generators" sometime). They are out of fashion now because
(1) the achievable speed difference isn't what it once was, and
(2) programs that execute self-modified code are prone to seriously
nasty security issues. Get any sort of control over the code generator,
and you can happily execute anything you want.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us
Subject: Re: MemSQL the "world's fastest database"?
In-Reply-To: <29682.1340655331@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox