| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Checkpoint_segments optimal value |
| Date: | 2014-07-26 02:05:30 |
| Message-ID: | 53D30CEA.5080101@hogranch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On 7/25/2014 5:58 PM, Prabhjot Sheena wrote:
> We do have i/o problem during heavy loads because we share mount point
> from netapp across different machines which we are getting rid in few
> weeks by moving stuff to Amazon aws and than IO issues will go away
> with fast iops
Netapp has to be some of the most expensive storage I've ever seen in a
datacenter and is frequently a source of performance problems. NFS
isn't really appropriate for storing database data on, there's way too
many opportunites for fsync to get lost, more so if you've got a
virtualization layer in there too.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2014-07-26 02:59:44 | Re: Can't get a standby built |
| Previous Message | Prabhjot Sheena | 2014-07-26 00:58:43 | Re: Checkpoint_segments optimal value |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | byfei163@163.com | 2014-07-26 06:35:58 | Re: PG_TERMINATE_BACKEND not working. |
| Previous Message | Prabhjot Sheena | 2014-07-26 00:58:43 | Re: Checkpoint_segments optimal value |