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
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,
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
