Re: Best approach for a "gap-less" sequence

Поиск
Список
Период
Сортировка
От Jorge Godoy
Тема Re: Best approach for a "gap-less" sequence
Дата
Msg-id 87y7trt66s.fsf@gmail.com
обсуждение исходный текст
Ответ на Re: Best approach for a "gap-less" sequence  (Harald Fuchs <hf0731x@protecting.net>)
Список pgsql-general
Harald Fuchs <hf0731x@protecting.net> writes:

> In article <87zme7uvcn.fsf@gmail.com>,
> Jorge Godoy <jgodoy@gmail.com> writes:
>
>> Harald Fuchs <hf0731x@protecting.net> writes:
>>> Why putting gapless numbers into the database at all?  Just calculate them at
>>> query time.
>
>> And how would you retrieve the record that corresponds to invoice number
>> #16355, for example?  Recalculating few records is fine, but millions of them
>> everytime you need to recover some of those is something that doesn't look
>> efficient to me...
>
> This would be
>
>   SELECT whatever
>   FROM tbl
>   ORDER BY id
>   LIMIT 1
>   OFFSET 16355 -1
>
> Since id is the primary key, this can use an index scan.

If the ID was the number yes.  I thought you were suggesting having the number
computed at "query time", not to insert the record on the table...

--
Jorge Godoy      <jgodoy@gmail.com>

В списке pgsql-general по дате отправления:

Предыдущее
От: Harald Fuchs
Дата:
Сообщение: Re: Best approach for a "gap-less" sequence
Следующее
От: marcelo Cortez
Дата:
Сообщение: wal files on temporary tables