Re: Index Skip Scan - attempting to evalutate patch

> On Wed, Jun 26, 2019 at 1:53 PM pguser <pguser(at)diorite(dot)uk> wrote:
>
> If I apply the latest patch (which says 1 of 2? - maybe I'm missing a part of the patch?), I apply with

Hi,

First of all, thanks for evaluation!

> psql (12beta2)
> Type "help" for help.
>
> db1=> show enable_indexskipscan;
> enable_indexskipscan
> ----------------------
> on
> (1 row)
>
> db1=> \d
> psql: server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
> !> \q
>
>
> I got a backtrace out of the process:
>
> (gdb) backtrace
> #0 MemoryContextAllocZeroAligned (context=0x0, size=size(at)entry=80) at mcxt.c:864
> #1 0x000000000067d2d4 in get_eclass_for_sort_expr (root=root(at)entry=0x22ecb10, expr=expr(at)entry=0x22ee280, nullable_relids=nullable_relids(at)entry=0x0, opfamilies=0x22ff530,
> opcintype=opcintype(at)entry=19, collation=collation(at)entry=950, sortref=<optimized out>, rel=0x0, create_it=true) at equivclass.c:704
> #2 0x0000000000686d9e in make_pathkey_from_sortinfo (root=root(at)entry=0x22ecb10, expr=expr(at)entry=0x22ee280, nullable_relids=nullable_relids(at)entry=0x0, opfamily=1994, opcintype=19,
> collation=950, reverse_sort=false, nulls_first=false, sortref=1, rel=0x0, create_it=true) at pathkeys.c:228
> #3 0x0000000000686eb7 in make_pathkey_from_sortop (root=root(at)entry=0x22ecb10, expr=0x22ee280, nullable_relids=0x0, ordering_op=660, nulls_first=<optimized out>, sortref=1,
> create_it=true) at pathkeys.c:271
> #4 0x0000000000687a4a in make_pathkeys_for_sortclauses (root=root(at)entry=0x22ecb10, sortclauses=<optimized out>, tlist=tlist(at)entry=0x22ee2f0) at pathkeys.c:1099
> #5 0x0000000000694588 in standard_qp_callback (root=0x22ecb10, extra=<optimized out>) at planner.c:3635
> #6 0x0000000000693024 in query_planner (root=root(at)entry=0x22ecb10, qp_callback=qp_callback(at)entry=0x6944e0 <standard_qp_callback>, qp_extra=qp_extra(at)entry=0x7ffe6fe2b8e0)
> at planmain.c:207
> #7 0x00000000006970e0 in grouping_planner (root=root(at)entry=0x22ecb10, inheritance_update=inheritance_update(at)entry=false, tuple_fraction=<optimized out>, tuple_fraction(at)entry=0)
> at planner.c:2048
> #8 0x000000000069978d in subquery_planner (glob=glob(at)entry=0x22e43c0, parse=parse(at)entry=0x22e3f30, parent_root=parent_root(at)entry=0x0, hasRecursion=hasRecursion(at)entry=false,
> tuple_fraction=tuple_fraction(at)entry=0) at planner.c:1012
> #9 0x000000000069a7b6 in standard_planner (parse=0x22e3f30, cursorOptions=256, boundParams=<optimized out>) at planner.c:406
> #10 0x000000000073ceac in pg_plan_query (querytree=querytree(at)entry=0x22e3f30, cursorOptions=cursorOptions(at)entry=256, boundParams=boundParams(at)entry=0x0) at postgres.c:878
> #11 0x000000000073cf86 in pg_plan_queries (querytrees=<optimized out>, cursorOptions=cursorOptions(at)entry=256, boundParams=boundParams(at)entry=0x0) at postgres.c:968
> #12 0x000000000073d399 in exec_simple_query (
> query_string=0x222a9a0 "SELECT n.nspname as \"Schema\",\n c.relname as \"Name\",\n CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN '"...) at postgres.c:1143
> #13 0x000000000073ef5a in PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x2255440, dbname=<optimized out>, username=<optimized out>) at postgres.c:4249
> #14 0x00000000006cfaf6 in BackendRun (port=0x224e220, port=0x224e220) at postmaster.c:4431
> #15 BackendStartup (port=0x224e220) at postmaster.c:4122
> #16 ServerLoop () at postmaster.c:1704
> #17 0x00000000006d09d0 in PostmasterMain (argc=argc(at)entry=3, argv=argv(at)entry=0x2224c50) at postmaster.c:1377
> #18 0x00000000004820c4 in main (argc=3, argv=0x2224c50) at main.c:228

Could you by any change provide also relations schema that were supposed to be
described by this command?