Database Administrators
Erwin Brandstetter's user avatar
Erwin Brandstetter's user avatar
Erwin Brandstetter's user avatar
Erwin Brandstetter
  • Member for 11 years, 6 months
  • Last seen this week
  • Vienna, Austria
Profile Activity

12 Questions

Score Activity Newest Views
40 votes
1 answer
18k views

USING construct in JOIN clause can introduce optimization barriers in certain cases?

28 votes
2 answers
15k views

"Recheck Cond:" line in query plans with a bitmap index scan

19 votes
2 answers
8k views

Naming conflict between function parameter and result of JOIN with USING clause

13 votes
1 answer
11k views

Why *not* ERROR: index row size xxxx exceeds maximum 2712 for index "foo"?

11 votes
1 answer
2k views

Surprising results for data types with type modifier

11 votes
1 answer
2k views

Can declaring function volatility IMMUTABLE harm performance?

9 votes
1 answer
2k views

Why does the cast from double precision to numeric round to 15 significant digits?

7 votes
2 answers
2k views

Are results from UNION ALL clauses always appended in order?

7 votes
1 answer
2k views

When to mark functions as PARALLEL RESTRICTED vs PARALLEL SAFE?

7 votes
1 answer
560 views

Reckless behavior of psql \e

6 votes
1 answer
6k views

ERROR: improper qualified name (too many dotted names) when trying ALTER FUNCTION

2 votes
2 answers
4k views

How can the concatenatation of a text and a NULL value return a non-null result?

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.