Re: Does anyone use in ram postgres database?

As a  kind of [very?] dumb question, is this where SQLite has been
used?  I am just curious.


On Mar 26, 2010, at 3:14 PM, Ozz Nixon wrote:

> On 3/26/10 10:06 AM, Alan McKay wrote:
>> On Thu, Mar 25, 2010 at 4:15 PM, Scott Marlowe<scott.marlowe@gmail.com
>> >  wrote:
>>
>>> These questions always get the first question back, what are you
>>> trying to accomplish?  Different objectives will have different
>>> answers.
>>>
>> We have a real-time application that processes data as it comes in.
>> Doing some simple math tells us that a disk-based DB cannot possible
>> perform fast enough to allow us to process the data.
>>
>
> I have to ask the obvious question... as we develop solutions which
> must process 100,000 queries a second. In those cases, we use a
> combination hash table and link-lists. There are times where SQL is
> not the right choice, it is great for simplifying indexing and locks
> - but prior to SQL *we* had to write code guys... and it sounds like
> you too need to go back to old-school programming techniques.
>
> O.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general