Re: database speed - Mailing list pgsql-general

From Doug McNaught
Subject Re: database speed
Date
Msg-id m3r80tksba.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Re: database speed  ("Chris Stokes" <ChrisS@BassSoftware.com>)
List pgsql-general
Dennis Gearon <gearond@fireserve.net> writes:

> Is ist possible for a trigger to fork off a 'reindex' command and the
> trigger terminates leaving the reindex running?

Even if possible, ick.

I'd say the best thing to do would to have such a trigger set a flag
(value in a one-row table) and have a cron job that checks for that
flag and runs REINDEX.

-Doug

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cartesian product bug?
Next
From: DeJuan Jackson
Date:
Subject: Re: regular backups - super user