From: | Michael Widenius <monty(at)mysql(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Justin Clift <justin(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org, Anna Ewerlid <Anna(dot)Ewerlid(at)signal(dot)uu(dot)se>, jamppa(at)mysql(dot)com |
Subject: | Re: [Fwd: MySQL Benchmark page - Problem with vacuum() in PostgreSQL] |
Date: | 2001-08-07 19:52:36 |
Message-ID: | 200108071952.f77JqaZ32158@tik.mysql.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
Tom> Justin Clift <justin(at)postgresql(dot)org> forwards:
>> The problem was that when we run the benchmark with the --fast option,
>> which basicly does a vacuum() between after each batch of updates,
>> postmaster started to fill up disk with log files during one of the
>> vacuum() runs and didn't stop until the disk was full.
Tom> See
Tom> http://www.ca.postgresql.org/mhonarc/pgsql-patches/2001-06/msg00061.html
Tom> regards, tom lane
Thanks!
I will look at this as soon as I am back home from my vacation and
then do a new benchmark run and update the benchmark page.
Regards,
Monty
PS: If anyone has any ideas of things that we have missed in our
current benchmark pages, please email them to Anna so that she can
add these to the next generation of the benchmark suite.
Some things that I know we have missed in the single user
benchmark are:
- Sub select (all different forms of sub select, with a comparison
to normal selects for those select that can be
changed to normal selects)
- Foreign keys (which should contain a comparison with multi-table-delete)
- Transactions
- Rollback
With comparison I mean that there should be at least one test that
makes it easy for the user to see which construct is better for
this database.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2001-08-07 20:19:42 | Re: Very Precision Time for Database Server |
Previous Message | wsheldah | 2001-08-07 19:52:07 | Re: Problems with Blank space |