From: | Keaton Adams <kadams(at)mxlogic(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Persistent objects within PG or the availability of non-logged tables or databases? |
Date: | 2008-04-08 17:19:57 |
Message-ID: | C421055D.3529%kadams@mxlogic.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Is there a way to manage a queue in memory within Postgres?
We have a scenario where we have a list of servers stored in a table. Multiple clients make a request for the next "group" of servers to process. Something within the database needs to keep track of the last server set that was passed back to a client so the entire server list is rotated through in a round-robin fashion. Is there a way for an object (variable/table/etc) to remain persistent in memory that is shared among multiple client sessions? If not, an alternative we thought of is to use a small table within the DB in conjunction with a function to keep track of the last set of data. The question we have, though, is the rate at which the table is updated (possibly many times per second) and the amount of WAL data that is generated by this operation.
Is there such as thing as a non-logged table or a non-logged database in PG?
I have looked through the docs and can't find anything on this subject, so I thought someone on the list might know of a feature (current or upcoming) that might be helpful.
Thanks,
Keaton
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Caduto | 2008-04-08 17:21:56 | Re: Number or parameters for functions - limited to 32 ? |
Previous Message | Andrew Falanga | 2008-04-08 17:02:33 | How does psql actually implement the \d commands |