Database Administrators
Laurenz Albe's user avatar
Laurenz Albe's user avatar
Laurenz Albe's user avatar
Laurenz Albe
  • Member for 4 years, 5 months
  • Last seen this week
Profile Activity
Stats
45,683
reputation
2.3m
reached
1,794
answers
0
questions
top 0.06% this year
Communities
About
  • PostgreSQL support specialist and consultant
  • PostgreSQL enthusiast and contributor
  • System and application programmer
  • PostgreSQL blog
Badges
View all badges
4
gold badges
37
silver badges
62
bronze badges
Top tags
View all tags
3,107
Score
1,753
Posts
98
Posts %
292
Score
169
Posts
9
Posts %
232
Score
88
Posts
5
Posts %
207
Score
100
Posts
6
Posts %
143
Score
76
Posts
4
Posts %
139
Score
69
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
20
Why does PostgreSQL allow certain type mismatches in Foreign Keys?
Feb 15, 2022
answer
19
Postgres get function owner
Feb 6, 2020
answer
18
Postgres Upsert Performance Considerations (millions of rows/hour)
Sep 5, 2019
answer
18
Understanding where pg_toast is coming from
Apr 9, 2020
answer
17
What does KEY SHARE OF in a PostgreSQL statement mean?
Jun 24, 2021
answer
17
Query hanging in ClientRead and blocking all others
Oct 25, 2019
answer
16
Is it necessary to ANALYZE a table after an index has been created?
Jun 24, 2019
answer
16
Why am I getting a deadlock for a single UPDATE query?
Jan 12, 2020
answer
16
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
165
PostgreSQL: Create index for boolean column
115
Differentiate inserted and updated rows in UPSERT using system columns
86
Nested Join vs Merge Join vs Hash Join in PostgreSQL
83
will pg_restore overwrite the existing tables?
78
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.