| From: | Faheem Mitha <faheem(at)email(dot)unc(dot)edu> |
|---|---|
| To: | Andy Colson <andy(at)squeakycode(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: simultaneously reducing both memory usage and runtime for a query |
| Date: | 2010-03-29 06:28:45 |
| Message-ID: | alpine.DEB.2.00.1003291138300.13883@orwell.homelinux.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, 28 Mar 2010, Andy Colson wrote:
> Wait... Your saying your question is so complex it needs 41 pages
> (including graphs) to ask? I didn't bother before, but now I'm curious,
> I'll have to go take a look.
No, only the 25 page document (which has the graphs) is directly related
to the question. It is different variants on a query (well, two queries,
but they are very similar), along with EXPLAIN ANALYZE VERBOSE and
time-memory graphs.
The 41 page document is just background, but relevant background. It
contains information about the schema, tables, hardware, pg config info.
It also has transcripts of a couple of old IRC sessions, which are
increasingly less relevant, so I may remove that.
Since I've been told by a couple of different people that the way I asked
my question was not ideal, I'll try reposting again with a modified
version (but still containing the same information) in a bit.
Regards, Faheem.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Faheem Mitha | 2010-03-29 06:43:30 | Re: simultaneously reducing both memory usage and runtime for a query |
| Previous Message | Greg Smith | 2010-03-29 05:14:59 | Re: Simultaneous write requests |