Laurenz Albe

Laurenz Albe has asked 2 questions and find answers to 696 problems.

Stats

About

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

Laurenz Albe questions

occasional slow UPDATE using primary key

Laurenz Albe answers

PostgreSQL's `initdb` fails with "invalid locale settings; check LANG and LC_* environment variables"
pyscopg2, should I commit in chunks?
Can we have both Physical and Logical replication on the same postgres database for different purposes?
Django best practices - ensuring atomicity while executing business logic
How to pass a table or rows to a function in Postgresql?
Performance/scalability difference between different transaction isolation levels
Correct planner estimate of 1:1 join without FK or left join
Performance wise, is it better to create a separate triggers for INSERT, DELETE and UPDATE events or just one for all the events
pg_restore: can't import data if table has a constraint with a function calling another function
How to add unique constraint in postgres on two columns where value of one column is `true`