Skip site navigation (1) Skip section navigation (2)

Re: out of memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: out of memory
Date: 2007-09-12 03:58:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
"Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> 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

In response to


pgsql-admin by date

Next:From: Tena SakaiDate: 2007-09-12 04:15:56
Subject: Re: out of memory
Previous:From: Tena SakaiDate: 2007-09-12 01:36:19
Subject: out of memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group