Message-ID: <4FF43638.5080301@web.de>
Date: Wed, 04 Jul 2012 14:25:28 +0200
From: Hermann Matthes <hermann.matthes@web.de>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:13.0) Gecko/20120614 Thunderbird/13.0.1
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Paged Query
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

I want to implement a "paged Query" feature, where the user can enter in 
a dialog, how much rows he want to see. After displaying the first page 
of rows, he can can push a button to display the next/previous page.
On database level I could user "limit" to implement this feature. My 
problem now is, that the user is not permitted to view all rows. For 
every row a permission check is performed and if permission is granted, 
the row is added to the list of rows sent to the client.
If for example the user has entered a page size of 50 and I use "limit 
50" to only fetch 50 records, what should I do if he is only permitted 
to see 20 of these 50 records? There may be more records he can view.
But if I don't use "limit", what happens if the query would return 
5,000,000 rows? Would my result set contain 5,000,000 rows or would the 
performance of the database go down?

Thanks in advance
Hermann