Erwin Brandstetter

less info
meta site favicon meta user | stack exchange network profile network profile
8,886 reputation
1238
bio website
location Vienna, Austria
age 93
visits member for 1 year, 7 months
seen 3 hours ago
stats profile views 348

212 Answers

newest activity votes
18
Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL
14
PostgreSQL multi-column unique constraint and NULL values
14
Working of indexes in PostgreSQL
12
Is a composite index also good for queries on the first field?
12
PostgreSQL versus MySQL for EAV structures storage
10
For absolute performance, is SUM faster or COUNT?
10
Custom unique column constraint, only enforced if one column has a specific value
10
Can spatial index help a “range - order by - limit” query
10
Query takes hours
10
Best practices for schema changes and data migrations to a live database without downtime?
9
Create index if it does not exist
9
Unexpected Seq Scan when doing query against boolean with value NULL
8
How do I preserve the order of the original elements in an unnested array?
8
Are regular VACUUM ANALYZE stil recommended under 9.1?
7
PostgreSQL created a PostgreSQL user on mac. Is this necessary?
7
MySQL case sensitivity for table names
7
Index max row size error
7
PostgreSQL unexplained table bloat
6
PostgreSQL Stored Procedure Performance
6
Full Text Search With PostgreSQL
6
Casting issue when calling a function with composite type parameter
6
How do I know what indexes to create for a table
6
PostgreSQL Index optimization with dates
6
Modelling constraints on subset aggregates?
6
Postgres query plan of a UDF invocation written in pgpsql
6
Generate an exception with a Context
6
What is retrieved from disk during a query?
6
Improve sort performance in PostgreSQL?
6
Working of indexes in PostgreSQL
5
Table for optional parent/child relationship
1 2 3 4 5 … 8