Re: Query running longer

On Fri, 2 Feb 2024 at 02:43, Laurenz Albe wrote: > On Fri, 2024-02-02 at 02:27 +0530, veem v wrote: > > We have the below query which is running for ~45 seconds on postgres > aurora reader instance. > > I have captured the explain analyze. Want to understand, where exactly > the resources are > >

Logical replication and AFTER UPDATE triggers [PG 16]

After various iterations of logical on PG 15, I bit the bullet and installed PG 16. (Using the bookworm-pgdg repository.) Turns out, that basically solved all the problems I'd been having previously - yay! Got a bit of a curveball thrown at me though. I have a singleton settings table (see other t

Re: Query running longer

On Thu, Feb 1, 2024 at 4:13 PM Laurenz Albe wrote: > On Fri, 2024-02-02 at 02:27 +0530, veem v wrote: > > We have the below query which is running for ~45 seconds on postgres > aurora reader instance. > > I have captured the explain analyze. Want to understand, where exactly > the resources are >

Re: Query running longer

On Fri, 2024-02-02 at 02:27 +0530, veem v wrote: > We have the below query which is running for ~45 seconds on postgres aurora > reader instance. > I have captured the explain analyze. Want to understand, where exactly the > resources are > getting spent and if we can be able to optimize it furth

Query running longer

Hello All, We have the below query which is running for ~45 seconds on postgres aurora reader instance. I have captured the explain analyze. Want to understand, where exactly the resources are getting spent and if we can be able to optimize it further. It's a UI query showing top 50 rows and is sup

Re: Postgresql BUG / Help Needed

Reply to list also. Ccing list. On 2/1/24 09:11, Johnathan Tiamoh wrote: No. I  have done any of this in the present cluster, I'm facing this issue. Do you have some sort of replication or backup system running on this cluster? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgresql BUG / Help Needed

On 2/1/24 06:10, Johnathan Tiamoh wrote: I haven't had difficulties in this cluster recently. However I upgraded it from  version 9.5 to 14.10  about 3 weeks ago. Have you being doing any of the things that got you in trouble in this thread: https://www.postgresql.org/message-id/CACoPQdbEo

Re: using palloc/pfree for OpenSSL allocations with CRYPTO_set_mem_functions

Evan Czaplicki writes: > I noticed that OpenSSL has a CRYPTO_set_mem_functions > > function: >> If no allocations have been done, it is possible to “swap out” the default >> implementations for OPENSSL_malloc(), OPENSSL_real

Re: TableOID in description of inlined function

Marius Lorek writes: > If I have a table > create table my_table(id int primary key); > and a function > create function my_function() returns table(id int) stable as $$ select * > from my_table $$ language sql; > then Postgres knows that selecting from the function is really just > selecting

Re: Postgresql BUG / Help Needed

I haven't had difficulties in this cluster recently. However I upgraded it from version 9.5 to 14.10 about 3 weeks ago. On Thu, Feb 1, 2024 at 9:06 AM Jehan-Guillaume de Rorthais wrote: > On Thu, 1 Feb 2024 08:28:45 -0500 > Johnathan Tiamoh wrote: > > > Thank you Laurenz! > > > > Is there

Re: Postgresql BUG / Help Needed

On Thu, 1 Feb 2024 08:28:45 -0500 Johnathan Tiamoh wrote: > Thank you Laurenz! > > Is there a way of preventing this from happening ? This could either come from a hardware issue, or easily from your own actions or procedures. Did you have some difficulties with your instance lately? exception

Re: Postgresql BUG / Help Needed

Thank you Laurenz! Is there a way of preventing this from happening ? On Thu, Feb 1, 2024 at 2:36 AM Laurenz Albe wrote: > On Thu, 2024-02-01 at 00:48 -0500, Johnathan Tiamoh wrote: > > I am having the following issue below. Please, I need help to fix it. > > > > ERROR: could not access stat

using palloc/pfree for OpenSSL allocations with CRYPTO_set_mem_functions

I noticed that OpenSSL has a CRYPTO_set_mem_functions function: If no allocations have been done, it is possible to “swap out” the default > implementations for OPENSSL_malloc(), OPENSSL_realloc() and OPENSSL_free() > and rep

Re: building a singularity image from docker hub postgres image

On Tue, Jan 30, 2024 at 12:27 PM Justin Clift wrote: > On 2024-01-30 15:52, Allan Kamau wrote: > > I am trying to build a singularity image from postgres docker image. > > I am issuing the command below. > > > > $ singularity build /local/data/some/postgres.16.1.sif > > docker://postgres/postgres

TableOID in description of inlined function

Hi All, If I have a table create table my_table(id int primary key); and a function create function my_function() returns table(id int) stable as $$ select * from my_table $$ language sql; then Postgres knows that selecting from the function is really just selecting from the table: explain se

Re: support fix query_id for temp table

On Thu, Feb 01, 2024 at 07:37:32AM +, ma lz wrote: > session 1: > create temp table ttt ( a int ); > insert into ttt values(3); -- query_id is XXX from > pg_stat_activity > > session 2: > create temp table ttt ( a int ); > insert into ttt values(3);