From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Pam Ozer <pozer@automotive.com>
To: pgsql-performance@postgresql.org
Subject: Re: Two servers - One Replicated - Same query
Date: Tue, 12 Apr 2011 09:32:46 -0500
Message-ID: <4DA41C3E020000250003C6DC@gw.wicourts.gov> (raw)
In-Reply-To: <216FFB77CBFAEE4B8EE4DF0A939FF1D14F858B@mail-001.corp.automotive.com>
References: <216FFB77CBFAEE4B8EE4DF0A939FF1D14F858B@mail-001.corp.automotive.com>
"Ozer, Pam" <pozer@automotive.com> wrote:
> I have two servers one has replication the other does not. The
> same query on both servers. One takes 225seconds on the
> replicated server the first time it runs and only 125ms on the
> other server the first time it runs. The second time you execute
> the query it drops to the 125ms. They are using the same query
> plan. What kind of things should I be looking at?
Caching.
Apparently the usage pattern on one server tends to keep the
necessary data in cache, while the usage pattern on the other is
flushing it out occasionally to make room for other data. Adding
RAM to the server might help.
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, pozer@automotive.com
Subject: Re: Two servers - One Replicated - Same query
In-Reply-To: <4DA41C3E020000250003C6DC@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox