pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Recommended Specs
2+ messages / 2 participants
[nested] [flat]

* Recommended Specs
@ 2004-12-02 00:20 Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
  2004-12-02 06:15 ` Re: Recommended Specs Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Hasnul Fadhly bin Hasan @ 2004-12-02 00:20 UTC (permalink / raw)
  To: pgsql-performance

Hi,

I was reading a lot on the specs that was used by those who runs 
postgres.  I was wondering is the a more structured method of 
determining what is the required hardware specs?  The project that i am 
doing can populate about few millions records a day (worst case).

Based on what i read, this is what i guess

RAM - the more the better
postgresql.conf must be optimized
CPU - not sure if adding more CPU will really help unless i start to 
create parrallel insert sessions.
Hard disks - ?? how do i actually check how much space this records take 
on the hard drives?
optimized queries is a must
OS? linux? freebsd? solaris?
cpu type? sun sparc? intel? amd?
anything else?

Hasnul





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Recommended Specs
  2004-12-02 00:20 Recommended Specs Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
@ 2004-12-02 06:15 ` Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Josh Berkus @ 2004-12-02 06:15 UTC (permalink / raw)
  To: pgsql-performance; +Cc: Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>

Hasnul,

> Hard disks - ?? how do i actually check how much space this records take
> on the hard drives?
> optimized queries is a must
> OS? linux? freebsd? solaris?
> cpu type? sun sparc? intel? amd?
> anything else?

There have been treads discussing these as well.  Work your way through the 
archives.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-12-02 06:15 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-02 00:20 Recommended Specs Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
2004-12-02 06:15 ` Josh Berkus <josh@agliodbs.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