emonstrates that the PG planner is smart.
Not so smart are the MapServer and QGIS query builders, which use
a CURSOR to FETCH ALL.
I will investigate in this direction now.
Thank you very much, your help was excellent!
--
Niccolo Rigacci
Firenze - Italy
War against Iraq? Not in my name!
--
On Wed, Jul 06, 2005 at 11:19:46PM +0200, Niccolo Rigacci wrote:
>
> I have a performace problem with the following query:
>
> BEGIN;
> DECLARE mycursor BINARY CURSOR FOR
> SELECT
> toponimo,
> wpt
> FROM wpt_comuni_view
>
r;
END;
I tried to put EXPLAIN ANALYZE in front of the SELECT and in
front of the FETCH, but I got two "syntax error"...
Thanks
--
Niccolo Rigacci
Firenze - Italy
War against Iraq? Not in my name!
---(end of broadcast)---
TIP 8: explain analyze is your friend
M istat_comuni
JOIN istat_comuni2wpt
USING (idprovincia, idcomune)
JOIN istat_wpt
ON (idwpt = id);
Thank you for any hint.
--
Niccolo Rigacci
Firenze - Italy
War against Iraq? Not in my name!
---(end of broadcast)---
TIP
