Re: Memory Leak

I am using Postgres 7.0.2 :)

Sorry about that.  I promise to put done my crack pipe before I send emails :)

Justin Foster wrote:

> Hello,
>
> RedHat 7.0, Postgres 7.1 (libpq), Intel Cel 433, 64mb, 15g hd.
>
> I am running a test which performs 1000 transactions of 1000 updates of a single column in a single table, or (1
tranaction= 1000 updates) * 
> 1000.  I have no indecies for any of the columns and the table has 3 columns and 200 records.  I do a VACUUM ANALYZE
afterevery transaction. A 
> single transaction takes about 3-6 seconds.
>
> It appears that RAM decreases at about 10 to 100K a second until it is all gone.  Any thoughts on how I can
optimise/configurethe db to 
> alleviate this problem?  Any hints on where this leak maybe occurring?
>
> Thanks,
> -justin