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
243 votes
Accepted

Optimizing queries on a range of timestamps (two columns)

221 votes
Accepted

Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL

195 votes
Accepted

Postgres UPDATE ... LIMIT 1

164 votes
Accepted

How to turn JSON array into Postgres array?

160 votes
Accepted

PostgreSQL multi-column unique constraint and NULL values

143 votes
Accepted

Measure the size of a PostgreSQL table row

126 votes
Accepted

Create index if it does not exist

124 votes
Accepted

Difference between now() and current_timestamp

123 votes
Accepted

How to manage DEFAULT PRIVILEGES for USERs on a DATABASE vs SCHEMA?

120 votes

Is a composite index also good for queries on the first field?

105 votes
Accepted

Should I add an arbitrary length limit to VARCHAR columns?

99 votes
Accepted

Select columns inside json_agg

98 votes
Accepted

Working of indexes in PostgreSQL

93 votes

Postgres multiple columns to json

91 votes

List all columns for a specified table

83 votes
Accepted

Function Performance

72 votes
Accepted

What is the search_path for a given database and user?

71 votes
Accepted

What is the optimal data type for an MD5 field?

66 votes
Accepted

Best way to populate a new column in a large table?

65 votes

How do I efficiently get "the most recent corresponding row"?

64 votes
Accepted

Configuring PostgreSQL for read performance

63 votes
Accepted

Differences between MATCH FULL, MATCH SIMPLE, and MATCH PARTIAL?

60 votes
Accepted

Optimizing bulk update performance in PostgreSQL

60 votes
Accepted

Indexes: integer vs string performance if the number of nodes is the same

56 votes
Accepted

Does updating a row with the same value actually update the row?

55 votes

How do I insert a row which contains a foreign key?

55 votes
Accepted

SQL injection in Postgres functions vs prepared queries

55 votes

Optimizing a Postgres query with a large IN

53 votes
Accepted

VACUUM returning disk space to operating system

53 votes
Accepted

How to view data in pgAdmin III

1
2 3 4 5
69