Re: [HACKERS] Materialiation is slower than non-materialized

2015-03-23 Thread Rajeev rastogi
On 23 March 2015 21:39, Robert Haas > On Mon, Mar 23, 2015 at 6:01 AM, Rajeev rastogi > wrote: > > The cost of re-scan of SeqScan node is considered to be same scan of > > SeqScan node, which always assumes that the records is fetched from > > disk and hence disk access cost is added (As we don’

Re: [HACKERS] Materialiation is slower than non-materialized

2015-03-23 Thread Robert Haas
On Mon, Mar 23, 2015 at 6:01 AM, Rajeev rastogi wrote: > The cost of re-scan of SeqScan node is considered to be same scan of SeqScan > node, which always assumes that the records is fetched from disk and hence > disk access cost is added (As we don’t know really how much memory will be > availabl