Greg, >8MB working out best is > really unexpected though; I'd like to know what you were doing where *that* > was the optimal setting. Developer machine, XP professional, 1 Gig memory. other applications are running, ~2-4 concurrent acceses to PostgreSQL. Value was in the 200MB range, system trashed the harddrive badly. Setting down to 8MB, and DB acesses AND the rest of the system run much smoother. Did not benchmark queries; difference between settings was too obvious (from many seconds down to <2 seconds) A server (2Gig, win2003, 8.4) is set to 32MB and runs as smoothly as with 128. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - %s is too gigantic of an industry to bend to the whims of reality -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
