migration timeout
Hello
I have a table with ~40M rows. I am trying to build a hash or btree index but I can't get supabase to build the index, it always times out. Is there any setting to tweak to increase timeout tollerance on migration applications?
I have tried with both
CREATE INDEX X
and
CREATE INDEX CONCURRENTLY X
I think CONCURRENTLY used to work but would timeout actually building the index in the background... Now it wont even apply the migration:
Applying migration 20250911154635_create_trips_payment_intent_hash_index_concurrently.sql...
ERROR: canceling statement due to statement timeout (SQLSTATE 57014)
At statement: 0
CREATE INDEX CONCURRENTLY idx_trips_payment_intent_hash
ON trips USING HASH (payment_intent_id)
WHERE payment_intent_id IS NOT NULL
I have a table with ~40M rows. I am trying to build a hash or btree index but I can't get supabase to build the index, it always times out. Is there any setting to tweak to increase timeout tollerance on migration applications?
I have tried with both
CREATE INDEX X
and
CREATE INDEX CONCURRENTLY X
I think CONCURRENTLY used to work but would timeout actually building the index in the background... Now it wont even apply the migration:
Applying migration 20250911154635_create_trips_payment_intent_hash_index_concurrently.sql...
ERROR: canceling statement due to statement timeout (SQLSTATE 57014)
At statement: 0
CREATE INDEX CONCURRENTLY idx_trips_payment_intent_hash
ON trips USING HASH (payment_intent_id)
WHERE payment_intent_id IS NOT NULL
