Re: Reindexing pg_catalog - Mailing list pgsql-admin

From raghu ram
Subject Re: Reindexing pg_catalog
Date
Msg-id BANLkTimxkz1eqqQgYxJ+u11pCVK6E19F0Q@mail.gmail.com
Whole thread Raw
In response to Reindexing pg_catalog  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
List pgsql-admin


On Fri, Apr 8, 2011 at 12:13 PM, Lukasz Brodziak <lukasz.brodziak@gmail.com> wrote:
Hello,

Is there a way to reiindex whole pg_catalog instead of reindexing each table?


You can achieve this by using below command::

postgres@raghu:/opt/PostgreSQL/8.3/bin$ ./reindexdb -s test -p 5433

[or]

postgres=# reindex system postgres;


--Raghu Ram

 
--
Łukasz Brodziak
"What if everyting around You isn't quite as it seems,
What if all the world You think You know is an inelaborate dream
When You look at Your reflection is that all you want it to be
What if You could look right through the cracks
Would You find Yourself...... Find Yourself afraid to see"

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: droland
Date:
Subject: pg_start_backup - backups
Next
From: Scott Marlowe
Date:
Subject: Re: Out Of Memory 8.1