| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | DANTE ALEXANDRA <ALEXANDRA(dot)DANTE(at)BULL(dot)NET> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: out of memory during query execution |
| Date: | 2005-12-20 13:04:54 |
| Message-ID: | 20051220130439.GC4853@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Dec 20, 2005 at 01:35:03PM +0100, DANTE ALEXANDRA wrote:
> You will find below the explain plan of one of the queries which has
> finished with "out of memory". This query contains aggregate and a
> sub-select with 6 joins :
1. Firstly, it could be the Hash node. Does the estimated number of
matches in part (96000 rows) match reality?
2. Secondly, looks like lineitem could use an index on partkey. Maybe it
could then use a more efficient join?
Do you have indexes on the relevent columns?
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henrique Engelmann | 2005-12-20 13:42:51 | Could not read - Permission denied |
| Previous Message | Francisco Reyes | 2005-12-20 12:47:06 | Re: One DB not backed up by pg_dumpall |