Re: Out of memry with large result set

From: "olivier(dot)scalbert(at)algosyn(dot)com" <olivier(dot)scalbert(at)algosyn(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Out of memry with large result set
Date: 2008-07-15 05:53:36
Message-ID: 73df8dc4-f06f-47df-beae-cccbbac914a0@25g2000hsx.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edoardo Panfili 2008-07-15 06:19:25 Re: optimizer ignoring primary key and doing sequence scan
Previous Message Klint Gore 2008-07-15 05:30:09 download latest points to wrong place [was Re: Installing PostgreSQL without using CygWin]