Skip site navigation (1) Skip section navigation (2)

Re: BUG #2260: PGCrypto Memory Problem

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Daniel Blaisdell <lunk(dot)djedi(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2260: PGCrypto Memory Problem
Date: 2006-02-15 18:20:43
Message-ID: 20060215182043.GA84192@winnie.fuhr.org (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-02-15 18:21:48
Subject: Re: BUG #2260: PGCrypto Memory Problem
Previous:From: Tom LaneDate: 2006-02-15 17:44:18
Subject: Re: BUG #2261: ILIKE seems to be buggy on koi8 input

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group