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.
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2006-02-15 18:21:48|
|Subject: Re: BUG #2260: PGCrypto Memory Problem |
|Previous:||From: Tom Lane||Date: 2006-02-15 17:44:18|
|Subject: Re: BUG #2261: ILIKE seems to be buggy on koi8 input |