Laurenz Albe's user avatar
Laurenz Albe's user avatar
Laurenz Albe's user avatar
Laurenz Albe
  • Member for 4 years, 10 months
  • Last seen this week
27 votes
Accepted

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

22 votes
Accepted

What's the order of operations in PostgreSQL?

21 votes
Accepted

Understanding where pg_toast is coming from

21 votes
Accepted

What does KEY SHARE OF in a PostgreSQL statement mean?

20 votes
Accepted

Postgres get function owner

20 votes
Accepted

Why does PostgreSQL allow certain type mismatches in Foreign Keys?

19 votes

Postgres Upsert Performance Considerations (millions of rows/hour)

18 votes
Accepted

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

18 votes
Accepted

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

17 votes
Accepted

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

17 votes

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

17 votes

Query hanging in ClientRead and blocking all others

16 votes
Accepted

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

16 votes

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

15 votes

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

15 votes
Accepted

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

14 votes
Accepted

Case-insensitive collation still comparing case-sensitive

14 votes
Accepted

Disk usage of integer column vs boolean column in Postgres

14 votes
Accepted

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

13 votes
Accepted

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

13 votes
Accepted

Unused columns in WHERE clause

12 votes
Accepted

How to clear PostgreSQL temp files after crash

11 votes

Postgresql extremely slow count (with index, simple query)

11 votes
Accepted

PostgreSQL 12: column proisagg does not exist

11 votes
Accepted

Postgres EXPLAIN ANALYZE is super slow

11 votes
Accepted

default permissible datatype conversion matrix

10 votes
Accepted

Postgres strategy for UPDATE SET x = NULL

10 votes

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

9 votes
Accepted

How can I find the shortest path between two currencies?

9 votes
Accepted

Is the size limit of a json field before or after compression in Postgres?

1
2 3 4 5
65