- Desktop
- Enterprise
- Gaming
- Graphics
- Hardware
- Linux Kernel
- Multimedia
- Operating Systems
- Programming
- System Internals
- All Projects
- Latest News
- oox: initial customshape preset data loader
- oox: add customshapes preset data
- i965: Add writes_accumulator flag
- i965/vec4: Add support for the MAC instruction
- i965/fs: Add support for the MAC instruction
- drawtext: Add fontconfig support
- less: use the outsourced packages
- oox: add --data switch to generatePresetsCXX.pl
- Latest News (cont.)
- hmac: Add support for SHA-512 in GHmac
- Updated Basque language
- DragonFlyBSD: initrd: Fix installation during make release
- gengrid: apply key binidng
- Split outdev2.cxx
- list: apply key binding
- ilo: add genhw headers
- BlueZ: Release 5.18
- radeon/vce: add proper CPB backtrack
- mfw I forget git add
- libdrm: Bump version to 2.4.53 for release
Featured content is also available via:
PostgreSQL
PostgeSQL is a leading open-source SQL database server.
Other Activity This Week
- Provide moving-aggregate support for boolean aggregates
Tom Lane - Provide moving-aggregate support for a bunch of numerical aggregates
Tom Lane: First installment of the promised moving-aggregate support in built-in aggregates: count(), sum(), avg(), stddev() and variance() for assorted datatypes, though not for float4/float8. In passing, remove a 2001-vintage kluge in interval_accum(): interval array elements have been properly aligned since around 2003, but nobody remembered to take out this workaround. - Create infrastructure for moving-aggregate optimization
Tom Lane: Until now, when executing an aggregate function as a window function within a window with moving frame start (that is, any frame start mode except UNBOUNDED PRECEDING), we had to recalculate the aggregate from scratch each time the frame head moved.
Recent Activity
- Provide moving-aggregate support for boolean aggregates
Tom Lane - Provide moving-aggregate support for a bunch of numerical aggregates
Tom Lane: First installment of the promised moving-aggregate support in built-in aggregates: count(), sum(), avg(), stddev() and variance() for assorted datatypes, though not for float4/float8. In passing, remove a 2001-vintage kluge in interval_accum(): interval array elements have been properly aligned since around 2003, but nobody remembered to take out this workaround. - Create infrastructure for moving-aggregate optimization
Tom Lane: Until now, when executing an aggregate function as a window function within a window with moving frame start (that is, any frame start mode except UNBOUNDED PRECEDING), we had to recalculate the aggregate from scratch each time the frame head moved. - Add an in-core GiST index opclass for inet/cidr types
Tom Lane: This operator class can accelerate subnet/supernet tests as well as btree-equivalent ordered comparisons. - Block signals earlier during postmaster startup
Tom Lane: Formerly, we set up the postmaster's signal handling only when we were about to start launching subprocesses. - Avoid promising that "ADD COLUMN ... DEFAULT NULL" is free
Tom Lane: The system realizes that DEFAULT NULL is dummy in simple cases, but not if a cast function (such as a length coercion) needs to be applied. - Add -f/--follow option to pg_xlogdump
Heikki Linnakangas: This is useful for seeing what WAL records are inserted in real-time, by pointing pg_xlogdump to a live server. - Documentation for logical decoding
Robert Haas: Craig Ringer, Andres Freund, Christian Kruse, with edits by me. - Add pg_recvlogical, a tool to receive data logical decoding data
Robert Haas: This is fairly basic at the moment, but it's at least useful for testing and debugging, and possibly more. - Release notes for 9.3.4, 9.2.8, 9.1.13, 9.0.17, 8.4.21.
Tom Lane
Most Popular In The Past Month
- Add pg_recvlogical, a tool to receive data logical decoding data
Robert Haas: This is fairly basic at the moment, but it's at least useful for testing and debugging, and possibly more. - Block signals earlier during postmaster startup
Tom Lane: Formerly, we set up the postmaster's signal handling only when we were about to start launching subprocesses. - Add -f/--follow option to pg_xlogdump
Heikki Linnakangas: This is useful for seeing what WAL records are inserted in real-time, by pointing pg_xlogdump to a live server. - Avoid promising that "ADD COLUMN ... DEFAULT NULL" is free
Tom Lane: The system realizes that DEFAULT NULL is dummy in simple cases, but not if a cast function (such as a length coercion) needs to be applied. - Add an in-core GiST index opclass for inet/cidr types
Tom Lane: This operator class can accelerate subnet/supernet tests as well as btree-equivalent ordered comparisons. - Documentation for logical decoding
Robert Haas: Craig Ringer, Andres Freund, Christian Kruse, with edits by me. - Create infrastructure for moving-aggregate optimization
Tom Lane: Until now, when executing an aggregate function as a window function within a window with moving frame start (that is, any frame start mode except UNBOUNDED PRECEDING), we had to recalculate the aggregate from scratch each time the frame head moved. - Provide moving-aggregate support for a bunch of numerical aggregates
Tom Lane: First installment of the promised moving-aggregate support in built-in aggregates: count(), sum(), avg(), stddev() and variance() for assorted datatypes, though not for float4/float8. In passing, remove a 2001-vintage kluge in interval_accum(): interval array elements have been properly aligned since around 2003, but nobody remembered to take out this workaround. - Provide moving-aggregate support for boolean aggregates
Tom Lane