Re: Postgresql Hardware

Thanks,Greg!

I will read your articles.

This is a great help to understand what HW and how to tune my
postgresql.

Best regards.

On 14 Set, 16:46, scott(dot)marl(dot)(dot)(dot)(at)gmail(dot)com (Scott Marlowe) wrote:
> On Mon, Sep 14, 2009 at 9:30 AM, Greg Smith <gsm(dot)(dot)(dot)(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 athttp://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.)
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general