Question : Reading the PostgreSQL documentation there is an excerpt that mentions that you should run a VACUUM FULL when […]
Tag: postgresql-12
How query errors affect Postgresql DB performance
Question : I have an application stored measurements data in PostgreSQL-12. Couple of processes write data by queries like: INSERT […]
Can PostgreSQL manage a table with 1.5 billion rows?
Question : The table has three columns: id string (up to 400 characters) length which records the length of string […]
How to predict how much space a VACUUM FULL would reclaim?
Question : Is there a way to determine in advance how much disk space a VACUUM FULL on a particular […]
if multiple users run a query that creates a temp table at the same time, would the data in the table be corrupted in each session? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Postgres 12: Are there performance differences between PRIMARY KEY(A, B) and PRIMARY KEY (B, A) on a table PARTITION BY (A)?
Question : Given a table this table: CREATE TABLE tbl ( a int not null, b int not null, created […]
update the timestamp on column when data is filled in another
Question : I am new to Postgresql and SQL in general. I have a table that looks like this id […]
How do I loop through every table and alter the PK column like so? (Postgres)
Question : Using psql in Postgres 12, I need to alter every column in every table of my database that’s: […]
Poor execution plan leads to query time increasing dramatically
Question : I have a relatively complex query like the one that follows select * from ( select distinct on(“car”) […]
Stop rollback of anonymous DO code block?
Question : I’m executing some code through this anonymous DO code feature. I am observing that whenever it fails, all […]