Pg Qualstats Versions Save

A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing

2.1.0

8 months ago

New feature: - Allow custom schema at extension creation time (Julien Rouhaud) - Report the queryid in the index advisor (Julien Rouhaud, thanks to Zhihong Yu for the request) Bugfix: - Mark the extension as not relocatable as it internally references the extension schema (Julien Rouhaud)

2.0.4

2 years ago

Bugfix: - Fix memory allocation for PostgreSQL 12 and above (Julien Rouhaud) - Fix bug when append plans are empty (Ronan Dunklau) Miscellaneous: - Fix a faulty strncpy() call (Julien Rouhaud, per report from github user RekGRpth) - Fix some cppcheck warnings (Julien Rouhaud, per report from github user RekGRpth) - Improve extension ugprade documentation (Julien Rouhaud) - Make sure the code can be compiled and used on Windows (Julien Rouhaud, per report from github user suprimex) - Add compatibility with PostgreSQL 15 (Julien Rouhaud)

2.0.3

2 years ago

Miscellaneous: - Add support for PostgreSQL 14 (Julien Rouhaud, per report from Michael Paquier) - Add extension update documentation (Julien Rouhaud) - Debian packaging improvements (Christoph Berg)

2.0.2

3 years ago

Bugfix

  • Correctly handle different versions for the SQL objects and the shared library (Julien Rouhaud, per report from github users seqizz and akovac)

2.0.1

4 years ago

Bugfix:

  • Fix compilation for PG11- on some platforms (Julien Rouhaud, per report from Devrim Gündüz)

2.0.0

4 years ago

New features:

  • Handle statistics on selectivity estimation errors (Julien Rouhaud, per idea from Oleg Bartunov)
  • Add an index advisor feature (Julien Rouhaud)
  • Allow pgqs to work locally without being in shared_preload_libraries (Julien Rouhaud)

Bugfix:

  • Fix handling of quals of the form Constant Operator Val where the operator doesn't have a commutator
  • Compute the same identifier whether the operator was commuted or not
  • Correctly discard all quals not referencing a relation
  • Fix (unique)qualid computation to only consider AND-ed quals

Miscellaneous:

  • Add missing fields description (Julien Rouhaud)

1.0.9

4 years ago

Bugfix:

  • Fix constant value truncation when multibyte encoding characters are used (thanks to Gürkan Gür for the report)

Miscellaneous:

  • Remove unneeded cast, that prevented compilation at least on Solaris 10 SPARC (thanks to github user edechaux for the report)

1.0.8

4 years ago

Miscellaneous:

  • Fix pg12 compatibility
  • Fix possible issue with array processing

1.0.7

5 years ago

Bugfix:

  • Fix a bug for queries having JOIN or WHERE predicates on foreign tables or custom scans (Julien Rouhaud). Thanks a lot to Andrej Urvantsev, Raymond Barbiero and mbroxson who all reported this issue, and especially to mbroxson who provided a reproducer!

Miscellaneous:

  • Fix debian packaging to ignore debian/* tags (Christoph Berg)

1.0.6

5 years ago

Bugfix:

  • Fix bug for handling of nodes having multiple children, such as Append node (Julien Rouhaud).

Miscellaneous:

  • Fix compilation issue with C90 compatibility (Julien Rouhaud)
  • Fix README.d installation in debian packaging (Thanks to Andreas Beckmann for the report)