Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5123C2E0084 for ; Sun, 25 Nov 2007 02:26:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77250-06 for ; Sun, 25 Nov 2007 02:25:59 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.176]) by postgresql.org (Postfix) with ESMTP id AA7E32E00B2 for ; Sun, 25 Nov 2007 02:25:59 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so371380waf for ; Sat, 24 Nov 2007 22:25:56 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=6NWz5sxWiCOa1u+/7PillePfM0gcEM4MIE/6BRJonN0=; b=X6fLqpJ6ETTZxX8xB8V1dw6eZYZTx/UFVpxToB34EujI7OGyD5sAgQ8yIt32oui3xRo2DQ3hz3/h22sdMuGXo7wNFcjzMoTm9q31OgQVKS06nqaw0g25eFmzBQs7WiWm56ylgY4UGOzNsl7I+165dtgqcXDV+OZ3Ie7VKVp2868= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=buU+I4pDFZ5kGhS4t7kVx/Pz0qw8cJJh5shIbe7xNPXYc7V5jIXYhv4gPht+tujR7pMyGIh967ly1ISDYmAkHONS4a0Tylbdu4dv/9vXhbZWzcIjeH+Vl/kUbpIa/MnRuQBaACZo0Shmbc8mb0eWihQc59mkQBDFJ5bVdNjwxqo= Received: by 10.114.106.1 with SMTP id e1mr1312483wac.1195971956558; Sat, 24 Nov 2007 22:25:56 -0800 (PST) Received: by 10.114.53.7 with HTTP; Sat, 24 Nov 2007 22:25:56 -0800 (PST) Message-ID: Date: Sun, 25 Nov 2007 00:25:56 -0600 From: "Scott Marlowe" To: claudia.amorim@pcinformatica.com.br Subject: Re: Problems with PostGreSQL and Windows 2003 Cc: "Heikki Linnakangas" , pgsql-performance@postgresql.org, claudiacomput@hotmail.com In-Reply-To: <58995.189.5.149.224.1195966621.squirrel@smart> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/287 X-Sequence-Number: 27702 On Nov 24, 2007 10:57 PM, 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