On Tue, Sep 13, 2022 at 08:17:27AM +1200, David Rowley wrote:
> > certain operating systems, PostgreSQL 15 supports the ability to
> > [prefetch WAL file
> > contents](https://www.postgresql.org/docs/15/runtime-config-wal.html#GUC-RECOVERY-PREFETCH)
>
> I think "ability to prefetch WAL file conte
On Tue, 13 Sept 2022 at 08:56, Jonathan S. Katz wrote:
> What do you think of this (copied from the attached file)
>
> On certain operating systems, PostgreSQL 15 adds support to [prefetch
> pages referenced in
> WAL](https://www.postgresql.org/docs/15/runtime-config-wal.html#GUC-RECOVERY-PREFETCH
On 9/12/22 4:17 PM, David Rowley wrote:
On Tue, 13 Sept 2022 at 04:53, Jonathan S. Katz wrote:
Here is a (penultimate?) draft that includes URLs. Please provide any
additional feedback no later than 2022-09-14 0:00 AoE. After that, we
will begin the translation process.
Thanks for drafting th
On Tue, 13 Sept 2022 at 04:53, Jonathan S. Katz wrote:
> Here is a (penultimate?) draft that includes URLs. Please provide any
> additional feedback no later than 2022-09-14 0:00 AoE. After that, we
> will begin the translation process.
Thanks for drafting these up.
I noticed a couple of things,
On 9/12/22 3:34 PM, Justin Pryzby wrote:
On Mon, Sep 12, 2022 at 12:52:49PM -0400, Jonathan S. Katz wrote:
sorted. Using `row_number()`, `rank()`, and `count()` as
[window functions](https://www.postgresql.org/docs/15/functions-window.html)
also have performance benefits in PostgreSQL 15, and qu
On Mon, Sep 12, 2022 at 12:52:49PM -0400, Jonathan S. Katz wrote:
> sorted. Using `row_number()`, `rank()`, and `count()` as
> [window functions](https://www.postgresql.org/docs/15/functions-window.html)
> also have performance benefits in PostgreSQL 15, and queries using
Remove "using" ?
> certa
On 9/12/22 2:01 PM, Peter Eisentraut wrote:
On 12.09.22 18:52, Jonathan S. Katz wrote:
On 9/1/22 9:10 PM, Jonathan S. Katz wrote:
New version attached.
Here is a (penultimate?) draft that includes URLs. Please provide any
additional feedback no later than 2022-09-14 0:00 AoE. After that, we
On 12.09.22 18:52, Jonathan S. Katz wrote:
On 9/1/22 9:10 PM, Jonathan S. Katz wrote:
New version attached.
Here is a (penultimate?) draft that includes URLs. Please provide any
additional feedback no later than 2022-09-14 0:00 AoE. After that, we
will begin the translation process.
Is t
On 9/1/22 9:10 PM, Jonathan S. Katz wrote:
New version attached.
Here is a (penultimate?) draft that includes URLs. Please provide any
additional feedback no later than 2022-09-14 0:00 AoE. After that, we
will begin the translation process.
Thanks,
Jonathan
The PostgreSQL Global Developm
On 8/31/22 8:15 PM, Justin Pryzby wrote:
On Tue, Aug 30, 2022 at 03:58:48PM -0400, Jonathan S. Katz wrote:
In this latest release, PostgreSQL improves on its in-memory and on-disk sorting
algorithms, with benchmarks showing speedups of 25% - 400% based on sort types.
rather than "based on": "
On 8/31/22 1:51 PM, Michael Banck wrote:
Hi,
On Tue, Aug 30, 2022 at 03:58:48PM -0400, Jonathan S. Katz wrote:
### Other Notable Changes
PostgreSQL server-level statistics are now collected in shared memory,
eliminating the statistics collector process and writing these stats to disk.
PostgreS
On Tue, Aug 30, 2022 at 03:58:48PM -0400, Jonathan S. Katz wrote:
> In this latest release, PostgreSQL improves on its in-memory and on-disk
> sorting
> algorithms, with benchmarks showing speedups of 25% - 400% based on sort
> types.
rather than "based on": "depending on the data types being s
Hi,
On Tue, Aug 30, 2022 at 03:58:48PM -0400, Jonathan S. Katz wrote:
> ### Other Notable Changes
>
> PostgreSQL server-level statistics are now collected in shared memory,
> eliminating the statistics collector process and writing these stats to disk.
> PostgreSQL 15 also revokes the `CREATE` pe
13 matches
Mail list logo
