Changes between Initial Version and Version 1 of Ticket #4739, comment 2


Ignore:
Timestamp:
10/02/20 03:55:36 (4 years ago)
Author:
ansel

Legend:

Unmodified
Added
Removed
Modified

  • TabularUnified Ticket #4739, comment 2

    initial v1  
    2525create index on t using gist (c);
    2626select 1 from t where postgis.st_dwithin(postgis.st_geomfromtext('POINT(3373062 5626876)'::text, 31467), c, 1000.);
     27create materialized view v as SELECT * FROM t WHERE postgis.st_dwithin(postgis.st_geomfromtext('POINT(3373062 5626876)'::text, 31467), c, 1000.);
    2728}}}
    2829