Re: Spatial join insists on sequential scan of larger

From: Clive Page <cgp(at)star(dot)le(dot)ac(dot)uk>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Spatial join insists on sequential scan of larger
Date: 2004-04-02 16:05:01
Message-ID: Pine.LNX.4.44L0.0404021700370.2713-100000@peneca.star.le.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 2 Apr 2004, Tom Lane wrote:

> Could we see EXPLAIN ANALYZE output?

Certainly, but that's going to take a little time (as the ANALYZE causes
it to run the actual query, which I only just discovered), so may have to
wait until Monday if I don't get time to finish it this afternoon.

--
Clive Page
Dept of Physics & Astronomy,
University of Leicester,
Leicester, LE1 7RH, U.K.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gary Doades 2004-04-03 10:50:51 Re: PostgreSQL and Linux 2.6 kernel.
Previous Message Bruno Wolff III 2004-04-02 15:56:04 Re: single index on more than two coulumns a bad thing?