Il 13/01/25 18:26, Adrian Klaver ha scritto:
On 1/13/25 08:59, Enrico Schenone wrote:
Il 13/01/25 17:19, Adrian Klaver ha scritto:
On 1/13/25 00:45, Enrico Schenone wrote:
Hello, Adrian.
As I said days ago, I have arranged a kind of stress test in
production environment.
I wrote a program th
On Mon, Jan 13, 2025 at 3:41 PM Peter J. Holzer wrote:
> On 2025-01-13 12:19:06 -0500, Ron Johnson wrote:
> > On Sun, Jan 12, 2025 at 5:59 PM Tom Lane wrote:
> > [snip]
> >
> > I think this idea is a nonstarter, TLS or not. We're generally
> moving
> > in the direction of never letting
On 2025-01-13 12:19:06 -0500, Ron Johnson wrote:
> On Sun, Jan 12, 2025 at 5:59 PM Tom Lane wrote:
> [snip]
>
> I think this idea is a nonstarter, TLS or not. We're generally moving
> in the direction of never letting the server see cleartext passwords.
> It's already possible to co
Hello, Yes, you are right; it seems that only 4 batches had data changes. However, the query also accessed other batches and then removed them again. What could be the reason for this and how can it be solved? Obviously, I would like to understand this situation better and learn the solution. I wou
Hello, Yes, you are right; this query is not a SELECT, it is an UPDATE query, there was a mistake in expressing it here. The columns I want to update here only operate on data from the last 3 months time interval. I am also sharing the EXPLAIN ANALYZE output of the relevant query below: Update on "
On 1/13/25 08:59, Enrico Schenone wrote:
Il 13/01/25 17:19, Adrian Klaver ha scritto:
On 1/13/25 00:45, Enrico Schenone wrote:
Hello, Adrian.
As I said days ago, I have arranged a kind of stress test in
production environment.
I wrote a program that loads a temporary table, loads 2049 rows in
Thank you for the response Justin found and fixed the error
On Mon, 13 Jan 2025, 10:15 pm Justin, wrote:
> Hi Divyansh,
>
> Go to the subscriber and look for errors in the PostgreSQL logs.
>
> When creating a subscription the default action is to sync the tables. Is
> the subscriber table empty?
On Sun, Jan 12, 2025 at 5:59 PM Tom Lane wrote:
[snip]
> I think this idea is a nonstarter, TLS or not. We're generally moving
> in the direction of never letting the server see cleartext passwords.
> It's already possible to configure libpq to refuse such requests
> (see require_auth parameter
On Mon, Jan 13, 2025 at 08:01:56PM +0300, Eşref Halıcıoğlu wrote:
> Yes, you are right; it seems that only 4 batches had data changes. However,
> the query also accessed other batches and then removed
> them again. What could be the reason for this and how can it be solved?
>
> Obviously, I woul
On 1/12/25 17:59, Tom Lane wrote:
"Peter J. Holzer" writes:
The web framework Django will automatically and transparently rehash any
password with the currently preferred algorithm if it isn't stored that
way already.
Really? That implies that the framework has access to the original
clearte
Il 13/01/25 17:19, Adrian Klaver ha scritto:
On 1/13/25 00:45, Enrico Schenone wrote:
Hello, Adrian.
As I said days ago, I have arranged a kind of stress test in
production environment.
I wrote a program that loads a temporary table, loads 2049 rows into
them from a baseline_table and finall
On Mon, Jan 13, 2025 at 07:48:09PM +0300, Eşref Halıcıoğlu wrote:
> Hello,
>
> Yes, you are right; this query is not a SELECT, it is an UPDATE query, there
> was a mistake in expressing it here. The columns I want
> to update here only operate on data from the last 3 months time interval.
>
>
Hi Divyansh,
Go to the subscriber and look for errors in the PostgreSQL logs.
When creating a subscription the default action is to sync the tables. Is
the subscriber table empty??
Thank you,
On Mon, Jan 13, 2025 at 7:30 AM Divyansh Gupta JNsThMAudy <
ag1567...@gmail.com> wrote:
> Hii PostgreS
On 1/13/25 00:45, Enrico Schenone wrote:
Hello, Adrian.
As I said days ago, I have arranged a kind of stress test in production
environment.
I wrote a program that loads a temporary table, loads 2049 rows into
them from a baseline_table and finally declare two nested cursors.
The first cursor i
On Mon, Jan 13, 2025 at 05:26:09PM +0300, Eşref Halıcıoğlu wrote:
> Hello,
>
> I have a query in PostgreSQL and I want this query to retrieve only data from
> the last 3 months. However, when I examine the query
> plan, I see that all partitions are listed.
Please note that your explain is for
On Mon, Jan 13, 2025 at 12:40:06PM +, nicolas wrote:
> Hello everyone,
>
> We are using postgresql v12 and added the pg_repack package
>
> Since I cannot stop other process, I use the “--no-kill-backend” and
> Pg_repack will wait indefinitly until pg_repack get the lock
>
> I get sometimes
> On Jan 13, 2025, at 5:30 AM, Divyansh Gupta JNsThMAudy
> wrote:
>
>
> Hii PostgreSQL Community,
>
> I am setting up logical replication between two clusters in the same subnet
> group. I’ve created a publication on the primary and a subscription on the
> secondary, and the replication
Hello, I have a query in PostgreSQL and I want this query to retrieve only data from the last 3 months. However, when I examine the query plan, I see that all partitions are listed. This raises a few questions in my mind:Are all partitions really being accessed, or only the partitions of the last 3
Hello everyone,
We are using postgresql v12 and added the pg_repack package
Since I cannot stop other process, I use the “--no-kill-backend” and Pg_repack
will wait indefinitly until pg_repack get the lock
I get sometimes a problem of lock:
sometimes, I get indefinitly this message : “NOTICE:
Hii PostgreSQL Community,
I am setting up logical replication between two clusters in the same subnet
group. I’ve created a publication on the primary and a subscription on the
secondary, and the replication slot has been created. However, the slot
remains inactive, and changes aren’t being applie
Am Donnerstag, dem 26.12.2024 um 13:48 +0200 schrieb Slava Shpitalny:
> Do you happen to have any updates on this issue?
Hi,
unfortunately not, the only thing I found is this in "man 2 open":
...
EINTR While blocked waiting to complete an open of a slow device
(e.g., a FIFO; see fifo(7)), the
Hello, Adrian.
As I said days ago, I have arranged a kind of stress test in production
environment.
I wrote a program that loads a temporary table, loads 2049 rows into
them from a baseline_table and finally declare two nested cursors.
The first cursor is on the temp table as parent while the se
22 matches
Mail list logo
