user avatar
user avatar
user avatar
Erwin Brandstetter
  • Member for 10 years, 10 months
  • Last seen this week
  • Vienna, Austria
39 votes
1 answer
18k views

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

28 votes
2 answers
14k views

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

19 votes
2 answers
7k views

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

12 votes
1 answer
9k 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

9 votes
1 answer
2k views

Can declaring function volatility IMMUTABLE harm performance?

8 votes
0 answers
316 views

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

7 votes
1 answer
349 views

Reckless behavior of psql \e

6 votes
1 answer
1k views

When to mark functions as PARALLEL RESTRICTED vs PARALLEL SAFE?

6 votes
1 answer
5k views

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

2 votes
2 answers
2k views

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