User Laurenz Albe

27 votes

Accepted

What is the right data type to store only -1 0 and 1 in postgres column?

answered Dec 2, 2019 at 8:16

22 votes

Accepted

What's the order of operations in PostgreSQL?

answered Nov 15 at 5:20

20 votes

Accepted

Understanding where pg_toast is coming from

answered Apr 9, 2020 at 15:03

20 votes

Accepted

Why does PostgreSQL allow certain type mismatches in Foreign Keys?

answered Feb 15, 2022 at 13:04

19 votes

Accepted

Postgres get function owner

answered Feb 6, 2020 at 5:39

19 votes

Accepted

What does KEY SHARE OF in a PostgreSQL statement mean?

answered Jun 24, 2021 at 15:12

18 votes

Accepted

Is it necessary to ANALYZE a table after an index has been created?

answered Jun 24, 2019 at 9:56

18 votes

Postgres Upsert Performance Considerations (millions of rows/hour)

answered Sep 5, 2019 at 6:41

17 votes

Query hanging in ClientRead and blocking all others

answered Oct 25, 2019 at 14:15

17 votes

Accepted

Is "deadlock detected" really an error? Should I be suppressing them after handling them?

answered Feb 25, 2021 at 17:06

16 votes

Accepted

Why am I getting a deadlock for a single UPDATE query?

answered Jan 12, 2020 at 19:26

16 votes

Accepted

What is "special" about PostgreSQL update vs delete+insert

answered Oct 22, 2020 at 7:34

15 votes

Why is PostgreSQL limited to ASCII-only characters for the "application_name"?

answered Jan 31, 2020 at 11:05

15 votes

In PostgreSQL URL I can't use a password containing special characters

answered Jul 18, 2019 at 15:49

15 votes

Is there a common pattern for storing many boolean flags other than adding a ton of columns?

answered Jun 11, 2021 at 6:31

14 votes

Accepted

Disk usage of integer column vs boolean column in Postgres

answered Aug 26, 2019 at 9:33

14 votes

Accepted

What are the performance implications of using uuid as primary key in Postgres 10.12? (need canonical answer)

answered Apr 2, 2021 at 18:53

13 votes

Accepted

Case-insensitive collation still comparing case-sensitive

answered Dec 17, 2019 at 11:11

13 votes

Accepted

PostgreSQL: How can I list the tables to which a sequence belongs?

answered Mar 2, 2020 at 8:56

13 votes

Accepted

Unused columns in WHERE clause

answered Apr 6, 2022 at 16:00

13 votes

Accepted

Query time of fetching a particular, single row id by PK is extremely slow

answered Nov 20, 2021 at 17:10

11 votes

Accepted

Postgres EXPLAIN ANALYZE is super slow

answered Dec 13, 2019 at 14:01

11 votes

Accepted

How to clear PostgreSQL temp files after crash

answered Jun 22, 2020 at 15:24

11 votes

Accepted

PostgreSQL 12: column proisagg does not exist

answered Oct 23, 2019 at 15:33

11 votes

Accepted

default permissible datatype conversion matrix

answered Nov 27, 2019 at 15:26

10 votes

Postgresql extremely slow count (with index, simple query)

answered Aug 22, 2019 at 16:25

10 votes

Accepted

Postgres strategy for UPDATE SET x = NULL

answered Feb 3, 2021 at 14:49

10 votes

What does it mean when a session is highlighted in red in the PgAdmin dashboard?

answered Oct 5, 2021 at 14:35

9 votes

Accepted

What does "psql: /usr/pgsql-11/lib/libpq.so.5: no version information available (required by psql)" actually mean?

answered Jun 19, 2020 at 12:21

9 votes

Accepted

Multi language full text search using postgresql

answered Jan 27, 2020 at 13:08

Stack Exchange Network

1,874 Answers

What is the right data type to store only -1 0 and 1 in postgres column?

What's the order of operations in PostgreSQL?

Understanding where pg_toast is coming from

Why does PostgreSQL allow certain type mismatches in Foreign Keys?

Postgres get function owner

What does KEY SHARE OF in a PostgreSQL statement mean?

Is it necessary to ANALYZE a table after an index has been created?

Postgres Upsert Performance Considerations (millions of rows/hour)

Query hanging in ClientRead and blocking all others

Is "deadlock detected" really an error? Should I be suppressing them after handling them?

Why am I getting a deadlock for a single UPDATE query?

What is "special" about PostgreSQL update vs delete+insert

Why is PostgreSQL limited to ASCII-only characters for the "application_name"?

In PostgreSQL URL I can't use a password containing special characters

Is there a common pattern for storing many boolean flags other than adding a ton of columns?

Disk usage of integer column vs boolean column in Postgres

What are the performance implications of using uuid as primary key in Postgres 10.12? (need canonical answer)

Case-insensitive collation still comparing case-sensitive

PostgreSQL: How can I list the tables to which a sequence belongs?

Unused columns in WHERE clause

Query time of fetching a particular, single row id by PK is extremely slow

Postgres EXPLAIN ANALYZE is super slow

How to clear PostgreSQL temp files after crash

PostgreSQL 12: column proisagg does not exist

default permissible datatype conversion matrix

Postgresql extremely slow count (with index, simple query)

Postgres strategy for UPDATE SET x = NULL

What does it mean when a session is highlighted in red in the PgAdmin dashboard?

What does "psql: /usr/pgsql-11/lib/libpq.so.5: no version information available (required by psql)" actually mean?

Multi language full text search using postgresql