Re: huge execution time difference with almost same plan

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: huge execution time difference with almost same plan
Date: 2004-09-06 19:51:22
Message-ID: 413CBFBA.3090804@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

> Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> writes:
>
>>BTW, in 8.0 table spaces allow a table and an index to be placed on
>>different disk devices, which may improve the performance. Is it
>>possible that planner accounts for this in the future.
>
>
> I'm not sure how we could model it in any useful way ...
>

Isn't enough have the related costs for table spaces ?

Regards
Gaetano Mendola

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-09-06 21:15:13 SetQuerySnapshot redesign: yet another try
Previous Message Andrew Dunstan 2004-09-06 17:29:09 Re: APR 1.0 released