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 after every 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/configure the db to
> alleviate this problem? Any hints on where this leak maybe occurring?
>
> Thanks,
> -justin