Database Administrators
Laurenz Albe's user avatar
Laurenz Albe's user avatar
Laurenz Albe's user avatar
Laurenz Albe
  • Member for 5 years
  • Last seen this week
Profile Activity
Stats
51,693
reputation
2.9m
reached
1,982
answers
0
questions
Communities
About
  • PostgreSQL support specialist and consultant
  • PostgreSQL enthusiast and contributor
  • System and application programmer
  • PostgreSQL blog
Badges
View all badges
4
gold badges
40
silver badges
69
bronze badges
Top tags
View all tags
3,533
Score
1,939
Posts
98
Posts %
344
Score
189
Posts
10
Posts %
247
Score
112
Posts
6
Posts %
247
Score
96
Posts
5
Posts %
159
Score
87
Posts
4
Posts %
149
Score
74
Posts
4
Posts %
Top posts
View all questions and answers
answer
27
What is the right data type to store only -1 0 and 1 in postgres column?
Dec 2, 2019
answer
22
What does KEY SHARE OF in a PostgreSQL statement mean?
Jun 24, 2021
answer
22
Is "deadlock detected" really an error? Should I be suppressing them after handling them?
Feb 25, 2021
answer
22
What's the order of operations in PostgreSQL?
Nov 15, 2023
answer
21
Understanding where pg_toast is coming from
Apr 9, 2020
answer
20
Why does PostgreSQL allow certain type mismatches in Foreign Keys?
Feb 15, 2022
answer
20
Postgres get function owner
Feb 6, 2020
answer
19
Postgres Upsert Performance Considerations (millions of rows/hour)
Sep 5, 2019
answer
18
Is it necessary to ANALYZE a table after an index has been created?
Jun 24, 2019
answer
17
In PostgreSQL URL I can't use a password containing special characters
Jul 18, 2019
Top Meta posts
3
1
15
Why do people "answer" without reading the question here?
10
Should I vote to "move to Stackoverflow" on SQL questions?
10
Do I misunderstand the "too localized" close reason?
5
Spurious double grant of "Steward" badge
Top network posts
View all network posts
179
PostgreSQL: Create index for boolean column
121
Differentiate inserted and updated rows in UPSERT using system columns
95
How do you create a read-only user in PostgreSQL?
95
will pg_restore overwrite the existing tables?
91
Nested Join vs Merge Join vs Hash Join in PostgreSQL