- Desktop
- Enterprise
- Gaming
- Graphics
- Hardware
- Linux Kernel
- Multimedia
- Operating Systems
- Programming
- System Internals
- All Projects
- Latest News
- Add backend-level statistics to pgstats
- Linux Kernel: Linux 6.13-rc3
- Implement C23 atan2pi
- Add UUID version 7 generation function
- Implement C23 atanpi
- Add TEST_CC and TEST_CXX support
- Enable BUFFERS with EXPLAIN ANALYZE by default
- Implement C23 asinpi
- Latest News (cont.)
- Tests for logical replication with temporal keys
- Implement C23 acospi
- Linux Kernel: Linux 6.13-rc2
- Implement C23 tanpi
- swscale/aarch64: add neon {lum,chr}ConvertRange16
- tools/xl: add suspend and resume subcommands
- avformat/mov: add support for pssh box
- avutil/csp: add EOTF function definitions
- Implement C23 sinpi
- Implement C23 cospi
- Pixman: Pre-release version bump to 0.44.2
Featured content is also available via:
PostgreSQL
PostgeSQL is a leading open-source SQL database server.
Yesterday's Activity
- Optimize alignment calculations in tuple form/deform
David Rowley: Here we convert CompactAttribute.attalign from a char, which is directly derived from pg_attribute.attalign into a uint8, which stores the number of bytes to align the column's value by in the tuple. This allows tuple deformation and tuple size calculations to move away from using the inefficient att_align_nominal() macro, which manually checks each TYPALIGN_* char to translate that into the alignment bytes for the given type. - Introduce CompactAttribute array in TupleDesc, take 2
David Rowley: The new compact_attrs array stores a few select fields from FormData_pg_attribute in a more compact way, using only 16 bytes per column instead of the 104 bytes that FormData_pg_attribute uses.
Other Activity This Week
- Get rid of old version of BuildTupleHashTable().
Tom Lane: It was reasonable to preserve the old API of BuildTupleHashTable() in the back branches, but in HEAD we should actively discourage use of that version. - Convert SetOp to read its inputs as outerPlan and innerPlan
Tom Lane: The original design for set operations involved appending the two input relations into one and adding a flag column that allows distinguishing which side each row came from. - Add backend-level statistics to pgstats
Michael Paquier: This adds a new variable-numbered statistics kind in pgstats, where the object ID key of the stats entries is based on the proc number of the backends. - Add common interface for TBMIterators
Melanie Plageman: Add and use TBMPrivateIterator, which replaces the current TBMIterator for serial use cases, and repurpose TBMIterator to be a unified interface for both the serial ("private") and parallel ("shared") TID Bitmap iterator interfaces. - psql: Add more information about service name
Michael Paquier: This commit adds support for the following items in psql, able to show a service name, when available: - libpq: Add service name to PGconn and PQservice()
Michael Paquier: This commit adds one field to PGconn for the database service name (if any), with PQservice() as routine to retrieve it. - Avoid unnecessary wrapping for more complex expressions
Richard Guo: When pulling up a subquery that is under an outer join, if the subquery's target list contains a strict expression that uses a subquery variable, it's okay to pull up the expression without wrapping it in a PlaceHolderVar: if the subquery variable is forced to NULL by the outer join, the expression result will come out as NULL too. If the strict expression does not contain any subquery variables, the current code always wraps it in a PlaceHolderVar. - Refactor string case conversion into provider-specific files
Jeff Davis: Create API entry points pg_strlower(), etc., that work with any provider and give the caller control over the destination buffer. - psql: Tab completion for ALTER TYPE ... ADD ATTRIBUTE
Tomas Vondra: Improve psql tab completion for ALTER TYPE ...
PostgreSQL Release Tags
- Support SSL_R_VERSION_TOO_LOW when using LibreSSL
Daniel Gustafsson: The SSL_R_VERSION_TOO_LOW error reason is supported in LibreSSL since LibreSSL 3.6.3, shipped in OpenBSD 7.2. - Log OpenSSL version in ./configure output
Michael Paquier: This information is useful to know when scanning buildfarm results, and it is already displayed in Meson. - meson: Improve PG_VERSION_STR generation
Andres Freund: Previously the host operating system and 32/64 bit were not included and the build machine's cpu was used, which is potentially wrong for cross builds. - Fix ALTER COLLATION "default" REFRESH VERSION.
Jeff Davis: Issue a helpful error message rather than an internal error. Discussion: - Require version 0.98 of Test::More for TAP tests
Andrew Dunstan: This means that the subtest feature will be available for use. We expect that this change will make prairiedog go red until it is updated, but other buildfarm animals should be fine. Discussion: - doc: Fix link reference for PGSSLMAXPROTOCOLVERSION
Michael Paquier: The link was pointing to the minimum protocol version. - nbtree: BTREE_[MIN|NOVAC]_VERSION comment tweaks
Peter Geoghegan: Author: Peter Geoghegan - Automate the maintenance of SO_MINOR_VERSION for our shared libraries
Tom Lane: Up to now we've manually adjusted these numbers in several different Makefiles at the start of each development cycle. - Advance PG_CONTROL_VERSION.
Tom Lane: This should have been done in commit 73c986adde5d73a5 which added several new fields to pg_control, and again in commit 5028f22f6eb05798 which changed the CRC algorithm, but it wasn't. - Tab complete CREATE EXTENSION .. VERSION.
Robert Haas: Jeff Janes
Most Popular In The Past Month
- Add backend-level statistics to pgstats
Michael Paquier: This adds a new variable-numbered statistics kind in pgstats, where the object ID key of the stats entries is based on the proc number of the backends. - Support LIKE with nondeterministic collations
Peter Eisentraut: This allows for example using LIKE with case-insensitive collations. - Add UUID version 7 generation function
Masahiko Sawada: This commit introduces the uuidv7() SQL function, which generates UUID version 7 as specified in RFC 9652. - jsonapi: add lexer option to keep token ownership
Andrew Dunstan: Commit 0785d1b8b adds support for libpq as a JSON client, but allocations for string tokens can still be leaked during parsing failures. - Enable BUFFERS with EXPLAIN ANALYZE by default
David Rowley: The topic of turning EXPLAIN's BUFFERS option on with the ANALYZE option has come up a few times over the past few years. - Add a planner support function for numeric generate_series().
Dean Rasheed: This allows the planner to estimate the number of rows returned by generate_series(numeric, numeric[, numeric]), when the input values can be estimated at plan time. - Tests for logical replication with temporal keys
Peter Eisentraut: This covers some cases that were previously failing before the "Support for GiST in get_equal_strategy_number()" patch. Author: Paul A. - Reordering DISTINCT keys to match input path's pathkeys
Richard Guo: The ordering of DISTINCT items is semantically insignificant, so we can reorder them as needed. - Require sizeof(bool) == 1.
Thomas Munro: The C standard says that sizeof(bool) is implementation-defined, but we know of no current systems where it is not 1. - jit: Use -mno-outline-atomics for bitcode on ARM.
Thomas Munro: If the executable's .o files were produced by a compiler (probably gcc) not using -moutline-atomics, and the corresponding .bc files were produced by clang using -moutline-atomics (probably by default), then the generated bitcode functions would have the target attribute "+outline-atomics", and could fail at runtime when inlined.