| 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: | Whole Thread | Raw Message | 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
| 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 |