Search Postgresql Archives

Re: Does anyone use in ram postgres database?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx > 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux