How to compress a table in Postgres?

F

fokin_nikolay19892021-11-23 11:29:44

PostgreSQL

fokin_nikolay1989, 2021-11-23 11:29:44

Good afternoon
This team

# pgcompactor --reindex --dbname geodata --table cities --verbose info >pgcompactor.log 2>&1

whether it will be possible to compress the tablet in the database without losing data from it?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Slava Rozhnev, 2021-11-23
@rozhnev

If possible, it is better to use the standard VACUUM [FULL] :

Similar questions

S

Sanzhar Bazarbek2021-04-04 12:35:40

T

Tayrus02022-01-17 13:38:20

N

Nursultan I am2018-11-16 19:31:54

E

Ekaterina Shundeeva2020-09-24 17:15:02

K

Khanover2014-05-20 09:07:20

Didn't find what you were looking for?