Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ta32h-0006Zs-GW for pgsql-sql@postgresql.org; Sun, 18 Nov 2012 11:28:03 +0000 Received: from outmail149056.authsmtp.com ([62.13.149.56]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ta32f-00043f-P6 for pgsql-sql@postgresql.org; Sun, 18 Nov 2012 11:28:02 +0000 Received: from mail-c233.authsmtp.com (mail-c233.authsmtp.com [62.13.128.233]) by punt10.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id qAIBS0Lc099402 for ; Sun, 18 Nov 2012 11:28:00 GMT Received: from ayaki.localdomain (124-148-90-153.dyn.iinet.net.au [124.148.90.153]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/) with ESMTP id qAIBRtbR071067 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO) for ; Sun, 18 Nov 2012 11:27:58 GMT Message-ID: <50A8C63A.5070801@2ndQuadrant.com> Date: Sun, 18 Nov 2012 19:27:54 +0800 From: Craig Ringer Organization: 2nd Quadrant User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20121016 Thunderbird/16.0.1 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: organizing cron jobs in one function References: <20121117161916.GA9492@apartia.fr> In-Reply-To: <20121117161916.GA9492@apartia.fr> X-Enigmail-Version: 1.4.5 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Server-Quench: 018ee540-3173-11e2-a49c-0025907707a1 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZeVg0b BQteCiN5VAwpPBRK HVkIKg5MOFUSTAAU KV9eBkJUK0ETX1xC QjoVBBYDHlx5Rh0q LRVTbQRfcktPVQdt Wk1ADFNQEBtpBRQf Dx4AUxxxaAdDentv ZAgjLwkpPgAoF0Z6 Q05SEiMHbGBgJmAe WBUNcgdUbQBLeRxY a1EqVm5cZWxUe3pg RVJiZ29uZWpWcTJv T1NFHmkrZXNDGSQz ThYDDzQpEgUOXSI1 Zx4hIEVUHUBZNUM/ eVU8X1kEMhgUYgAA X-Authentic-SMTP: 61633235383639.1021:706 X-AuthFastPath: 0 (Was 255) X-AuthSMTP-Origin: 124.148.90.153/2525 X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201211/15 X-Sequence-Number: 36948 On 11/18/2012 12:19 AM, Louis-David Mitterrand wrote: > Hi, > > I'm planning to centralize all db maintenance jobs from a single > pl/pgsql function called by cron every 15 minutes (highest frequency > required by a list of jobs). It sounds like you're effectively duplicating PgAgent. Why not use PgAgent instead? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services