cursor MOVE vs OFFSET in SELECT

Поиск
Список
Период
Сортировка
От silly8888
Тема cursor MOVE vs OFFSET in SELECT
Дата
Msg-id 3c8f9f940910260330l36a07bcbgc11a1264c5dd6750@mail.gmail.com
обсуждение исходный текст
Ответы Re: cursor MOVE vs OFFSET in SELECT  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-general
Suppose that you have a query, say $sql_query, which is very
complicated and produces many rows. Which of the following is going to
be faser:

    $sql_query OFFSET 3000 LIMIT 12;

or

    BEGIN;
    DECLARE cur1 CURSOR FOR $sql_query;
    MOVE 3000 IN cur1;
    FETCH 12 FROM cur1;
    COMMIT;

Naturally, the former cannot be slower than the latter. So my question
essentially is whether the MOVE operation on a cursor is
(significantly) slower that a OFFSET on the SELECT.

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Can the string literal syntax for function definitions please be dropped ?
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: cursor MOVE vs OFFSET in SELECT