Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle

Поиск
Список
Период
Сортировка
От Chris Mair
Тема Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
Дата
Msg-id 1147947373.7943.35.camel@dell.home.lan
обсуждение исходный текст
Ответ на Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2  ("Olivier Andreotti" <olivier.andreotti@gmail.com>)
Ответы Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle  ("Olivier Andreotti" <olivier.andreotti@gmail.com>)
Список pgsql-performance
Hello :)

What version would PostgreSQL 8.1.4 be?

> I'm running a benchmark with theses 3 databases, and the first results
> are not very good for PostgreSQL.

Could you give us some more infos about the box' performance while you
run the PG benchmark? A few minutes output of "vmstat 10" maybe? What
does "top" say?

> My benchmark uses the same server for theses 3 databases :
> Dell Power edge - Xeon 2.8 Ghz - 2 Go Ram - 3 SCSI disks - Debian
> Sarge - Linux 2.6

How are you using the 3 disks? Did you split pg_xlog and the database
on different disks or not?

> The transactions are a random mix of request in read (select) and
> write (insert, delete, update) on many tables about 100 000 to 15 000
> 000 rows.
>
> Transactions are executed from 500 connections.

Can you say something about the clients? Do they run over network from
other hosts? What language/bindings do they use?

When they do inserts, are the inserts bundled or are there
single insert transactions? Are the statements prepared?


Bye, Chris.





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

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: Lot'sa joins - performance tip-up, please?
Следующее
От: "Olivier Andreotti"
Дата:
Сообщение: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle