Skip to main content
Melkij's user avatar
Melkij's user avatar
Melkij's user avatar
Melkij
  • Member for 4 years
  • Last seen this week
30 votes
Accepted

How can I set a column to NOT NULL without locking the table during a table scan?

13 votes
Accepted

How to specify not null contraints for the fields of composite types in postgres

11 votes

Why not use two columns instead of collation for case insensitive data?

9 votes
Accepted

What type of locks are needed when creating a Postgres index concurrently?

7 votes
Accepted

What is the difference between "server_lifetime" and "server_idle_timeout"?

6 votes
Accepted

Postgres REINDEX time estimate

6 votes
Accepted

Is it possible in PostgreSQL to have some DBs under PITR stragtegy while other DBs are not?

6 votes
Accepted

Where temp table data goes after creation?

5 votes
Accepted

Unable to use INSERT within CTE

4 votes
Accepted

PostgreSQL trigger to update date modified

4 votes

How I can remove autoincrement from a Primary key in postgresql?

4 votes
Accepted

Is there any pattern behind the naming conventions of PostgreSQL Table-Level Locks?

4 votes
Accepted

Postgres - What is a vacuum delay?

4 votes

PostgreSQL - 1 billion rows table cannot get vacuumed despite no errors

4 votes
Accepted

How to handle duplicates in an UPDATE on a primary key in Postgres?

4 votes

Parsing JSON data from a text column in Postgres

4 votes
Accepted

How to set uuid-ossp as a default extension for whole server?

4 votes
Accepted

PostgreSQL: what are purpose of functions uuid_hash(uuid) and uuid_hash_extended(uuid, bigint)

3 votes

Is there some way to automatically "follow"/pre-determine the release date for stable/GA PostgreSQL 14?

3 votes
Accepted

TimescaleDB on Azure Postgres error when creating continuous aggregation

3 votes

Postgres Logical Replication For Specific tables

3 votes
Accepted

Incompatible function reference when upgrading to Postgres 13

3 votes
Accepted

PostgreSQL undocumented timenow() function?

3 votes
Accepted

How can a PostgreSQL standby decide whether its primary is still active or not

3 votes

ERROR: role "user1" cannot be dropped because some objects depend on it

3 votes

Partition scan order in Postgres

3 votes

PgBackrest perfom restore without wal files

3 votes
Accepted

PostgreSQL: How to switch database inside cursor script

3 votes
Accepted

Using postgres to check if a file exists

3 votes
Accepted

PostgreSQL pg_xlog and wal_keep_segments/max_wal_size