I have two instances of a production application that uses Postgres 7.2,
deployed in two different data centers for about the last 6 months. The
sizes, schemas, configurations, hardware, and access patterns of the two
databases are nearly identical, but one consistently takes at least 5x
longer
to stop or change this
behavior? Apologies if this is a known problem...
mike
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael
Nonemacher
Sent: Friday, June 04, 2004 10:43 AM
To: [EMAIL PROTECTED]
Subject: [PERFORM] postgres performance: comparing
, 2004 5:27 PM
To: Michael Nonemacher
Cc: Postgresql Performance
Subject: Re: [PERFORM] postgres performance: comparing 2 data centers
The members table contains about 500k rows. It has an index on
(group_id, member_id) and on (member_id, group_id).
Yes, bad stats are causing it to pick a poor