On Thu, Oct 14, 2004 at 04:28:52PM +0200, tohny at netcourrier.com wrote:
> Thanks for your response Andrew
> for information, the master and the slave are on a server with
> the same configuration, and the same applications on it. So i wonder
> why my queries are slower on the slave than on the master. The
> only difference between the database is that the master is read/write
> and the slave read only.  Perhaps the slon process could have an impact
> on the performance ?? Have you another idea ?

How much slower?  Are you getting different plans?  Are they on the
_same_ server?  Are they fetching from the same disk?  The same
filesystem?  What are your settings of these?  It's hard to answer
your question without a whole lot more background.  But I can tell
you for sure that being a replica does not automatically slow down a
system.  In fact, the opposite is more likely.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well. 
		--Dennis Ritchie