User Erwin Brandstetter

238 votes

Accepted

Optimizing queries on a range of timestamps (two columns)

answered Apr 9, 2013 at 21:55

213 votes

Accepted

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

postgresql index pattern-matching regular-expression string-searching

answered Jan 15, 2012 at 11:38

186 votes

Accepted

Postgres UPDATE ... LIMIT 1

postgresql update concurrency queue

answered Jul 1, 2014 at 23:24

154 votes

Accepted

How to turn JSON array into Postgres array?

postgresql postgresql-9.3 array json

answered Dec 2, 2013 at 21:56

150 votes

Accepted

PostgreSQL multi-column unique constraint and NULL values

postgresql constraint null unique-constraint

answered Dec 27, 2011 at 10:51

135 votes

Accepted

Measure the size of a PostgreSQL table row

postgresql disk-space performance size postgresql-performance

answered Sep 8, 2012 at 16:08

120 votes

Accepted

Create index if it does not exist

postgresql index functions plpgsql postgresql-8.4

answered Feb 27, 2013 at 22:22

118 votes

Accepted

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

postgresql database-design permissions

answered Oct 11, 2015 at 3:09

116 votes

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

postgresql database-design performance index index-tuning

answered Oct 23, 2012 at 22:49

112 votes

Accepted

Difference between now() and current_timestamp

postgresql timestamp

answered Apr 21, 2014 at 0:27

97 votes

Accepted

Should I add an arbitrary length limit to VARCHAR columns?

postgresql performance datatypes varchar

answered Jul 25, 2012 at 16:10

93 votes

Accepted

Working of indexes in PostgreSQL

postgresql index primary-key

answered Nov 1, 2011 at 21:42

93 votes

Accepted

Select columns inside json_agg

postgresql group-by json row

answered Jul 3, 2014 at 15:07

88 votes

Postgres multiple columns to json

postgresql json row

answered Feb 3, 2015 at 2:52

87 votes

List all columns for a specified table

postgresql metadata information-schema catalogs

answered Aug 13, 2012 at 23:05

79 votes

Accepted

Function Performance

postgresql best-practices plpgsql

answered Nov 21, 2011 at 11:33

69 votes

Accepted

What is the search_path for a given database and user?

postgresql configuration

answered Jan 3, 2014 at 0:56

65 votes

Accepted

What is the optimal data type for an MD5 field?

postgresql database-design index datatypes uniqueidentifier

answered Sep 17, 2015 at 3:48

62 votes

Accepted

Configuring PostgreSQL for read performance

postgresql performance postgresql-9.1 query-performance

answered May 27, 2013 at 16:46

62 votes

Accepted

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

postgresql storage ddl

answered Oct 30, 2013 at 19:44

62 votes

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

postgresql performance greatest-n-per-group query-performance

answered Sep 9, 2013 at 22:32

60 votes

Accepted

Optimizing bulk update performance in PostgreSQL

postgresql performance update bulk

answered Apr 28, 2013 at 14:08

60 votes

Accepted

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

postgresql foreign-key constraint ddl referential-integrity

answered Jul 15, 2014 at 1:09

54 votes

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

postgresql foreign-key postgresql-9.1 insert

answered Jul 16, 2013 at 20:40

53 votes

Accepted

SQL injection in Postgres functions vs prepared queries

postgresql plpgsql prepared-statement sql-injection functions

answered Sep 12, 2013 at 10:42

52 votes

Accepted

VACUUM returning disk space to operating system

postgresql postgresql-9.2 maintenance disk-space vacuum

answered Mar 19, 2013 at 16:22

52 votes

Accepted

How to view data in pgAdmin III

postgresql pgadmin-3

answered May 5, 2012 at 19:41

52 votes

Accepted

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

postgresql update performance postgresql-performance

answered Oct 16, 2015 at 6:55

52 votes

Optimizing a Postgres query with a large IN

postgresql index optimization performance postgresql-performance

answered Feb 10, 2015 at 2:17

52 votes

Accepted

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

postgresql index performance index-tuning query-performance

answered May 9, 2016 at 4:46

Stack Exchange Network

current community

your communities

more stack exchange communities

1,976 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

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

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

Difference between now() and current_timestamp

Should I add an arbitrary length limit to VARCHAR columns?

Working of indexes in PostgreSQL

Select columns inside json_agg

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?

Configuring PostgreSQL for read performance

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

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

Optimizing bulk update performance in PostgreSQL

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

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

SQL injection in Postgres functions vs prepared queries

VACUUM returning disk space to operating system

How to view data in pgAdmin III

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

Optimizing a Postgres query with a large IN

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