-
Notifications
You must be signed in to change notification settings - Fork 27
/
Copy pathCHANGELOG
165 lines (165 loc) · 6.62 KB
/
CHANGELOG
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
2.1.1
Miscellaneous:
- Add support for PostgreSQL 17 (Georgy Shelkovy)
Bugfix:
- Fix memory leak (Ronan Dunklau)
- Fix column order of multi-column index in the index advisor (Julien
Rouhaud, per report from disqus user Sivan)
2.1.0
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
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)
- Add compatibility with PostgreSQL 15 (Julien Rouhaud)
- 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)
2.0.3
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
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
Bugfix:
- Fix compilation for PG11- on some platforms (Julien Rouhaud, per report
from Devrim Gündüz)
2.0.0
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
- Don't expose recorded constants to unauthorized users
Miscellaneous:
- Add missing fields description (Julien Rouhaud)
1.0.9
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
Miscellaneous:
- Fix pg12 compatibility
- Fix possible issue with array processing
1.0.7
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
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)
1.0.5:
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
1.0.4:
- Fix a bug in Bitmap Index Scan nodes handling for PostgreSQL 10+ (Fix by
Julien Rouhaud, thanks to Marc Cousin and Adrien Nayrat for reporting the
issue)
- Fix sampled array buffer overflow (Fix by Julien Rouhaud, reporting and
much testing by Nicolas Gollet)
1.0.3:
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)
1.0.2:
Bugfix
- Fix infinite loop for queries having a huge number of WHERE or JOIN
clauses
1.0.1:
Bugfix
- Fix impossibility to install pg_qualstats if intarray extension is
installed
1.0.0:
Incompatibilites:
- RenameGUC 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 !
0.0.9:
- add sample_ratio hook
- fix mistake while releasing 0.0.8
0.0.8:
- add sample_ratio parameter
0.0.7:
- fix counters for 32 bits builds
- handle different collations for constants sampling
- add a new "occurences" field, displaying the number of qual call
- keep a unnormalized query string for each queryid
- fix a bug with operator id retrieval
- handles casts
- add stats collection for nestedloops
- handle FuncExpr and MinMaxExpr
- improve performances for queries having multiple quals
0.0.6:
- order quals and constants by their text positions.
- fix bug with Index-Only Scans, which where not correctly supported
- make pg_config configurable from the make invocation
- ensure pg_qualstats is in shared_preload_libraries
0.0.5:
- fix bug with = ANY(NULL) expressions
0.0.4:
- add inline documentation in the sql script
- fix a bug with 32bits builds (thanks to Alain Delorme for reporting it)