On Tue, Jul 15, 2025 at 1:44 AM Laurenz Albe wrote:
>
> On Tue, 2025-07-15 at 01:51 +0900, Fujii Masao wrote:
> >
> > On 2025/06/18 6:53, Robert Treat wrote:
> > > I think the more cases where you document this behavior (and I do like
> > > the idea of docume
On Wed, Jun 18, 2025 at 4:12 PM Tom Lane wrote:
> Robert Treat writes:
> > On Fri, Feb 28, 2025 at 7:15 AM Ben Peachey Higdon
> > wrote:
> >> The current documentation for width_bucket
> >> (https://www.postgresql.org/docs/current/functions-math.html) does not
ng parallel builds.
>
> These references should be updated to include GIN indexes as well. Patch
> attached.
>
Makes sense, +1 from me.
Robert Treat
https://xzilla.net
sive.
>
I'm not sure it's the most ground breaking thing, but would probably
save a bunch of future people from having to gin up an example to test
it, so I'd probably update it per the following patch.
Robert Treat
https://xzilla.net
v1-0001-Document-width_bucket-range-as-inclusive-exclusiv.patch
Description: Binary data
On Tue, Jun 17, 2025 at 10:54 AM Fujii Masao
wrote:
> On 2025/06/13 21:09, Robert Treat wrote:
> > Well, I admit I mostly mentioned it because when I noticed this one
> > wasn't documented the same way the other ones were, I second-guessed
> > myself about if I knew how
On Thu, Jun 12, 2025 at 10:28 PM Fujii Masao
wrote:
> On 2025/06/07 0:13, Robert Treat wrote:
> > On Fri, Jun 6, 2025 at 9:57 AM David G. Johnston
> > wrote:
> >> On Friday, June 6, 2025, Fujii Masao wrote:
> >>>
> >>> Hi,
> >>>
&g
On Tue, Jun 10, 2025 at 11:50 PM Fujii Masao
wrote:
> On 2025/06/07 3:11, Robert Treat wrote:
> > On Thu, May 22, 2025 at 7:17 AM Fujii Masao
> > wrote:
> >> I noticed that the documentation is missing references to the database
> >> object statisti
EW,
- REINDEX, and LOCK TABLE on a
- relation.
+ REINDEX, LOCK TABLE,
+ and database object statistics manipulation functions
+ (see ) on a relation.
Robert Treat
https://xzilla.net
(This includes the time spent sleeping due to cost-based delays.)
>>
>>
>
>
> Makes sense. Our naming this table rewrite vacuum full does confuse people
> into thinking it is related to vacuum.
>
+1 for this change, but I think we should also update
n_ins_since_vacuum as well, no?
Robert Treat
https://xzilla.net
temp_lo); WRONG
> ERROR: aggregate functions are not allowed in WHERE
> LINE 1: SELECT city FROM weather WHERE temp_lo = max(temp_lo);
> ^
While this was a small change, I do think it was an improvement, so
bumping Euler's suggested patch as I think it got lost in the other
discussion.
Robert Treat
https://xzilla.net
;
> Originally, the secondary entries made sense because
> max_active_replication_origins was part of max_replication_slots,
> so both needed separate index entries. But commit 04ff636cbce
> split them into distinct parameters.
>
> Patch attached.
>
Make sense, +1 from me.
Robert Treat
https://xzilla.net
On Sat, Mar 29, 2025 at 10:58 AM David G. Johnston
wrote:
>
> On Saturday, March 29, 2025, Robert Treat wrote:
>>
>> On Thu, Mar 27, 2025 at 5:57 PM David G. Johnston
>> wrote:
>> > On Thu, Mar 27, 2025 at 2:28 PM Robert Treat wrote:
>> >> On Th
On Thu, Mar 27, 2025 at 5:57 PM David G. Johnston
wrote:
> On Thu, Mar 27, 2025 at 2:28 PM Robert Treat wrote:
>> On Thu, Mar 27, 2025 at 12:06 PM David G. Johnston
>> wrote:
>> > I expanded upon the material regarding using different file systems and
>> > dis
system snapshots to grab contents of the data directory without
grabbing wal (which can be handled separately).
Robert Treat
https://xzilla.net
ons should be able
to stand on their own while we are also making references back to
previous lessons. In this case, it does seem like we could satisfy
both use cases by adding:
DROP TABLE cities IF EXISTS;
DROP TABLE weather IF EXISTS;
Before the new create table commands. If you are following
sequentially, these will clean up for you, and if you came here as a
stand-alone these will no-op;
Robert Treat
https://xzilla.net
nd discussed.
> + the script used to find that information so that both the script
> + and the information can be checked and discussed.
>
>
+1 from me.
Robert Treat
https://xzilla.net
e talking about either streaming or wal shipping,
so I don't think we can completely eliminate that, but hopefully this
improves what we have.
> I don't think our current setup is sustainable so I think it does need
> to be cleaned up. Also, physical/logical replication slots also n
On Fri, Feb 14, 2025 at 3:00 AM Amit Langote
wrote:
> On Sun, Feb 9, 2025 at 12:59 AM Robert Treat wrote:
> > So, how does this thing get used? AFAIK there is no way to reference
> > these aliases at the query level, instead they only show up within
> > EXPLAIN VERBOSE
On Fri, Feb 7, 2025 at 11:56 AM Miłosz Chmura wrote:
>
>
>
> On Thu, Feb 6, 2025 at 10:22 PM Robert Treat wrote:
> > On Wed, Feb 5, 2025 at 5:11 AM PG Doc comments form
> > wrote:
> > >
> > > The following documentation comment has been logg
On Thu, Feb 6, 2025 at 5:33 PM Tom Lane wrote:
> Robert Treat writes:
> > On Mon, Feb 3, 2025 at 12:23 PM Tom Lane wrote:
> >> Hmm, I kind of like the up-front statement that timestamptz stores
> >> UTC. How about this simpler change?
>
> > I thought the re-
ot;name": "Wonder", "authors": [{"name": "Jun Murakami"},
{"name":"Craig Doe"}]}]
}}'::json, '$.favorites[*]' as fav
COLUMNS (
user_id FOR ORDINALITY,
NESTED '$.movies[*]'
COLUMNS (
movie_id FOR ORDINALITY,
mname text PATH '$.name',
director text),
NESTED '$.books[*]' as book
COLUMNS (
book_id FOR ORDINALITY,
bname text PATH '$.name',
NESTED '$.authors[*]' as writer
COLUMNS (
author_id FOR ORDINALITY,
author_name text PATH '$.fav.book.writer.name';
Note the last line. My assumption is that people concoct complIcated
enough json objects and path expressions that the aliasing makes it a
bit easier to follow. If that example sparks an example that you think
is worth adding (or maybe you think the above is?) please post it to
the list, I'd be happy to work it into a patch.
Robert Treat
https://xzilla.net
On Mon, Feb 3, 2025 at 12:23 PM Tom Lane wrote:
>
> =?utf-8?Q?=C3=81lvaro?= Herrera writes:
> > On 2025-Feb-03, Robert Treat wrote:
> >> This does seem to come up often enough that it probably is worth being
> >> a bit more explicit about how this works; att
ementation to put into core, but there
are some attempts to solve this problem floating around in extension
land. See https://github.com/mweber26/timestampandtz/blob/master/README.md
as one such attempt.
Robert Treat
https://xzilla.net
From 359a2df63065e3327ca3ab7cb0cfb73da6934a31 Mon Sep 17 00
at the idea of anyone actually
using this procedure.
Regards,
--
Robert Haas
EDB: http://www.enterprisedb.com
ps://stackoverflow.com/users/10081937/widuranga-dilruksha> reply here:
https://stackoverflow.com/questions/68808730/the-repository-https-apt-postgresql-org-pub-repos-apt-trusty-pgdg-release-do
best regards
Robert
Sigh, I should just go home now...
From: David G. Johnston
Sent: Thursday, January 27, 2022 10:26 AM
To: Kruus, Robert SPSA ; Pg Docs
Subject: Re: Datetime formatting
WARNING: This message originated from a source that is not managed by
SaskBuilds and Procurement, Information Technology
et again, and applied most of the
> suggested changes on HEAD as of 8550cbd, updating while on it some
> extra instances of "master" to "primary" to be more consistent with
> the other changes of this patch.
Merci monsieur!
Robert Treat
https://xzilla.net
On Mon, Sep 14, 2020 at 4:11 AM Michael Paquier wrote:
>
> On Sat, Sep 12, 2020 at 12:40:45PM -0400, Robert Treat wrote:
> > maybe "to one or more replicas." or maybe "to one or more replica
> > targets." I'd avoid the word cluster because you could set
On Fri, Sep 11, 2020 at 9:46 PM Michael Paquier wrote:
>
> On Fri, Sep 11, 2020 at 07:16:43PM -0400, Robert Treat wrote:
> > A recent discussion on slack prompted me to read through the
> > high-availability section of the docs, turning in to some suggested
> > changes th
attached, lmk if you have questions.
Robert Treat
https://xzilla.net
replication-wordsmithing.patch
Description: Binary data
No fair, I only looked at the back of the spine, not at the front page, so
I missed the actual subtitle :P
nice work Daniel
--trc
On Thu, Sep 10, 2020 at 1:50 PM Daniel Gustafsson wrote:
> > On 10 Sep 2020, at 11:26, PG Doc comments form
> wrote:
> >
> > The following documentation comment has
tation to build is pretty annoying.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
t up:
sudo port install docbook-xml-4.2 docbook-xsl fop
I have to also 'port install libxslt'. Otherwise, /usr/bin/xsltproc
is used, and it won't use files installed by MacPorts packages.
And then it takes, like you reported originally, an insanely long time.
--
Robert Haas
E
33 matches
Mail list logo
