PostgeSQL is a leading open-source SQL database server.
- Fix multiple problems with satisfies_hash_partition
Robert Haas: Fix the function header comment to describe the actual behavior.
- Support index-only scans in contrib/cube and contrib/seg GiST indexes
Tom Lane: To do this, we only have to remove the compress and decompress support functions, which have never done anything more than detoasting.
- Add support for Motorola 88K to s_lock.h
Tom Lane: Apparently there are still people out there who care about this old architecture.
- Merge near-duplicate code in RI triggers
Tom Lane: Merge ri_restrict_del and ri_restrict_upd into one function ri_restrict.
- Prevent to_number() from losing data when template doesn't match exactly
Tom Lane: Non-data template patterns would consume characters whether or not those characters were what the pattern expected, for example SELECT TO_NUMBER('1234', '9,999'); produced 134 because the '2' got eaten by the comma pattern.
- Make PL/Python handle domain-type conversions correctly
Tom Lane: Fix PL/Python so that it can handle domains over composite, and so that it enforces domain constraints correctly in other cases that were not always done properly before.
- Pass InitPlan values to workers via Gather (Merge).
Robert Haas: If a PARAM_EXEC parameter is used below a Gather (Merge) but the InitPlan that computes it is attached to or above the Gather (Merge), force the
value to be computed before starting parallelism and pass it down to all workers.
- Prevent int128 from requiring more than MAXALIGN alignment
Tom Lane: Our initial work with int128 neglected alignment considerations, an oversight that came back to bite us in bug #14897 from Vincent Lachenal.
- Allow running just selected steps of pgbench's initialization sequence
Tom Lane: This feature caters to specialized use-cases such as running the normal pgbench scenario with nonstandard indexes, or inserting other actions between steps of the initialization sequence.
- Install Windows crash dump handler before all else
Noah Misch: Apart from calling write_stderr() on failure, the handler depends on no PostgreSQL facilities.
Most Popular In The Past Month
- Support domains over composite types
Tom Lane: This is the last major omission in our domains feature: you can now make a domain over anything that's not a pseudotype.
The major complication from an implementation standpoint is that places that might be creating tuples of a domain type now need to be prepared to apply domain_check().
- Add hash partitioning
Robert Haas: Hash partitioning is useful when you want to partition a growing data set evenly.
- First-draft release notes for 10.1.
Tom Lane: As usual, the release notes for other branches will be made by cutting these down, but put them up for community review first.
- Always require SELECT permission for ON CONFLICT DO UPDATE.
Dean Rasheed: The update path of an INSERT ...
- Release notes for 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20, 9.2.24.
Tom Lane: In the v10 branch, also back-patch the effects of 1ff01b390 and c29c57890 on these files, to reduce future maintenance issues.
- Remove secondary checkpoint
Simon Riggs: Previously server reserved WAL for last two checkpoints, which used too much disk space for small servers.
- Add -wnet to SP invocations
Peter Eisentraut: This causes a warning when accidentally backpatching an XML-style empty-element tag like <xref linkend="abc"/>.
- In client support of v10 features, use standard schema handling
Noah Misch: Back-patch to v10.
- Fix ALTER TABLE code to update domain constraints when needed
Tom Lane: It's possible for dropping a column, or altering its type, to require changes in domain CHECK constraint expressions; but the code was previously only expecting to find dependent table CHECK constraints.
- doc: Add to hot standby documentation
Peter Eisentraut: Document the order of changing certain settings when using hot-standby servers.