Chris's user avatar
Chris's user avatar
Chris's user avatar
Chris
  • Member for 8 years, 9 months
  • Last seen more than 8 years ago
  • San Francisco Bay Area
36 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

11 votes
Accepted

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

10 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
Accepted

full outer join not working

4 votes
Accepted

Update postgres row where condition is from another table

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

EXPLAIN EXECUTE completes quickly, but is slow without EXPLAIN

3 votes

A costly approach to filtering on a calculated date

2 votes
Accepted

Combine the effects of separate delete and insert rows

2 votes
Accepted

PostgreSQL table partitioning problem

2 votes

PostgreSQL array column, querying and grouping by array field

2 votes

What database supports over a thousand fields and tables

2 votes

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

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

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