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 ?

Best regards

Tony

>> very slow.  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 ?

>No, and in any case, your reasoning is faulty.  What other
>differences are there between the systems?  In particylar, have you
>VACUUMed and ANALYZEd the replica?  Any of the other usual
>performance tips apply, too.  Restricting writes in the database
>doesn't make it slower.

-------------------------------------------------------------
NetCourrier, votre bureau virtuel sur Internet : Mail, Agenda, Clubs, Toolbar...
Web/Wap : www.netcourrier.com
T?l?phone/Fax : 08 92 69 00 21 (0,34 ? TTC/min)
Minitel: 3615 NETCOURRIER (0,16 ? TTC/min)