"Tena Sakai" <tsakai@xxxxxxxxxxxxxx> 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