| From: | Robert Lor <Robert(dot)Lor(at)Sun(dot)COM> |
|---|---|
| To: | Chris Mair <list(at)1006(dot)org> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>, pgsql-performance(at)postgresql(dot)org, llonergan(at)greenplum(dot)com |
| Subject: | Re: bad performance on Solaris 10 |
| Date: | 2006-04-06 07:36:37 |
| Message-ID: | 4434C505.1000205@sun.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Chris Mair wrote:
>Ok, so I did a few runs for each of the sync methods, keeping all the
>rest constant and got this:
>
>open_datasync 0.7
>fdatasync 4.6
>fsync 4.5
>fsync_writethrough not supported
>open_sync 0.6
>
>in arbitrary units - higher is faster.
>
>Quite impressive!
>
>
>
>
Chris,
Just to make sure the x4100 config is similar to your Linux system, can
you verify the default setting for disk write cache and make sure they
are both enabled or disabled. Here's how to check in Solaris.
As root, run "format -e" -> pick a disk -> cache -> write_cache -> display
Not sure how to do it on Linux though!
Regards,
-Robert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leigh Dyer | 2006-04-06 07:42:27 | Re: Sun Fire T2000 and PostgreSQL 8.1.3 |
| Previous Message | Miguel | 2006-04-06 07:32:41 | Re: Sun Fire T2000 and PostgreSQL 8.1.3 |