On Fri, Jul 04, 2003 at 08:07:18PM +0200, Arjen van der Meijden wrote: > > Andrew Sullivan wrote: > > results under production conditions, and not bother to read > > even the basic "quickstart"-type stuff that is kicking > > around. > Then please point out where it sais, in the documentation, that the > value for the shared_memory of 64 is too low and that 4000 is a nice > value to start with?
I think I did indeed speak too soon, as the criticism is a fair one: nowhere in the installation instructions or the "getting started" docs does it say that you really ought to do some tuning once you have the system installed. Can I suggest for the time being that something along these lines should go in 14.6.3, "Tuning the installation": ---snip--- By default, PostgreSQL is configured to run on minimal hardware. As a result, some tuning of your installation will be necessary before using it for anything other than extremely small databases. At the very least, it will probably be necessary to increase your shared buffers setting. See Chapter 16 for details on what tuning options are available to you. ---snip--- > I'm sorry to put this in a such a confronting manner, but you simply > can't expect people to search for information that they don't know the > existence of. No need to apologise; I think you're right. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <[EMAIL PROTECTED]> M2P 2A8 +1 416 646 3304 x110 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org