Bookmarks
From Wiki
Contents |
Papers, White-papers
Dynamic Load Balancing in Hierarchical Parallel Database Systems
Load Balancing for Parallel Query Execution on NUMA Multiprocessors
Load Balancing for Parallel Query Execution on NUMA Multiprocessors
Experimenting NUMA for Scaleable CDR Processing
Oracle Whitepapers - Oracle Database 11g Architechture on Windows
IEEE Spectrum: Multicore Is Bad News For Supercomputers
Eclipse
Eclipse - Access restriction: Class is not accessible due to restriction on required library
PostgreSQL
Postgresql: Tunning PostgreSQL for performance
Postgresql: Annotated POSTGRESQL.CONF Guide for PostgreSQL
Postgresql: PostgreSQL Performance Tuning
Postgresql: Performance Tuning PostgreSQL by Frank Wiles
Postgresql: Shared Memory tutorial. The slides Inside the PostgreSQL Buffer Cache are probably the best read I had on how the PG Buffer Cache operates and how it relates to the OS's disk caching mechanisms.
Postgresql: Script that shows PG objects from linux memory. Python script showing PostgreSQL objects in linux memory: pg_osmem.py.
Postgresql: Optimizing Postgresql Database Size - VACUUM vs. RE-INDEX vs. DUMP/RESTORE
Postgresql: Performance scaling vs. Database Size Determining the right pgbench database size scale
Postgresql: Statistics enabling and gathering Monitoring Stats
Postgresql: PGCon on HOT (INCLUDEs cool postgresql.conf file against which they benchmarked) HOT Inside PostgreSQL
Postgresql: Postgresql internal workings - not extremely useful for Gany PostgreSQL Internals Through Pirctures
Scaling PostgreSQL on SMP Architectures
Postgresql: Transaction Processing in PostgreSQL
Postgresql: SPI - Server side functionality via C code SPI Examples and C-Language functions
Postgresql: Source Code
Postgresql - Oracle diffs (including migration from Oracle to Postgresql): PGCon 2007 The PostgreSQL Conference Oracle to PostgreSQL Conversion
Concurrency
Database Replication
Understanding replication in databases and distributed systems
MIDDLE-R: Consistent database replication at the middleware level
Java
Tool that enhances class loading - support for native lib in jar [1]
NUMA
Personal code snippets on NUMA.
Data Distribution, Migration and Replication on a cc-NUMA Architecture (2002)
