Postgres Pro
Downloads
Home   >   mailing lists

Re: Spatial join insists on sequential scan of larger - Mailing list pgsql-performance

From Clive Page
Subject Re: Spatial join insists on sequential scan of larger
Date
Msg-id Pine.LNX.4.44L0.0404021700370.2713-100000@peneca.star.le.ac.uk
Whole thread Raw
In response to Re: Spatial join insists on sequential scan of larger table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: single index on more than two coulumns a bad thing?
Next
From: "Gary Doades"
Date:
Subject: Re: PostgreSQL and Linux 2.6 kernel.