[HACKERS] TODO item: Improve speed with indexes

Hi everyone, Regarding the mentioned TODO item, the past discussion as I see from the following thread: http://archives.postgresql.org/pgsql-general/2007-01/msg00879.php concludes that during vacuum full, the relations' indexes should be recreated via REINDEX, rather than updating them. One s

[HACKERS] TODO item: Allow the server to be stopped/restarted via an SQL API

Hi all, Would it be acceptable to invoke pg_ctl in the API functions to stop and restart the server? thanks

Re: [HACKERS] TODO item: Allow the server to be stopped/restarted via an SQL API

Via signal handling? Use the kill() function (or its pg equivalent) to send the appropriate signal? On 4/6/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Aleksis Petrov" <[EMAIL PROTECTED]> writes: > Would it be acceptable to invoke pg_ctl in the API functions to stop and