On Mon, Sep 14, 2009 at 9:30 AM, Greg Smith <gsmith@xxxxxxxxxxxxx> 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.) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
