Re: BUG #2260: PGCrypto Memory Problem

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