Re: Working with very large datasets

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(at)DevIS(dot)com>