Re: [PERFORM] TPC-R benchmarks

2003-10-03 Thread Oleg Lebedev
any time soon. Thanks. Oleg -Original Message- From: Josh Berkus [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:27 PM To: Oleg Lebedev; scott.marlowe Cc: [EMAIL PROTECTED] Subject: Re: [PERFORM] TPC-R benchmarks Oleg, I have another question. How do I optimize my

Re: [PERFORM] TPC-R benchmarks

2003-10-02 Thread Oleg Lebedev
I ran VACUUM FULL ANALYZE yesterday and the re-ran the query with EXPLAIN ANALYZE. I got the same query plan and execution time. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:20 PM To: Oleg Lebedev Cc: Josh Berkus; scott.marlowe; [EMAIL

Re: [PERFORM] TPC-R benchmarks

2003-10-02 Thread Oleg Lebedev
to make this query run fast without hurting the performance of the other queries? Thanks. Oleg -Original Message- From: scott.marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:00 PM To: Oleg Lebedev Cc: Josh Berkus; [EMAIL PROTECTED] Subject: Re: [PERFORM] TPC-R

Re: [PERFORM] Tuning/performance issue...

2003-10-01 Thread Oleg Lebedev
Jeff, I would really appreciate if you could send me that lengthy presentation that you've written on pg/other dbs comparison. Thanks. Oleg -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 6:23 AM To: David Griffiths Cc: [EMAIL PROTECTED]

Re: [PERFORM] TPC-R benchmarks

2003-10-01 Thread Oleg Lebedev
To: Oleg Lebedev Cc: [EMAIL PROTECTED] Subject: Re: [PERFORM] TPC-R benchmarks On Tue, 30 Sep 2003, Oleg Lebedev wrote: I continue struggling with the TPC-R benchmarks and wonder if anyone could help me optimize the query below. ANALYZE statistics indicate that the query should run relatively

Re: [PERFORM] TPC-R benchmarks

2003-10-01 Thread Oleg Lebedev
) (actual time=0.08..0.08 rows=1 loops=348760) Index Cond: (outer.ps_suppkey = supplier.s_suppkey) Total runtime: 6674724.23 msec (28 rows) -Original Message- From: Oleg Lebedev Sent: Wednesday, October 01, 2003 12:00 PM To: Josh Berkus

Re: [PERFORM] TPC-R benchmarks

2003-09-29 Thread Oleg Lebedev
Message- From: Mary Edie Meredith [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 10:12 AM To: Tom Lane Cc: Oleg Lebedev; Jenny Zhang; pgsql-performance Subject: Re: [PERFORM] TPC-R benchmarks The TPC-H/R rules allow only minor changes to the SQL that are necessary due to SQL

Re: [PERFORM] TPC-R benchmarks

2003-09-29 Thread Oleg Lebedev
! I just checked -Original Message- From: Mary Edie Meredith [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:04 AM To: Oleg Lebedev Cc: Tom Lane; Jenny Zhang; pgsql-performance Subject: RE: [PERFORM] TPC-R benchmarks On Mon, 2003-09-29 at 07:35, Oleg Lebedev wrote: I left

Re: [PERFORM] TPC-R benchmarks

2003-09-29 Thread Oleg Lebedev
- From: Oleg Lebedev Sent: Monday, September 29, 2003 11:23 AM To: Mary Edie Meredith Cc: Jenny Zhang; pgsql-performance Subject: Re: [PERFORM] TPC-R benchmarks Importance: Low It took 10 hours to compute the query without the index on lineitem.l_partkey. Once I created the index

Re: [PERFORM] TPC-R benchmarks

2003-09-29 Thread Oleg Lebedev
: Josh Berkus [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 12:11 PM To: Oleg Lebedev; Mary Edie Meredith Cc: Jenny Zhang; pgsql-performance Subject: Re: [PERFORM] TPC-R benchmarks Oleg, I just checked the restrictions on the TPC-R and TPC-H schemas and it seems that all indexes

[PERFORM] TPC-R benchmarks

2003-09-25 Thread Oleg Lebedev
Title: Message I am running TPC-R benchmarks with a scale factor of 1, which correspond to approximately 1 GB database size on PostgreSQL 7.3.4 installed on CygWin on Windows XP. I dedicated 128 MB of shared memory to my postrges installation. Most of the queries were able to complete in a