File tree Expand file tree Collapse file tree 2 files changed +14
-8
lines changed Expand file tree Collapse file tree 2 files changed +14
-8
lines changed Original file line number Diff line number Diff line change 1
- pg_repack -- Reorganize tables in PostgreSQL databases without any locks
2
- ========================================================================
1
+ pg_repack -- Reorganize tables in PostgreSQL databases with minimal locks
2
+ =========================================================================
3
3
4
4
.. contents ::
5
5
:depth: 1
6
6
:backlinks: none
7
7
8
-
9
- pg_repack _ is an utility program to reorganize tables in PostgreSQL databases.
10
- Unlike clusterdb _, it doesn't block any selections and updates during
11
- reorganization.
8
+ pg_repack _ is a PostgreSQL extension which lets you remove bloat from
9
+ tables and indexes, and optionally restore the physical order of clustered
10
+ indexes. Unlike CLUSTER _ and `VACUUM FULL `_ it works online, without
11
+ holding an exclusive lock on the processed tables during processing.
12
+ pg_repack is efficient to boot, with performance comparable to using
13
+ CLUSTER directly.
12
14
13
15
pg_repack is a fork of the previous pg_reorg _ project. Please check the
14
16
`project page `_ for bug report and development information.
@@ -26,8 +28,10 @@ NOTICE:
26
28
NOT NULL column.
27
29
28
30
.. _pg_repack : http://reorg.github.com/pg_repack
31
+ .. _CLUSTER : http://www.postgresql.org/docs/current/static/sql-cluster.html
32
+ .. _VACUUM FULL : VACUUM _
33
+ .. _VACUUM : http://www.postgresql.org/docs/current/static/sql-vacuum.html
29
34
.. _project page : https://github.com/reorg/pg_repack
30
- .. _clusterdb : http://www.postgresql.org/docs/current/static/app-clusterdb.html
31
35
.. _pg_reorg : http://reorg.projects.pgfoundry.org/
32
36
33
37
Original file line number Diff line number Diff line change @@ -50,4 +50,6 @@ div.contents {
50
50
margin-top : 2.5em !important ;
51
51
}
52
52
53
-
53
+ div .contents ul {
54
+ padding-left : 1em ;
55
+ }
You can’t perform that action at this time.
0 commit comments