Re: Fwd: Receipt for PostgreSQL US Invoice #1840

I filed it under SPAM. As I do most things with a PDF or other attachment that looks even the slightest iffy. If I had my way, such people would be impaled. On Tue, Mar 12, 2024, 21:27 Adrian Klaver wrote: > On 3/12/24 19:14, Christophe Pettus wrote: > > Oops? > > > > > > >> Begin forwarded mess

Re: Receipt for PostgreSQL US Invoice #1840

> On Mar 12, 2024, at 19:27, Adrian Klaver wrote: > > Oops? Oops. Apologies for the mis-forward.

Re: Fwd: Receipt for PostgreSQL US Invoice #1840

On 3/12/24 19:14, Christophe Pettus wrote: Oops? Begin forwarded message: *From: *Sadie Bella > *Subject: **Fwd: Receipt for PostgreSQL US Invoice #1840* *Date: *March 12, 2024 at 19:13:40 PDT *To: *Christophe mailto:x...@dvvent.com>> -- Forwarded

Fwd: Receipt for PostgreSQL US Invoice #1840

Begin forwarded message:From: Sadie Bella Subject: Fwd: Receipt for PostgreSQL US Invoice #1840Date: March 12, 2024 at 19:13:40 PDTTo: Christophe -- Forwarded message -From: Date: Tue, Mar 12, 2024, 7:07 PMSubject:

Re: Is it possible to keep track of SELECTs?

On 2024-Mar-12, Dominique Devienne wrote: > So is it possible to track the last time a SELECT was performed on some > TABLE? Perhaps you could use the pgAudit module for this purpose. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/

RE: [External] Simple way to simulate a bug in logical replication

Please note: I tried it also with Postgres 15.6 and the behavior is the same I'm running inside docker. I do not know if it matters... Hi All, I think I hit a bug in logical replication in version 15.2. I sync two tables of size 305MB but pg_stat_progress_copy shows that 5GB as bytes_processed

Re: Is it possible to keep track of SELECTs?

On Tue, 2024-03-12 at 16:34 +0100, Dominique Devienne wrote: > PostgreSQL tables and indexes are ultimately files. > And there are ways to map them to file names, I've seen in the past. > So isn't it possible, provided the filesystem tracks last access time, to > infer when a table was accessed th

Re: Is it possible to keep track of SELECTs?

On Tue, Mar 12, 2024 at 3:30 PM Christophe Pettus wrote: > > On Mar 12, 2024, at 07:15, Dominique Devienne > wrote: > > So is it possible to track the last time a SELECT was performed on some > TABLE? > > Directly, no. You could periodically sample the various table-level > statistics, and conc

Re: Simple way to simulate a bug in logical replication

On Tue, Mar 12, 2024 at 11:16 AM Avi Weinberg wrote: > Hi All, > > > > I think I hit a bug in logical replication in version 15.2. > But 15.6 is the latest version. Maybe it's been fixed since then.

Simple way to simulate a bug in logical replication

Hi All, I think I hit a bug in logical replication in version 15.2. I sync two tables of size 305MB but pg_stat_progress_copy shows that 5GB as bytes_processed and the sync takes forever. Is this a bug? If so, what can I do with this scenario? Thanks Create a dummy table CREATE TABLE exampl

Re: could not open file "global/pg_filenode.map": Operation not permitted

On 3/12/24 02:57, Nick Renders wrote: On 11 Mar 2024, at 16:04, Adrian Klaver wrote: On 3/11/24 03:11, Nick Renders wrote: Thank you for your reply Laurenz. I don't think it is related to any third party security software. We have several other machines with a similar setup, but this is the o

Re: Is it possible to keep track of SELECTs?

> On Mar 12, 2024, at 07:15, Dominique Devienne wrote: > So is it possible to track the last time a SELECT was performed on some TABLE? Directly, no. You could periodically sample the various table-level statistics, and conclude that tables that have had some type of scan since the last sca

Is it possible to keep track of SELECTs?

Hi, Our legacy 3-tier backend is adding a feature requested by users, to keep track of the last-access-time of projects. The primary purpose is to archive projects which haven't been used (read from) in a while (offline), or perhaps move them to a cheaper / slower storage tier (still online, but s

Re: could not open file "global/pg_filenode.map": Operation not permitted

On 11 Mar 2024, at 16:04, Adrian Klaver wrote: > On 3/11/24 03:11, Nick Renders wrote: >> Thank you for your reply Laurenz. >> I don't think it is related to any third party security software. We have >> several other machines with a similar setup, but this is the only server >> that has this is

Re: pgBadger: Cannot find any log entries from systemd-journald

Hello, Sorry for the late response. Am 06.03.24 um 16:40 schrieb Greg Sabino Mullane: On Tue, Mar 5, 2024 at 3:14 AM Frank Lanitz mailto:fr...@frank.uvena.de>> wrote: $ pgbadger --journalctl "journalctl -u postgresql.service" You could try adding --verbose to see if it gives more clues.

RE: [External] Re: walsender RAM increases by 500 MB while data is 80 MB

Hi, Thanks Masahiko Sawada for your reply. We did not have many transactions running when walsenders started consuming more than expected RAM. We only had 1-2 transactions that inserted a row with about 40-70 MB of binary data to a table. Changing logical_decoding_work_mem to as low as 1MB di