Hi,
if you have not seen any benefit , of course you can remove identity column
from a DWH table , there is a sequence and a trigger for identity serial
column.
ID columns are being generaly used for base tables which are under end-user
operations.
From: Ertan
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
CREATE OR REPLACE FUNCTION get_film (p_pattern VARCHAR)
RETURNS TABLE (
film_title VARCHAR,
film_release_year INT
)
AS $$
BEGIN
RETURN QUERY SELECT
title,
cast( release_year as integer)
FROM
film
WHERE
title ILIKE p_pattern ;
END
Hi ,
its about xid.
u may use the following sqls for check.
---Transaction ID Exhaustion Analysis --
SELECT datname
, age(datfrozenxid)
, current_setting('autovacuum_freeze_max_age')
FROM pg_database where datallowconn = true
ORDER BY 2 DESC;
WI
his bouncing layer.
From: Mladen Marinović
Sent: Monday, May 5, 2025 1:26 PM
To: Efrain J. Berdecia
Cc: SERHAD ERDEM ; Achilleas Mantzios
; pgsql-general@lists.postgresql.org
Subject: Re: Different execution plans in PG17 and pgBouncer...
Hi,
Mystery not solved...but identi
: Monday, May 5, 2025 12:52 PM
To: SERHAD ERDEM
Cc: Achilleas Mantzios ;
pgsql-general@lists.postgresql.org
Subject: Re: Different execution plans in PG17 and pgBouncer...
On Mon, May 5, 2025 at 2:38 PM SERHAD ERDEM
mailto:serh...@hotmail.com>> wrote:
Hi , you had better try vacuum analy
Hi , you had better try vacuum analyze for the whole db , pgbouncer
connection layer can not causeslow queries.
From: Mladen Marinović
Sent: Monday, May 5, 2025 12:27 PM
To: Achilleas Mantzios
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Different
