1) Please format the query you want help optimising. Proper query format
FROM table JOIN table
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:
After that, we'll probably be able to help you!
Aglio Database Solutions
In response to
pgsql-novice by date
|Next:||From: Michael Fuhr||Date: 2005-08-25 21:43:56|
|Subject: Re: Superuser can execute but not view function|
|Previous:||From: Saranya Sivakumar||Date: 2005-08-25 20:25:01|
|Subject: query optimization|