Re: LIMIT clause and long timings - Mailing list pgsql-novice

Andrea <andrea.b73@email.it> writes:
> Then I have tried:
> SELECT * FROM banche ORDER BY banca LIMIT 10 OFFSET 34000;
> [....]
> (10 rows)

> Time: 2433,000 ms

> Why do I get this big timing???

Because the system has to scan through 34000 rows before it gets to the
ten you asked for.  OFFSET is not some bit of black magic, it just
causes the executor to discard the first N rows it's computed rather
than sending them over to the client.

            regards, tom lane