Postgres Pro
Downloads
Home   >   mailing lists

out of memory for query result - Mailing list pgsql-general

From Francisco Reyes
Subject out of memory for query result
Date
Msg-id cone.1145731273.238820.55795.1000@zoraida.natserv.net
Whole thread Raw
Responses Re: out of memory for query result  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
What resource do I need to increase to avoid the error above?

Trying to do a straight select against a table with 6 million records.
So far tried increasing SHMMAX to 512MB

pgsql-general by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Automatically assuming a specific role after connecting to pg
Next
From: Tom Lane
Date:
Subject: Re: out of memory for query result