One last ping, hoping someone will have more time now than in january.
Perhaps my test is wrong, but I'd like to know why.
Thanks.
Le mar. 17 janv. 2023 à 16:53, Guillaume Lelarge a
écrit :
> Quick ping, just to make sure someone can get a look at this issue :)
> Thanks.
>
>
>
Quick ping, just to make sure someone can get a look at this issue :)
Thanks.
Le ven. 6 janv. 2023 à 11:07, Guillaume Lelarge a
écrit :
> Hello,
>
> One of our customers has an issue with partitions and foreign keys. He
> works on a v13, but the issue is also present on v15.
>
&
Hello,
One of our customers has an issue with partitions and foreign keys. He
works on a v13, but the issue is also present on v15.
I attach a SQL script showing the issue, and the results on 13.7, 13.9, and
15.1. But I'll explain the script here, and its behaviour on 13.9.
There is one
Le ven. 3 juin 2022 à 19:29, Nathan Bossart a
écrit :
> On Fri, Jun 03, 2022 at 12:56:20PM -0400, Tom Lane wrote:
> > Nathan Bossart writes:
> >> Another option could be to move it after the "Input/Output" section so
> that
> >> it's closer to some other commands that involve files. I can't
Le mer. 13 avr. 2022 à 11:29, Alvaro Herrera a
écrit :
> On 2022-Apr-13, Guillaume Lelarge wrote:
>
> > Once again, I've found that there was no .po file for oid2name, pgbench,
> > and vacuumlo. I suppose that's because they are contrib applications. But
> > pgbenc
Hello,
I've been working yesterday on the translation of v15 .po french files.
Once again, I've found that there was no .po file for oid2name, pgbench,
and vacuumlo. I suppose that's because they are contrib applications. But
pgbench is no longer a contrib application. It's now located in the
Le jeu. 7 avr. 2022 à 15:44, Frédéric Yhuel a
écrit :
>
>
> On 4/7/22 14:40, Justin Pryzby wrote:
> > On Thu, Apr 07, 2022 at 01:37:57PM +0200, Frédéric Yhuel wrote:
> >> Maybe something along this line? (patch attached)
> > Some language fixes.
>
> Thank you Justin! I applied your fixes in the
Le ven. 25 mars 2022, 14:25, Tom Lane a écrit :
> Guillaume Lelarge writes:
> > Did this get anywhere? Is there something we could do to make this move
> > forward?
>
> No. Write a patch?
>
I wouldn't have asked if I could write such a patch :-)
Le dim. 2 janv. 2022 à 01:07, Noah Misch a écrit :
> On Sat, Jan 01, 2022 at 11:35:02AM -0500, Tom Lane wrote:
> > Noah Misch writes:
> > > I get the same results. The leak arises because AIX freelocale()
> doesn't free
> > > all memory allocated in newlocale(). The following program uses
>
Le jeu. 30 déc. 2021 à 17:25, Tom Lane a écrit :
> Japin Li writes:
> > On Thu, 30 Dec 2021 at 18:53, Guillaume Lelarge
> wrote:
> >> pg_dump works in a single transaction, so it's already dealt with
> >> idle_in_transaction_timeout. Though I guess setting both
Le jeu. 30 déc. 2021 à 12:01, Japin Li a écrit :
>
> On Thu, 30 Dec 2021 at 18:53, Guillaume Lelarge
> wrote:
> > Le jeu. 30 déc. 2021 à 11:44, Japin Li a écrit :
> >
> >>
> > pg_dump works in a single transaction, so it's already dealt with
> > i
Le jeu. 30 déc. 2021 à 11:44, Japin Li a écrit :
>
> On Thu, 30 Dec 2021 at 17:18, Guillaume Lelarge
> wrote:
> > Hello,
> >
> > I've been reading the autovacuum code (the launcher and the worker) on
> the
> > 14 branch. As previously, I've seen
Hello,
I've been reading the autovacuum code (the launcher and the worker) on the
14 branch. As previously, I've seen some configuration at the beginning,
especially for statement_timeout, lock_timeout and
idle_in_transaction_session_timeout, and I was surprised to discover there
was no
Le sam. 11 déc. 2021 à 07:52, Justin Pryzby a écrit :
> On Fri, Dec 10, 2021 at 03:40:50PM +0100, Guillaume Lelarge wrote:
> > Hello,
> >
> > Our customer thinks he has found a memory leak on ECPG and AIX.
> >
> > The code is quite simple. It declares a cursor, o
Hello,
Our customer thinks he has found a memory leak on ECPG and AIX.
The code is quite simple. It declares a cursor, opens it, and fetches the
only line available in the table many times. After some time, the client
crashes with a segfault error. According to him, it consumed around 256MB.
Le mer. 1 déc. 2021 à 19:48, Tom Lane a écrit :
> Justin Pryzby writes:
> > @Guillaume: Even if memory use with the patch isn't constant, I imagine
> it's
> > enough to have avoided OOM.
>
> I think it's good enough in HEAD. In the back branches, the sinval
> queue growth is bad enough that
Le mar. 30 nov. 2021 à 00:25, Tom Lane a écrit :
> Guillaume Lelarge writes:
> > Le lun. 29 nov. 2021 à 22:27, Tom Lane a écrit :
> >> I'm checking it in HEAD though; perhaps there's something else wrong
> >> in the back branches?
>
> > That's also wh
Le lun. 29 nov. 2021 à 22:47, Tom Lane a écrit :
> Guillaume Lelarge writes:
> > Le lun. 29 nov. 2021 à 22:27, Tom Lane a écrit :
> >> I'm checking it in HEAD though; perhaps there's something else wrong
> >> in the back branches?
>
> > That's also wh
Le lun. 29 nov. 2021 à 22:27, Tom Lane a écrit :
> Guillaume Lelarge writes:
> > Le lun. 29 nov. 2021 à 20:39, Tom Lane a écrit :
> >> [ looks closer ... ] Ah, that patch is a bit buggy: it fails to do the
> >> right thing in the cases where the loop does
Le lun. 29 nov. 2021 à 20:39, Tom Lane a écrit :
> Guillaume Lelarge writes:
> > I've tried Justin's patch but it didn't help with my memory allocation
> > issue. FWIW, I attach the patch I used in v14.
>
> [ looks closer ... ] Ah, that patch is a bit buggy: it fails to
Le lun. 29 nov. 2021 à 19:40, Tom Lane a écrit :
> Justin Pryzby writes:
> > I reproduced the issue like this.
>
> > psql postgres -c 'CREATE ROLE two WITH login superuser'
> > psql postgres two -c "SELECT lo_import('/dev/null') FROM
> generate_series(1,22111)" >/dev/null
> > psql postgres -c
Hi,
One of our customers had a very bad issue while trying to reassign objects
from user A to user B. He had a lot of them, and the backend got very
hungry for memory. It finally all went down when the linux kernel decided
to kill the backend (-9 of course).
I attach three shell scripts showing
Le mer. 30 juin 2021 à 22:44, Tom Lane a écrit :
> The Core Team would like to extend our congratulations to
> Daniel Gustafsson and John Naylor, who have accepted invitations
> to become our newest Postgres committers.
>
> Please join me in wishing them much success and few bugs.
>
>
Congrats
Le ven. 25 juin 2021 à 08:55, Amit Kapila a
écrit :
> On Thu, Jun 24, 2021 at 6:38 PM Amit Kapila
> wrote:
> >
> > On Thu, Jun 24, 2021 at 5:27 PM Guillaume Lelarge
> > wrote:
> > >
> > > Really tiny patch attached to fix this if it really
Hey,
I was translating logicaldecoding.sgml, and I saw this sentence:
There are multiple required streaming callbacks
(stream_start_cb, stream_stop_cb,
stream_abort_cb, stream_commit_cb
and stream_change_cb) and two optional callbacks
(stream_message_cb) and
(stream_truncate_cb).
The two last
Le mar. 25 mai 2021 à 00:05, Tom Lane a écrit :
> Guillaume Lelarge writes:
> > While working on the french translation of the manual, I found that one
> > column of pg_stats_ext was on the pg_stats columns' list. Here is a quick
> > patch to fix this.
>
> Right
Hey,
While working on the french translation of the manual, I found that one
column of pg_stats_ext was on the pg_stats columns' list. Here is a quick
patch to fix this.
Regards.
--
Guillaume.
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index 8aebc4d12f..1063168646
Le ven. 21 mai 2021 à 05:43, Amit Kapila a écrit :
> On Fri, May 21, 2021 at 1:30 AM Guillaume Lelarge
> wrote:
> >
> >
> >> If so, the
> >> problem might be that copying the data of the first table creates a
> >> transaction which bloc
Hi,
Le jeu. 20 mai 2021 à 12:09, Amit Kapila a écrit :
> On Wed, Apr 28, 2021 at 2:43 PM Guillaume Lelarge
> wrote:
> >
> > And it logs the "still waiting" message as long as the first table is
> being synchronized. Once this is done, it releases the
Le mer. 28 avr. 2021 à 11:37, Guillaume Lelarge a
écrit :
> Le mer. 28 avr. 2021 à 11:12, Guillaume Lelarge
> a écrit :
>
>> Hi,
>>
>> One of my customers has an issue with logical replication. As $SUBJECT
>> says, multiple table synchronization happens seriall
Le mer. 28 avr. 2021 à 11:12, Guillaume Lelarge a
écrit :
> Hi,
>
> One of my customers has an issue with logical replication. As $SUBJECT
> says, multiple table synchronization happens serially. To be honest, it
> doesn't do this every time. It happens when the tables
Hi,
One of my customers has an issue with logical replication. As $SUBJECT
says, multiple table synchronization happens serially. To be honest, it
doesn't do this every time. It happens when the tables are big enough.
This issue was already described on this thread (from 2017):
Le jeu. 15 avr. 2021 à 09:58, Michael Paquier a
écrit :
> On Wed, Apr 14, 2021 at 05:31:15AM -0700, Noah Misch wrote:
> > The name "without_extension_explicit_schema" arose because that test
> differs
> > from the "without_extension" test by adding --schema=public. The test
> named
> >
Le mer. 31 mars 2021 à 02:37, Michael Paquier a
écrit :
> On Tue, Mar 30, 2021 at 12:02:45PM +0900, Michael Paquier wrote:
> > Okay. So I have looked at that stuff in details, and after fixing
> > all the issues reported upthread in the code, docs and tests I am
> > finishing with the attached.
Le lun. 15 mars 2021 à 11:32, Julien Rouhaud a écrit :
> Le lun. 15 mars 2021 à 18:25, Michael Paquier a
> écrit :
>
>> On Mon, Mar 15, 2021 at 06:21:55PM +0800, Julien Rouhaud wrote:
>> > Is that a feature you really want to see in pg14? If yes and if you're
>> sure
>> > you won't have time
Le lun. 15 mars 2021 à 06:00, Michael Paquier a
écrit :
> On Sun, Feb 21, 2021 at 08:14:45AM +0900, Michael Paquier wrote:
> > Okay, that sounds fine to me. Thanks for confirming.
>
> Guillaume, it has been a couple of weeks since your last update. Are
> you planning to send a new version of
Le sam. 20 févr. 2021 à 17:31, Tom Lane a écrit :
> Michael Paquier writes:
> > As presented in this patch, specifying both --extension and
> > --table/--schema means that pg_dump will dump both tables and
> > extensions matching the pattern passed down. But shouldn't extensions
> > not be
Le sam. 20 févr. 2021 à 13:25, Michael Paquier a
écrit :
> On Thu, Feb 18, 2021 at 11:13:06AM +0100, Guillaume Lelarge wrote:
> > I finally managed to get a working TAP test for my patch. I have no idea
> if
> > it's good, and if it's enough. Anyway, new version of
Le mar. 26 janv. 2021 à 13:42, Guillaume Lelarge a
écrit :
> Le mar. 26 janv. 2021 à 13:41, Guillaume Lelarge
> a écrit :
>
>> Le mar. 26 janv. 2021 à 05:10, Julien Rouhaud a
>> écrit :
>>
>>> On Mon, Jan 25, 2021 at 9:34 PM Guillaume Lelarge
>>>
Hi,
Thanks for the review.
Le mer. 3 févr. 2021 à 18:33, Asif Rehman a écrit :
> The following review has been posted through the commitfest application:
> make installcheck-world: tested, passed
> Implements feature: tested, passed
> Spec compliant: not tested
>
Le mar. 26 janv. 2021 à 13:41, Guillaume Lelarge a
écrit :
> Le mar. 26 janv. 2021 à 05:10, Julien Rouhaud a
> écrit :
>
>> On Mon, Jan 25, 2021 at 9:34 PM Guillaume Lelarge
>> wrote:
>> >
>> > "Anytime soon" was a long long time ago,
Le mar. 26 janv. 2021 à 05:10, Julien Rouhaud a écrit :
> On Mon, Jan 25, 2021 at 9:34 PM Guillaume Lelarge
> wrote:
> >
> > "Anytime soon" was a long long time ago, and I eventually completely
> forgot this, sorry. As nobody worked on it yet, I took a s
Hi,
Le sam. 23 mai 2020 à 14:53, Guillaume Lelarge a
écrit :
> Le mer. 20 mai 2020 à 16:39, Tom Lane a écrit :
>
>> Guillaume Lelarge writes:
>> > Le mer. 20 mai 2020 à 11:26, Daniel Gustafsson a
>> écrit :
>> >> The question is what --extensions sh
Hi,
Here is a quick issue I found on the BRIN documentation. I'm not a 100%
sure I'm right but it looks like a failed copy/paste from the GIN
documentation.
Cheers.
--
Guillaume.
diff --git a/doc/src/sgml/brin.sgml b/doc/src/sgml/brin.sgml
index 4c5eeb875f..55b6272db6 100644
---
Le mer. 3 juin 2020 à 04:16, David Fetter a écrit :
> On Tue, Jun 02, 2020 at 09:28:48PM +0200, Vik Fearing wrote:
> > On 6/2/20 7:54 PM, David G. Johnston wrote:
> > > At this point, given the original goal of the patch was to try and
> > > grease a smoother path to changing the default for
Le mar. 26 mai 2020 à 16:25, Stephen Frost a écrit :
> Greetings,
>
> * Guillaume Lelarge (guilla...@lelarge.info) wrote:
> > Le mar. 26 mai 2020 à 04:27, Stephen Frost a écrit
> :
> > > To that end- what if this was done client-side with '\explain' or
> > >
Le mar. 26 mai 2020 à 04:27, Stephen Frost a écrit :
> Greetings,
>
> * Michael Paquier (mich...@paquier.xyz) wrote:
> > On Mon, May 25, 2020 at 09:36:50PM -0400, Bruce Momjian wrote:
> > > I am not excited about this new feature. Why do it only for EXPLAIN?
>
> Would probably help to
Le mer. 20 mai 2020 à 16:39, Tom Lane a écrit :
> Guillaume Lelarge writes:
> > Le mer. 20 mai 2020 à 11:26, Daniel Gustafsson a
> écrit :
> >> The question is what --extensions should do: only dump any
> >> extensions that objects in the schema depend on
Le mer. 20 mai 2020 à 11:26, Daniel Gustafsson a écrit :
> > On 20 May 2020, at 10:06, Guillaume Lelarge
> wrote:
>
> > I was wondering the reason behind this choice. If anyone knows, I'd be
> happy to hear about it.
>
> Extensions were dumped uncon
Hello,
I've discovered something today that I didn't really expect. When a user
dumps a database with the --schema flag of pg_dump, extensions in this
schema aren't dumped. As far as I can tell, the documentation isn't clear
about this ("Dump only schemas matching pattern; this selects both the
Hi,
Le jeu. 7 mai 2020 à 11:13, Marc Rechté a écrit :
> Hello,
>
> It is possible to startup an instance with min > max, without the system
> complaining:
>
> mrechte=# show min_wal_size ;
>
> 2020-05-07 11:12:11.422 CEST [11098] LOG: durée : 0.279 ms
>
> min_wal_size
>
> --
>
>
Le ven. 3 janv. 2020 à 09:06, Amit Kapila a
écrit :
> On Thu, Jan 2, 2020 at 7:09 PM Guillaume Lelarge
> wrote:
> >
> > Le jeu. 2 janv. 2020 à 13:09, Amit Kapila a
> écrit :
> >>
> >> If parallel vacuum is *not* enabled by default, then I think th
Le jeu. 2 janv. 2020 à 13:09, Amit Kapila a
écrit :
> Hi,
>
> I am starting a new thread for some of the decisions for a parallel vacuum
> in the hope to get feedback from more people. There are mainly two points
> for which we need some feedback.
>
> 1. Tomas Vondra has pointed out on the main
Le jeu. 26 déc. 2019 à 10:26, Julien Rouhaud a écrit :
> On Thu, Dec 26, 2019 at 10:20 AM Guillaume Lelarge
> wrote:
> >
> > Le jeu. 26 déc. 2019 à 09:49, Julien Rouhaud a
> écrit :
> >>
> >> On Thu, Dec 26, 2019 at 9:08 AM Guillaume Lelarge
> >>
Le jeu. 26 déc. 2019 à 09:49, Julien Rouhaud a écrit :
> On Thu, Dec 26, 2019 at 9:08 AM Guillaume Lelarge
> wrote:
> >
> > Le mer. 25 déc. 2019 à 19:30, Julien Rouhaud a
> écrit :
> >>
> >> On Wed, Dec 25, 2019 at 7:03 PM Julien Rouhaud
> wrote
Le mer. 25 déc. 2019 à 19:30, Julien Rouhaud a écrit :
> On Wed, Dec 25, 2019 at 7:03 PM Julien Rouhaud wrote:
> >
> > Guillaume (in Cc) recently pointed out [1] that it's currently not
> > possible to retrieve the list of parallel workers for a given backend
> > at the SQL level. His use case
Le mer. 12 juin 2019 à 20:45, Alvaro Herrera a
écrit :
> On 2019-May-14, Michael Paquier wrote:
>
> > Thanks, committed. I have noticed an extra one in reorderbuffer.c.
>
> Some grepping found a bit more; patch attached.
>
>
Thanks a lot, this is very good. I've got some fixes to do :)
--
Le dim. 9 juin 2019 à 04:27, Michael Paquier a écrit :
> On Sat, Jun 08, 2019 at 04:23:55PM +0200, Guillaume Lelarge wrote:
> > We might find more typos, but it will take time. Applying this patch now
> > (if it fits you) is probably better.
>
> I can imagine that it is a
Le sam. 8 juin 2019 à 15:44, Julien Rouhaud a écrit :
> On Sat, Jun 8, 2019 at 3:33 PM Michael Paquier
> wrote:
> >
> > Hi Guillaume,
> >
> > On Wed, May 29, 2019 at 08:28:59PM +0200, Guillaume Lelarge wrote:
> > > Sure.
> >
> > I
Le mer. 29 mai 2019 19:52, Michael Paquier a écrit :
> On Wed, May 29, 2019 at 07:47:12PM +0200, Guillaume Lelarge wrote:
> > Yeah, I still have quite a lot to process. That might be better to do it
> > all in once.
>
> OK, thanks! Could you ping me on this thread once you
Le mer. 29 mai 2019 19:45, Michael Paquier a écrit :
> On Wed, May 29, 2019 at 05:30:33PM +0200, Guillaume Lelarge wrote:
> > And here is another one. See patch attached.
>
> Are you still going through some parts of the documentation? Perhaps
> you may notice something els
Le mar. 28 mai 2019 à 21:46, Guillaume Lelarge a
écrit :
> Le mar. 28 mai 2019 à 21:28, Michael Paquier a
> écrit :
>
>> On Tue, May 28, 2019 at 05:05:10PM +0200, Guillaume Lelarge wrote:
>> >
>> >> linkend="catalog-pg-am">pg_am
&
Le mar. 28 mai 2019 à 21:28, Michael Paquier a écrit :
> On Tue, May 28, 2019 at 05:05:10PM +0200, Guillaume Lelarge wrote:
> >
> > linkend="catalog-pg-am">pg_am
> > - index access methods
> > + table and index access methods
Issue found while translating the v12 manual. I also fixed something that
was missing, as far as I understand it (first fix, the typo is the second
fix).
See patch attached.
Thanks.
--
Guillaume.
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index 4c7e93892a..f81f3d4160
64 matches
Mail list logo
