User Dan W - Database Administrators Stack Exchange

Dan W

Member for 3 years, 6 months
Last seen this week

4 Questions

Score Activity Newest Views

2 votes

1 answer

499 views

PostgreSQL planner over estimates and self join query large table optimization

postgresql performance optimization postgresql-11 query-performance

asked Sep 11, 2019 at 17:38

2 votes

2 answers

621 views

Postgresql Query plan different on two servers

postgresql performance optimization execution-plan postgresql-11 query-performance

asked Nov 26, 2019 at 16:40

1 vote

1 answer

223 views

Postgresql 11 - Storing billions of relationships in normalized table paritions or intarray[] column

postgresql query-performance optimization graph

asked Apr 17, 2020 at 18:33

1 vote

1 answer

3k views

Postgresql INSERT stuck, what can cause this with no locks blocking

postgresql locking insert

asked Sep 30, 2020 at 14:36