Re: [PERFORM] FreeBSD config

2004-03-01 Thread Mark Kirkwood
I noticed this passage too, but ... Quoting from http://www.daemonnews.org/21/freebsd_vm.html : snip* When To Free a Page* Since the VM system uses all available memory for disk caching, there ^ The VM system, as you can see from the article, is focused on

Re: [PERFORM] compiling 7.4.1 on Solaris 9

2004-03-01 Thread Andrew Sullivan
On Thu, Feb 26, 2004 at 12:46:23PM +, teknokrat wrote: I've read about the place. Would using -O3 be an improvement? In my experience, it's not only not an improvement, it sometimes breaks the code. That's on 8, though, not 9. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of

[PERFORM] Scaling further up

2004-03-01 Thread Anjan Dave
Title: Message All: We havea Quad-Intel XEON 2.0GHz (1MB cache), 12GB memory, running RH9, PG 7.4.0. There's an internal U320, 10K RPM RAID-10 setup on 4 drives. We are expecting apretty high load,a few thousands of 'concurrent' users executing either select, insert, update, statments.

Re: [PERFORM] WAL Optimisation - configuration and usage

2004-03-01 Thread Rob Fielding
Further update to my WAL experimentation. pg_xlog files have increased to 81, and checking today up to 84. Currently nothing much going on with the server save a background process running a select every 30 seconds with almost no impact (according to IO from vmstats). This in itself is a good

Re: [PERFORM] WAL Optimisation - configuration and usage

2004-03-01 Thread Simon Riggs
Rob Fielding wrote: My focus today has been on WAL - I've not looked at WAL before. By increasing the settings thus : wal_buffers = 64 # need to determin WAL usage wal_files = 64 # range 0-64 wal_sync_method = fsync # the default varies across platforms: wal_debug = 0 # range

Re: [PERFORM] WAL Optimisation - configuration and usage

2004-03-01 Thread Josh Berkus
Simon, Please set WAL_DEBUG to 1 so we can see a bit more info: thanks. I'm pretty sure that WAL_DEBUG requires a compile-time option. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched

Re: [PERFORM] Scaling further up

2004-03-01 Thread Josh Berkus
Anjan, Other than the disks, I am curious what other people are using in terms of the horsepower needed. The Quad server has been keeping up, but we are expecting quite high loads in the near future, and I am not sure if just by having the disks on a high-end storage will do it. Do a