Re: Postgresql Hardware

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: Psicopunk <gil(dot)nunes(dot)resende(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql Hardware
Date: 2009-09-14 15:46:39
Message-ID: dcc563d10909140846h7d15e177q2282012566584e5a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 14, 2009 at 9:30 AM, Greg Smith <gsmith(at)gregsmith(dot)com> wrote:
> On Mon, 14 Sep 2009, Psicopunk wrote:
>
>> I will take some measurements and analyze this graphs.
>
> A snapshot of "vmstat 1" data from when something like your real app is
> running is far more useful at figuring out where you should allocate your
> hardware resources for than any theoretical planning can be.
>
>> Does anyone know where i can get a book about Postgresql Tuning and
>> hardware impact on performance?
>
> There aren't any yet.  I've collected links to the best stuff out there and
> written a few articles all at
> http://wiki.postgresql.org/wiki/Performance_Optimization
>
> And my personal page at http://www.westnet.com/~gsmith/content/postgresql/
> has some articles you might find interesting.  The "Database Hardware
> Benchmarking" presentation covers a lot of the relevant material if you want
> to spend an hour listening to me drone on about it, there's a lot of
> background I cover that you can't really get just from the slides.

Thumbs up to Greg's articles on performance tuning, they were a BIG
help to me a few years back when I was in Chicago (and they still are,
I've just learned a lot from them so I don't have to go back and read
them all the time now.)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-09-14 15:53:08 Re: Locks in postgres causing system load and crash.
Previous Message Saleem EDAH-TALLY 2009-09-14 15:45:14 Re: postgresql.key secure storage