On Thu, Nov 29, 2007 at 01:26:00PM +, Pedro Doria Meunier wrote:
Hi People.
I need some help optimizing this query:
snip
I still get Seq Scans although all used fields are indexed, hence the
time used... :-(
A seq scan on a table with 10 rows is *good*. An index would take
longer. What
Hi People.
I need some help optimizing this query:
SELECT u.friendly_name, distance(transform(u.curr_location,32628),
rc.agg_geometry) AS thedistance, u.mobile
FROM (SELECT transform(collect(r.geometry),32628) AS agg_geometry,
t.county FROM pt_madeira_roads r, pt_madeira_toponymy t
WHERE
Hello,
I have a query, which is quite big and there is a huge difference
between execution time in MySQL and PostgreSQL. I think that I have made
all possible steps to increase the speed of the query, but unfortunately
it is still about 100 times slower. I'm out of ideas what to do next,
so
Marek Lewczuk wrote:
Hello,
I have a query, which is quite big and there is a huge difference
between execution time in MySQL and PostgreSQL. I think that I have made
all possible steps to increase the speed of the query, but unfortunately
it is still about 100 times slower. I'm out of ideas
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Marek Lewczuk
Sent: Friday, August 20, 2004 2:01 AM
To: Lista dyskusyjna pgsql-general
Subject: [GENERAL] Help with optimizing query
Hello,
I have a query, which is quite big and there is a huge difference
between execution time in MySQL