604 questions
1
vote
1
answer
68
views
Can postgres auto-vacuum block another process trying to run ALTER or CREATE queries on the same table?
A process is trying to ALTER a table (to set default column value) in a workflow. It is getting blocked due to postgres auto-vacuum process not releasing a lock (It might be holding a ...
0
votes
0
answers
34
views
PgAdmin can't find the binaries path [duplicate]
When trying to validate the path of the bin directory for PostgreSQL 12, PgAdmin cannot find the related files.
I'm using Ubuntu 22 OS.
I have already installed postgresql-client-12 using the ...
- 26
0
votes
1
answer
50
views
Unable to connect to table in PostgreSQL DB with read permissions via Spring Boot
The task is as follows - it was necessary to connect to an existing DB that has read access to a certain schema with multiple tables. I am trying to connect to one of the tables (I repeat, only read ...
- 103
1
vote
1
answer
85
views
Is it safe to set the statistics target to zero for numeric columns?
I have some PostgreSQL tables with columns of type:
timestamp without time zone
interval
text
numeric
For example assume a table like:
CREATE TABLE IF NOT EXISTS table_foo(
"timestamp" ...
- 301
0
votes
1
answer
125
views
pg_repack - CREATE INDEX stucj in IDLE state for than 24 hrs
I am in the process of pg_repacking a huge table (13TB). Following is the info for my setup:
pg_total_relation_size (Including indexes) - 13TB
pg_table_size - 4TB
pg_repack version - 1.4.7
Postgres ...
- 439
1
vote
0
answers
47
views
How to debug "FATAL: database "ag_test3" does not exist" in postgres?
I have a simple postgresql 12.19 installation on my Ubuntu 20.04.06 LTS virtual server. The generic postgres packages are installed:
postgresql-12/focal-updates,now 12.19-0ubuntu0.20.04.1 amd64 [...
- 11
0
votes
0
answers
67
views
PostGreSQL 12 : Logical Replication - Specific Schemas
I've two database servers : Host 1 & Host 2
On the Host 1, I've several schemas in the database :
SchemaA
SchemaB
SchemaC
etc...
I would like ste in place a logical replication from Host 1 to ...
- 9
0
votes
0
answers
109
views
When to vacuum freeze a partition of a postgres table?
I have a postgresql-12 database containing tables that are partitioned on timestamp column. So, rows with timestamp belonging in day N are inserted in a child table that is attached to the parent ...
- 301
2
votes
0
answers
46
views
postgresql reindex results in index row size error
I have a huge table with a primary key and a btree_gist index. After some years of operation, the performance of selections went constantly down. I assume the gist index is fragmented.
When reindexing,...
- 468
0
votes
2
answers
49
views
Increment counter inside jsob based on itself value
I have an example table to demonstate a problem.
create table myteble (
id serial primary key ,
metadata jsonb
-- other fields
-- ......
)
metadata is a jsonb column, and it might and ...
- 2,217
-1
votes
1
answer
163
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 ...
- 302
1
vote
0
answers
93
views
PgBouncer - Trying to connect to ipv6 localhost
I have postgresql 12 and pgboucner 1.22-1. I am getting the following warning message in pgbouncer.log constantly:
WARNING sbuf_connect failed to connect to [::1]:5432: No route to host
I have in ...
- 301
0
votes
1
answer
310
views
Applying custom queries to multiple databases for PostgreSQL in Datadog
We're using RDS with PostgreSQL engine v12.17 and integration with Datadog. We have multiple databases and have multiple custom queries for these databases.
Currently, there is a lot of duplication, ...
1
vote
2
answers
870
views
How to make Postgres use an index for a set of values?
I have a table with ~35M rows, and trying to find "processed" records to remove from time to time. There are 14 valid statuses, and 10 of them are processed.
id uuid default uuid_generate_v4(...
- 6,738
1
vote
1
answer
145
views
Compatiility of Postgres 14.9 with Centos 6.9
I have postgres 12.18 installed on my Centos 6.9 OS (I know it's too old). I want to upgrade to postgres 14.9, is it possible ?
I am trying to install postgres 14 but getting lot of issues.
sudo yum ...
- 81