pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: claudia.amorim@pcinformatica.com.br
Cc: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: pgsql-performance@postgresql.org
Cc: claudiacomput@hotmail.com
Subject: Re: Problems with PostGreSQL and Windows 2003
Date: Sun, 25 Nov 2007 00:25:56 -0600
Message-ID: <dcc563d10711242225yd6438c2i18dea4b094705d91@mail.gmail.com> (raw)
In-Reply-To: <58995.189.5.149.224.1195966621.squirrel@smart>
References: <50326.189.5.149.224.1195860047.squirrel@smart>
	<4747E684.2000509@enterprisedb.com>
	<50662.189.5.149.224.1195905625.squirrel@smart>
	<58995.189.5.149.224.1195966621.squirrel@smart>

On Nov 24, 2007 10:57 PM,  <claudia.amorim@pcinformatica.com.br> wrote:
> Hello,
>
>    I forgot to say that I changed  work_mem  to 16 MB but I didn't have sucess.
> I received the same
> error message.

The error message you're getting is from your client because it's
getting too big of a result set back at once.

Try using a cursor



view thread (9+ messages)  latest in thread

Message-ID: <dcc563d10711242225yd6438c2i18dea4b094705d91@mail.gmail.com>
Permalink:  ../dcc563d10711242225yd6438c2i18dea4b094705d91@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10711242225yd6438c2i18dea4b094705d91@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: scott.marlowe@gmail.com, claudia.amorim@pcinformatica.com.br, heikki@enterprisedb.com, claudiacomput@hotmail.com
  Subject: Re: Problems with PostGreSQL and Windows 2003
  In-Reply-To: <dcc563d10711242225yd6438c2i18dea4b094705d91@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox