Re: About "Our CLUSTER implementation is pessimal" patch
From:
Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To:
Leonardo F <m_lists(at)yahoo(dot)it>
Cc:
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: About "Our CLUSTER implementation is pessimal" patch
Date:
2010-01-21 08:34:20
Message-ID:
20100121173419.D19E.52131E4D@oss.ntt.co.jp (view raw or flat )
Thread:
2010-01-15 11:45:24 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-15 12:05:32 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-15 15:48:29 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-15 18:23:13 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-20 17:48:00 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-21 08:18:01 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-21 08:34:20 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-01-21 12:00:09 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-21 15:30:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-22 00:45:04 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-01-21 11:06:04 from Greg Stark <stark(at)mit(dot)edu>
2010-01-21 15:44:19 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-21 16:03:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-21 16:13:25 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-21 16:19:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-21 17:00:20 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-21 17:12:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-21 18:28:34 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-21 18:32:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-22 08:11:28 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-22 16:54:39 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-22 17:31:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-22 17:56:55 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-01-22 18:09:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-22 14:19:47 from Greg Stark <stark(at)mit(dot)edu>
Lists:
pgsql-hackers
Leonardo F <m_lists(at)yahoo(dot)it> wrote:
> Anyone? I'd like some feedback before moving on to do the seq scan + sort in those
> CLUSTER cases where "use_index_scan" returns false...
+1 for CLUSTER using sort.
I have a couple of comments for the current implementation:
* Do we need to disable sort-path for tables clustered on a gist index?
* I'd prefer to separate cost calculation routines from create_index_path()
and cost_sort(), rather than using a dummy planner.
Regards,
---
Takahiro Itagaki
NTT Open Source Software Center
In response to
Responses
pgsql-hackers by date
Next :From: Greg SmithDate: 2010-01-21 08:35:55Subject : Re: HS/SR and smart shutdownPrevious :From : KaiGai KoheiDate : 2010-01-21 08:31:14Subject : Re: Largeobject Access Controls (r2460)
