Chris's user avatar
Chris's user avatar
Chris's user avatar
Chris
  • Member for 7 years, 3 months
  • Last seen more than 6 years ago
  • San Francisco Bay Area
34 votes
Accepted

How to store time series data

15 votes
Accepted

Postgres - window function rank and count

12 votes

"Recheck Cond:" line in query plans with a bitmap index scan

11 votes
Accepted

SELECT DISTINCT ON subquery uses inefficient plan

10 votes
Accepted

Update by iterating table in batches faster than whole table in PostgreSQL

9 votes

Does PostgreSQL benefit from more cores or faster cores for READ heavy applications?

8 votes

Is it recommended to install extensions into pg_catalog schema?

6 votes
Accepted

How does Postgres make its B-tree index?

6 votes

PostgreSQL not using index

4 votes

Remove duplicate values from query result

4 votes

How to speed up ORDER BY sorting when using GIN index in PostgreSQL?

4 votes

Adding two columns results in concatenation instead of addition

4 votes

Cummulative Sum with Reset Value

3 votes

Calculate number of consecutive years (not gapless)

3 votes

Is index performance on a TIMESTAMP(6) column impacted when converting it to a number

3 votes

Kibana-like tool for PosgreSQL

3 votes
Accepted

How can I join two tables of an Oracle database containing all rows (not the intersection)

3 votes

A costly approach to filtering on a calculated date

3 votes

EXPLAIN EXECUTE completes quickly, but is slow without EXPLAIN

2 votes

Why does the query plan still sort a table despite having an index sorted on the columns?

2 votes
Accepted

full outer join not working

2 votes

PostgreSQL array column, querying and grouping by array field

2 votes

What database supports over a thousand fields and tables

2 votes
Accepted

Combine the effects of separate delete and insert rows

2 votes
Accepted

PostgreSQL table partitioning problem

2 votes
Accepted

How can I improve this query in PostgreSQL?

2 votes

Use trigger to synchronize columns with fields in json column on insert or update

2 votes
Accepted

Update postgres row where condition is from another table

2 votes
Accepted

Postgres or MapReduce to Match Reciprocal Needle Pairs from a Stack of Needles?

2 votes
Accepted

Updating/Inserting 2000 entries takes over 12 hours to complete