user avatar
user avatar
user avatar
Paul Draper
  • Member for 8 years, 5 months
  • Last seen more than a week ago
13 votes
1 answer
2k views

Why is PostgreSQL choosing the more expensive join order?

12 votes
1 answer
2k views

What is "special" about PostgreSQL update vs delete+insert

6 votes
2 answers
491 views

What is the `TABLE example` syntax called?

2 votes
1 answer
30 views

Weird PostgreSQL expression parsing

2 votes
1 answer
88 views

How to reduce foreign key performance impact in PostgreSQL

2 votes
1 answer
274 views

Is SELECT FOR ... UPDATE *necessary* to DELETE or UPDATE multiple rows without deadlock?

2 votes
0 answers
103 views

How to monitor query load, counts, and durations in PostgreSQL

2 votes
1 answer
59 views

Are reportedly "bloated" index sizes a problem?

1 vote
2 answers
297 views

How do I simultaneously update unique keys in PostgreSQL?

1 vote
0 answers
31 views

Using one sequence across all tables in PostgreSQL [duplicate]

1 vote
1 answer
99 views

Why is VACUUM FULL necessary here?

1 vote
0 answers
180 views

Why is PostgreSQL prefix/range search finicky?

1 vote
0 answers
22 views

How not to "naturalize" surrogate keys?

0 votes
1 answer
358 views

Getting by list of ids: `unnest() JOIN` vs `= ANY()`

0 votes
1 answer
655 views

Hash index for InnoDB

0 votes
2 answers
171 views

How to deal with fragmentation in PostgreSQL?

0 votes
0 answers
99 views

Why isn't autovaccum running/completing?

0 votes
1 answer
164 views

Index maintenance on pg_catalog tables in AWS RDS

0 votes
0 answers
192 views

Aurora I/O IOPS vs Billed Volume IOPS

0 votes
1 answer
74 views

Get number of deleted pages in PostgreSQL table/index?