Re: [PERFORM] "Mysterious" issues with newly installed 8.3

On Mon, 13 Oct 2008, Carlos Moreno wrote: Another really handy way to gauge memory speed on Linux, if there are similar kernels installed on each system like your case, is to use "hdparm -T". Great tip! I was familiar with the -T switch, but was not clear on the notion that the figure tells y

Re: [PERFORM] "Mysterious" issues with newly installed 8.3

Scott Marlowe wrote: > On Mon, Oct 13, 2008 at 8:55 AM, Carlos Moreno <[EMAIL PROTECTED]> wrote: > >> I guess my logical next step is what was suggested by Scott --- install >> 8.2.4 and repeat the same tests with this one; that should give me >> interesting information. >> > > I'd suggest

Re: [PERFORM] "Mysterious" issues with newly installed 8.3

On Mon, Oct 13, 2008 at 8:55 AM, Carlos Moreno <[EMAIL PROTECTED]> wrote: > I guess my logical next step is what was suggested by Scott --- install > 8.2.4 and repeat the same tests with this one; that should give me > interesting information. I'd suggest updating to the latest 8.2.x update as we

Re: [PERFORM] "Mysterious" issues with newly installed 8.3

Thanks Greg and others for your replies, > This is really something to watch out for. One quick thing first > though: what frequency does the CPU on the new server show when you > look at /proc/cpuinfo? If you see "cpu MHz: 1000.00" It was like that in the initial setup --- I just disabled t

Re: [PERFORM] "Mysterious" issues with newly installed 8.3

On Thu, 9 Oct 2008, Scott Carey wrote: Sure, the processor should be faster, but Athlon64s / Opterons are very sensitive to the RAM used and its performance and tuning. So, you should find some basic CPU benchmarks and RAM benchmarks -- you'll want to measure latency as well as bandwidth. Athl

Re: [PERFORM] "Mysterious" issues with newly installed 8.3

On Thu, 9 Oct 2008, Craig James wrote: Did you do an ANALYZE on the new database after you cloned it? He ran "vacuumdb -f -z", the -z does an analyze. Also, he's getting nearly identical explain plans out of the two systems, which suggests the stats are similar enough in the two cases. --

Re: [PERFORM] "Mysterious" issues with newly installed 8.3

The first thing I'd try is installing 8.2 on the new server to see if the problem is the server or postgresql. Set up the new server and new pgsql install the same and see how it runs. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscript

Re: [PERFORM] "Mysterious" issues with newly installed 8.3

Scott Carey wrote: On Thu, Oct 9, 2008 at 4:51 PM, Carlos Moreno <[EMAIL PROTECTED] > wrote: Ok, I know that such an open and vague question like this one is... well, open and vague... But still. The short story: Just finished an 8.3.4 installation

Re: [PERFORM] "Mysterious" issues with newly installed 8.3

On Thu, Oct 9, 2008 at 4:51 PM, Carlos Moreno <[EMAIL PROTECTED]> wrote: > > Ok, I know that such an open and vague question like this one > is... well, open and vague... But still. > > The short story: > > Just finished an 8.3.4 installation on a new machine, to replace > an existing one; the

[PERFORM] "Mysterious" issues with newly installed 8.3

Ok, I know that such an open and vague question like this one is... well, open and vague... But still. The short story: Just finished an 8.3.4 installation on a new machine, to replace an existing one; the new machine is superior (i.e., higher performance) in virtually every way --- twice as