Re: Poor performance on seq scan - Mailing list pgsql-performance

From Guillaume Cottenceau
Subject Re: Poor performance on seq scan
Date
Msg-id 874pvdxnw9.fsf@meuh.mnc.lan
Whole thread Raw
In response to Re: Poor performance on seq scan  (Laszlo Nagy <gandalf@designaproduct.biz>)
List 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 by date:

Previous
From: Laszlo Nagy
Date:
Subject: Re: Poor performance on seq scan
Next
From: Guillaume Cottenceau
Date:
Subject: Re: Poor performance on seq scan