�� PostgreSQL 8.2 (renton)

Fri, 07 Aug 2009 11:28:40 GMT

>��-�� .
>x10001=> REINDEX SYSTEM x10001;
>x10001=> REINDEX DATABASE x10001;
>x10001=> REINDEX TABLE x10001.ttt;

�� , �� vacuumdb ��.

�� PostgreSQL 8.2 (renton)

Fri, 07 Aug 2009 10:55:32 GMT

>�� REINDEX (SQL).
>
>� �� .

��-�� .
x10001=> select pg_size_pretty (pg_database_size ('x10001'));
pg_size_pretty
----------------
2380 MB
(1 row)

��:
x10001=> REINDEX SYSTEM x10001;
x10001=> REINDEX DATABASE x10001;
x10001=> REINDEX TABLE x10001.ttt;

x10001=> select pg_size_pretty (pg_database_size ('x10001'));
pg_size_pretty
----------------
2380 MB
(1 row)

�� :
# ll -hrS
-rw------- 1 postgres postgres 68M Aug 7 12:30 2610
-rw------- 1 postgres postgres 202M Aug 7 12:27 1247
-rw------- 1 postgres postgres 237M Aug 7 12:30 2608
-rw------- 1 postgres postgres 403M Aug 7 13:52 1259
-rw------- 1 postgres postgres 445M Aug 7 12:29 1249.1
-rw------- 1 postgres postgres 1.0G Jun 4 11:51 1249

# oid2name -d x10001 -S | grep 1249
1249 pg_attribute

�� , �� .

�� PostgreSQL 8.2 (renton)

Mon, 04 Aug 2008 17:33:08 GMT

>�� REINDEX (SQL).

��, ��.

�� PostgreSQL 8.2 (��)

Mon, 04 Aug 2008 17:03:53 GMT

�� REINDEX (SQL).

� �� .

OpenForum RSS: ����������� ������ �� PostgreSQL 8.2

����������� ������ �� PostgreSQL 8.2 (renton)

����������� ������ �� PostgreSQL 8.2 (renton)

����������� ������ �� PostgreSQL 8.2 (renton)

����������� ������ �� PostgreSQL 8.2 (������)

OpenForum RSS: �� PostgreSQL 8.2

�� PostgreSQL 8.2 (renton)

�� PostgreSQL 8.2 (renton)

�� PostgreSQL 8.2 (renton)

�� PostgreSQL 8.2 (��)