Re: [PERFORM] TPCH 100GB - need some help

2004-05-18 Thread Eduardo Almeida
Mr. Tom Lane --- Tom Lane [EMAIL PROTECTED] wrote: Eduardo Almeida [EMAIL PROTECTED] writes: I need some help in a TPCH 100GB benchmark. Here I put the query #19, the explain and the top for it. IIRC, this is one of the cases that inspired the work that's been done on the query

Re: [PERFORM] TPCH 100GB - need some help

2004-05-14 Thread Rod Taylor
On Fri, 2004-05-14 at 14:00, Eduardo Almeida wrote: Hi folks, I need some help in a TPCH 100GB benchmark. Performance with 7.5 is much improved over 7.4 for TPCH due to efforts of Tom Lane and OSDL. Give it a try with a recent snapshot of PostgreSQL. Otherwise, disable nested loops for that