Database Administrators
Laurenz Albe's user avatar
Laurenz Albe's user avatar
Laurenz Albe's user avatar
Laurenz Albe
  • Member for 4 years, 7 months
  • Last seen this week
Profile Activity
Stats
47,786
reputation
2.5m
reached
1,870
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
38
silver badges
66
bronze badges
Top tags
View all tags
3,256
Score
1,826
Posts
98
Posts %
303
Score
175
Posts
9
Posts %
238
Score
91
Posts
5
Posts %
221
Score
104
Posts
6
Posts %
147
Score
78
Posts
4
Posts %
144
Score
74
Posts
4
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
27
What is the right data type to store only -1 0 and 1 in postgres column?
Dec 2, 2019
answer
22
What's the order of operations in PostgreSQL?
Nov 15
answer
20
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
19
What does KEY SHARE OF in a PostgreSQL statement mean?
Jun 24, 2021
answer
19
Postgres get function owner
Feb 6, 2020
answer
18
Is it necessary to ANALYZE a table after an index has been created?
Jun 24, 2019
answer
18
Postgres Upsert Performance Considerations (millions of rows/hour)
Sep 5, 2019
answer
17
Query hanging in ClientRead and blocking all others
Oct 25, 2019
answer
17
Is "deadlock detected" really an error? Should I be suppressing them after handling them?
Feb 25, 2021
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
171
PostgreSQL: Create index for boolean column
117
Differentiate inserted and updated rows in UPSERT using system columns
90
Nested Join vs Merge Join vs Hash Join in PostgreSQL
86
will pg_restore overwrite the existing tables?
83
How do you create a read-only user in PostgreSQL?

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.