Questions tagged [postgresql-12]
Specifically for PostgreSQL version 12
241 questions
0
votes
0
answers
18
views
Auto-vacuum shows different behaviour in two similar situations. I am unable to understand why?
I have a insert-only table event on PostgreSQL-12 where I am having a high volume of inserts per sec (~2000 per sec). I regularly faced an issue when anti-wraparound auto-vacuum was running on this ...
0
votes
0
answers
37
views
Is there a reason why anti-wraparound autovacuum took around 42000 seconds to complete?
I have default auto-vacuum settings as follows -
Autovacuum is running on a table with high-volume of insert operations. I have also applied a table-specific setting of autovacuum_freeze_max_age to ...
0
votes
1
answer
83
views
After acquiring the lock following a 1.5-hour wait, if the PostgreSQL log shows that the query was executed, table was not updated
I have a table on which I am executing ALTER TABLE event ALTER pkey SET DEFAULT (1740891600).
The logs show the following -
2025-03-02T06:37:03.876771+00:00 sys-1 postgres-1_1[113323]: [25-1] [113323]:...
0
votes
1
answer
100
views
Do long running queries get dropped when you restart the PostgreSQL instance?
Maybe this is a very basic question, but I want to be sure.
I am upgrading an RDS cluster with a blue green deployment. I was checking the cluster, following the AWS guidelines, and saw a bunch of ...
- 3
2
votes
1
answer
296
views
Is concurrently using nextval with generate_series guaranteed to return incremental values?
I need to obtain multiple values from a sequence with only one query. On Stack Overflow I found this:
https://stackoverflow.com/questions/896274/select-multiple-ids-from-a-postgresql-sequence
The ...
- 125
0
votes
0
answers
90
views
Why vacuum analyze takes much time in an empty table?
I have a table in my database that used to have data long time ago, but now data have been deleted and is empty and no new data are inserted on it.
Once a day I run vacuum analyze for several tables ...
- 109
0
votes
0
answers
69
views
How do I successfully migrate a (very) old PostgreSQL database with PostGIS objects to a new version of PostgreSQL and PostGIS?
I've been trying to migrate a PostgreSQL database on version 9.0.1 with PostGIS objects to Postgres version 12.9 (both on linux) and I've been encountering numerous errors. I believe the source ...
- 694
0
votes
1
answer
154
views
My postgresql indexes are read slowly from disk
I have a database of sufficient size that it does not fit entirely in RAM, including indexes that also exceed RAM capacity. When performing queries, I observe significant differences in processing ...
- 141
0
votes
1
answer
166
views
Erratic Performance of CLUSTER in PostgreSQL
I work with PostgreSQL 12 and have partitioned tables that I am trying to cluster. Each partition is roughly the same size in terms of GB. However, the performance can vary significantly, ranging from ...
- 141
0
votes
1
answer
57
views
How to Retrieve and Compare All Settings and Overrides for a Specific Table in PostgreSQL (version 12)?
I am working with a PostgreSQL 12 database and currently investigating a table (table_name in schema schema_name) that has accumulated a significant number of dead tuples. To address this, I am ...
- 136
1
vote
1
answer
91
views
Return the longest consecutive sequence of a value in specific column
I am using PostgreSQL 12.0 and trying to get the longest sequence of continuous rows for a specific column and value.
The table is called team2 and contains a team's results which looks like:
match_id ...
- 13
0
votes
1
answer
104
views
Outliers produce a bad query plan
I have table document with ~2.5 millions rows and more than 100 columns. I provide only used in query columns:
CREATE TABLE document
(
id serial PRIMARY KEY,
organizationid INTEGER,
status_1 ...
1
vote
1
answer
744
views
PostgreSQL 12 generates WAL files even if it is disabled
I am having problems disabling the generation of WAL files in a non-productive database.
Although in the postgresql.conf file I have disabled WAL generation, I see that they are still generated with ...
- 143
0
votes
0
answers
36
views
Verify a postgresql index can be dropped securely
Indexes use resources because they have to be updated when data changes.
How to check if an index can be securely dropped (ie. not used at all)?
This request seems to return the unused indexes, ...
- 291
0
votes
1
answer
181
views
postgres was not the same version as pg_ctl in PostgreSQL 12
As per the log files, I am getting the below errors.
The program "postgres" was found by "/usr/lib/postgresql/12/bin/pg_ctl"
but was not the same version as pg_ctl.
Check your ...
- 101