Guru - Badge - Database Administrators Stack Exchange

Guru

Accepted answer and score of 40 or more. This badge can be awarded multiple times.

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

earned this badge 35 times.

Convert Postgres TIMESTAMP to TIMESTAMPTZ

Awarded Mar 1 at 19:02

What is the meaning of n_live_tup and n_dead_tup in pg_stat_user_tables

Awarded Sep 12, 2022 at 10:27

Permission denied for relation <table>

Awarded Jul 20, 2022 at 23:42

Using column alias in a WHERE clause doesn't work

Awarded Jul 6, 2022 at 23:11

Reference column alias in same SELECT list

Awarded May 6, 2022 at 6:55

Custom unique constraint, only enforced if one column has a specific value

Awarded Apr 26, 2022 at 9:19

How to get all roles that a user is a member of (including inherited roles)?

Awarded Apr 22, 2022 at 10:36

PostgreSQL EXCLUDE USING error: Data type integer has no default operator class

Awarded Mar 7, 2022 at 15:57

Retrieving all PK and FK

Awarded Nov 19, 2021 at 18:55

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

Awarded Apr 8, 2021 at 13:57

VACUUM returning disk space to operating system

Awarded Mar 18, 2021 at 8:50

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

Awarded Sep 14, 2020 at 14:27

Multicolumn index and performance

Awarded Aug 17, 2020 at 19:52

SQL injection in Postgres functions vs prepared queries

Awarded Jul 2, 2020 at 14:46

What is the search_path for a given database and user?

Awarded Mar 31, 2020 at 11:20

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

Awarded Feb 27, 2020 at 10:45

What is the optimal data type for an MD5 field?

Awarded Jul 8, 2019 at 13:10

Should I add an arbitrary length limit to VARCHAR columns?

Awarded Jun 24, 2019 at 18:20

Select columns inside json_agg

Awarded May 1, 2019 at 16:50

Would index lookup be noticeably faster with char vs varchar when all values are 36 chars

Awarded Apr 30, 2019 at 21:00

How to view data in pgAdmin III

Awarded Feb 20, 2019 at 16:35

Optimizing bulk update performance in PostgreSQL

Awarded Feb 10, 2019 at 15:50

Difference between now() and current_timestamp

Awarded Jan 25, 2019 at 15:25

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

Awarded Nov 5, 2018 at 13:45

Configuring PostgreSQL for read performance

Awarded Sep 19, 2018 at 19:05

Function Performance

Awarded Jun 11, 2018 at 16:01

Measure the size of a PostgreSQL table row

Awarded May 9, 2018 at 10:41

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

Awarded Nov 13, 2017 at 3:16

How to turn JSON array into Postgres array?

Awarded Jan 19, 2017 at 14:34

Postgres UPDATE ... LIMIT 1

Awarded May 17, 2016 at 23:02

Optimizing queries on a range of timestamps (two columns)

Awarded Apr 17, 2016 at 9:36

Working of indexes in PostgreSQL

Awarded Nov 9, 2015 at 3:38

PostgreSQL multi-column unique constraint and NULL values

Awarded Oct 9, 2015 at 18:18

Create index if it does not exist

Awarded Sep 16, 2015 at 11:15

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

Awarded Dec 18, 2014 at 11:02

Others with this badge