Questions tagged [postgres-14]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers

Postgres superuser privilege disappeared

I've installed Postgres 14 on Ubuntu 22.04. I use pgAdmin as postgres-User to work on it. Everything worked fine until after a few days i realized that the superuser privilege was deactivated for the ...
RafaelG's user avatar
0 votes
0 answers

How much space required to merge two tables?

I have some large sets of tables that I partition by date. Every day I run a query similar to this to merge the two tables WITH moved_rows AS ( DELETE FROM tableA_20230531 RETURNING * ) INSERT INTO ...
ConanTheGerbil's user avatar