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

[PERFORM] TPCH 100GB - need some help

Hi folks, I need some help in a TPCH 100GB benchmark. I described our settings in: http://archives.postgresql.org/pgsql-performance/2004-04/msg00377.php Some queries are taking to long to finish (4, 8, 9, 10, 19,20 and 22) and I need some help to increase the system performance. Here I put the q

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

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

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

8AM -0700, > 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) >

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 te