3 ms·

My manager wrote a blog post explaining partial indexes and some of the advantages of them: https://blog.heapanalytics.com/speeding-up-postgresql-queries-with-p

My manager wrote a blog post explaining partial indexes and some of the advantages of them: https://blog.heapanalytics.com/speeding-up-postgresql-queries-with-partial-indexes/ https://blog.heapanalytics.com/speeding-up-postgresql-querie...

jonatron 9y ago
In that blog post, you store "time" as BIGINT. Does it work better than TIMESTAMP?
- ddorian43 9y ago
  It's same. Timestamp also uses bigint. It's nicer to use timestamp I guess since you get many datetime functions.