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