User Erwin Brandstetter

243 votes

Accepted

Optimizing queries on a range of timestamps (two columns)

answered Apr 9, 2013 at 21:55

221 votes

Accepted

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

answered Jan 15, 2012 at 11:38

195 votes

Accepted

Postgres UPDATE ... LIMIT 1

answered Jul 1, 2014 at 23:24

164 votes

Accepted

How to turn JSON array into Postgres array?

answered Dec 2, 2013 at 21:56

160 votes

Accepted

PostgreSQL multi-column unique constraint and NULL values

answered Dec 27, 2011 at 10:51

143 votes

Accepted

Measure the size of a PostgreSQL table row

answered Sep 8, 2012 at 16:08

126 votes

Accepted

Create index if it does not exist

answered Feb 27, 2013 at 22:22

124 votes

Accepted

Difference between now() and current_timestamp

answered Apr 21, 2014 at 0:27

123 votes

Accepted

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

answered Oct 11, 2015 at 3:09

120 votes

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

answered Oct 23, 2012 at 22:49

105 votes

Accepted

Should I add an arbitrary length limit to VARCHAR columns?

answered Jul 25, 2012 at 16:10

99 votes

Accepted

Select columns inside json_agg

answered Jul 3, 2014 at 15:07

98 votes

Accepted

Working of indexes in PostgreSQL

answered Nov 1, 2011 at 21:42

93 votes

Postgres multiple columns to json

answered Feb 3, 2015 at 2:52

91 votes

List all columns for a specified table

answered Aug 13, 2012 at 23:05

83 votes

Accepted

Function Performance

answered Nov 21, 2011 at 11:33

72 votes

Accepted

What is the search_path for a given database and user?

answered Jan 3, 2014 at 0:56

71 votes

Accepted

What is the optimal data type for an MD5 field?

answered Sep 17, 2015 at 3:48

66 votes

Accepted

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

answered Oct 30, 2013 at 19:44

65 votes

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

answered Sep 9, 2013 at 22:32

64 votes

Accepted

Configuring PostgreSQL for read performance

answered May 27, 2013 at 16:46

63 votes

Accepted

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

answered Jul 15, 2014 at 1:09

60 votes

Accepted

Optimizing bulk update performance in PostgreSQL

answered Apr 28, 2013 at 14:08

60 votes

Accepted

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

answered May 9, 2016 at 4:46

56 votes

Accepted

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

answered Oct 16, 2015 at 6:55

55 votes

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

answered Jul 16, 2013 at 20:40

55 votes

Accepted

SQL injection in Postgres functions vs prepared queries

answered Sep 12, 2013 at 10:42

55 votes

Optimizing a Postgres query with a large IN

answered Feb 10, 2015 at 2:17

53 votes

Accepted

VACUUM returning disk space to operating system

answered Mar 19, 2013 at 16:22

53 votes

Accepted

How to view data in pgAdmin III

answered May 5, 2012 at 19:41

Stack Exchange Network

2,045 Answers

Optimizing queries on a range of timestamps (two columns)

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

Postgres UPDATE ... LIMIT 1

How to turn JSON array into Postgres array?

PostgreSQL multi-column unique constraint and NULL values

Measure the size of a PostgreSQL table row

Create index if it does not exist

Difference between now() and current_timestamp

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

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

Should I add an arbitrary length limit to VARCHAR columns?

Select columns inside json_agg

Working of indexes in PostgreSQL

Postgres multiple columns to json

List all columns for a specified table

Function Performance

What is the search_path for a given database and user?

What is the optimal data type for an MD5 field?

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

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

Configuring PostgreSQL for read performance

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

Optimizing bulk update performance in PostgreSQL

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

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

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

SQL injection in Postgres functions vs prepared queries

Optimizing a Postgres query with a large IN

VACUUM returning disk space to operating system

How to view data in pgAdmin III