Re: PG on NFS may be just a bad idea

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: PG on NFS may be just a bad idea
Дата
Msg-id 1191915861.4223.601.camel@ebony.site
обсуждение исходный текст
Ответ на Re: PG on NFS may be just a bad idea  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, 2007-10-01 at 19:25 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > http://blogs.netapp.com/dave/2007/08/oracle-optimize.html
> 
> Not a whole lot of technical content there, but pretty interesting
> nonetheless.  I *think* that the issues we're seeing are largely in the
> NFS client-side kernel code, so bypassing that stack as Oracle is doing
> might eliminate the problem.  Of course, there's a sizable amount of
> code to be written to do that ...

Yeh, that would take a while.

I thought of another reason to do that also.

If you put a tablespace on an NFS mount and the remote server crashes,
it sounds like there could be a window of potential data loss. We could
guard against that by recovering the tablespace, but we don't do that
unless the local server crashes. 

So having your own NFS client would allow you to tell that the link had
dropped and needed to be recovered.

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Gokulakannan Somasundaram"
Дата:
Сообщение: Re: Including Snapshot Info with Indexes
Следующее
От: "Gokulakannan Somasundaram"
Дата:
Сообщение: Re: Including Snapshot Info with Indexes