Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] pg_sleep(interval) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [PATCH] pg_sleep(interval)
Date
Msg-id CA+TgmoaQTudMc2riYt3bHTfy-cZm9gba9oT48_+gMCvCho9j8g@mail.gmail.com
Whole thread Raw
In response to [PATCH] pg_sleep(interval)  (Vik Fearing <vik.fearing@dalibo.com>)
Responses Re: [PATCH] pg_sleep(interval)  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
Tree view 
On Thu, Aug 8, 2013 at 7:52 AM, Vik Fearing <vik.fearing@dalibo.com> wrote:
> Someone on IRC a while ago was complaining that there was no way to
> specify an interval for pg_sleep, so I made one.  Patch against today's
> HEAD attached.
>
> Usage: SELECT pg_sleep(interval '2 minutes');

The problem with this is that then pg_sleep would be overloaded, and
as we've found from previous experience (cf. pg_size_pretty) that can
make things that currently work start failing as ambiguous.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Server crash when using bgw_main for a dynamic bgworker
Next
From: Robert Haas
Date:
Subject: Re: Foreground vacuum and buffer access strategy