Re: why so many open files?

On Mon, Jun 02, 2008 at 09:38:29AM -0400, Tom Lane wrote:
> That's not very surprising at all: a backend might have to write out a
> dirty buffer in order to reclaim the buffer for re-use, and which
> database the page is from doesn't enter into that.
> What does seem surprising is that it's had to do that quite a lot.
> Is this an old PG version without a bgwriter process? In a properly
> functioning recent release, I'd expect only the bgwriter to have a
> really eclectic mix of open files.

# select version();
version
-----------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.2.7 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
(1 row)

# select name, setting from pg_settings where name ~ 'bgw';
name | setting
-----------------------+---------
bgwriter_all_maxpages | 5
bgwriter_all_percent | 0.333
bgwriter_delay | 200
bgwriter_lru_maxpages | 5
bgwriter_lru_percent | 1
(5 rows)

should i show any more information?

regards,

depesz