Mark Stosberg wrote:
I've used PQA to analyze my queries and happy overall with how they are
running. About 55% of the query time is going to variations of the pet
searching query, which seems like where it should be going. The query is
frequent and complex. It has already been combed over for appropriate
indexing.


It might be worth posting the EXPLAIN ANALYZE and relevant schema definitions for this query, in case there is additional room for optimization.

   Our hardware: Dual 3 Ghz processors 3 GB RAM, running on FreeBSD.

Disk?

You are presumably using Xeon processors, right? If so, check the list archives for information on the infamous "context switching storm" that causes performance problems for some people using SMP Xeons.

-Neil

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to