Thread: Sql-bench

Anyone here ever try to run MySQL's  'crash-me' benchmark
agained Postgresql?  I did. it said it ran out of memeory.
didn't crash postgres but I thought my server was dead. but
thigns came back to life.   I have 256meg ram and 64 meg
swap file and  mysql ran the test fine byt PostgreSQL
failed.


I know this benchmark prolly means jack but I was just
wondering... :)


--
Jason J. Czerak (Jason-Czerak@Jasnik.net)
  Linux Systems Evangelist

Jasnik Services, LLC
  http://www.Jasnik.net

"Jason J. Czerak" <Jason-Czerak@Jasnik.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