Le 12/08/2010 09:43, Georgi Ivanov a écrit : > [...] > I have query like this > Select * from tabelname limit 10 OFFSET 10; > > If i increase the OFFSET to 1000 for example, the query runs slower . The > bigger is OFFSET the slower is the query. > > This is standard pagination feature i use for my website. > Actually the query is little bit more complex than this, but it is generally > a > select with a join. > > So i wander if there is a way to speed up this kind of query ? > You should better use cursors, than the OFFSET/LIMIT clause. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
