jjanes

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

Stats

About

jjanes questions

user data scripts fails without giving reason

jjanes answers

Efficiency of indexes for a field with low cardinality
PostgreSQL logical replication not working after added a new table to publication
Is Postgres autovacuum process blocking reading and writing the table
Cannot Drop Subscription from PostgresQL
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?