Database Administrators
Profile Activity
Meta user
Network profile
Erwin Brandstetter
Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

1,594 Answers

Votes Activity Newest
177
Optimizing queries on a range of timestamps (two columns)
Apr 9 '13 at 21:55
170
Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL
Jan 15 '12 at 11:38
138
Postgres UPDATE … LIMIT 1
Jul 1 '14 at 23:24
105
Measure the size of a PostgreSQL table row
Sep 8 '12 at 16:08
105
Create index if it does not exist
Feb 27 '13 at 22:22
101
PostgreSQL multi-column unique constraint and NULL values
Dec 27 '11 at 10:51
99
How to turn JSON array into Postgres array?
Dec 2 '13 at 21:56
96
How to manage DEFAULT PRIVILEGES for USERs on a DATABASE vs SCHEMA?
Oct 11 '15 at 3:09
92
Is a composite index also good for queries on the first field?
Oct 23 '12 at 22:49
83
Working of indexes in PostgreSQL
Nov 1 '11 at 21:42
76
How do I list all columns for a specified table
Aug 13 '12 at 23:05
63
Difference between now() and current_timestamp
Apr 21 '14 at 0:27
58
Select columns inside json_agg
Jul 3 '14 at 15:07
57
Postgres multiple columns to json
Feb 3 '15 at 2:52
55
Configuring PostgreSQL for read performance
May 27 '13 at 16:46
55
Function Performance
Nov 21 '11 at 11:33
53
Should I add an arbitrary length limit to VARCHAR columns?
Jul 25 '12 at 16:10
49
How do I efficiently get “the most recent corresponding row”?
Sep 9 '13 at 22:32
47
Best way to populate a new column in a large table?
Oct 30 '13 at 19:44
47
Optimizing bulk update performance in PostgreSQL
Apr 28 '13 at 14:08
46
How to view data in pgAdmin III
May 5 '12 at 19:41
45
How do I insert a row which contains a foreign key?
Jul 16 '13 at 20:40
44
Would index lookup be noticeably faster with char vs varchar when all values are 36 chars
Jan 16 '15 at 1:55
44
What is the optimal data type for an MD5 field?
Sep 17 '15 at 3:48
43
What is the search_path for a given database and user?
Jan 3 '14 at 0:56
43
Differences between MATCH FULL, MATCH SIMPLE, and MATCH PARTIAL?
Jul 15 '14 at 1:09
39
PostgreSQL: Force data into memory
Sep 29 '15 at 23:11
37
Multicolumn index and performance
Jan 20 '13 at 7:00
37
SQL injection in Postgres functions vs prepared queries
Sep 12 '13 at 10:42
37
Does updating a row with the same value actually update the row?
Oct 16 '15 at 6:55
1
2 3 4 5
…
54