Erwin Brandstetter's user avatar
Erwin Brandstetter's user avatar
Erwin Brandstetter's user avatar
Erwin Brandstetter
  • Member for 12 years, 6 months
  • Last seen this week
  • Vienna, Austria
3 votes
Accepted

Why does COALESCE prevent the use of an index on a varchar, but not on a text column?

2 votes
Accepted

How to use user defined exception - PostgreSQL Function

4 votes
Accepted

Can I change CITEXT columns to VARCHAR without encountering any surprise difficulties?

9 votes
Accepted

Step through multiple arrays in parallel with FOREACH

9 votes
Accepted

PostgreSQL: cast row to type

3 votes

SELECT... with LIMIT, but iterate forward getting other records?

3 votes
Accepted

UPDATE with LIMIT / OFFSET in PL/pgSQL function

6 votes

How to Pivot in PostgreSQL

2 votes
Accepted

Count number of occurences per location per hour in PostgreSQL

27 votes
Accepted

Index not used with = ANY() but used with IN

7 votes

How to add a generated column with an expression subtracting days?

12 votes
Accepted

Analyze needed after a refresh materialized view?

5 votes
Accepted

Efficiently return two aggregated arrays from a m:n table

2 votes

Joining only one row of a table?

11 votes

Efficient query to get greatest value per group from big table

1 vote

Locking row for INSERT, still getting duplicate key exception

8 votes
Accepted

PostgreSQL: Using schema and table names from other tables?

3 votes

How to list all the indexes along with their type (BTREE, BRIN, HASH etc...)

3 votes

Multiple Outer Joins vs. Single Join with Multiple OR Conditions in ON

0 votes

calculate and return the ratings using sql

0 votes
Accepted

How to insert a row from JSON in Postgres

4 votes
Accepted

Viewing the statement in EXECUTE with USING

37 votes
Accepted

How can I benchmark a PostgreSQL query?

1 vote

SERIAL for multi-column unique constraints

38 votes
Accepted

How to ORDER BY typical software release versions like X.Y.Z?

4 votes
Accepted

How can I match the items in an array column, with a different table in Postgres?

5 votes

Finding timestamp when index was created or reindexed

1 vote

How to find progress of database reindexing on PostgreSQL?

4 votes

How do I write a Postgres SQL command based on metadata of the tables themselves?

10 votes
Accepted

AWS Aurora PostgreSQL Serverless: How do you pre-warm the shared buffer after scaling?

1
23 24
25
26 27
72