Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database. - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.
Date
Msg-id 28168.1081736612@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: REINDEX DATABASE: Can be executed only on the currently open database.  (Clodoaldo Pinto Neto <clodoaldo_pinto@yahoo.com.br>)
Responses Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.
List pgsql-general
Tree view 
=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?= <clodoaldo_pinto@yahoo.com.br> writes:
> I suspect there is something wrong because it takes 73s to delete a single line
> from a table whith 140 lines. So I tried to reindex the database:

It's fairly unlikely that that is the solution you need.  How often do
you vacuum this table?  Does it participate in any foreign keys, or do
you have any user-defined triggers on it?

> backend> reindex database KakaoStats
> ERROR:  REINDEX DATABASE: Can be executed only on the currently open database.

Double quotes would help here.

            regards, tom lane

pgsql-general by date:

Previous
From: Edmund Dengler
Date:
Subject: REINDEX slow?
Next
From: Bruce Momjian
Date:
Subject: Re: pg_ctl written in c