Re: [HACKERS] Unexpected speed PLAIN vs. MAIN

2015-05-05 Thread Sandro Santilli
On Mon, May 04, 2015 at 01:50:45PM -0400, Tom Lane wrote: > Sandro Santilli writes: > > I'm comparing speed of some queries against tables having the same data > > but different storage, and got an unexpected behavior. > > > The tables have 2 integer fields and a PcPatch field > > ("p", custom t

Re: [HACKERS] Unexpected speed PLAIN vs. MAIN

2015-05-04 Thread Tom Lane
Sandro Santilli writes: > I'm comparing speed of some queries against tables having the same data > but different storage, and got an unexpected behavior. > The tables have 2 integer fields and a PcPatch field > ("p", custom type from pgPointCloud). > There are no TOASTs involved (the toast tab