Need advice to avoid ORDER BY

From: Condor <condor(at)stz-bg(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Need advice to avoid ORDER BY
Date: 2013-04-04 21:32:21
Message-ID: 3253f619f765efc87f379460e09bc9e5@stz-bg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have one query in my postgresql 9.2.3 that took 137 ms to me executed
and looking a way
what I can do to optimize it. I have one table generated numbers from 1
to 1 000 000 and
I need to get first free id, meanwhile id's when is taken can be free
(deleted data and id
is free for next job). Table is simple:

id serial,
jobid text,
valids int default 0

(Yes, I have index).

my query is: SELECT jobid FROM mytable WHERE valids = 0 ORDER BY id ASC
LIMIT 1

I need the first id only.

My question is: Is there a way how I can avoid using ORDER BY to
receive the first
free id from mytable ?

Cheers,
Condor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2013-04-04 21:38:07 Re: Need advice to avoid ORDER BY
Previous Message Mads.Tandrup 2013-04-04 19:24:11 Re: CVE-2013-1899 security issue and limited IP addresses in pg_hba.conf