Re: Sql-bench

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jason-Czerak(at)Jasnik(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sql-bench
Date: 2000-11-25 16:44:25
Message-ID: 640.975170665@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jason J. Czerak" <Jason-Czerak(at)Jasnik(dot)net> writes:
> Anyone here ever try to run MySQL's 'crash-me' benchmark
> agained Postgresql? I did. it said it ran out of memeory.

Last time I tried to run crash-me against PG (7.0.something),
Postgres was just fine but the perl process running the crash-me
script expanded past the kernel's per-process memory limit and
crashed. Their scheme for detecting the maximum allowable query
length is evidently not very bulletproof.

I had to reduce the script's $max_buffer_size setting to "+1000000"
to get it to run to completion.

In short, it's crash-me that's crashing, not Postgres.
Pretty funny...

regards, tom lane

In response to

  • Sql-bench at 2000-11-25 07:57:36 from Jason J. Czerak

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-11-25 16:46:46 Re: Table whose name has Capital letters
Previous Message Alim Akkaya 2000-11-25 15:33:35 cannot read block 0 of pg_shadow