[Geobd] Réduire la précision géométrique augmente la taille ?

Message posté par : Christophe BADOL ---------------------------------------- J'ai creusé la partie cartouche spatial car j'étais surpris du gain de place dans la démonstration de Nicolas Ribot. Gain de place qu'on définisse le cartouche en geometry('MULTIPOLYGON',2154) en geometry(multipolygon,2154) en geometry(multipolygon) ou en geometry tout simple ----------------- Code : ---- Le cartouche façon BADOL DROP TABLE IF EXISTS public.n_batiment_pepci_001_2024_t5; CREATE TABLE public.n_batiment_pepci_001_2024_t5 (LIKE r_parcellaire_express_2024.n_batiment_pepci_001_2024 INCLUDING ALL); ALTER TABLE public.n_batiment_pepci_001_2024_t5 ALTER COLUMN geom TYPE geometry('MULTIPOLYGON',2154); INSERT INTO public.n_batiment_pepci_001_2024_t5 SELECT * FROM r_parcellaire_express_2024.n_batiment_pepci_001_2024; VACUUM FULL public.n_batiment_pepci_001_2024_t5; REINDEX TABLE public.n_batiment_pepci_001_2024_t5; select pg_size_pretty(pg_total_relation_size('public.n_batiment_pepci_001_2024_t5')) as tot, pg_size_pretty(pg_relation_size('public.n_batiment_pepci_001_2024_t5')) as tab, pg_size_pretty(pg_indexes_size('public.n_batiment_pepci_001_2024_t5')) as idx; /* tot |tab |idx | ------+------+-----+ 166 MB|123 MB|43 MB| */ ---- Le cartouche façon dbeaver DROP TABLE IF EXISTS public.n_batiment_pepci_001_2024_t6; CREATE TABLE public.n_batiment_pepci_001_2024_t6 (LIKE r_parcellaire_express_2024.n_batiment_pepci_001_2024 INCLUDING ALL); ALTER TABLE public.n_batiment_pepci_001_2024_t6 ALTER COLUMN geom TYPE geometry(multipolygon,2154); INSERT INTO public.n_batiment_pepci_001_2024_t6 SELECT * FROM r_parcellaire_express_2024.n_batiment_pepci_001_2024; VACUUM FULL public.n_batiment_pepci_001_2024_t6; REINDEX TABLE public.n_batiment_pepci_001_2024_t6; select pg_size_pretty(pg_total_relation_size('public.n_batiment_pepci_001_2024_t6')) as tot, pg_size_pretty(pg_relation_size('public.n_batiment_pepci_001_2024_t6')) as tab, pg_size_pretty(pg_indexes_size('public.n_batiment_pepci_001_2024_t6')) as idx; /* tot |tab |idx | ------+------+-----+ 166 MB|123 MB|43 MB| */ ---- Le cartouche sans projection DROP TABLE IF EXISTS public.n_batiment_pepci_001_2024_t7; CREATE TABLE public.n_batiment_pepci_001_2024_t7 (LIKE r_parcellaire_express_2024.n_batiment_pepci_001_2024 INCLUDING ALL); ALTER TABLE public.n_batiment_pepci_001_2024_t7 ALTER COLUMN geom TYPE geometry(multipolygon); INSERT INTO public.n_batiment_pepci_001_2024_t7 SELECT * FROM r_parcellaire_express_2024.n_batiment_pepci_001_2024; VACUUM FULL public.n_batiment_pepci_001_2024_t7; REINDEX TABLE public.n_batiment_pepci_001_2024_t7; select pg_size_pretty(pg_total_relation_size('public.n_batiment_pepci_001_2024_t7')) as tot, pg_size_pretty(pg_relation_size('public.n_batiment_pepci_001_2024_t7')) as tab, pg_size_pretty(pg_indexes_size('public.n_batiment_pepci_001_2024_t7')) as idx; /* tot |tab |idx | ------+------+-----+ 166 MB|123 MB|43 MB| */ ---- Le cartouche sans rien DROP TABLE IF EXISTS public.n_batiment_pepci_001_2024_t8; CREATE TABLE public.n_batiment_pepci_001_2024_t8 (LIKE r_parcellaire_express_2024.n_batiment_pepci_001_2024 INCLUDING ALL); ALTER TABLE public.n_batiment_pepci_001_2024_t8 ALTER COLUMN geom TYPE geometry; INSERT INTO public.n_batiment_pepci_001_2024_t8 SELECT * FROM r_parcellaire_express_2024.n_batiment_pepci_001_2024; VACUUM FULL public.n_batiment_pepci_001_2024_t8; REINDEX TABLE public.n_batiment_pepci_001_2024_t8; select pg_size_pretty(pg_total_relation_size('public.n_batiment_pepci_001_2024_t8')) as tot, pg_size_pretty(pg_relation_size('public.n_batiment_pepci_001_2024_t8')) as tab, pg_size_pretty(pg_indexes_size('public.n_batiment_pepci_001_2024_t8')) as idx; /* tot |tab |idx | ------+------+-----+ 166 MB|123 MB|43 MB| */ ----------------- ---------------------------------------- Le message est situé https://georezo.net/forum/viewtopic.php?pid=369979#p369979 Pour y répondre : geobd(a)ml.georezo.net ou reply de votre messagerie Pour vous désabonner connectez-vous sur le forum puis Profil / Abonnement -- Association GeoRezo - le portail géomatique https://georezo.net