Re: [osdldbt-general] Re: [PERFORM] OSDL Database Test Suite 3 is

From: Craig Thomas <craiger(at)osdl(dot)org>
To: shridhar_daithankar(at)persistent(dot)co(dot)in
Cc: pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, osdldbt-general(at)lists(dot)sourceforge(dot)net
Subject: Re: [osdldbt-general] Re: [PERFORM] OSDL Database Test Suite 3 is
Date: 2003-08-04 22:48:31
Message-ID: 1060037311.24401.155.camel@bullpen.pdx.osdl.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On Mon, 2003-08-04 at 09:39, Shridhar Daithankar wrote:
> 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..:-)

OSDL has run workloads using the SAP DB and PostgreSQL. However, each
of the workloads have been tweaked to work around deficiencies of each
database with respect to the TPC benchmarks from with the DBT workloads
are derrived. Since there are extensive modifications to each workload
an that the fact that each workload operates under different situations
(SAP uses raw disk, PostgreSQL uses a file system), it is not beneficial
to compare numbers between different databases.

Remember, the intent is to provide a tool kit that can be used to
benefit the community. From other postings, it appears that these
workloads we have available can be used to help the PostgreSQl community
develop a better database; one that is better able to handle the kinds
of stress these workloads can produce when scaled to large database
sizes.

We have been using these kits to characterize the abilities of the Linux
kernel. To show that these workloads work with two different databases
implies that Linux is capable of supporting these two databases.

The other tool kits, by the way, are being ported to PostgreSQL as well.
Help is needed to tune the workloads to exercise PostgreSQL better. It
would be great if you could get involved with the porting efforts and
assist with the tuning of the PostgreSQL kit.

>
> </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.
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> _______________________________________________
> osdldbt-general mailing list
> osdldbt-general(at)lists(dot)sourceforge(dot)net
> https://lists.sourceforge.net/lists/listinfo/osdldbt-general
--
Craig Thomas
craiger(at)osdl(dot)org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jenny Zhang 2003-08-04 22:48:55 Re: [osdldbt-general] Re: [PERFORM] OSDL Database Test Suite 3 is
Previous Message scott.marlowe 2003-08-04 22:40:11 Re: [osdldbt-general] Re: [PERFORM] OSDL Database Test Suite 3 is

Browse pgsql-performance by date

  From Date Subject
Next Message Jenny Zhang 2003-08-04 22:48:55 Re: [osdldbt-general] Re: [PERFORM] OSDL Database Test Suite 3 is
Previous Message scott.marlowe 2003-08-04 22:40:11 Re: [osdldbt-general] Re: [PERFORM] OSDL Database Test Suite 3 is