Re: wal files on temporary tables - Mailing list pgsql-general

From Enver ALTIN
Subject Re: wal files on temporary tables
Date
Msg-id 20060814212340.GF15142@mercata.parkyeri.net
Whole thread Raw
In response to wal files on temporary tables  (marcelo Cortez <jmdc_marcelo@yahoo.com.ar>)
List pgsql-general
On Mon, Aug 14, 2006 at 05:32:41PM -0300, marcelo Cortez wrote:
> folks

Hi,

> I have a asp application connected with postgres.  The postgres
> temporary tables is useless because i need remain this tables between
> sessions, perfomance reasons.  This tables are created on the fly and
> remain between session but asp server finalize connection and
> temporary table are dropped .  Then i've  created "normal" tables but
> the wal file generated by this tables grows and grows.  This wal file
> ares useless , temporary information here.  what is the way to not
> generate wal files for this tables? to identify these archives not to
> put them in backup

I'd suggest using right tool for the job. I think you can go with
memcached[1] instead of PostgreSQL.

-HTH

[1] http://www.danga.com/memcached/
--
Enver

Attachment

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: select updates pg_stat_database
Next
From: Tom Lane
Date:
Subject: Re: wal files on temporary tables