Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: 12 Sep 2006 14:36:22 +0200
- Message-id: <874pvdxnw9(dot)fsf(at)meuh(dot)mnc(dot)lan>
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/
- References:
- Re: Poor performance on seq scan
- From: Luke Lonergan
- Re: Poor performance on seq scan
- From: Laszlo Nagy
- Re: Poor performance on seq scan
- Prev by Date: Re: Poor performance on seq scan
- Next by Date: Re: Poor performance on seq scan
- Previous by thread: Re: Poor performance on seq scan
- Next by thread: Re: Poor performance on seq scan
- Indexes: