| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "david(at)shadovitz(dot)com" <david(at)shadovitz(dot)com> |
| Cc: | "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Query plan - now what? |
| Date: | 2003-12-12 15:33:30 |
| Message-ID: | 19869.1071243210@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
David Shadovitz <david(at)shadovitz(dot)com> writes:
> Well, now that I have the plan for my slow-running query, what do I
> do?
This is not very informative when you didn't show us the query nor
the table schemas (column datatypes and the existence of indexes
are the important parts). I have a feeling that you might be well
advised to fold the multiple tables into one "animals" table, but
there's not enough info here to make that recommendation for sure.
BTW, what did you do with this, print and OCR it? It's full of the
most bizarre typos ... mostly "l" for "1", but others too ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Shadovitz | 2003-12-12 15:46:36 | Re: Query plan - now what? |
| Previous Message | Rhaoni Chiu Pereira | 2003-12-12 12:39:59 | ODBC Driver generates a too big "windows swap file" and it's too slow |