Reputation
Next privilege 200 Rep.
See reduced ads
Badges
3
Newest
 Teacher
Impact
~6k people reached

  • 0 posts edited
  • 0 helpful flags
  • 11 votes cast
Dec
17
comment Azure IO performance sql server
Regarding cloud solutions - marking a question as a duplicate of something from a year ago isn't a particularly good idea. Things change frequently enough that asking a new question is likely to be more productive than opening a new question.
May
4
comment How well does PostgreSQL perform with a large number of databases?
@Eduardo A moderately priced server with connection pooling turned on at the clients can theoretically handle a pretty heavy load, but it depends on the load: the type of queries you're running, different querying patterns, network connectivity and host of other things that are pretty difficult to determine through Stack Overflow. Enabling connection pooling, using gigabit ethernet or Infiniband, multiple ethernet cards, and proper storage configuration go a long way toward serving a huge number of concurrent users.
Apr
28
comment How well does PostgreSQL perform with a large number of databases?
@Eduardo I have a great deal of experiencing designing, developing, and administering multi-tenant applications, specifically from the database side of things.
Apr
28
comment How well does PostgreSQL perform with a large number of databases?
@Eduardo don't design for features that you don't have right. If that were the case my car would be a submarine and would repel bears and would be able to fly to the moon. There are plenty of solid database design patterns that will let you start with a large table and add additional features as needed. The key is to ask yourself what you need today and what your ops team will be able to support based on growth projections.
Apr
26
awarded  Teacher
Apr
26
answered How well does PostgreSQL perform with a large number of databases?
Mar
23
comment PostgreSQL High Performance Setup
I couldn't agree more. When database people refer to separate drives, they really do mean separate drives. This may be different in a SAN where you're carving up massive numbers of disks to make LUNs, but with internal storage, you'll want to be careful about how you carve up those drives. I'd use a mirrored pair for the OS, a mirrored pair for the logs and RAID 10 for data.
Mar
19
comment Benchmarking a hard disk drive for OLTP
If you can afford it, use 4 drives in RAID 10 for everything. Separate your logs and data files on different LUN/RAID groups and have a max of 1 LUN/RAID group per CPU core. Otherwise, read the PostgreSQL 9.0 High Peformance book that @StarShip3000 recommended. I hear great things about it.
Apr
30
awarded  Autobiographer
Apr
30
awarded  Supporter