| From: | "Mark Steben" <msteben(at)autorevenue(dot)com> |
|---|---|
| To: | "'Dave Dutcher'" <dave(at)tridecap(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Cc: | "'Rich Garabedian'" <richg(at)autorevenue(dot)com> |
| Subject: | Re: Performance issue - 2 linux machines, identical configs, different performance |
| Date: | 2009-06-17 18:05:10 |
| Message-ID: | 20090617180509.D3B0C6344DC@mail.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Dave Dutcher
Sent: Wednesday, June 17, 2009 1:39 PM
To: 'Mark Steben'; pgsql-performance(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Cox | 2009-06-17 18:35:48 | very slow selects on a small table |
| Previous Message | Dave Dutcher | 2009-06-17 17:39:22 | Re: Performance issue - 2 linux machines, identical configs, different performance |