Re: Large Result and Memory Limit - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Large Result and Memory Limit
Date
Msg-id 470556C1.2060704@commandprompt.com
Whole thread Raw
In response to Re: Large Result and Memory Limit  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bill Moran wrote:
> In response to "Scott Marlowe" <scott.marlowe@gmail.com>:

> The process is, web interface -> request export -> get an estimate
> on completion time -> come back later and check the status -> download
> if complete.
>
> It's difficult (maybe impossible) to materialize the data on a schedule,
> since the user has a number of options how how to export the data
> (filters, etc) so we chose to do it on-demand.

Export to large object, not text.

Joshua D. Drake

- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHBVbBATb/zqfZUUQRAivqAKCSiEcdssuENH/MBZy8L/SV7jP2igCdFVb5
VEevi+031549JN8WvXrHFnI=
=o5hR
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Large Result and Memory Limit
Next
From: "Scott Marlowe"
Date:
Subject: Re: time penalties on triggers?