Re: BUG #2260: PGCrypto Memory Problem - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: BUG #2260: PGCrypto Memory Problem
Date
Msg-id 20060215182043.GA84192@winnie.fuhr.org
Whole thread Raw
In response to BUG #2260: PGCrypto Memory Problem  ("Daniel Blaisdell" <lunk.djedi@gmail.com>)
Responses Re: BUG #2260: PGCrypto Memory Problem
List pgsql-bugs
On Tue, Feb 14, 2006 at 05:28:25PM +0000, Daniel Blaisdell wrote:
> Problem Query:
> select * from table where md5password = crypt('password',salt)
>
> The first time this query is run, I see the postgres process bump up to 8MB
> of ram from where it initializes.
>
> On subsequent issues of the same query the postgres's process memory
> footprint grows each time.

I can reproduce this in 8.1.3 on FreeBSD 6.0 and Solaris 9.  Here's
a standalone test case:

SELECT crypt(x::text, '$1$salt') FROM generate_series(1, 500) AS g(x);

Running the query with 'salt' instead of '$1$salt' doesn't exhibit
a memory leak, not even with more iterations from generate_series.

--
Michael Fuhr

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2261: ILIKE seems to be buggy on koi8 input
Next
From: Tom Lane
Date:
Subject: Re: BUG #2260: PGCrypto Memory Problem