| From: | Eugene Fokin <elf(at)solvo(dot)ru> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Victor Yegorov <viktors(dot)jegorovs(at)nordlb(dot)lv>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: 7.3.2 vs 7.1.2 |
| Date: | 2003-05-21 07:19:03 |
| Message-ID: | 20030521071903.GC4664@solvo.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, May 20, 2003 at 12:40:21PM -0400, Tom Lane wrote:
>
> [...skipped...]
>
> I'm not sure whether selecting the count from this view is really all
> that important to Eugene, but if it is he could make an alternate view
> that has the same FROM clause and nothing interesting in its select
> list, and then count that.
>
This is the one sample from the working system for which I'm trying
to upgrade the database.
And you're right. I've removed all subqueries from select list and I've
got original 5 seconds ! After that I tried to add one subquery back (the
simpliest one) and got the same 40-50 seconds again !
--
Eugene Fokin
SOLVO Ltd. Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | amol | 2003-05-21 10:16:00 | Re: nested select query failing |
| Previous Message | Eugene Fokin | 2003-05-21 07:11:25 | Re: 7.3.2 vs 7.1.2 |