| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | anj patnaik <patna73(at)gmail(dot)com> |
| Cc: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: can postgres run well on NFS mounted partitions? |
| Date: | 2015-11-11 02:59:44 |
| Message-ID: | CAOR=d=0F5XcxjPdr0V5d2ZBn-qChCqSxY+X4T=kLVZhcRCad0A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Nov 10, 2015 at 4:26 PM, anj patnaik <patna73(at)gmail(dot)com> wrote:
> Thanks for the feedback. I have setup a second Linux VM (running RHEL 5.11)
> and Postgres 9.4. I ran some insertions today from a client running on
> Windows. The client does a loop of 30 updates.
>
> I am seeing about 10-20% increase in latency in the case where DB is on NFS
> (over TCP) compared to directly on disk.
>
> The other machine I am using to compare is running RHEL 6.5 and Postgres
> 9.4.
>
> Are there any specific tests that are recommended to test that postgres over
> NFS works well?
>
> I am planning on doing a few large data inserts and fetches.
>
> With the little testing, the DB over NFS appears fine.
You need to do a power failure test. While running something like
pgbench for a few minutes, run a checkpoint command and then pull the
plug on the NFS server and / or the pg server. Bring it back up. Is
your db corrupted? Then there's something that needs fixing.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2015-11-11 08:37:32 | Re: can postgres run well on NFS mounted partitions? |
| Previous Message | Scott Mead | 2015-11-11 02:40:50 | Re: can postgres run well on NFS mounted partitions? |