Persistent objects within PG or the availability of non-logged tables or databases?

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

Responses

Browse pgsql-general by date

  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