Re: High update activity, PostgreSQL vs BigDBMS

Поиск
Список
Период
Сортировка
От Lars Heidieker
Тема Re: High update activity, PostgreSQL vs BigDBMS
Дата
Msg-id D047C103-FB89-4CC4-B18C-55C8CA35434E@heidieker.de
обсуждение исходный текст
Ответ на Re: High update activity, PostgreSQL vs BigDBMS  (Ragnar <gnari@hive.is>)
Ответы Re: High update activity, PostgreSQL vs BigDBMS  ("Jeremy Haile" <jhaile@fastmail.fm>)
Список pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On 2 Jan 2007, at 14:54, Ragnar wrote:

> On þri, 2007-01-02 at 09:04 -0500, Geoffrey wrote:
>> Alvaro Herrera wrote:
>>>
>>> Actually it has been suggested that a combination of ext2 (for
>>> WAL) and
>>> ext3 (for data, with data journalling disabled) is a good performer.
>>> AFAIK you don't want the overhead of journalling for the WAL
>>> partition.
>>
>> I'm curious as to why ext3 for data with journalling disabled?  Would
>> that not be the same as ext2?
>
> I believe Alvaro was referring to ext3 with journalling enabled
> for meta-data, but not for data.
> I also believe this is the standard ext3 configuration, but I
> could be wrong on that.
>
> gnari
>
>
it doesn't really belong here but ext3 has
data journaled (data and meta data)
ordered (meta data journald but data written before meta data (default))
journald (meta data only journal)
modes.

The performance differences between ordered and meta data only
journaling should be very small enyway

- --

Viele Grüße,
Lars Heidieker

lars@heidieker.de
http://paradoxon.info

- ------------------------------------

Mystische Erklärungen.
Die mystischen Erklärungen gelten für tief;
die Wahrheit ist, dass sie noch nicht einmal oberflächlich sind.
      -- Friedrich Nietzsche



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFFmnJUcxuYqjT7GRYRApNrAJ9oYusdw+Io4iSZrEITTbFy2qDA4QCgmBW5
7cpQZmlIv61EF2wP2yNXZhA=
=glwc
-----END PGP SIGNATURE-----

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

Предыдущее
От: Ragnar
Дата:
Сообщение: Re: High update activity, PostgreSQL vs BigDBMS
Следующее
От: "Jeremy Haile"
Дата:
Сообщение: Re: High update activity, PostgreSQL vs BigDBMS