Search Postgresql Archives

Re: Postgresql Hardware

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux