| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Cc: | Saranya Sivakumar <sarlavk(at)yahoo(dot)com> |
| Subject: | Re: query optimization |
| Date: | 2005-08-25 21:08:55 |
| Message-ID: | 200508251408.55390.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Saranya,
1) Please format the query you want help optimising. Proper query format
is like:
SELECT columns
FROM table JOIN table
JOIN table
WHERE condition
condition
LIMIT
2) Please run EXPLAIN ANALYZE rather than just EXPLAIN, and please run it
on the query you actually want help with (the query you gave us and the
explain output do not match).
3) Please give us the following settings from your PostgreSQL.conf:
effective_cache_size
random_page_cost
After that, we'll probably be able to help you!
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-08-25 21:43:56 | Re: Superuser can execute but not view function |
| Previous Message | Saranya Sivakumar | 2005-08-25 20:25:01 | query optimization |