23 lines
1.4 KiB
SQL
23 lines
1.4 KiB
SQL
-- Reversion de optimizaciones de busqueda textual.
|
|
-- No elimina pg_trgm porque puede ser usado por indices existentes del backend.
|
|
|
|
DROP INDEX CONCURRENTLY IF EXISTS idx_bench_catalog_categoria_linea_coalesce_trgm;
|
|
DROP INDEX CONCURRENTLY IF EXISTS idx_bench_catalog_categoria_canonica_coalesce_trgm;
|
|
DROP INDEX CONCURRENTLY IF EXISTS idx_bench_catalog_producto_coalesce_trgm;
|
|
DROP INDEX CONCURRENTLY IF EXISTS idx_bench_catalog_expediente_coalesce_trgm;
|
|
DROP INDEX CONCURRENTLY IF EXISTS idx_bench_catalog_registro_coalesce_trgm;
|
|
DROP INDEX CONCURRENTLY IF EXISTS idx_bench_catalog_order;
|
|
DROP INDEX CONCURRENTLY IF EXISTS idx_bench_catalog_order_prefix;
|
|
|
|
ALTER TABLE invima_api_catalog ALTER COLUMN fecha_vencimiento SET STATISTICS -1;
|
|
ALTER TABLE invima_api_catalog ALTER COLUMN producto SET STATISTICS -1;
|
|
ALTER TABLE invima_api_catalog ALTER COLUMN registro_sanitario SET STATISTICS -1;
|
|
ALTER TABLE invima_api_catalog ALTER COLUMN expediente SET STATISTICS -1;
|
|
ALTER TABLE invima_api_catalog ALTER COLUMN categoria_canonica SET STATISTICS -1;
|
|
ALTER TABLE invima_api_catalog ALTER COLUMN categoria_linea SET STATISTICS -1;
|
|
ALTER TABLE invima_api_catalog ALTER COLUMN search_text SET STATISTICS -1;
|
|
|
|
-- ANALYZE se omite en esta base local porque la tabla contiene bytes con
|
|
-- codificacion invalida que hacen fallar el escaneo estadistico completo.
|
|
-- Si los datos se normalizan, ejecutar manualmente: ANALYZE invima_api_catalog;
|