| From: | "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com>, pgsql-general(at)postgresql(dot)org, Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu> |
| Subject: | Re: Out of memory error in 8.1.0 Win32 |
| Date: | 2006-06-22 20:48:45 |
| Message-ID: | 449B022D.4080106@blackducksoftware.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Tom Lane wrote:
>
> Hmm. One of the things that's on my TODO list is to make the planner
> smarter about drilling down into sub-selects to extract statistics.
> I think that's what's called for here, but your example has eliminated
> all the interesting details. Can you show us the actual query, its
> EXPLAIN plan, and the definitions of the tables/views involved?
I've already altered the queries that ran into this problem. I'll
dig the old ones out of CVS and send them to you tomorrow.
-- todd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Relyea, Mike | 2006-06-22 21:02:57 | Re: Out of memory error in 8.1.0 Win32 |
| Previous Message | Jacob Coby | 2006-06-22 20:43:52 | autovacuum template0 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-06-22 20:49:04 | Re: Overhead for stats_command_string et al, take 2 |
| Previous Message | Jim Nasby | 2006-06-22 20:42:10 | Re: vacuum, performance, and MVCC |