import type { PoolClient } from 'pg'; /** * Index `url_redirect.to_path`. * * `recordRedirect`/`recordRedirectsBatch` run a "collapse" step on every capture: * `UPDATE url_redirect SET to_path = ... WHERE to_path = ` (so * A->B plus B->C becomes A->C). Without an index on `to_path` that is a sequential * scan of the whole table, which turns a category rename/reparent — one collapse * per moved descendant — into O(descendants × table_size) work as the redirect * table grows over the store's lifetime. `from_path` already has the UNIQUE index * the reclaim/upsert steps use; this covers the collapse. * * See wiki/url-redirects.md. */ declare const _default: (connection: PoolClient) => Promise; export default _default;