user avatar
user avatar
user avatar
Erwin Brandstetter
  • Member for 10 years, 10 months
  • Last seen this week
  • Vienna, Austria
238 votes
Accepted

Optimizing queries on a range of timestamps (two columns)

213 votes
Accepted

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

186 votes
Accepted

Postgres UPDATE ... LIMIT 1

154 votes
Accepted

How to turn JSON array into Postgres array?

150 votes
Accepted

PostgreSQL multi-column unique constraint and NULL values

135 votes
Accepted

Measure the size of a PostgreSQL table row

120 votes
Accepted

Create index if it does not exist

118 votes
Accepted

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

116 votes

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

112 votes
Accepted

Difference between now() and current_timestamp

97 votes
Accepted

Should I add an arbitrary length limit to VARCHAR columns?

93 votes
Accepted

Working of indexes in PostgreSQL

93 votes
Accepted

Select columns inside json_agg

88 votes

Postgres multiple columns to json

87 votes

List all columns for a specified table

79 votes
Accepted

Function Performance

69 votes
Accepted

What is the search_path for a given database and user?

65 votes
Accepted

What is the optimal data type for an MD5 field?

62 votes
Accepted

Configuring PostgreSQL for read performance

62 votes
Accepted

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

62 votes

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

60 votes
Accepted

Optimizing bulk update performance in PostgreSQL

60 votes
Accepted

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

54 votes

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

53 votes
Accepted

SQL injection in Postgres functions vs prepared queries

52 votes
Accepted

VACUUM returning disk space to operating system

52 votes
Accepted

How to view data in pgAdmin III

52 votes
Accepted

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

52 votes

Optimizing a Postgres query with a large IN

52 votes
Accepted

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

1
2 3 4 5
66