Re: Poor performance on seq scan

Поиск
Список
Период
Сортировка
От Guillaume Cottenceau
Тема Re: Poor performance on seq scan
Дата
Msg-id 874pvdxnw9.fsf@meuh.mnc.lan
обсуждение исходный текст
Ответ на Re: Poor performance on seq scan  (Laszlo Nagy <gandalf@designaproduct.biz>)
Список pgsql-performance
Laszlo Nagy <gandalf 'at' designaproduct.biz> writes:

> This is a mirrored disk with two SATA disks. In theory, writing should
> be slower than reading. Is this a hardware problem? Or is it that
> "sync" did not do the sync?

SATA disks are supposed to be capable of lying to pg's fsync (pg
asking the kernel to synchronize a write and waiting until it is
finished). Same can probably happen to the "sync" command.

--
Guillaume Cottenceau
Create your personal SMS or WAP Service - visit http://mobilefriends.ch/

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

Предыдущее
От: Laszlo Nagy
Дата:
Сообщение: Re: Poor performance on seq scan
Следующее
От: Guillaume Cottenceau
Дата:
Сообщение: Re: Poor performance on seq scan