Re: [PERFORM] Questions about 2 databases.

y stuff off the master db and using 1 transaction instead of 175 to the disk based master db. Thanks, Jelle ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[PERFORM] Questions about 2 databases.

ple RAID-1 spindles, profiled the queries, maxed the CPU/ram. Migrating to 64bit fedora soon. Thanks, this mailing list has been invaluable. Jelle ---(end of broadcast)--- TIP 8: explain analyze is your friend

[PERFORM] iostat question

0.09 10.51 2.76 0.21 The /sdc1's await seems awfully long compared to the rest to the stats. Jelle -- http://www.sv650.org/audiovisual/loading_a_bike.mpeg Osama-in-October office

Re: [PERFORM] Context Switching issue: Spinlock doesn't fix.

Hello, Is context switching problem resolved in 8.0? Can I drop in another Xeon? Thanks, Jelle On Wed, 2 Jun 2004, Josh Berkus wrote: > Folks, > > I've been testing varying SPINS_PER_DELAY in a client's installation of > PostgreSQL against a copy of a production dat

Re: [PERFORM] Wierd context-switching issue on Xeon

Same problem with dual 1Ghz P3's running Postgres 7.4.2, linux 2.4.x, and 2GB ram, under load, with long transactions (i.e. 1 "cannot serialize" rollback per minute). 200K was the worst observed with vmstat. Finally moved DB to a single xeon box. ---(end of broadcast)-