[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] database speed
From:       Doug McNaught <doug () mcnaught ! org>
Date:       2003-10-31 21:31:21
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]