Re: Effect of stopped status collector process - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Effect of stopped status collector process
Date
Msg-id 20081126123047.GA4275@alvh.no-ip.org
Whole thread Raw
In response to Re: Effect of stopped status collector process  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Merlin Moncure escribió:
> On Tue, Nov 25, 2008 at 9:03 AM, Alvaro Herrera
> <alvherre@commandprompt.com> wrote:

> > Why do we _have_ to write the file to disk?  I wonder if it would work
> > to store the file in a mmaped memory region and have the readers get
> > data from there.  We could have more than one copy, reference-counted so
> > that they can be removed when the old readers are gone.
>
> what about fifo files...would they be appropriate for something like this?

Doubtful -- the collector would have to write the contents every time
someone wanted to read it, and nobody could open it while someone else
is reading (or they'd read from the middle of the contents).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Clemens Schwaighofer
Date:
Subject: Re: Postgres 8.3 only uses seq scan
Next
From: Tom Lane
Date:
Subject: Re: slow, long-running 'commit prepared'