Re: using database for queuing operations? - Mailing list pgsql-general

From Ron St-Pierre
Subject Re: using database for queuing operations?
Date
Msg-id 414F45DD.3050901@syscor.com
Whole thread Raw
In response to using database for queuing operations?  (Mark Harrison <mh@pixar.com>)
List pgsql-general
Mark Harrison wrote:

>     select * from nameq where serial = (select min(serial) from nameq);
>
You might also want to try this as:
     select * from nameq where serial = (select serial from nameq order
by serial asc limit 1);
and see if runs faster.

Ron


pgsql-general by date:

Previous
From: jao@geophile.com
Date:
Subject: Any reason not to use inheritance?
Next
From: Scott Ribe
Date:
Subject: Re: using database for queuing operations?