How to compress a table in Postgres?

F

F

fokin_nikolay19892021-11-23 11:29:44

PostgreSQL

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

How to compress a table in Postgres?

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

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

M

Menaskop2017-07-09 03:41:20

Quantum computer and Bitcoin: what will happen? 2Reply

G

GrimJack2017-09-05 13:04:04

Why doesn't carbon parse the timestamp correctly? 2Reply

K

Kenny002021-04-12 17:50:46

Why doesn't Barman find pg_receivexlog? 1Reply

I

Innoel2019-10-10 14:17:02

How to design a database for a Django project? 2Reply

K

kukarekuu2019-10-10 20:45:06

What is the best way to transfer millions of rows from one database to another using Pandas? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question