Laurenz Albe

Laurenz Albe has asked 2 questions and find answers to 691 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

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`
PostgreSQL List of Transactions
Do PostgreSQL cursors operate on snapshots?
Search is not working with lowercase LIKE for russian characters
Postgres JSONB: where clause for arrays of arrays
PostgreSQL boolean comparison