- Desktop
- Enterprise
- Gaming
- Graphics
- Hardware
- Linux Kernel
- Multimedia
- Operating Systems
- Programming
- System Internals
- All Projects
- Latest News
- xwayland: Add glamor egl_backend for EGLStreams
- tools: Add initial code for btmon-logger
- gallivm: add early cse pass
- libavformat: add mbedTLS based TLS
- i965: perf: add support for raw queries
- i965: perf: enable GPA query statistics
- Linux Kernel: Linux 4.17-rc2
- [NDS32] Add unaligned access support
- Latest News (cont.)
- Remove IPsec and related code from the system
- avfilter: add deblock filter
- gallium/util: Android backtrace support
- x86: Enable -fcf-protection with multi-byte NOPs
- all: add support for thunderbolt networking
- swr/rast: Add some archrast stats
- swr/rast: Start refactoring of builder/packetizer
- swr/rast: Enable generalized fetch jit
- merge: branch 'bg/n-acd-rh1507864'
- [PR c++/80290] recycle tinst garbage sooner
- QEMU: Update version for v2.12.0-rc4 release
Featured content is also available via:
PostgreSQL
PostgeSQL is a leading open-source SQL database server.
Other Activity This Week
- Add GUC enable_partition_pruning
Alvaro Herrera: This controls both plan-time and execution-time new-style partition pruning. - Rework code to determine partition pruning procedure
Alvaro Herrera: Amit Langote reported that partition prune was unable to work with arrays, enums, etc, which led him to research the appropriate way to match query clauses to partition keys: instead of searching for an exact match of the expression's type, it is better to rely on the fact that the expression qual has already been resolved to a specific operator, and that the partition key is linked to a specific operator family. - Enlarge find_other_exec's meager fgets buffer
Alvaro Herrera: The buffer was 100 bytes long, which is barely sufficient when the version string gets longer (such as by configure --with-extra-version). - Fix datatype for number of heap tuples during last cleanup
Teodor Sigaev: It appears that new fields introduced in 857f9c36 have inconsistent datatypes: BTMetaPageData.btm_last_cleanup_num_heap_tuples is of float4 type, while xl_btree_metadata.last_cleanup_num_heap_tuples is of double type.
Recent Activity
- Update ExecInitPartitionInfo comment
Alvaro Herrera: Remove the words "if not already done." This obsolete wording corresponds to an early development version of what became edd44738bc8. - Add GUC enable_partition_pruning
Alvaro Herrera: This controls both plan-time and execution-time new-style partition pruning. - Rework code to determine partition pruning procedure
Alvaro Herrera: Amit Langote reported that partition prune was unable to work with arrays, enums, etc, which led him to research the appropriate way to match query clauses to partition keys: instead of searching for an exact match of the expression's type, it is better to rely on the fact that the expression qual has already been resolved to a specific operator, and that the partition key is linked to a specific operator family. - Enlarge find_other_exec's meager fgets buffer
Alvaro Herrera: The buffer was 100 bytes long, which is barely sufficient when the version string gets longer (such as by configure --with-extra-version). - Fix datatype for number of heap tuples during last cleanup
Teodor Sigaev: It appears that new fields introduced in 857f9c36 have inconsistent datatypes: BTMetaPageData.btm_last_cleanup_num_heap_tuples is of float4 type, while xl_btree_metadata.last_cleanup_num_heap_tuples is of double type. - Simplify genbki.pl's data quoting rules
Tom Lane: During the bootstrap data format conversion, it seemed important for verifiability's sake that the generated postgres.bki file stayed the same as before. - Add commentary explaining why MaxIndexTuplesPerPage calculation is safe
Tom Lane: MaxIndexTuplesPerPage ignores the fact that btree indexes sometimes store tuples with no data payload. - Cleanup covering infrastructure
Teodor Sigaev: - Explicitly forbids opclass, collation and indoptions (like DESC/ASC etc) for including columns. - doc: Add more information about logical replication privileges
Peter Eisentraut: In particular, the requirement to have SELECT privilege for the initial table copy was previously not documented. - Make reformat_dat_file.pl preserve all blank lines
Tom Lane: In its original form, reformat_dat_file.pl smashed consecutive blank lines to a single blank line, which was helpful for mopping up excess whitespace during the bootstrap data format conversion.
PostgreSQL Release Tags
- 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
- Add predicate locking for GiST
Teodor Sigaev: Add page-level predicate locking, due to gist's code organization, patch seems close to trivial: add check before page changing, add predicate lock before page scanning. - Add documentation for the JIT feature
Andres Freund: As promised in earlier commits, this adds documentation about the new build options, the new GUCs, about the planner logic when JIT is used, and the benefits of JIT in general. - Add catversion bump missed in 16828d5c0.
Andres Freund: Given that pg_attribute changed its layout. - Add inlining support to LLVM JIT provider
Andres Freund: This provides infrastructure to allow JITed code to inline code implemented in C. - Add casts from jsonb
Teodor Sigaev: Add explicit cast from scalar jsonb to all numeric and bool types. - New files for MERGE
Simon Riggs - Optimize btree insertions for common case of increasing values
Andrew Dunstan: Remember the last page of an index insert if it's the rightmost leaf page. - MERGE SQL Command following SQL:2016
Simon Riggs: MERGE performs actions that modify rows in the target table using a source table or query. - Allow to lock views
Tatsuo Ishii: Now all tables used in view definitions can be recursively locked by a LOCK command. - Support partition pruning at execution time
Alvaro Herrera: Existing partition pruning is only able to work at plan time, for query quals that appear in the parsed query.