Re: Performance issue - 2 linux machines, identical configs, different performance - Mailing list pgsql-performance

From Mark Steben
Subject Re: Performance issue - 2 linux machines, identical configs, different performance
Date
Msg-id 20090617180509.D3B0C6344DC@mail.postgresql.org
Whole thread Raw
In response to Re: Performance issue - 2 linux machines, identical configs, different performance  ("Dave Dutcher" <dave@tridecap.com>)
List pgsql-performance
Yes I analyze after each replication.

Mark Steben│Database Administrator│

@utoRevenue-R- "Join the Revenue-tion"
95 Ashley Ave. West Springfield, MA., 01089
413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax)

@utoRevenue is a registered trademark and a division of Dominion Enterprises

-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Dave Dutcher
Sent: Wednesday, June 17, 2009 1:39 PM
To: 'Mark Steben'; pgsql-performance@postgresql.org
Cc: 'Rich Garabedian'
Subject: Re: [PERFORM] Performance issue - 2 linux machines, identical
configs, different performance


>We have two machines.  Both running Linux Redhat, both running postgres
8.2.5.
>Both have nearly identical 125 GB databases.  In fact we use PITR Recovery
to
>Replicate from one to the other.

I have to ask the obvious question.  Do you regularly analyze the machine
you replicate too?


Dave



--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Re: Performance issue - 2 linux machines, identical configs, different performance
Next
From: Brian Cox
Date:
Subject: very slow selects on a small table