On Tue, 8 Apr 2008 11:19:57 -0600 Keaton Adams <kadams@xxxxxxxxxxx> wrote: > 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. You could use pg_memcache. > > Is there such as thing as a non-logged table or a non-logged database > in PG? No but if the updates taking place are on columns that are not indexed (and you are running 8.3) then HOT will kick in and the load is significantly reduced. E.g.; CREATE TABLE foo (id serial pk, bar text); UPDATE foo SET bar = 'baz'; Will not create a dead row and thus greatly reduces overall load and maintenance requirements. SIncerely, Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
