user avatar
user avatar
user avatar
Paul Draper
  • Member for 8 years, 6 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
3k views

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

6 votes
2 answers
492 views

What is the `TABLE example` syntax called?

2 votes
1 answer
32 views

Weird PostgreSQL expression parsing

2 votes
1 answer
90 views

How to reduce foreign key performance impact in PostgreSQL

2 votes
1 answer
342 views

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

2 votes
0 answers
114 views

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

2 votes
1 answer
79 views

Are reportedly "bloated" index sizes a problem?

1 vote
2 answers
362 views

How do I simultaneously update unique keys in PostgreSQL?

1 vote
0 answers
33 views

Using one sequence across all tables in PostgreSQL [duplicate]

1 vote
1 answer
112 views

Why is VACUUM FULL necessary here?

1 vote
0 answers
190 views

Why is PostgreSQL prefix/range search finicky?

1 vote
0 answers
22 views

How not to "naturalize" surrogate keys?

0 votes
1 answer
448 views

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

0 votes
1 answer
657 views

Hash index for InnoDB

0 votes
2 answers
196 views

How to deal with fragmentation in PostgreSQL?

0 votes
0 answers
111 views

Why isn't autovaccum running/completing?

0 votes
1 answer
194 views

Index maintenance on pg_catalog tables in AWS RDS

0 votes
0 answers
221 views

Aurora I/O IOPS vs Billed Volume IOPS

0 votes
1 answer
86 views

Get number of deleted pages in PostgreSQL table/index?