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
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
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
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]
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
) (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
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
!
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
-
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
: 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
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
11 matches
Mail list logo