Home > mailing lists

Re: Out of memry with large result set - Mailing list pgsql-general

From	olivier.scalbert@algosyn.com
Subject	Re: Out of memry with large result set
Date	July 15, 2008 18:31:22
Msg-id	73df8dc4-f06f-47df-beae-cccbbac914a0@25g2000hsx.googlegroups.com Whole thread Raw
In response to	Out of memry with large result set ("olivier.scalbert@algosyn.com" <olivier.scalbert@algosyn.com>)
Responses	Re: Out of memry with large result set
List	pgsql-general

Tree view

> Try copy (query) to stdout.
>
> For me, psql sits at 4.9mb ram on a 3x10^16 row query.
>
> klint.
>

Thanks Klint.
Can I use a 'copy to' for a query ? I thought I can only do 'copy
table to stdout'
I will do some tests tomorrow and keep you inform.

Olivier

pgsql-general by date:

From: David Fetter
Date: 15 July 2008, 17:17:18
Subject: Re: Referential integrity vulnerability in 8.3.3

From: "Bob Pawley"
Date: 15 July 2008, 20:50:50
Subject: pg_dump

Re: Out of memry with large result set - Mailing list pgsql-general

Previous

Next