Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY

2024-02-06 Thread Olivier Gautherot
El mié, 7 feb 2024 8:07, Sean v escribió: > Exactly. I'm really just trying to understand if there's some functional > limitation to it being able to do that with how it executes these types of > queries, or if its just an optimization that hasn't been built into the > query planner yet. > > I

Re: Question on partitioning

2024-02-06 Thread Ron Johnson
On Tue, Feb 6, 2024 at 2:40 PM veem v wrote: > Thank you Laurenz. Got it. > > So basically , you mean to say any DDL on a table won't allow the table to > be read by other processes. I was under the assumption that it should allow > the read queries to move ahead at least. I must be wrong here.

Re: Question on partitioning

2024-02-06 Thread veem v
Thank you Laurenz. Got it. So basically , you mean to say any DDL on a table won't allow the table to be read by other processes. I was under the assumption that it should allow the read queries to move ahead at least. I must be wrong here. Thanks for correcting me. On Tue, 6 Feb 2024 at 15:46,

Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common

2024-02-06 Thread Marcelo Marques
gdal-libs package belongs to PostGIS PostGIS Support Ticket #5664 - https://trac.osgeo.org/postgis/ticket/5664#ticket On Tue, Feb 6, 2024 at 10:12 AM Marcelo Marques wrote: > I appreciate the reply. > We have an internal Satellite that we pull from the EPEL repo. > The Satellite Repos are

Re: Exclude certain application pgaudit logging?

2024-02-06 Thread Adrian Klaver
On 2/6/24 10:18 AM, Adrian Klaver wrote: On 2/6/24 10:11 AM, Ron Johnson wrote: Currently, we use Object audit logging to capture all READ access to columns FOO_1, FOO_2 and FOO_3 in table BAR.SCRABBLE.  (They are the three columns have PII data.) Using what audit software? Memo to

Re: Exclude certain application pgaudit logging?

2024-02-06 Thread Christophe Pettus
> On Feb 6, 2024, at 10:11, Ron Johnson wrote: > Thus, I'd like to exclude reads from "Postgresql JDBC Driver". (Currently, I > filter that out using "grep -v" in a shell script that runs hourly from cron, > but I find that unsatisfactory.) pgAudit doesn't currently include filters by

Re: Exclude certain application pgaudit logging?

2024-02-06 Thread Adrian Klaver
On 2/6/24 10:11 AM, Ron Johnson wrote: Currently, we use Object audit logging to capture all READ access to columns FOO_1, FOO_2 and FOO_3 in table BAR.SCRABBLE.  (They are the three columns have PII data.) Using what audit software? The problem is that the application legitimately

Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common

2024-02-06 Thread Marcelo Marques
I appreciate the reply. We have an internal Satellite that we pull from the EPEL repo. The Satellite Repos are refreshed daily by the IT department. It seems then that the EPEL repo has not been refreshed. I will check with my IT department. Thanks again for your help. On Mon, Feb 5, 2024 at 8:18 

Exclude certain application pgaudit logging?

2024-02-06 Thread Ron Johnson
Currently, we use Object audit logging to capture all READ access to columns FOO_1, FOO_2 and FOO_3 in table BAR.SCRABBLE. (They are the three columns have PII data.) The problem is that the application legitimately reads these columns thousands of times per day. Thus, the log fills up with

Re: Deleting duplicate rows using ctid ?

2024-02-06 Thread Andreas Kretschmer
Am 06.02.24 um 00:32 schrieb David G. Johnston: On Mon, Feb 5, 2024 at 4:09 PM David Gauthier wrote: I want the result to be just 2 recs, one for each dog. My present goto link for this question:

Re: Question on partitioning

2024-02-06 Thread Laurenz Albe
On Tue, 2024-02-06 at 00:26 +0530, veem v wrote: > On Mon, 5 Feb 2024 at 17:52, Laurenz Albe wrote: > > On Mon, 2024-02-05 at 03:09 +0530, veem v wrote: > > > In postgresql, Is it possible to partition an existing nonpartitioned > > > table having data > > > already residing in it and indexes

Re: Log pre-master keys during TLS v1.3 handshake

2024-02-06 Thread Daniel Gustafsson
> On 5 Feb 2024, at 22:38, Максим Чистяков wrote: > > Is there a way to save the pre-master keys which are encrypted TLS handshake > between PostgreSQL server and psql client due to a TLS handshake? > For example, in a Chrome you can save those keys due to connecting through > HTTPS with

Re: Unused indexes

2024-02-06 Thread Ron Johnson
On Mon, Feb 5, 2024 at 9:54 PM Greg Sabino Mullane wrote: > The pg_stat_*_tables tables idx_* columns has accumulated usage since the >> last time you started the postmaster. >> > > Actually, those persist at restart - you can use > > select datname, stats_reset from pg_stat_database; > > to

Log pre-master keys during TLS v1.3 handshake

2024-02-06 Thread Максим Чистяков
Is there a way to save the pre-master keys which are encrypted TLS handshake between PostgreSQL server and psql client due to a TLS handshake? For example, in a Chrome you can save those keys due to connecting through HTTPS with option --ssl-key-log-file or an environment variable SSLKEYLOGFILE (

Problem managing slots in Patroni

2024-02-06 Thread Fabrice Chapuis
Hi, I use patroni version 3.2.1. There is a point that I do not understand in the slots management with Patroni. Patroni creates a slot automatically on primary node when there is a standby attached, although this slot does not belong to the patroni configuration. How to prevent the automatic