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

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: [pgsql-advocacy] [PERFORM] MySQL vs PG TPC-H benchmarks

Folks, I’m doing the 100GB TPC-H and I’ll show the previous results to our community (Postgres) in 3 weeks before finishing the study. My intention is to carry through a test with a VLDB in a low cost platform (PostgreSQL, Linux and cheap HW) and not to compare with another DBMS. So far I can

Re: [pgsql-advocacy] [PERFORM] MySQL vs PG TPC-H benchmarks

, Eduardo Almeida used the keyboard: - The configuration of the machine is: Dual opteron 64 bits model 240 4GB RAM 960 GB on RAID 0 Mandrake Linux 64 with Kernel 2.6.5 (I compiled a kernel for this test) Java SDK java version 1.4.2_04 PostgreSQL JDBC pg74.1jdbc3.jar - The TPC

Re: [pgsql-advocacy] [PERFORM] MySQL vs PG TPC-H benchmarks

for this ones. The last thing is that Jan forgets to mention that Teradata doesn’t show up now but in older lists shows 3TB and 10TB results. regards Eduardo --- Jan Wieck [EMAIL PROTECTED] wrote: Eduardo Almeida wrote: Folks, I’m doing the 100GB TPC-H and I’ll show the previous