Jeremiah Peschka

less info
131 reputation
3
bio website facility9.com
location Portland, OR
age 35
visits member for 5 years, 2 months
seen Jun 10 at 9:45

I am a founder and owner at Brent Ozar Unlimited. I’ve worked as a database and emerging technology expert at Quest Software where I researched new trends and technologies in the world of data storage. Over the course of my career I’ve worked with a number of companies in a variety of industries as a system administrator, developer, and DBA. I’ve been involved with most aspects of application development and deployment. I blog about data storage, relational databases, and software development at http://www.facility9.com and can be found on twitter as @peschkaj


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