On 10/14/2004 4:59 PM, tohny at netcourrier.com wrote:

> For a given request, it take 4 s on the master and 8 s on the slave.
> The query is execute via a web service. The 2 databases are on
> 2 distinct server. On the 2 servers, there is a jboss. the configuration
> of the server is exactly the same like the configuration of the JVM
> for the jboss. The servers are on the same network and communicate
> with one apache. So i don't understand why the queries is slower on
> the slave than on the master. The only difference is the su state of
> the database. But it can be interresting to pass the slave read-write
> and see if there is the same difference with the master.

The only difference the read-only state makes is that the relations will 
have a different list of triggers to fire "if the application would try 
to modify any of the replicated tables". But that's not what it tries, 
so I can absolutely not imagine where you get the idea that this is the 
cause of your performance problem.

Could you please isolate the SQL query that is causing this big 
difference and run it through EXPLAIN ANALYZE on both servers?


Jan

> 
> Tony 
> 
> -------------------------------------------------------------
> 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)
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #