Re: [ANNOUNCE] PostgreSQL Portland Performance Practice Project (P5)

Here's a copy of the flyer produced by Portland State University:

-----

PostgreSQL Portland Performance Practice Project (P5)

A series of presentations
by
Mark Wong

This series will consist of 5 to 6 presentations aimed at PostgreSQL
database users who wish to learn more about tuning their systems for
performance. Attendees will learn how to generate and interpret
operating system (Linux) and database statistics, and the effects of
some system tuning techniques. This involves studying the well known
Online Transaction Processing (OLTP) benchmark called TPC-C ( www.tpc.org
). TPC-C was developed by a committee, representing all major
players in the database marketplace, to be representative of typical
online enterprise databases. TPC-C consists of a precisely defined
schema and 19 queries. We will review the schema and queries and
demonstrate how each tuning technique affects their performance. We
will use an open source package that the speaker has developed, called
DBT-2, which many DBAs have found useful.

Mark Wong has an MS in Computer Science from OGI and several years of
experience developing and executing various database systems
benchmarks. Most relevant to this series are his years spent at the
OSDL developing and using a fair-use derivative of the TPC-C benchmark
to characterize system performance of open source software. He now
works at HP StorageWorks on their NAS products.

2nd THURSDAY OF EACH MONTH, BEGINNING JANUARY 8, 7:00 PM
PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE,
FOURTH AVENUE BUILDING – ROOM 86-01

Will there be a fee for attending?

thanks,
-wes

On Mon, Dec 15, 2008 at 9:12 PM, Mark Wong <markwkm(at)gmail(dot)com> wrote:

> Here's a copy of the flyer produced by Portland State University:
>
> -----
>
> PostgreSQL Portland Performance Practice Project (P5)
>
> A series of presentations
> by
> Mark Wong
>
> This series will consist of 5 to 6 presentations aimed at PostgreSQL
> database users who wish to learn more about tuning their systems for
> performance. Attendees will learn how to generate and interpret operating
> system (Linux) and database statistics, and the effects of some system
> tuning techniques. This involves studying the well known Online Transaction
> Processing (OLTP) benchmark called TPC-C ( www.tpc.org ). TPC-C was
> developed by a committee, representing all major players in the database
> marketplace, to be representative of typical online enterprise databases.
> TPC-C consists of a precisely defined schema and 19 queries. We will review
> the schema and queries and demonstrate how each tuning technique affects
> their performance. We will use an open source package that the speaker has
> developed, called DBT-2, which many DBAs have found useful.
>
> Mark Wong has an MS in Computer Science from OGI and several years of
> experience developing and executing various database systems benchmarks.
> Most relevant to this series are his years spent at the OSDL developing and
> using a fair-use derivative of the TPC-C benchmark to characterize system
> performance of open source software. He now works at HP StorageWorks on
> their NAS products.
>
> 2nd THURSDAY OF EACH MONTH, BEGINNING JANUARY 8, 7:00 PM
> PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE,
> FOURTH AVENUE BUILDING – ROOM 86-01
> --
> Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pdxpug
>

On Tue, Dec 16, 2008 at 10:11 AM, wes <pdxpug(at)the-wes(dot)com> wrote:
> Will there be a fee for attending?

No, it's a free series.

Regards,
Mark

Mark Wong wrote:
> On Tue, Dec 16, 2008 at 10:11 AM, wes <pdxpug(at)the-wes(dot)com> wrote:
>> Will there be a fee for attending?
>
> No, it's a free series.

Any plans for it be recorded? Put online? Even the notes used would be
great for us non-locals.

Rod
--
>
> Regards,
> Mark

On Tue, Dec 16, 2008 at 10:41 AM, Roderick A. Anderson <raanders(at)acm(dot)org> wrote:
> Mark Wong wrote:
>>
>> On Tue, Dec 16, 2008 at 10:11 AM, wes <pdxpug(at)the-wes(dot)com> wrote:
>>>
>>> Will there be a fee for attending?
>>
>> No, it's a free series.
>
> Any plans for it be recorded? Put online? Even the notes used would be
> great for us non-locals.

Hi Rod,

I hadn't thought about video taping. We might be able to do that.
Nevertheless, the slides will be available.

Regards,
Mark

Is there a more recent source repository / tarball than the one I found
on Sourceforge (dbt2-0.40.tar.gz)? I am experimenting with it on my
workstation. So far, the only thing I have found that's wrong is that
there are missing files in the "doc" directory, so the documentation
won't build. I commented out the offending lines in the ".tex" files to
get the builds to run, but there aren't any diagrams in the resulting
PDF files.

--
M. Edward (Ed) Borasky, FBG, AB, PTA, PGS, MS, MNLP, NST, ACMC(P), WOM

I've never met a happy clam. In fact, most of them were pretty steamed.

On Dec 20, 2008, at 5:59 PM, M. Edward (Ed) Borasky wrote:

> Is there a more recent source repository / tarball than the one I
> found
> on Sourceforge (dbt2-0.40.tar.gz)? I am experimenting with it on my
> workstation. So far, the only thing I have found that's wrong is that
> there are missing files in the "doc" directory, so the documentation
> won't build. I commented out the offending lines in the ".tex" files
> to
> get the builds to run, but there aren't any diagrams in the resulting
> PDF files.

There is not a more recent release but there is a more recent
repository on git.postgresql.org. I suggest signing up on the osdldbt-
general mailing list on sourceforge if you want to keep up with the
database tests. That is a more appropriate place to ask rather than
the pdxpug mailing list.

Regards,
Mark