Re: [PERFORM] OSDL Database Test Suite 3 is available on PostgreSQL

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, osdldbt-general(at)lists(dot)sourceforge(dot)net
Subject: Re: [PERFORM] OSDL Database Test Suite 3 is available on PostgreSQL
Date: 2003-08-04 16:39:27
Message-ID: 3F2ED997.25642.6C9A5E@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On 4 Aug 2003 at 15:33, Manfred Koizar wrote:

> On 01 Aug 2003 11:04:10 -0700, Jenny Zhang <jenny(at)osdl(dot)org> wrote:
> >A sample OSDL-DBT3 test result report can be found at:
> >http://khack.osdl.org/stp/276912/
> >
> >Your comments are welcome,

I could not get postgresql .conf so I will combine the comments.

1. Effective cache size, already mentioned
2. Sort memory already mentioned.
3. Was WAL put on different drive?
4. Can you try with autovacuum daemon and 7.4beta when it comes out..
5. What was the file system? Ext2/Ext3/reiser/XFS?

<Scratching head>

Is there any comparison available for other databases.. Could be interesting to
see..:-)

</Scratching head>

Thanks for the good work. I understand it must have been quite an effort to run
it..

Keep it up..

Bye
Shridhar

--
Fourth Law of Revision: It is usually impractical to worry beforehand about
interferences -- if you have none, someone will make one for you.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-08-04 16:42:41 Re: plPHP -- sort of an announcement.. but not commercial
Previous Message Joe Conway 2003-08-04 16:36:52 Re: plPHP -- sort of an announcement.. but not commercial

Browse pgsql-performance by date

  From Date Subject
Next Message Matt Clark 2003-08-04 16:56:00 Re: [SQL] EXTERNAL storage and substring on long strings
Previous Message Scott Cain 2003-08-04 16:25:41 Re: [SQL] EXTERNAL storage and substring on long strings