   .   user postgres database regression options  -c intervalstyle=postgres_verbose application_name pg_regress/gist datestyle Postgres, MDY timezone PST8PDT      
SCRAM-SHA-256   +2SCRAM-SHA-256     n,,n=,r=6uI6MF95slzCUULOqQGKRxj3 X   r=6uI6MF95slzCUULOqQGKRxj30iL2VfrfTnywd2IuOXPCfWwX,s=mQx2iUTPO330iLg0sLTn5g==,i=4096 ,hc=biws,r=6uI6MF95slzCUULOqQGKRxj30iL2VfrfTnywd2IuOXPCfWwX,p=ZQKXh3geQ7XiX3XRNqa6Ybfv3ELwUrDSuzFBLptIBkU= 2   v=xEXM7Y0OzbiIEhi7kagu7eIVyheNpIot5vEjg0cUJ14=      #!application_name pg_regress/gist  #client_encoding UTF8  #DateStyle Postgres, MDY  #"default_transaction_read_only off  #in_hot_standby off  #integer_datetimes on  #IntervalStyle postgres_verbose  #is_superuser on  #server_encoding UTF8  #server_version 15.4  #session_authorization postgres  #standard_conforming_strings on  #TimeZone PST8PDT    :´ċAİ2 )I (/create table gist_point_tbl(id int4, p point);  CREATE TABLE  )I (<create index gist_pointidx on gist_point_tbl using gist(p);  CREATE INDEX  )I (bcreate index gist_pointidx2 on gist_point_tbl using gist(p) with (buffering = on, fillfactor=50);  CREATE INDEX  )I (Tcreate index gist_pointidx3 on gist_point_tbl using gist(p) with (buffering = off);  CREATE INDEX  )I (Ucreate index gist_pointidx4 on gist_point_tbl using gist(p) with (buffering = auto);  CREATE INDEX  )I (;drop index gist_pointidx2, gist_pointidx3, gist_pointidx4;  DROP INDEX  )I (^create index gist_pointidx5 on gist_point_tbl using gist(p) with (buffering = invalid_value);  ¤SERROR VERROR C22023 Minvalid value for enum option "buffering": invalid_value DValid values are "on", "off", and "auto". Freloptions.c L1666 Rparse_one_reloption   )I (Qcreate index gist_pointidx5 on gist_point_tbl using gist(p) with (fillfactor=9);  SERROR VERROR C22023 Mvalue 9 out of bounds for option "fillfactor" DValid values are between "10" and "100". Freloptions.c L1622 Rparse_one_reloption   )I (Screate index gist_pointidx5 on gist_point_tbl using gist(p) with (fillfactor=101);  SERROR VERROR C22023 Mvalue 101 out of bounds for option "fillfactor" DValid values are between "10" and "100". Freloptions.c L1622 Rparse_one_reloption   )I (hinsert into gist_point_tbl (id, p)
select g,        point(g*10, g*10) from generate_series(1, 10000) g;  INSERT 0 10000  )I (linsert into gist_point_tbl (id, p)
select g+100000, point(g*10+1, g*10+1) from generate_series(1, 10000) g;  INSERT 0 10000  )I (-delete from gist_point_tbl where id % 2 = 1;  DELETE 10000  )I (,delete from gist_point_tbl where id > 5000;  DELETE 7500  )I (vacuum analyze gist_point_tbl;  VACUUM  )I (1alter index gist_pointidx SET (fillfactor = 40);  ALTER INDEX  )I (reindex index gist_pointidx;  REINDEX  )I (2create table gist_tbl (b box, p point, c circle);  CREATE TABLE  )I (ğinsert into gist_tbl
select box(point(0.05*i, 0.05*i), point(0.05*i, 0.05*i)),
       point(0.05*i, 0.05*i),
       circle(point(0.05*i, 0.05*i), 1.0)
from generate_series(0,10000) as i;  INSERT 0 10001  )I (vacuum analyze gist_tbl;  VACUUM  )I (set enable_seqscan=off;  SET  )I (set enable_bitmapscan=off;  SET  )I (set enable_indexonlyscan=on;  SET  )I (>create index gist_tbl_point_index on gist_tbl using gist (p);  CREATE INDEX  )I (Xexplain (costs off)
select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5));  * QUERY PLAN          ˙˙˙˙˙˙   <    6Index Only Scan using gist_tbl_point_index on gist_tbl 1    +  Index Cond: (p <@ '(0.5,0.5),(0,0)'::box) EXPLAIN  )I (Dselect p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5));  * p  M   X ˙˙˙˙       (0,0)     (0.05,0.05)     	(0.1,0.1)     (0.15,0.15)     	(0.2,0.2)     (0.25,0.25)     	(0.3,0.3)     (0.35,0.35)     	(0.4,0.4)     (0.45,0.45)     	(0.5,0.5) 
SELECT 11  )I ({explain (costs off)
select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
order by p <-> point(0.201, 0.201);  * QUERY PLAN          ˙˙˙˙˙˙   <    6Index Only Scan using gist_tbl_point_index on gist_tbl 1    +  Index Cond: (p <@ '(0.5,0.5),(0,0)'::box) 0    *  Order By: (p <-> '(0.201,0.201)'::point) EXPLAIN  )I (gselect p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
order by p <-> point(0.201, 0.201);  * p  M   X ˙˙˙˙       	(0.2,0.2)     (0.25,0.25)     (0.15,0.15)     	(0.3,0.3)     	(0.1,0.1)     (0.35,0.35)     (0.05,0.05)     	(0.4,0.4)     (0,0)     (0.45,0.45)     	(0.5,0.5) 
SELECT 11  )I ({explain (costs off)
select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
order by point(0.101, 0.101) <-> p;  * QUERY PLAN          ˙˙˙˙˙˙   <    6Index Only Scan using gist_tbl_point_index on gist_tbl 1    +  Index Cond: (p <@ '(0.5,0.5),(0,0)'::box) 0    *  Order By: (p <-> '(0.101,0.101)'::point) EXPLAIN  )I (gselect p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
order by point(0.101, 0.101) <-> p;  * p  M   X ˙˙˙˙       	(0.1,0.1)     (0.15,0.15)     (0.05,0.05)     	(0.2,0.2)     (0,0)     (0.25,0.25)     	(0.3,0.3)     (0.35,0.35)     	(0.4,0.4)     (0.45,0.45)     	(0.5,0.5) 
SELECT 11  )I (explain (costs off)
select p from
  (values (box(point(0,0), point(0.5,0.5))),
          (box(point(0.5,0.5), point(0.75,0.75))),
          (box(point(0.8,0.8), point(1.0,1.0)))) as v(bb)
cross join lateral
  (select p from gist_tbl where p <@ bb order by p <-> bb[0] limit 2) ss;  * QUERY PLAN          ˙˙˙˙˙˙       Nested Loop %      ->  Values Scan on "*VALUES*"       ->  Limit H    B        ->  Index Only Scan using gist_tbl_point_index on gist_tbl 9    3              Index Cond: (p <@ "*VALUES*".column1) =    7              Order By: (p <-> ("*VALUES*".column1)[0]) EXPLAIN  )I (select p from
  (values (box(point(0,0), point(0.5,0.5))),
          (box(point(0.5,0.5), point(0.75,0.75))),
          (box(point(0.8,0.8), point(1.0,1.0)))) as v(bb)
cross join lateral
  (select p from gist_tbl where p <@ bb order by p <-> bb[0] limit 2) ss;  * p  M   X ˙˙˙˙       	(0.5,0.5)     (0.45,0.45)     (0.75,0.75)     	(0.7,0.7)     (1,1)     (0.95,0.95) 	SELECT 6  )I (!drop index gist_tbl_point_index;  DROP INDEX  )I (<create index gist_tbl_box_index on gist_tbl using gist (b);  CREATE INDEX  )I (Sexplain (costs off)
select b from gist_tbl where b <@ box(point(5,5), point(6,6));  * QUERY PLAN          ˙˙˙˙˙˙   :    4Index Only Scan using gist_tbl_box_index on gist_tbl -    '  Index Cond: (b <@ '(6,6),(5,5)'::box) EXPLAIN  )I (?select b from gist_tbl where b <@ box(point(5,5), point(6,6));  * b  M   [  ˙˙˙˙       (5,5),(5,5)     (5.05,5.05),(5.05,5.05)     (5.1,5.1),(5.1,5.1)     (5.15,5.15),(5.15,5.15)     (5.2,5.2),(5.2,5.2)     (5.25,5.25),(5.25,5.25)     (5.3,5.3),(5.3,5.3)     (5.35,5.35),(5.35,5.35)     (5.4,5.4),(5.4,5.4)     (5.45,5.45),(5.45,5.45)     (5.5,5.5),(5.5,5.5)     (5.55,5.55),(5.55,5.55)     (5.6,5.6),(5.6,5.6)     (5.65,5.65),(5.65,5.65)     (5.7,5.7),(5.7,5.7)     (5.75,5.75),(5.75,5.75)     (5.8,5.8),(5.8,5.8)     (5.85,5.85),(5.85,5.85)     (5.9,5.9),(5.9,5.9)     (5.95,5.95),(5.95,5.95)     (6,6),(6,6) 
SELECT 21  )I (sexplain (costs off)
select b from gist_tbl where b <@ box(point(5,5), point(6,6))
order by b <-> point(5.2, 5.91);  * QUERY PLAN          ˙˙˙˙˙˙   :    4Index Only Scan using gist_tbl_box_index on gist_tbl -    '  Index Cond: (b <@ '(6,6),(5,5)'::box) -    '  Order By: (b <-> '(5.2,5.91)'::point) EXPLAIN  )I (_select b from gist_tbl where b <@ box(point(5,5), point(6,6))
order by b <-> point(5.2, 5.91);  * b  M   [  ˙˙˙˙       (5.55,5.55),(5.55,5.55)     (5.6,5.6),(5.6,5.6)     (5.5,5.5),(5.5,5.5)     (5.65,5.65),(5.65,5.65)     (5.45,5.45),(5.45,5.45)     (5.7,5.7),(5.7,5.7)     (5.4,5.4),(5.4,5.4)     (5.75,5.75),(5.75,5.75)     (5.35,5.35),(5.35,5.35)     (5.8,5.8),(5.8,5.8)     (5.3,5.3),(5.3,5.3)     (5.85,5.85),(5.85,5.85)     (5.25,5.25),(5.25,5.25)     (5.9,5.9),(5.9,5.9)     (5.2,5.2),(5.2,5.2)     (5.95,5.95),(5.95,5.95)     (5.15,5.15),(5.15,5.15)     (6,6),(6,6)     (5.1,5.1),(5.1,5.1)     (5.05,5.05),(5.05,5.05)     (5,5),(5,5) 
SELECT 21  )I (sexplain (costs off)
select b from gist_tbl where b <@ box(point(5,5), point(6,6))
order by point(5.2, 5.91) <-> b;  * QUERY PLAN          ˙˙˙˙˙˙   :    4Index Only Scan using gist_tbl_box_index on gist_tbl -    '  Index Cond: (b <@ '(6,6),(5,5)'::box) -    '  Order By: (b <-> '(5.2,5.91)'::point) EXPLAIN  )I (_select b from gist_tbl where b <@ box(point(5,5), point(6,6))
order by point(5.2, 5.91) <-> b;  * b  M   [  ˙˙˙˙       (5.55,5.55),(5.55,5.55)     (5.6,5.6),(5.6,5.6)     (5.5,5.5),(5.5,5.5)     (5.65,5.65),(5.65,5.65)     (5.45,5.45),(5.45,5.45)     (5.7,5.7),(5.7,5.7)     (5.4,5.4),(5.4,5.4)     (5.75,5.75),(5.75,5.75)     (5.35,5.35),(5.35,5.35)     (5.8,5.8),(5.8,5.8)     (5.3,5.3),(5.3,5.3)     (5.85,5.85),(5.85,5.85)     (5.25,5.25),(5.25,5.25)     (5.9,5.9),(5.9,5.9)     (5.2,5.2),(5.2,5.2)     (5.95,5.95),(5.95,5.95)     (5.15,5.15),(5.15,5.15)     (6,6),(6,6)     (5.1,5.1),(5.1,5.1)     (5.05,5.05),(5.05,5.05)     (5,5),(5,5) 
SELECT 21  )I (drop index gist_tbl_box_index;  DROP INDEX  )I (Acreate index gist_tbl_multi_index on gist_tbl using gist (p, c);  CREATE INDEX  )I (Wexplain (costs off)
select p, c from gist_tbl
where p <@ box(point(5,5), point(6, 6));  * QUERY PLAN          ˙˙˙˙˙˙   7    1Index Scan using gist_tbl_multi_index on gist_tbl -    '  Index Cond: (p <@ '(6,6),(5,5)'::box) EXPLAIN  )I (rselect b, p from gist_tbl
where b <@ box(point(4.5, 4.5), point(5.5, 5.5))
and p <@ box(point(5,5), point(6, 6));  ** b  M   [  ˙˙˙˙  p  M   X ˙˙˙˙       (5,5),(5,5)   (5,5) ,    (5.05,5.05),(5.05,5.05)   (5.05,5.05) &    (5.1,5.1),(5.1,5.1)   	(5.1,5.1) ,    (5.15,5.15),(5.15,5.15)   (5.15,5.15) &    (5.2,5.2),(5.2,5.2)   	(5.2,5.2) ,    (5.25,5.25),(5.25,5.25)   (5.25,5.25) &    (5.3,5.3),(5.3,5.3)   	(5.3,5.3) ,    (5.35,5.35),(5.35,5.35)   (5.35,5.35) &    (5.4,5.4),(5.4,5.4)   	(5.4,5.4) ,    (5.45,5.45),(5.45,5.45)   (5.45,5.45) &    (5.5,5.5),(5.5,5.5)   	(5.5,5.5) 
SELECT 11  )I (!drop index gist_tbl_multi_index;  DROP INDEX  )I (Kcreate index gist_tbl_multi_index on gist_tbl using gist (circle(p,1), p);  CREATE INDEX  )I (lexplain (verbose, costs off)
select circle(p,1) from gist_tbl
where p <@ box(point(5, 5), point(5.3, 5.3));  * QUERY PLAN          ˙˙˙˙˙˙   C    =Index Only Scan using gist_tbl_multi_index on public.gist_tbl 0    *  Output: circle(p, '1'::double precision) :    4  Index Cond: (gist_tbl.p <@ '(5.3,5.3),(5,5)'::box) EXPLAIN  )I (Oselect circle(p,1) from gist_tbl
where p <@ box(point(5, 5), point(5.3, 5.3));  * circle         Î ˙˙˙˙       	<(5,5),1>     <(5.05,5.05),1>     <(5.1,5.1),1>     <(5.15,5.15),1>     <(5.2,5.2),1>     <(5.25,5.25),1>     <(5.3,5.3),1> 	SELECT 7  )I (bexplain (verbose, costs off)
select p from gist_tbl where circle(p,1) @> circle(point(0,0),0.95);  * QUERY PLAN          ˙˙˙˙˙˙   C    =Index Only Scan using gist_tbl_multi_index on public.gist_tbl       Output: p [    U  Index Cond: ((circle(gist_tbl.p, '1'::double precision)) @> '<(0,0),0.95>'::circle) EXPLAIN  )I (Eselect p from gist_tbl where circle(p,1) @> circle(point(0,0),0.95);  * p  M   X ˙˙˙˙       (0,0) 	SELECT 1  )I (<explain (verbose, costs off)
select count(*) from gist_tbl;  * QUERY PLAN          ˙˙˙˙˙˙       	Aggregate       Output: count(*) I    C  ->  Index Only Scan using gist_tbl_multi_index on public.gist_tbl EXPLAIN  )I (select count(*) from gist_tbl;  * count           ˙˙˙˙       10001 	SELECT 1  )I (aexplain (verbose, costs off)
select p from gist_tbl order by circle(p,1) <-> point(0,0) limit 1;  * QUERY PLAN          ˙˙˙˙˙˙       Limit J    D  Output: p, ((circle(p, '1'::double precision) <-> '(0,0)'::point)) I    C  ->  Index Only Scan using gist_tbl_multi_index on public.gist_tbl N    H        Output: p, (circle(p, '1'::double precision) <-> '(0,0)'::point) X    R        Order By: ((circle(gist_tbl.p, '1'::double precision)) <-> '(0,0)'::point) EXPLAIN  )I (Dselect p from gist_tbl order by circle(p,1) <-> point(0,0) limit 1;  * p  M   X ˙˙˙˙   SERROR VERROR C0A000 Mlossy distance functions are not supported in index-only scans Fnodeindexonlyscan.c L240 RIndexOnlyNext   )I (reset enable_seqscan;  RESET  )I (reset enable_bitmapscan;  RESET  )I (reset enable_indexonlyscan;  RESET  )I (drop table gist_tbl;  DROP TABLE  )I ((create unlogged table gist_tbl (b box);  CREATE TABLE  )I (<create index gist_tbl_box_index on gist_tbl using gist (b);  CREATE INDEX  )I (Zinsert into gist_tbl
  select box(point(0.05*i, 0.05*i)) from generate_series(0,10) as i;  INSERT 0 11  )I (drop table gist_tbl;  DROP TABLE  )I 0 