I have run fsync_test on this partition, and I got 2500+ for all kind of
sync method.
dmesg says:
blkfront: xvde: barriers enabled
blkfront: xvda: barriers enabled
One thing I haven't mentioned yet, that this a VM virtualized with Xen.
Perhaps this has some effect.
Thanks,
Otto
2011/12/20 Gre
Thank you guys for the ideas and suggestions, I will check them.
Best regards,
Otto
On 12/19/2011 10:52 AM, Havasvölgyi Ottó wrote:
PgSql 9.1.2
Debian, 2.6.32 kernel
WAL filesystem: ext4 with defaults
There's a pg_test_fsync program included with the postgresql-contrib
package that might help you sort out what's going on here. This will
eliminate the possibility that you're
* Havasvölgyi Ottó:
> 2011/12/19 Florian Weimer
>
>> * Havasvölgyi Ottó:
>>
>> > Even though the TPS in pgbench about 700 with 1 client.
>> > I have tried other sync methods (fdatasync, open_sync), but all are
>> similar.
>> > Should I disable write cache on HDD to make it work?
>>
>> Did you mou
2011/12/19 Florian Weimer
> * Havasvölgyi Ottó:
>
> > Even though the TPS in pgbench about 700 with 1 client.
> > I have tried other sync methods (fdatasync, open_sync), but all are
> similar.
> > Should I disable write cache on HDD to make it work?
>
> Did you mount your ext4 file system with th
2011/12/19 Tomas Vondra
> On 19 Prosinec 2011, 16:52, Havasvölgyi Ottó wrote:
> > config:
> > fsync=on
> > sync_commit=on
> > wal_sync_method=fsync
>
> I don't think you need to set wal_sync_method, comment it out.
>
> > Even though the TPS in pgbench about 700 with 1 client.
> > I have tried ot
* Havasvölgyi Ottó:
> Even though the TPS in pgbench about 700 with 1 client.
> I have tried other sync methods (fdatasync, open_sync), but all are similar.
> Should I disable write cache on HDD to make it work?
Did you mount your ext4 file system with the nobarrier option?
By default, ext4 is s
On 19 Prosinec 2011, 16:52, Havasvölgyi Ottó wrote:
> config:
> fsync=on
> sync_commit=on
> wal_sync_method=fsync
I don't think you need to set wal_sync_method, comment it out.
> Even though the TPS in pgbench about 700 with 1 client.
> I have tried other sync methods (fdatasync, open_sync), but
