Re: OT: Munin (was Re: [PERFORM] Determining server load from client)

2007-03-24 Thread CAJ CAJ
On 3/21/07, Erik Jones <[EMAIL PROTECTED]> wrote: On Mar 21, 2007, at 4:13 PM, Tobias Brox wrote: [Erik Jones - Wed at 09:31:48AM -0500] I use cacti (http://cacti.net) which does the same thing that munin does but in php instead. Here's what I use to db stats to it (again, php): I haven't

Re: [PERFORM] Optimization postgresql 8.1.4 FC 6 X64 ?

2007-03-24 Thread Dave Cramer
I also think there have been changes in pgbench itself. Make sure you run the same pgbench on both servers. Dave On 24-Mar-07, at 6:44 AM, Heikki Linnakangas wrote: amrit angsusingh wrote: I try to change my database server from the older one ie. 2Cpu Xeon 2.4 32 bit 4Gb SDram Hdd SCSI RAID

Re: [PERFORM] [HACKERS] EXISTS optimization

2007-03-24 Thread Martijn van Oosterhout
On Fri, Mar 23, 2007 at 05:30:27PM -0500, Kevin Grittner wrote: > I don't understand -- TRUE OR UNKNOWN evaluates to TRUE, so why would > the IN need to continue? I'm not quite following the rest; could you > elaborate or give an example? (Sorry if I'm lagging behind the rest > of the class here.

Re: [PERFORM] Optimization postgresql 8.1.4 FC 6 X64 ?

2007-03-24 Thread Heikki Linnakangas
amrit angsusingh wrote: I try to change my database server from the older one ie. 2Cpu Xeon 2.4 32 bit 4Gb SDram Hdd SCSI RAID 5 and FC 3 ix86 with 7..4.7 PG to the newer one with 2CPU Xeon 3.0 64 Bit 4Gb DDRram SCSI Raid5 and FC6 X64 PG 8.14 and try to use rather the same parameter from the pre