Re: Large Result and Memory Limit

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Mike Ginsburg <mginsburg(at)collaborativefusion(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Large Result and Memory Limit
Date: 2007-10-04 21:10:25
Message-ID: 470556C1.2060704@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bill Moran wrote:
> In response to "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)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-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-10-04 21:50:40 Re: ERROR: variable not found in subplan target lists
Previous Message Scott Marlowe 2007-10-04 21:09:44 Re: time penalties on triggers?