Re: Why very high CPU usage

On Fri, 10 May 2002, Samuel J. Sutjiono wrote:

> This is the SQL that I used:

Can't really say much, not knowing the schema you're using. By looking
at this query, I can probably guess it isn't pretty. 7 search columns
instead of a search table? Putting a sort case in the query itself
instead of predetermining the sort order and dynmaically writing the
query? That gigantic group-by isn't helping you, either.

My guess is that your schema could use an overhaul. We of course are
going to ask you the standard questions. I'll list them off, because
you asked your question without listing the obvious elements:

1.) Have you vacuumed/analyzed recently?
2.) What kind of indexes are you using?
3.) Can we see a schema to see what kind of column types you're using?
4.) Can you send an explain plan or two?
5.) Did you try turning off sequence scans?

Do not expect us to help you with something if you can't give us the
proper tools to do so. We're not magical mind-readers.

--
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
| Shaun M. Thomas INN Database Administrator |
| Phone: (309) 743-0812 Fax : (309) 743-0830 |
| Email: sthomas(at)townnews(dot)com AIM : trifthen |
| Web : www.townnews.com |
| |
| "Most of our lives are about proving something, either to |
| ourselves or to someone else." |
| -- Anonymous |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+