After running ldconfig I then recompiled Postgres 8.1.2 againt the newly installed libraries and ended up with the same results. Michael's standalone testcase was blowing up the memory usage very quickly.
I did notice as I was doing more testing that if i disconnect my client after running subsequent queries that the memory usage drops due to the server process getting killed.
Other Possibly Useful info:
CFLAGS="-O3 -march=pentium4 -pipe"
MAKEOPTS="-j3"
I'm going to try compiling with the -ssl USE flag set to avoid any external libraries and attempt to duplicate this bug. I'll let you know what results I find.
-Daniel
On 2/15/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Wed, Feb 15, 2006 at 01:43:18PM -0500, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > 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);
>
> Interesting, because I see no leak with this example on Fedora 4 or
> HPUX. Platform dependency is sounding more and more likely.
Did you test OpenSSL builds? Both of my systems are built with
OpenSSL and that causes pgcrypto to use different code in some
places (e.g., px_find_digest() in internal.c and openssl.c). I'll
build and test a non-OpenSSL version when I get a chance.
--
Michael Fuhr
