pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
wal_sync_method on FreeBSD 9.0 - ZFS
3+ messages / 2 participants
[nested] [flat]

* wal_sync_method on FreeBSD 9.0 - ZFS
@ 2012-09-14 20:19  Sébastien Lorion <sl@thestrangefactory.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Sébastien Lorion @ 2012-09-14 20:19 UTC (permalink / raw)
  To: pgsql-performance

I am not able to set wal_sync_method to anything but fsync on FreeBSD 9.0
for a DB created on ZFS (I have not tested on UFS). Is that expected ? Has
it anything to do with running on EC2 ?

Sébastien

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: wal_sync_method on FreeBSD 9.0 - ZFS
@ 2012-09-17 10:56  Ivan Voras <ivoras@freebsd.org>
  parent: Sébastien Lorion <sl@thestrangefactory.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Ivan Voras @ 2012-09-17 10:56 UTC (permalink / raw)
  To: pgsql-performance

On 14/09/2012 22:19, Sébastien Lorion wrote:
> I am not able to set wal_sync_method to anything but fsync on FreeBSD 9.0
> for a DB created on ZFS (I have not tested on UFS). Is that expected ? Has
> it anything to do with running on EC2 ?

Can you explain what prevents you for setting the wal_sync_method?

Attachments:

  signature.asc (application/pgp-signature, 259B) download

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: wal_sync_method on FreeBSD 9.0 - ZFS
@ 2012-09-22 14:01  Sébastien Lorion <sl@thestrangefactory.com>
  parent: Ivan Voras <ivoras@freebsd.org>
  0 siblings, 0 replies; 3+ messages in thread

From: Sébastien Lorion @ 2012-09-22 14:01 UTC (permalink / raw)
  To: Ivan Voras <ivoras@freebsd.org>; +Cc: pgsql-performance

I don't remember the exact error message, but basically, if I set it to
anything else but fsync, when I start PostgreSQL, it tells me that the new
method is not available on my platform.

Sébastien

On Mon, Sep 17, 2012 at 6:56 AM, Ivan Voras <ivoras@freebsd.org> wrote:

> On 14/09/2012 22:19, Sébastien Lorion wrote:
> > I am not able to set wal_sync_method to anything but fsync on FreeBSD 9.0
> > for a DB created on ZFS (I have not tested on UFS). Is that expected ?
> Has
> > it anything to do with running on EC2 ?
>
> Can you explain what prevents you for setting the wal_sync_method?
>
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2012-09-22 14:01 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-09-14 20:19 wal_sync_method on FreeBSD 9.0 - ZFS Sébastien Lorion <sl@thestrangefactory.com>
2012-09-17 10:56 ` Ivan Voras <ivoras@freebsd.org>
2012-09-22 14:01   ` Sébastien Lorion <sl@thestrangefactory.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox