fixes + PG async indexer writes