User Justin Lowen

1 vote

1 answer

122 views

PostgreSQL: pg_dump fails to correctly pg_restore due to missing or erroneous custom function, but present in dump

asked Sep 13 at 22:07

0 votes

2 answers

116 views

PostgreSQL - Row Estimates Leading to Nested Loop Being Selected Too Often, How To Improve Row Estimates

asked Oct 2 at 15:51

0 votes

1 answer

62 views

PostgreSQL CTE Recursion - How to Improve Performance for Parent->Child Tree (8 levels deep, 890 roots)

asked Oct 17 at 17:14

0 votes

1 answer

67 views

PostgreSQL & SQLAlchemy: Minimizing Impacts of latency with chatty applications

asked Apr 22 at 17:40

0 votes

1 answer

317 views

PostgreSQL driven by SQLAlchemy - Release Savepoint Idle in Transaction

asked Oct 8, 2023 at 17:16

0 votes

1 answer

4k views

PostgreSQL - when is pg_advisory_xact_lock released, and when will persisted data be visible to other transactions

asked Oct 18, 2023 at 21:25

0 votes

2 answers

224 views

PostgreSQL - 30000 row updates, setting non-indexed boolean column to 'true' takes hours

asked Dec 12, 2023 at 22:40

0 votes

3 answers

72 views

PostgreSQL enforcing order dependent constraints within a query

asked Feb 22 at 21:18

-1 votes

1 answer

1k views

PostgreSQL: How is the uuid datatype sorted?

asked Apr 9 at 16:09

Stack Exchange Network

9 Questions

PostgreSQL: pg_dump fails to correctly pg_restore due to missing or erroneous custom function, but present in dump

PostgreSQL - Row Estimates Leading to Nested Loop Being Selected Too Often, How To Improve Row Estimates

PostgreSQL CTE Recursion - How to Improve Performance for Parent->Child Tree (8 levels deep, 890 roots)

PostgreSQL & SQLAlchemy: Minimizing Impacts of latency with chatty applications

PostgreSQL driven by SQLAlchemy - Release Savepoint Idle in Transaction

PostgreSQL - when is pg_advisory_xact_lock released, and when will persisted data be visible to other transactions

PostgreSQL - 30000 row updates, setting non-indexed boolean column to 'true' takes hours

PostgreSQL enforcing order dependent constraints within a query

PostgreSQL: How is the uuid datatype sorted?