Re: database speed

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Dennis Gearon <gearond(at)fireserve(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, Vivek Khera <khera(at)kcilink(dot)com>
Subject: Re: database speed
Date: 2003-10-31 21:31:21
Message-ID: m3r80tksba.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dennis Gearon <gearond(at)fireserve(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stuart Johnston 2003-10-31 21:48:31 Re: regular backups - super user
Previous Message Tom Lane 2003-10-31 21:24:22 Re: Cartesian product bug?