Re: huge execution time difference with almost same plan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: huge execution time difference with almost same plan
Date: 2004-09-06 16:08:56
Message-ID: 14625.1094486936@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 ...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2004-09-06 17:17:24 Re: Indexed views?
Previous Message Reini Urban 2004-09-06 15:03:39 Re: APR 1.0 released