OFFSET and LIMIT - performance

From: "Jan Bilek" <bilekj(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: OFFSET and LIMIT - performance
Date: 2007-06-28 16:43:36
Message-ID: 001501c7b9a3$79e2c120$0100a8c0@ook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I'm using PGDB with JDBC. In my app i need to select only portion of all available rows. I know i can do it two ways:
1. I can use OFFSET and LIMIT SQL statements or
2. I can select all rows and then filter requested portion in Java.

My question - Does the second way significantly affect performance especially when used with JDBC?
Does the LIMIT statement do anything else then browsing/filtering rows with cursor (= the same thing i'd do in Java)?
How are the selected rows processed in select queries? Does PG select all rows and then filter them using statements like LIMIT and OFFSET or applies the statements while processing query?

Thanks for your analyzes!

JB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Björn Lundin 2007-06-28 16:43:41 Re: using PREPAREd statements in CURSOR
Previous Message Michael Glaesemann 2007-06-28 16:29:04 Re: Column Default Clause and User Defined Functions