Postgres Pro
Downloads
Home   >   mailing lists

Re: alter table set tablespace over nfs getting stuck - Mailing list pgsql-novice

From s anwar
Subject Re: alter table set tablespace over nfs getting stuck
Date
Msg-id 3e3c86f90601171723v825f1ebq4fe1f0668910ea24@mail.gmail.com
Whole thread Raw
In response to Re: alter table set tablespace over nfs getting stuck  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view
Thank you. That is working much better.

Regards.

On 1/17/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
s anwar <sanwar@gmail.com> writes:
> My NFSed directory is mounted
> "rw,tcp,hard,intr,rsize=8192,wsize=8192".

ISTR some discussion recently about INTR not being a good idea on NFS
mounts.  Does it work any better without that?  You might also try
sticking to the default rsize/wsize, whatever it happens to be.

                        regards, tom lane

pgsql-novice by date:

Previous
From: Andrew Chambers
Date:
Subject: Re: Finding and replacing text within records
Next
From: "Anthony Presley"
Date:
Subject: Huge size of Data directory