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

Convert PostgreSQL array type

3 votes

Optimal way to get a total count of rows in a paged query in Postgres?

0 votes

How can I speed up my query that involves `max(timestamp)` in a huge table? I already added an index to every field

1 vote
Accepted

Does a long string with "unique" constaint take a lot of space?

0 votes

Modeling Polymorphic Relations in Postgres 15 with bi-directional (cyclic) FK constraints

0 votes
Accepted

How to speed up SELECT from not-unique column?

3 votes
Accepted

Will Postgres reclaim space when a temporary table is dropped?

0 votes

Increased LIMIT results in performance degradation

4 votes
Accepted

Any pitfalls/benefits of creating PK with include(..) in PostgreSQL?

1 vote
Accepted

Move several tables from remote database to another

1 vote
Accepted

How to enforce entity existence across N-tables - postgres

2 votes
Accepted

Table aliasing to a column allows direct access to the column with same name?

1 vote

Create Postgres hash aggregate function

0 votes

Migrate columns from table A to table B, and update A with a reference to B

2 votes
Accepted

Get rows for a given time range, plus one preceding row

1 vote

Why am I getting the "Query has no destination for result" error?

2 votes
Accepted

Can you make Postgres execute ORDER BY after OFFSET and LIMIT?

4 votes
Accepted

How can I get a list of locales in PostgreSQL?

1 vote

Is there a function that adds together all numeric columns in a row?

0 votes
Accepted

Checking for already present data before commiting?

3 votes
Accepted

When using a CTE, why do I need to use SELECT twice in order to filter on values from an auxiliary statement?

1 vote
Accepted

Filter out rows where any value is not unique

1 vote

The size of my table is not growing

2 votes
Accepted

How to get lexemes in original sort order from ts_vector?

3 votes

Simple query with two WHERE clauses uses inferior index scan

2 votes
Accepted

Function returns one row, but the query it wraps returns many

1 vote
Accepted

How to sort by joined table property in PostgreSQL?

3 votes
Accepted

Why the second query is so much faster than the first one?

5 votes
Accepted

Impact of index on a "status" field with one (guaranteed) change

3 votes
Accepted

Worst performance multiple left join big tables after restore DB

1 2
3
4 5
72