Re: Poor performance on seq scan

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: Laszlo Nagy <gandalf(at)designaproduct(dot)biz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor performance on seq scan
Date: 2006-09-12 12:36:22
Message-ID: 874pvdxnw9.fsf@meuh.mnc.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Laszlo Nagy 2006-09-12 12:36:55 Re: Poor performance on seq scan
Previous Message Laszlo Nagy 2006-09-12 12:15:30 Re: Poor performance on seq scan