doc: Remove LC_COLLATE and LC_CTYPE from SHOW command

2024-12-04 Thread Pierre Giraud
b/?p=postgresql.git;a=commit;h=b0f6c437160db640d4ea3e49398ebc3ba39d1982 From 32575b9478ecff4dd27a7215f9d34e6eb2abf6d0 Mon Sep 17 00:00:00 2001 From: Pierre GIRAUD Date: Wed, 4 Dec 2024 09:03:02 +0100 Subject: [PATCH v1] doc: remove LC_COLLATE and LC_CTYPE from SHOW command The corresponding read-only server setti

Re: [PATCH] Add extra statistics to explain for Nested Loop

2020-10-19 Thread Pierre Giraud
Le 17/10/2020 à 06:26, Julien Rouhaud a écrit : > On Sat, Oct 17, 2020 at 12:15 PM Pavel Stehule > wrote: >> >> so 17. 10. 2020 v 0:11 odesílatel Anastasia Lubennikova >> napsal: >>> >>> On 16.10.2020 12:07, Julien Rouhaud wrote: >>> >>> Le ven. 16 oct. 2020 à 16:12, Pavel Stehule a >>> éc

Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)

2020-08-20 Thread Pierre Giraud
Le 20/08/2020 à 17:41, Fujii Masao a écrit : > > > On 2020/08/20 22:34, Julien Rouhaud wrote: >> On Thu, Aug 20, 2020 at 12:29 PM David Rowley >> wrote: >>> >>> On Thu, 20 Aug 2020 at 19:58, Fujii Masao >>> wrote: On 2020/08/20 13:00, David Rowley wrote: > I forgot to mention earl

Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)

2020-08-20 Thread Pierre Giraud
Can you please show what the plan would look like for? =# explain (buffers on, summary on, format JSON) select * from t; Le 20/08/2020 à 09:58, Fujii Masao a écrit : > > > On 2020/08/20 13:00, David Rowley wrote: >> On Thu, 20 Aug 2020 at 03:31, Fujii Masao >> wrote: >>> With the patch, for

Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)

2020-08-07 Thread Pierre Giraud
Le 07/08/2020 à 14:52, Julien Rouhaud a écrit : > Hi, > > On Fri, Aug 7, 2020 at 2:30 PM Pierre Giraud wrote: >> >> Hi all, >> >> As far as I understand, in the upcoming version 13, information about >> buffers used during planning is now ava

[PG13] Planning (time + buffers) data structure in explain plan (format text)

2020-08-07 Thread Pierre Giraud
Hi all, As far as I understand, in the upcoming version 13, information about buffers used during planning is now available in the explain plan. […] Planning Time: 0.203 ms Buffers: shared hit=14 […] In the JSON format, the data structure is a bit different: […] "Planning": { "P

Re: Poll: are people okay with function/operator table redesign?

2020-04-16 Thread Pierre Giraud
Le 16/04/2020 à 16:43, Tom Lane a écrit : > Pierre Giraud writes: >> Le 16/04/2020 à 00:18, Tom Lane a écrit : >>> The main disadvantage I can see to the v2 design is that we're back >>> to having two per function, which is inevitably going to result >&

Re: Poll: are people okay with function/operator table redesign?

2020-04-15 Thread Pierre Giraud
Le 16/04/2020 à 00:18, Tom Lane a écrit : > As I threatened to do earlier, I made a pass at converting table 9.10 > to a couple of the styles under discussion. (This is just a > draft-quality patch, so it might have some minor bugs --- the point > is just to see what these styles look like.) >

Explain: Duplicate key "Workers" in JSON format

2019-08-23 Thread Pierre Giraud
Hi, I'm currently working on a tool to visualize an execution plan [1]. For those who know PEV, it's actually a fork of this great tool since it hasn't been active for more than 2 years. Among other things, I'd like to show information for the parallel queries. First of which is information about