pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSources of information about sizing of hardwares to run PostgreSQL
2+ messages / 2 participants
[nested] [flat]
* Sources of information about sizing of hardwares to run PostgreSQL
@ 2008-06-27 17:56 Sérgio R F Oliveira <sergio.r.f.oliveira@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Sérgio R F Oliveira @ 2008-06-27 17:56 UTC (permalink / raw)
To: pgsql-performance
Hi all,
I need to specify servers and storage to run PostgreSQL. Does anyone
know any source of information (articles, presentations, books, etc.)
which describes methods of hardware sizing for running a large
PostgreSLQ installation?
Thank you in advance.
Sergio.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Sources of information about sizing of hardwares to run PostgreSQL
@ 2008-06-29 19:04 Greg Smith <gsmith@gregsmith.com>
parent: Sérgio R F Oliveira <sergio.r.f.oliveira@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Greg Smith @ 2008-06-29 19:04 UTC (permalink / raw)
To: Sérgio R F Oliveira <sergio.r.f.oliveira@gmail.com>; +Cc: pgsql-performance
On Fri, 27 Jun 2008, Sérgio R F Oliveira wrote:
> I need to specify servers and storage to run PostgreSQL. Does anyone
> know any source of information (articles, presentations, books, etc.)
> which describes methods of hardware sizing for running a large
> PostgreSLQ installation?
There aren't any, just a fair number of people who know how to do it and
some scattered bits of lore on the subject. The quickest way to get some
sort of estimate that is actually useful is to create a small prototype of
some tables you expect will be the larger ones for the application, load
some data into them, measure how big they are, and then extrapolate from
there. I'm dumping links and notes on the subject of measurements like
that http://wiki.postgresql.org/wiki/Disk_Usage that should get you
started with such a simulation.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-06-29 19:04 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-27 17:56 Sources of information about sizing of hardwares to run PostgreSQL Sérgio R F Oliveira <sergio.r.f.oliveira@gmail.com>
2008-06-29 19:04 ` Greg Smith <gsmith@gregsmith.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox