On Tue, 2003-02-11 at 18:42, Wilkinson Charlie E wrote:
> Greetings,
> Can anyone enlighten me or point me at resources concerning use of
> pgsql with
> very large datasets?
[snip]
> SELECT userid,name,size,mtime FROM users INNER JOIN files ON
> users.fileid = files.fileid;
If you just want to see a sample result from that query in psql, then
you can use LIMIT:
SELECT userid,name,size,mtime FROM users INNER JOIN files ON
users.fileid = files.fileid LIMIT 100;
This should only return 100 rows.
I hope that helps.
I think there is also a way to specify offsets so that you can return
the rows in batches.
--
Lex Berezhny <LBerezhny@DevIS.com>
