Hello,
On Sat, 2024-09-21 at 10:20 -0700, Adrian Klaver wrote:
> On 9/21/24 02:36, veem v wrote:
> >
> >
>
> >
> > Actually here the application is using kafka and flink stream and
> > is
> > using one of existing code in which it was doing row by row commit
> > which
> > is now changed to
Hi Justin,
Thank you for your suggestions and detailed insights.
Due to certain business constraints, we are unable to split the tables into
parallel publications. All of the tables involved are primary key tables,
which adds further complexity to separating them into multiple publications.
That
Hi,
Is it possible to start a pglogical subscription from a specific lsn? I am
on 16.2 pg version and pglogical extension version is 2.4.4, don't see any
argument to pass lsn in pglogical.create_subscription function.
On 2024-09-22 09:53:58 -0700, Adrian Klaver wrote:
> On 9/22/24 09:48, Paul Förster wrote:
> > Then I strongly suggest that the PostgreSQL developers develop a
> > fail safe sorting mechanism that holds for generations of locale
> > changes.
>
> https://www.postgresql.org/docs/17/release-17.html#R
On 2024-09-21 12:15:44 -0700, Adrian Klaver wrote:
> FYI, this is less of problem with psycopg(3) and pipeline mode:
>
[...]
> with db.pipeline():
> for i in range(1, num_inserts+1):
> csr.execute("insert into parent_table values(%s, %s)", (i, 'a'))
> if i % batch_size == 0:
>
On 2024-09-21 20:55:13 +0530, Lok P wrote:
> On Sat, Sep 21, 2024 at 8:07 PM Peter J. Holzer wrote:
[... lots of code elided. method2 used 1 insert per row, method3 1
insert for 50 rows ...]
> On my laptop, method2 is about twice as fast as method3. But if I
> connect to a database on the
On 9/22/24 12:53, Adrian Klaver wrote:
On 9/22/24 09:48, Paul Förster wrote:
Hi Joe
On 22. Sep, 2024, at 15:47, Joe Conway wrote:
Note that moving to ICU might improve things, but there are similar potential
issues with ICU as well. The trick there would be to get your OS distro
provider t
On 9/22/24 09:48, Paul Förster wrote:
Hi Joe
On 22. Sep, 2024, at 15:47, Joe Conway wrote:
Note that moving to ICU might improve things, but there are similar potential
issues with ICU as well. The trick there would be to get your OS distro
provider to maintain the same ICU version across m
Hi Ron,
> On 22. Sep, 2024, at 16:11, Ron Johnson wrote:
>
> The real question is why nobody notices it in other RDBMSs like Oracle, SQL
> Server and MySQL.
The answer is simple for Oracle: It includes a whole zoo of locale mappings and
uses each one as it is needed. This is one of the many t
Hi Joe
> On 22. Sep, 2024, at 15:47, Joe Conway wrote:
>
> Note that moving to ICU might improve things, but there are similar potential
> issues with ICU as well. The trick there would be to get your OS distro
> provider to maintain the same ICU version across major versions of the
> distro,
On 9/21/24 22:21, Lok P wrote:
On Sun, Sep 22, 2024 at 12:46 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
Thank you. So if I get it correct, if the client app(from which the data
is getting streamed/inserted) is in the same data center/zone as the
database (which is most
Am Sun, Sep 22, 2024 at 02:59:34PM +0100 schrieb Shaheed Haque:
> I've been working on Unix-like systems for decades and though I thought I
> understood most of the issues to do with i18n/l10n, I've only just started
> using Postgres and I don't understand is why these changes ONLY seem to
> affec
You may be able to solve this with advisory locks. In particular,
transaction-level advisory locks with the "try-pass/fail" variant. Here,
"123" is a unique number used by your app, related to this particular
table. You also need to force read committed mode, as the advisory locks go
away after the
Shaheed,
How often do you sort words in text editors?
How often do you have your text editor care whether the word you just typed
is the *only* instance of that word in the document?
Not too often. So... yes, we ignore the problem.
The real question is why nobody notices it in other RDBMSs like
I've been working on Unix-like systems for decades and though I thought I
understood most of the issues to do with i18n/l10n, I've only just started
using Postgres and I don't understand is why these changes ONLY seem to
affect Postgres. Or is it more that it also affects text editors and the
like,
On 9/21/24 15:19, Paul Foerster wrote:
I already expressed the idea of changing all locales to ICU. The
problem there is that I'd have to create new instances and then move
each database individually. I wish I could convert already running
databases… This also takes time. Still, I think I'm going
16 matches
Mail list logo
