Re: postgres: writer process,what does this process actually do?

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Thomas <freebsdjlu(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres: writer process,what does this process actually do?
Date: 2009-12-22 15:26:44
Message-ID: 2f4958ff0912220726v45f23178t9cb5b1d88f500dab@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 22, 2009 at 10:19 AM, Thomas <freebsdjlu(at)gmail(dot)com> wrote:
> Does it write data to data files to make buffer "clean"?if it
> does ,but I can not find open files from the result of lsof -p
>  PID.
>

writer actually takes care about writing pages down, from shared
memory. It is the central point that accesses disk on behalf of all
backends (which are spawned every time you create new connection).

--
GJ

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raimon Fernandez 2009-12-22 16:01:34 Extended Query vs Simple Query
Previous Message Adrian Klaver 2009-12-22 15:04:10 Re: table-valued arguments for functions