Hi, Postgres is refusing to use a GIST index on a spatial column.
Here's the table and column and index:
Table public.scene
Column| Type | Modifiers
-+-+---
...
footprint |
On Sat, May 05, 2007 at 03:01:36PM +1200, Glen Eustace wrote:
Is there some way that one can determine whether a table has changed
i.e. an insert, delete, update, without having to resort to setting a
flag in another table using a triger or rule.
You can NOTIFY a LISTENing client which does
I tried to set that policy to all available settings [activate, not
activate, not set] but the result does not change, the installer stops with
the same error.
Here below elevated privileges set for Windows installer
I then tried the same things on a true Windows XP Professional
4 maj 2007 kl. 18:09 skrev Tom Lane:
Henrik Zagerholm [EMAIL PROTECTED] writes:
I have a SELECT query that uses Seq scans instead of index scan
despite that the index scan is faster.
Try 8.2, it's a bit smarter about the costs of repeated indexscans
on the inside of a nestloop.
Ahh sorry
=?ISO-8859-1?Q?Greg_Jan=E9e?= [EMAIL PROTECTED] writes:
db= explain analyze SELECT * FROM scene A WHERE A.footprint box
'((-120.1, 34.3), (-119.7, 34.4))' ;
QUERY PLAN
Steps taken that work:
1. Take a low-level (tar) backup on the live server
2. Restore the files on a second server (identical OS and PG versions)
3. Copy the archived WAL files to the backup server
4. Restore the archived WAL files on the backup server
However, why don't steps 5 through 8
You already got an answer to the first part of your question, but I
thought you might be interested in the second as well. Here's what I
did:
Thanks. That's very helpful, to see a good example of using the built-in
catalog data.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/