How filesystems matter with PostgreSQL

Поиск
Список
Период
Сортировка
От Jon Schewe
Тема How filesystems matter with PostgreSQL
Дата
Msg-id 4C08EEDF.7090403@mtu.net
обсуждение исходный текст
Ответы Re: How filesystems matter with PostgreSQL  ("J. Roeleveld" <joost@antarean.org>)
Re: How filesystems matter with PostgreSQL  (Andres Freund <andres@anarazel.de>)
Re: How filesystems matter with PostgreSQL  (Greg Smith <greg@2ndquadrant.com>)
Список pgsql-performance
Some interesting data about different filesystems I tried with
PostgreSQL and how it came out.

I have an application that is backed in postgres using Java JDBC to
access it. The tests were all done on an opensuse 11.2 64-bit machine,
on the same hard drive (just ran mkfs between each test) on the same
input with the same code base. All filesystems were created with the
default options.

XFS (logbufs=8): ~4 hours to finish
ext4: ~1 hour 50 minutes to finish
ext3: 15 minutes to finish
ext3 on LVM: 15 minutes to finish


--
Jon Schewe | http://mtu.net/~jpschewe
If you see an attachment named signature.asc, this is my digital
signature. See http://www.gnupg.org for more information.


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

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Re: Weird XFS WAL problem
Следующее
От: "J. Roeleveld"
Дата:
Сообщение: Re: How filesystems matter with PostgreSQL