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