Re: logical decoding and replication of sequences

2022-03-12 Thread Peter Eisentraut
Further review (based on 20220310 patch): doc/src/sgml/ref/create_publication.sgml | 3 + For the clauses added to the synopsis, descriptions should be added below. See attached patch for a start. src/backend/commands/sequence.c| 79 ++ There is quite a bit of

Re: range_agg with multirange inputs

2022-03-12 Thread Chapman Flack
On 03/11/22 22:18, Paul Jungwirth wrote: > Arg, fixed. > >> In range_agg_transfn, you've changed the message in the "must be called >> with a range or multirange"; that seems like another good candidate to >> be an elog. > > Agreed. Updated here. This looks good to me and passes

Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*)

2022-03-12 Thread Justin Pryzby
On Sun, Mar 13, 2022 at 09:45:35AM +0900, Michael Paquier wrote: > On Wed, Mar 09, 2022 at 10:50:45AM -0600, Justin Pryzby wrote: > > Rebased over 9e9858389 (Michael may want to look at the tuplestore part?). > > Are you referring to the contents of 0003 here that changes the > semantics of

Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*)

2022-03-12 Thread Michael Paquier
On Wed, Mar 09, 2022 at 10:50:45AM -0600, Justin Pryzby wrote: > Rebased over 9e9858389 (Michael may want to look at the tuplestore part?). Are you referring to the contents of 0003 here that changes the semantics of pg_ls_dir_files() regarding its setup call? -- Michael signature.asc

Re: Allow async standbys wait for sync replication

2022-03-12 Thread Nathan Bossart
On Tue, Mar 08, 2022 at 06:01:23PM -0800, Andres Freund wrote: > To me it's architecturally the completely wrong direction. We should move in > the *other* direction, i.e. allow WAL to be sent to standbys before the > primary has finished flushing it locally. Which requires similar >

Re: EXPLAIN vs track_io_timing=on vs tests

2022-03-12 Thread Andres Freund
Hi, On 2020-10-29 16:10:37 -0700, Andres Freund wrote: > I run my development instances with track_io_timing=on, as I've found > that to be really useful. Unfortunately that causes tests to fail > whenever I forget to turn that off to run installcheck. > > The diffs are caused by the additional

Re: create_index test fails when synchronous_commit = off @ master

2022-03-12 Thread Andres Freund
On 2022-03-11 10:38:22 +0300, Aleksander Alekseev wrote: > > Here is an updated patch that includes the commit message. > > Since this is a trivial change and no one seems to object to it so far, I'm > going to re-check the patch against the recent `master` and change its > status to "Ready for

Re: Optimize external TOAST storage

2022-03-12 Thread Nathan Bossart
I think this is an interesting idea. My first thought is that it would be nice if we didn't have to first compress the data to see whether we wanted to store it compressed or not, but I don't think there is much we can do about that. In any case, we aren't adding much work in the write path

Re: Add index scan progress to pg_stat_progress_vacuum

2022-03-12 Thread Nathan Bossart
On Sat, Mar 12, 2022 at 07:00:06AM +, Imseih (AWS), Sami wrote: >> nitpick: Can we remove the extra spaces in the parentheses? > > fixed > >> What does it mean if there isn't an entry in the map? Is this actually >> expected, or should we ERROR instead? > > I cleaned up the code here and

Re: Issue with pg_stat_subscription_stats

2022-03-12 Thread Andres Freund
Hi, On 2022-03-12 08:28:35 +0530, Amit Kapila wrote: > On Sat, Mar 12, 2022 at 2:14 AM Melanie Plageman > wrote: > > > > So, I noticed that pg_stat_reset_subscription_stats() wasn't working > > properly, and, upon further investigation, I'm not sure the view > > pg_stat_subscription_stats is

Re: psql - add SHOW_ALL_RESULTS option

2022-03-12 Thread Fabien COELHO
Are you planning to send a rebased patch for this commit fest? Argh, I did it in a reply in another thread:-( Attached v15. So as to help moves things forward, I'd suggest that we should not to care too much about corner case repetition of some error messages which are due to libpq

Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce)

2022-03-12 Thread Justin Pryzby
On Tue, Jan 25, 2022 at 10:19:53AM +0530, Shruthi Gowda wrote: > On Tue, Jan 25, 2022 at 1:14 AM Robert Haas wrote: > > On Sat, Jan 22, 2022 at 2:20 AM Shruthi Gowda wrote: > > > Agree. In the latest patch, the template0 and postgres OIDs are fixed > > > to unused manually assigned OIDs 4 and 5

[GSOC 22] GUI representation of monitoring System Activity with the system_stats Extension in pgAdmin 4

2022-03-12 Thread Arjun Prashanth
Hello PGSQL Mailing List, I am Arjun a 2nd year CSE Student and I am eager to contribute to this community and was interested in the GUI System Admin Dashboard project mentioned here

Re: support for MERGE

2022-03-12 Thread Justin Pryzby
On Sat, Jan 29, 2022 at 12:03:35AM -0600, Justin Pryzby wrote: > Note that MergeWhenClause and MergeAction have the node definition in a > different order than the header, which is a bit confusing. The .h files still order these fields differently than the other .h files, and then the node funcs

Re: support for MERGE

2022-03-12 Thread Alvaro Herrera
FYI I intend to get the ModifyTable split patch (0001+0003) pushed hopefully on Tuesday or Wednesday next week, unless something really ugly is found on it. As for MERGE proper, I'm aiming at getting that one pushed on the week starting March 21st, though of course I'll spend some more time on it

Re: Add parameter jit_warn_above_fraction

2022-03-12 Thread Justin Pryzby
On Mon, Mar 07, 2022 at 04:02:16PM +0100, Magnus Hagander wrote: > On Mon, Mar 7, 2022 at 2:09 PM Justin Pryzby wrote: > > On Mon, Mar 07, 2022 at 01:10:32PM +0100, Magnus Hagander wrote: > > > On Fri, Feb 25, 2022 at 5:23 PM Justin Pryzby > > > wrote: > > > > > > > > I think it should be a

Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors

2022-03-12 Thread Fabien COELHO
Hello Yugo-san, About Pgbench error handling v16: This patch set needs a minor rebase because of 506035b0. Otherwise, patch compiles, global and local "make check" are ok. Doc generation is ok. This patch is in good shape, the code and comments are clear. Some minor remarks below,

Re: pg_stat_statements and "IN" conditions

2022-03-12 Thread Dmitry Dolgov
> On Thu, Mar 10, 2022 at 12:11:59PM -0500, Tom Lane wrote: > Dmitry Dolgov <9erthali...@gmail.com> writes: > > New status: Waiting on Author > > > This seems incorrect, as the only feedback I've got was "this is a bad > > idea", and no reaction on follow-up questions. > > I changed the status

Re: pg_walinspect - a new extension to get raw WAL data and WAL stats

2022-03-12 Thread Bharath Rupireddy
On Sat, Mar 12, 2022 at 2:09 AM Robert Haas wrote: > > On Thu, Mar 10, 2022 at 9:38 PM Kyotaro Horiguchi > wrote: > > It seems to me too rigorous that pg_get_wal_records_info/stats() > > reject future LSNs as end-LSN and I think WARNING or INFO and stop at > > the real end-of-WAL is more kind to

Re: pg_walinspect - a new extension to get raw WAL data and WAL stats

2022-03-12 Thread Bharath Rupireddy
On Fri, Mar 11, 2022 at 7:53 PM Ashutosh Sharma wrote: > > Some comments on pg_walinspect-docc.patch this time: > > + > + > + pg_get_wal_record_info(in_lsn pg_lsn, lsn OUT pg_lsn, > prev_lsn OUT pg_lsn, xid OUT xid, resource_manager OUT text, length > OUT int4, total_length OUT int4,

Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints

2022-03-12 Thread Dilip Kumar
On Fri, Mar 11, 2022 at 11:51 PM Robert Haas wrote: > > On Fri, Mar 11, 2022 at 1:10 PM Robert Haas wrote: > > I don't think you've adequately considered temporary relations here. > > It seems to be that ReadBufferWithoutRelcache() could not be safe on a > > temprel, because we'd need a

Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*)

2022-03-12 Thread Fabien COELHO
Hello Justin, Review about v34, up from v32 which I reviewed in January. v34 is an updated version of v32, without the part about lstat at the end of the series. All 7 patches apply cleanly. # part 01 One liner doc improvement about the directory flag. OK. # part 02 Add tests for