Full Text Search benchmark, Oracle vs Postgres, on 2x Quad core Xeon, 8G RAM, 2 SSDs x RAID 1. Pg is being slightly faster when query contains several words, once word count increases, oracle leaps ahead (suggesting a more mature FTS implementation)
Posted in benchmark, comparison, database, dba, Linux, oracle, performance, postgresql, search | Comments Off | permalink
http://www.pgcon.org/2010/schedule/attachments/141_PostgreSQL-and-NoSQL.pdf
Posted in database, dba, nosql, postgresql, presentation | Comments Off | permalink
horror story about duplicate records in a table with UNIQUE index. The guy buid a pg himself (w/out knowing much about it), at some point pg included a patch that changed string sorting order, and that led to duplicate records. / you had to do REINDE…
Posted in dba, dublicates, horror, icu, patch, postgresql, reindex | Comments Off | permalink
“There’s very little information about PostgreSQL buffer cache
Posted in article, database, dba, performance, postgres, postgresql, tuning | Comments Off | permalink
improvements to PostgreSQL that could be made by tuning wal/background writer processes
Posted in background, buffers, database, dba, LRU, optimization, performance, postgres, postgresql, reference, tuning, wal | Comments Off | permalink
Notes about PostgreSQL WAL synchronizations methods
Posted in database, dba, disk, filesystem, performance, postgres, postgresql, tuning, wal | Comments Off | permalink
Notes about Write-Ahead Log, Check points and other IO configuration related to postgresql transaction log settings
Posted in dba, performance, pg_xlog, postgres, postgresql, tuning, wal | Comments Off | permalink
a “bloat” view – provides info postgresql tables that need a vacuum
Posted in bloat, dba, monitoring, nagios, postgresql, vacuum | Comments Off | permalink
some info about managing/prioritizing resources (CPU/IO/RAM) under PostgreSQL from the project’s WIKI
Posted in dba, IO, ionice, nice, performance, postgresql, priorities | Comments Off | permalink
PostgresSQL: how to count number of rows returned by a query and do it fast
Posted in count, cursors, database, dba, postgresql, programming, sql | Comments Off | permalink
You are currently browsing the archives for the postgresql category.
Konstantin Antselovich (c) 2004-2011
powered by WordPress
Entries (RSS)
and Comments (RSS).