PostgreSQL
PostgeSQL is a leading open-source SQL database server.
www.postgresql.org
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.
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().