jjanes

jjanes has asked 2 questions and find answers to 63 problems.

Stats

About

jjanes questions

user data scripts fails without giving reason

jjanes answers

Postgres is doing a sequential scan when an index scan in simplest possible query
"CREATE EXTENTION IF NOT EXISTS" doesn't really check if extention does not exist
Postgres slow query (slow index scan)
Does Postgres remove dead tuples when restarted?
How to set a JSONB value to null
Is there any reason to include a `tsvector` column in a postgres table rather than in the index?
Postgres Slow group by query with max
Understanding the output of PSQL's \dp and \z
pgbench for postgresql 9.3 for centos where to find it?
I need to add up lots of values between date ranges as quickly as possible using PostgreSQL, what's the best method?