On 12/25/10, Mladen Gogala <mladen.gogala@xxxxxxxxxxx> wrote: > Jeff Janes wrote: >> If the background writer cannot keep up, then the individual backends >> start doing writes as well, so it isn't really serialized.. >> >> > Is there any parameter governing that behavior? No, it is automatic. There are parameters governing how likely it is that bgwriter falls behind in the first place, though. http://www.postgresql.org/docs/9.0/static/runtime-config-resource.html In particular bgwriter_lru_maxpages could be made bigger and/or bgwriter_delay smaller. But bulk copy binary might use a nondefault allocation strategy, and I don't know enough about that part of the code to assess the interaction of that with bgwriter. > Can you tell me where in > the code (version 9.0.2) can I find that? Thanks. Bufmgr.c, specifically BufferAlloc. Cheers, Jeff -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
