- Notifications
You must be signed in to change notification settings - Fork57
Closed
Labels
Description
table with 160k records
UPDATE {table_name} SET {document}=data.{document} FROM(VALUES %s) AS data ({document}, id)WHERE {table_name}.id=data.id;UPDATE {table_name} set {document_vector}=(select to_tsvector({document}));CREATE INDEX {table_name}_rum_indexON {table_name} USING RUM ({document_vector} rum_tsvector_ops);After this set of queries, the autovacuum consumes all available memory before it crashes.
