Re: NFS/NAS - Mailing list pgsql-novice

From Tom Lane
Subject Re: NFS/NAS
Date
Msg-id 2405.1025236549@sss.pgh.pa.us
Whole thread Raw
In response to NFS/NAS  ("James Kelty" <jamesk@ashlandagency.com>)
Responses Re: NFS/NAS  ("James Kelty" <jamesk@ashlandagency.com>)
List pgsql-novice
"James Kelty" <jamesk@ashlandagency.com> writes:
> How well does Postgres handle running the DB from a NAS?

Postgres doesn't care, although a lot of the oldtimers here will tell
you not to use NFS for any data you care about.  Check the archives
for some horror stories.

> For instance, can I
> have 10 single cpu systems all running the Postgres daemon with the data
> directory on a NetApp or some other device?

This will NOT work.  One data directory, one postmaster, no more.

Multi CPUs in an SMP box is fine, but not independent systems.

            regards, tom lane



pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: command length?
Next
From: Julie Keywell
Date:
Subject: DISTINCT and COUNT help