pg_idx_advisor
pg_idx_advisor copied to clipboard
cohenjo
A PostgreSQL extension to analyze queries and give indexing advice.
Hello! I get the following error when trying to build with PostgreSQL 10 ``` ~/workspace/pg_idx_advisor$ make gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fpic -I....
I am having a bit of trouble getting the extension to compile with PostGresSQL 9.6.1. I get the following errors: In file included from src/utils.c:20: src/utils.h:27:34: error: catalog/pg_collation.h: No such...
i'm getting an index creation warning, and no results on what should be an easy index: ``` WARNING: Failed to create index advice for: explain select max(unitsales) from measurement where...
colin@pisces ~/pg_idx_advisor $ gcc -v Using built-in specs. COLLECT_GCC=gcc COLLECT_LTO_WRAPPER=/usr/lib/gcc/x86_64-linux-gnu/4.8/lto-wrapper Target: x86_64-linux-gnu Configured with: ../src/configure -v --with-pkgversion='Ubuntu 4.8.2-19ubuntu1' --with-bugurl=file:///usr/share/doc/gcc-4.8/README.Bugs --enable-languages=c,c++,java,go,d,fortran,objc,obj-c++ --prefix=/usr --program-suffix=-4.8 --enable-shared --enable-linker-build-id --libexecdir=/usr/lib --without-included-gettext --enable-threads=posix --with-gxx-include-dir=/usr/include/c++/4.8 --libdir=/usr/lib --enable-nls...
