| From: | Chris Mair <list(at)1006(dot)org> |
|---|---|
| To: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
| Cc: | pgsql-performance(at)postgresql(dot)org, josh(at)agliodbs(dot)com, llonergan(at)greenplum(dot)com |
| Subject: | Re: bad performance on Solaris 10 |
| Date: | 2006-04-05 23:29:40 |
| Message-ID: | 1144279780.5133.19.camel@dell.home.lan |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> > I've done a few tests.
> >
> > Remounting the fs where $PGDATA lives with "forcedirectio"
> > (together with logging, that is default) did not help
> > (if not harm...) performance.
> >
> >
>
> Sure - forcedirectio on the entire $PGDATA is a definite loss, you only
> want it on $PGDATA/pg_xlog. The usual way this is accomplished is by
> making a separate filsystem for pg_xlog and symlinking from $PGDATA.
>
> Did you try the other option of remounting the fs for $PGDATA without
> logging or forcedirectio?
not yet, I'm not on the final disk set yet.
when I get there I'll have two separate filesystems for pg_xlog and base
and will try what you suggest.
(but note the other mail about wal_sync_method = fsync)
bye, chris.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Mair | 2006-04-05 23:33:07 | Re: bad performance on Solaris 10 |
| Previous Message | Mark Kirkwood | 2006-04-05 23:25:36 | Re: bad performance on Solaris 10 |