Re: Two servers - One Replicated - Same query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Ozer, Pam" <pozer@xxxxxxxxxxxxxx> 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

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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux