Pg Qualstats Versions Save

Incompatibilites:

• Due to changes in pg_stat_statements in 11, queryid is now on 64 bits. SQL functions no longer use oid type but bigint for queryid attribute (even for PG prior to 11).

Miscellaneous:

• Add pg 11 compatibility (Adrien Nayrat helped by Julien Rouhaud and Thomas Reiss)
• Warn if incorrect configuration setting is used (Julien Rouhaud)

Bugfix :

• Fix sampled array buffer overflow (Julien Rouhaud)
• Fix a bug in Bitmap Index Scan nodes handling for PostgreSQL 10+ (Julien Rouhaud)

Bugfix:

• Fix a missing call to InstrEndLoop (Tomas Vondra)
• Sample all nested queries when top level statement is sampled (Julien Rouhaud)
• Make sure hash keys can be compared using memcmp (Julien Rouhaud)
• Fix behavior with parallel queries (Julien Rouhaud based on a patch by Tomas Vondra)
• Fix bug on TEXTCONST not being byval (Ronan Dunklau)
• Fix 64bits counters on pass-by-ref float8 architectures (Julien Rouhaud)
• Fix bug in pg_qualstats_names (Ronan Dunklau)
• Fix bug in const position (Julien Rouhaud)
• Fix pg_qualstats_pretty to use text instead of regoper, allowing usage of pg_upgrade when pg_qualstats is installed (Julien Rouhaud)
• Fix segfault when interleaved executors cause bad sampling detection (Julien Rouhaud, reported by Andreas Seltenreich)

Miscellaneous:

• Add pg 10 compatibility (Julien Rouhaud)
• Do not install docs anymore (Ronan Dunklau)
• Add missing occurences/nbfiltered fields to pg_qualstats_pretty and pg_qualstats_all views (Julien Rouhaud)

Bugfix:

• Fix infinite loop for queries having a huge number of WHERE or JOIN clauses

Bugfix:

• Fix impossibility to install pg_qualstats if intarray extension is installed

Incompatibilites:

• Rename GUC from sample_ratio to sample_rate

Bugfix:

• only get the exclusive lock on shared memory when needed
• Fix bugs related to outer var resolution
• Add missing function prototype

Miscellaneous:

• Add 9.6 compatibility
• Code and comment cleanup

Thanks to Thomas Vondra and Julien Rouhaud !

• allow setting sample_ratio back to -1 to get automatic configuration
• add forgotten sql script for the version 0.0.8

• add a sample_ratio parameter to gather qual statistics for only a fraction of the queries. Default to -1 meaning sampling 1 / max_connections % of the queries

• add inline documentation in the sql script
• fix a bug with 32bits builds (thanks to Alain Delorme for reporting it)

• fix bug with = ANY(NULL) expressions