tohny at netcourrier.com wrote:
> Hi everybody,
> 
> I use slony-I but I have a problem with the slave database.
> This one is used by a jboss which act as a webserver.
> The problem is that the response time of this database is
> very slow.

Ahhh, I've had this before (and fixed it).

Are you running pg_autovacuum on the slave database server?

Also, what syncronisation delay settings are you using with Slony?

:)

Regards and best wishes,

Justin Clift


 > It seems to be that this problem is due to the fact
> that the slave database is read only. When i make test with the
> master database the response time of the database is good.
> So my question is, is there a way to make the slave database
> read-write to improve performance ?
> Thanks in advance for your response.
> 
> Best regards
> 
> Tony