Re: [GENERAL] Performace question

2003-10-29 Thread Lada 'Ray' Lostak
>Firstly, have you run ANALYZE across the database? ANALYZE not, only EXPLAIN. And it looks pretty normal :( There is basically nothing interested in soo simple SQL. >Secondly, the queries that are varying so much, can you post the EXPLAIN >ANALYZE output so we can see what is actually going on.

Re: [GENERAL] Performace question

2003-10-29 Thread Martijn van Oosterhout
Firstly, have you run ANALYZE across the database? Secondly, the queries that are varying so much, can you post the EXPLAIN ANALYZE output so we can see what is actually going on. Note also that the query log can be very helpful in finding out if the delay is in the database or not. Hope this he