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

From Clodoaldo Pinto Neto
Subject Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.
Date
Msg-id 20040412030216.84003.qmail@web40906.mail.yahoo.com
Whole thread Raw
In response to Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.
List pgsql-general
 --- Tom Lane <tgl@sss.pgh.pa.us> escreveu: >
> It's fairly unlikely that that is the solution you need.  How often do
> you vacuum this table?

A vacuum is executed every tree hours to the whole database after it is updated
with more than 300.000 inserts and deletes.

>  Does it participate in any foreign keys, or do
> you have any user-defined triggers on it?

It participates in two foreign keys. No ud triggers on it.

> > backend> reindex database KakaoStats
> > ERROR:  REINDEX DATABASE: Can be executed only on the currently open
> database.
>
> Double quotes would help here.
>
I will try it.


______________________________________________________________________

Yahoo! Messenger - Fale com seus amigos online. Instale agora!
http://br.download.yahoo.com/messenger/

pgsql-general by date:

Previous
From: Ericson Smith
Date:
Subject: Re: Large DB
Next
From: Tom Lane
Date:
Subject: Re: REINDEX slow?