PostgreSQL 9.0: High Performance
Accelerate your PostgreSQL system. Improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples. You'll find both here. Many of the examples given will be immediately useful for monitoring and improving your PostgreSQL deployments, providing insight into hard-to-obtain information about your database. This book is aimed at intermediate to advanced database administrators using or planning to use PostgreSQL. Portions will also interest systems administrators looking to build or monitor a PostgreSQL installation, as well as developers interested in advanced database internals that impact application design.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Summary by usage count
Server Configuration Tuning Interacting with thelive configuration Defaults and reset values
Recovering frommajor problems Autoanalyze
pgbench custom tests
Insert speed test Transaction Processing Performance Councilbenchmarks Summary 9 Database Indexing
Processing nodes Sort
Other query planning parameters effective_cache_size
actual allocated application autovacuum benchmarking block buffer cache canbe changes Chapter checkpoint client commit configuration create customerid customers database default DELETE disk drive DTrace endup example execute EXPLAIN ANALYZE SELECT ext2 ext3 ext4 feature filesystem FreeBSD fsync happens hardware Hash Index Scan INSERT installed inthe iostat join kernel Linux lock loops=1 memcached memtest86+ monitoring Nagios node ofthe onthe operating system orderid output overhead parameters partition performance pg_buffercache pg_class pgbench pgbench_accounts postgres PostgreSQL 9.0 PostgreSQL versions postgresql.conf primary key problem psql query optimizer query planning RAID relname replication rows rows=1 loops=1 running Seq Scan sequential server shared memory shared_buffers sort standby statements statistics syslog tablespace there's Total runtime tothe transaction ID trigger tuning tuples UNIX UPDATE vacuum vmstat width=4 Windows work_mem workload write cache youcan