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
On 9/13/19 10:34 AM, Ertan Küçükoglu wrote:
Hello,
We are using PostgreSQL 10.0 on a Windows VM.
There is one database in that server.
There are several tables that will be used for data warehouse purposes.
There are daily inserts and relatively heavy bulk (whole month data at once)
reads at
