Request a Demo
Home   >   mailing lists

Re: REPACK and naming - Mailing list pgsql-hackers

From Mihail Nikalayeu
Subject Re: REPACK and naming
Date
Msg-id CADzfLwXjBvqQCuPOaMGe20a+ySTcqSpfvoGyZZmrMkJ=HbtcOw@mail.gmail.com
Whole thread Raw
In response to Re: REPACK and naming  (Ranier Vilela <ranier.vf@gmail.com>)
List pgsql-hackers
Tree view 
Ranier Vilela <ranier.vf@gmail.com>:
> SqlServer has similar feature.
> SHRINK

MySQL/MariaDB
OPTIMIZE TABLE table_name

SQL Server
ALTER TABLE table_name REBUILD
DBCC SHRINKFILE
DBCC SHRINKDATABASE

Oracle
ALTER TABLE table_name SHRINK SPACE

SQLite
VACUUM

IBM DB2
REORG TABLE table_name

Sybase ASE
REORG REBUILD table_name

Best regards,
Mikhail.

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PATCH] Add tests for Bitmapset
Next
From: Peter Geoghegan
Date:
Subject: Re: Remove PointerIsValid()