| 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: | Whole Thread | Raw Message | 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-----
| 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? |