Skip to main content
The 2026 Annual Developer Survey is live— take the Survey today!
Laurenz Albe's user avatar
Laurenz Albe's user avatar
Laurenz Albe's user avatar
Laurenz Albe
Database Specialist at http://www.cybertec-postgresql.com/
  • Member for 10 years, 1 month
  • Last seen this week
Profile Activity

Profile

Stats

260,040
reputation
20.3m
reached
9,185
answers
5
questions
Communities

About

  • PostgreSQL support specialist and consultant
  • PostgreSQL enthusiast and contributor
  • System and application programmer
  • PostgreSQL blog

Badges

View all badges
22
gold badges
319
silver badges
398
bronze badges

Top tags

View all tags
18,859
Score
9,043
Posts
98
Posts %
3,240
Score
1,897
Posts
21
Posts %
1,156
Score
569
Posts
6
Posts %
846
Score
318
Posts
3
Posts %
643
Score
270
Posts
3
Posts %
485
Score
278
Posts
3
Posts %

Top posts

View all questions, answers, and articles
answer
201
PostgreSQL: Create index for boolean column
Mar 23, 2017
answer
148
Differentiate inserted and updated rows in UPSERT using system columns
Aug 29, 2016
answer
126
How do you create a read-only user in PostgreSQL?
Apr 22, 2021
answer
107
will pg_restore overwrite the existing tables?
Apr 25, 2017
answer
102
Nested Join vs Merge Join vs Hash Join in PostgreSQL
Feb 28, 2018
answer
84
Is PostgreSQL a NoSQL database?
Dec 22, 2017
answer
61
Refresh materialized views with concurrency
Jan 23, 2017
answer
59
How can I solve Postgresql SCRAM authentication problem?
Jul 9, 2020
answer
58
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "postgres" (Ubuntu)
Oct 22, 2021
answer
57
Why am I getting a permission denied error for schema public on pgAdmin 4?
Apr 27, 2021

Top Meta posts

2
3
35
Cookie banner keeps popping up
25
Cookie banner keeps popping up
8
"very low quality flag" declined - is that justified?

Top network posts

View all network posts
30
Is "deadlock detected" really an error? Should I be suppressing them after handling them?
28
What is the right data type to store only -1 0 and 1 in postgres column?
27
What does KEY SHARE OF in a PostgreSQL statement mean?
26
Postgres get function owner
22
Understanding where pg_toast is coming from