Re: simultaneously reducing both memory usage and runtime for a query

Faheem Mitha wrote:
>
>
> On Sun, 28 Mar 2010, Tom Lane wrote:
>
> > Faheem Mitha <faheem(at)email(dot)unc(dot)edu> writes:
> >> ... In any case, feedback would be helpful. Details of my attempts
> >> at optimization are at
> >> http://bulldog.duhs.duke.edu/~faheem/snppy/opt.pdf
> >
> > By and large, this is not the way to ask for help on the Postgres lists.
> > If you're supplying extremely large test data or something, it's fair to
> > provide a link instead of putting the information in-line, but otherwise
> > you should try to make your email self-contained. Those of us who are
> > willing to help are not here just to help you --- we'd like other people
> > to learn from it too, both at the time and later from the archived
> > discussion. So the information needs to be in the email thread, not
> > only on some transient web page.
>
> I submitted a modified self-contained email as requested, but it does not
> appear to have made it to the list, and I never got any kind of reject
> message. It was around 1000 lines with no attachments. Is there a size
> limit for posts, and if so, what is it? If it was rejected due to some
> filter, it would be desirable (and polite) if the recepient was told what
> happened.

The bottom line is that this email list is best at answering short,
detailed questions. Larger questions that require a lot of analysis by
readers are often ignored.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com