Hey folks,
I run PostgreSQL v15.8 (docker official image), and there is an issue when
reading pg_stat_staments table with a result of query most of the times
having `` value.
I have created the user that I use to fetch the data with the following way:
```
CREATE USER abcd WITH NOSUPERUSER NOCREAT
On Tue, 2024-08-20 at 12:11 -0400, Ron Johnson wrote:
> On Tue, Aug 20, 2024 at 11:56 AM H wrote:
> > I am looking for pg_config for postgresql 13.16 that I run under Rocky
> > Linux 9. It seems RL appstream latest version is pg_config in
> > libpq-devel-13.11-1.el9.x86_64 but dnf complains:
> >
On Wed, Aug 21, 2024 at 02:19:22AM +1000, Justin Clift wrote:
> On 2024-08-20 22:44, Greg Sabino Mullane wrote:
> > On Fri, Jul 19, 2024 at 3:22 AM Laurenz Albe
> > wrote:
> >
> > > Why not say that authors who repeatedly post grossly counterfactual or
> > > misleading content can be banned?
> >
We have a set of operational tables that are all partitioned by
organization ID (customer ID) in the 100M row range. We also have 3-4
composite indexes on these tables that currently do not include the
organization ID. Any queries that reference these tables always provide the
organization ID as a
Ron Johnson writes:
> On Tue, Aug 20, 2024 at 11:56 AM H wrote:
>> I am looking for pg_config for postgresql 13.16 that I run under Rocky
>> Linux 9. It seems RL appstream latest version is pg_config in
>> libpq-devel-13.11-1.el9.x86_64 but dnf complains:
>> installed package postgresql13-"devel-
On 2024-08-20 22:44, Greg Sabino Mullane wrote:
On Fri, Jul 19, 2024 at 3:22 AM Laurenz Albe
wrote:
Why not say that authors who repeatedly post grossly counterfactual or
misleading content can be banned?
I like this, and feel we are getting closer. How about:
"Posts should be technically a
On Tue, Aug 20, 2024 at 11:56 AM H wrote:
> I am looking for pg_config for postgresql 13.16 that I run under Rocky
> Linux 9. It seems RL appstream latest version is pg_config in
> libpq-devel-13.11-1.el9.x86_64 but dnf complains:
> installed package postgresql13-"devel-13.16-2PGDG.rhel9.x86_64 o
I am looking for pg_config for postgresql 13.16 that I run under Rocky Linux 9.
It seems RL appstream latest version is pg_config in
libpq-devel-13.11-1.el9.x86_64 but dnf complains:
installed package postgresql13-"devel-13.16-2PGDG.rhel9.x86_64 obsoletes
libpq-devel <= 42.0 provided by libpq-de
On Fri, Jul 19, 2024 at 3:22 AM Laurenz Albe
wrote:
> Why not say that authors who repeatedly post grossly counterfactual or
> misleading content can be banned?
>
I like this, and feel we are getting closer. How about:
"Posts should be technically and factually correct. Use of AI should be
used
On Tue, Jul 23, 2024 at 12:45 PM Avinash Vallarapu <
avinash.vallar...@gmail.com> wrote:
> However, I do agree with Lawrence that it is impossible to prove whether
> it is written by AI or a human.
> AI can make mistakes and it might mistakenly point out that a blog is
> written by AI (which I kno
On Tue, 20 Aug 2024 at 19:09, sud wrote:
> However, my initial understanding of "having the FK index will improve the
> insert performance in the child table" is not accurate it seems. Rather as
> you mentioned it may negatively impact the loading/insert performance because
> it has to now upda
It will record all statements in logs. If you are concerned about query
times then you may use pg_stat_statements.
Muhammad Ikram
On Tue, 20 Aug 2024 at 12:19, sud wrote:
>
> On Mon, Aug 19, 2024 at 1:25 PM Muhammad Ikram wrote:
>
>> Hi Sud,
>>
>> Please make following change in your postgr
On Mon, Aug 19, 2024 at 1:25 PM Muhammad Ikram wrote:
> Hi Sud,
>
> Please make following change in your postgresql.conf file
>
> log_statement = 'all'
>
>
Will this put all the internal sql query or the recursive query entries in
the pg_stats_statement view which we can analyze then? And also to
On Mon, Aug 19, 2024 at 4:33 PM David Rowley wrote:
> On Mon, 19 Aug 2024 at 19:48, sud wrote:
> > In a version 15.4 postgres database, Is it possible that , if we have
> two big range partition tables with foreign key relationships between them,
> insert into the child table can cause slowness
14 matches
Mail list logo
