"Tena Sakai" <[EMAIL PROTECTED]> writes: >> canon=3D# select * from public.genotype; >> out of memory
> The version is 8.2.4 and platform is redhat linux
> on dell server. The table has 36 million rows.
Try \set FETCH_COUNT 1000
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
