Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4
Дата
Msg-id 200308272102.26319.shridhar_daithankar@persistent.co.in
обсуждение исходный текст
Ответы Re: Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4  (Neil Conway <neilc@samurai.com>)
Список pgsql-performance
Hi all,

I did some benchmarking using pgbench and postgresql CVS head, compiled
yesterday.

The results are attached. It looks like 2.6.0-test4 does better under load but
under light load the performance isn't that great. OTOH 2.4.20 suffer major
degradation compare to 2.6. Looks like linux is also getting heavy at lower
end. Of course it isn't as bad as solaris as yet..:-)

IIRC in a kernel release note recently, it was commented that IO scheduler is
still being worked on and does not perform as much for random seeks, which
exaclty what database needs.

How does these number stack up with other platforms? Anybody with SCSI disks
out there? I doubt IDE has some role to play with this.

Comments?

 Shridhar

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Hardware recommendations to scale to silly load
Следующее
От: "Anders K. Pedersen"
Дата:
Сообщение: Queries sometimes take 1000 times the normal time