- Desktop
- Enterprise
- Gaming
- Graphics
- Hardware
- Linux Kernel
- Multimedia
- Operating Systems
- Programming
- System Internals
- All Projects
- Latest News
- Open master branch for glibc 2.38 development
- glibc: Create ChangeLog.old/ChangeLog.26.
- Linux Kernel: Linux 6.2-rc6
- lok: support per-user timezone
- Merge branch 'no-more-gl' into 'master'
- lavfi: Add vf_ssim360 filter
- libavcodec/amfenc: add AV1 encoding support
- Remove support for 32-bit S390
- Latest News (cont.)
- Remove support for AIX
- darwin: Implement DetermineClientCmd for macOS
- nb/intel/gm45: Wedge DDR2 SPD support in
- Add eager and lazy freezing strategies to VACUUM.
- tdf#153090 sw: add UI to SwTOXSelectTabPage
- sw: add document model for multi-page fly frames
- WINE: Release 8.0.
- Add non-decimal integer support to type numeric
- Linux Kernel: Linux 6.2-rc5
- WINE: Release 8.0-rc5.
- sw HTML import: initial CSS support on tables
Featured content is also available via:
PostgreSQL
PostgeSQL is a leading open-source SQL database server.
Recent Activity
- Generate code for query jumbling through gen_node_support.pl
Michael Paquier: This commit changes the query jumbling code in queryjumblefuncs.c to be generated automatically based on the information of the nodes in the headers of src/include/nodes/ by using gen_node_support.pl. - Ensure that MERGE recomputes GENERATED expressions properly
Dean Rasheed: This fixes a bug that, under some circumstances, would cause MERGE to fail to properly recompute expressions for GENERATED STORED columns. Formerly, ExecInitModifyTable() did not call ExecInitStoredGenerated() for a MERGE command, which meant that the generated expressions information was not computed until later, when the first merge action was executed. - Add eager and lazy freezing strategies to VACUUM.
Peter Geoghegan: Eager freezing strategy avoids large build-ups of all-visible pages. - Add non-decimal integer support to type numeric
Dean Rasheed: This enhances the numeric type input function, adding support for hexadecimal, octal, and binary integers of any size, up to the limits of the numeric type. Since 6fcda9aba8, such non-decimal integers have been accepted by the parser as integer literals and passed through to numeric_in(). - Remove special outfuncs/readfuncs handling of RangeVar.catalogname
Tom Lane: Historically we skipped writing/reading this field, but that no longer works under WRITE_READ_PARSE_PLAN_TREES since we expanded the coverage of that option to include utility commands (787102b56). - Add non-destructive modes to pgindent
Andrew Dunstan: This adds two modes of running pgindent, neither of which results in any changes being made to the source code. - Optimise numeric division for 3 and 4 base-NBASE digit divisors
Dean Rasheed: On platforms with 128-bit integer support, introduce a new function div_var_int64(), along the same lines as div_var_int() added in d1b307eef2 for divisors with 1 or 2 base-NBASE digits, and use it to speed up div_var() and div_var_fast() in a similar way when the divisor has 3 or 4 base-NBASE digits. - Allow parallel aggregate on string_agg and array_agg
David Rowley: This adds combine, serial and deserial functions for the array_agg() and string_agg() aggregate functions, thus allowing these aggregates to partake in partial aggregations. - Track logrep apply workers' last start times to avoid useless waits
Tom Lane: Enforce wal_retrieve_retry_interval on a per-subscription basis, rather than globally, and arrange to skip that delay in case of an intentional worker exit. - Allow REPLICA IDENTITY to be set on an index that's not (yet) valid
Tom Lane: The motivation for this change is that when pg_dump dumps a partitioned index that's marked REPLICA IDENTITY, it generates a command sequence that applies REPLICA IDENTITY before the partitioned index has been marked valid, causing restore to fail.
PostgreSQL Release Tags
- 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 - Bump PG_CONTROL_VERSION for previous 9.4 changes
Tom Lane: This should have been done in 6bc8ef0b7f1f1df3998745a66e1790e27424aa0c and/or 50e547096c4858a68abf09894667a542cc418315, but better late than never.
Most Popular In The Past Month
- instr_time: Represent time as an int64 on all platforms
Andres Freund: Until now we used struct timespec for instr_time on all platforms but windows. - Remove redundant grouping and DISTINCT columns
Tom Lane: Avoid explicitly grouping by columns that we know are redundant for sorting, for example we need group by only one of x and y in SELECT ... - Invent random_normal() to provide normally-distributed random numbers
Tom Lane: There is already a version of this in contrib/tablefunc, but it seems sufficiently widely useful to justify having it in core. - Add new GUC createrole_self_grant
Robert Haas: Can be set to the empty string, or to either or both of "set" or "inherit". - Improve handling of inherited GENERATED expressions
Tom Lane: In both partitioning and traditional inheritance, require child columns to be GENERATED if and only if their parent(s) are. - Windows support in pg_import_system_collations
Peter Eisentraut: Windows can enumerate the locales that are either installed or supported by calling EnumSystemLocalesEx(), similar to what is already done in the READ_LOCALE_A_OUTPUT switch. - Add new GUC reserved_connections
Robert Haas: This provides a way to reserve connection slots for non-superusers. - Create common infrastructure for cross-version upgrade testing
Tom Lane: To test pg_upgrade across major PG versions, we have to be able to modify or drop any old objects with no-longer-supported properties, and we have to be able to deal with cosmetic changes in pg_dump output. - Add BufFileRead variants with short read and EOF detection
Peter Eisentraut: Most callers of BufFileRead() want to check whether they read the full specified length. - Add non-decimal integer support to type numeric
Dean Rasheed: This enhances the numeric type input function, adding support for hexadecimal, octal, and binary integers of any size, up to the limits of the numeric type. Since 6fcda9aba8, such non-decimal integers have been accepted by the parser as integer literals and passed through to numeric_in().