| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Rainer Mager" <rmager(at)vgkk(dot)com> |
| Cc: | "PostgreSQL Admin" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: High memory usage |
| Date: | 2001-06-21 01:55:50 |
| Message-ID: | 11566.993088550@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-jdbc pgsql-patches |
"Rainer Mager" <rmager(at)vgkk(dot)com> writes:
> First, this type of query seems to use exponential amounts of memory.
Hmm. What does EXPLAIN show as the plan for the query? How long does
it take to do the EXPLAIN? If the EXPLAIN alone takes a lot of time/
space, then you need to reduce the size of the planner's search space
with an explicit JOIN --- see
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/explicit-joins.html
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-06-21 02:08:04 | Re: High memory usage [PATCH] |
| Previous Message | Kristis Makris | 2001-06-20 22:33:25 | Re: Using the extract() function in plpgsql |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-06-21 02:08:04 | Re: High memory usage [PATCH] |
| Previous Message | Rainer Mager | 2001-06-20 22:19:54 | RE: High memory usage |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-06-21 01:56:03 | Re: [PATCHES] Cygwin contrib patch |
| Previous Message | Rainer Mager | 2001-06-20 22:19:54 | RE: High memory usage |