Home > Archive > PostgreSQL Performance > May 2005










Posts(4)May 31, 2005, 9:24 amslow queries, possibly disk io
Posts(4)May 31, 2005, 3:23 ampoor performance involving a small table
Posts(2)May 30, 2005, 8:24 pmtuning
Posts(5)May 30, 2005, 1:23 pmPostgresql and xeon.
Posts(6)May 30, 2005, 1:23 pmsequential scan performance
Posts(3)May 30, 2005, 11:23 amIndex not used on join with inherited tables
Posts(4)May 30, 2005, 3:23 amOID vs overall system performances on high load
Posts(2)May 28, 2005, 1:23 pmRe: OID vs overall system performances on high load
Posts(2)May 27, 2005, 8:24 pmRedundant indexes?
Posts(1)May 27, 2005, 1:23 pmOID vs overall system performances on high load databases.
Posts(5)May 27, 2005, 3:24 amOptimising queries involving unions
Posts(1)May 25, 2005, 8:24 pmRe: [PORTS] Which library has these symbols? -- Eureka
Posts(4)May 25, 2005, 8:24 pmInner join on two OR conditions dont use index
Posts(1)May 25, 2005, 8:24 pmtest - pls delete and ignore
Posts(10)May 25, 2005, 3:24 amCan anyone explain this: duplicate dbs.
Posts(4)May 23, 2005, 8:25 pmseqential vs random io
Posts(1)May 23, 2005, 8:25 pmRe: Fwd: Index on table when using DESC clause
Posts(11)May 23, 2005, 8:25 pmTuning planner cost estimates
Posts(1)May 23, 2005, 8:25 pmRe: Fwd: Index on table when using DESC clause
Posts(1)May 23, 2005, 1:24 pmRe: Fwd: Index on table when using DESC clause
Posts(6)May 21, 2005, 1:24 pmOptimizing for writes. Data integrity not critical
Posts(1)May 20, 2005, 8:25 pmperformance on a querry with many group by's any way to speed it up?
Posts(1)May 20, 2005, 8:25 pmcant seem to post the explain
Posts(2)May 19, 2005, 8:24 pmWhich is better, correlated subqueries or joins?
Posts(20)May 19, 2005, 8:24 pmPostgreSQL strugling during high load
Posts(1)May 18, 2005, 8:26 pmRe: [pgsql-benchmarks] Error when try installing pgbench ?
Posts(3)May 18, 2005, 11:23 amwhere+orderby+limit not (always) using appropriate index?
Posts(3)May 18, 2005, 3:24 amIs there any other way to do this?
Posts(1)May 17, 2005, 8:24 pmWhy is it taking so long?
Posts(3)May 17, 2005, 1:24 pmTrigger performance problem
Posts(2)May 16, 2005, 1:23 pmPrefetch
Posts(6)May 16, 2005, 11:23 amcheckpoint segments
Posts(4)May 16, 2005, 3:23 amPostgresql Performance via the LSI MegaRAID 2x Card
Posts(2)May 15, 2005, 8:24 pmRe: ok you all win what is best opteron (I dont want a
Posts(2)May 15, 2005, 8:24 pmSwapping and Kernel 2.6
Posts(1)May 15, 2005, 8:24 pmRe: ok you all win what is best opteron (I dont want a hosed system
Posts(5)May 15, 2005, 1:23 pmfull outer performance problem
Posts(1)May 14, 2005, 8:24 pmRe: ok you all win what is best opteron (I dont want a hosed system
Posts(5)May 14, 2005, 8:24 pmok you all win what is best opteron (I dont want a hosed system again)
Posts(49)May 14, 2005, 11:23 amPartitioning / Clustering
Posts(17)May 14, 2005, 11:23 amSort and index
Posts(5)May 13, 2005, 8:24 pmRe: Optimize complex join to use where condition before
Posts(10)May 13, 2005, 1:23 pmBad plan after vacuum analyze
Posts(4)May 13, 2005, 11:24 amRecommendations for set statistics
Posts(1)May 13, 2005, 3:24 amRe: Optimize complex join to use where condition before
Posts(3)May 12, 2005, 8:24 pmAND OR combination: index not being used
Posts(1)May 12, 2005, 8:24 pmOptimize complex join to use where condition before join
Posts(4)May 12, 2005, 1:24 pmtuning Postgres for large data import (using Copy from)
Posts(3)May 12, 2005, 7:24 amBLOB's bypassing the OS Filesystem for better Image loading speed?
Posts(20)May 12, 2005, 3:24 amIntel SRCS16 SATA raid?
Posts(5)May 11, 2005, 8:24 pmOptimizer wrongly picks Nested Loop Left Join
Posts(1)May 11, 2005, 8:24 pmFederated PG servers -- Was: Re: [GENERAL] "Hash index" vs. "b-tree index" (Pos
Posts(11)May 11, 2005, 8:24 pmPrefetch
Posts(1)May 11, 2005, 9:23 amRe: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL
Posts(24)May 11, 2005, 9:23 amRe: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL
Posts(14)May 11, 2005, 9:23 amQuery tuning help
Posts(3)May 11, 2005, 3:24 amConfiging 8 gig box.
Posts(1)May 10, 2005, 8:24 pmRe: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL
Posts(1)May 10, 2005, 8:24 pmRe: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL
Posts(3)May 10, 2005, 8:24 pmPrefetch - OffTopic
Posts(6)May 10, 2005, 8:24 pmPGSQL Capacity
Posts(1)May 10, 2005, 1:24 pmRe: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL
Posts(1)May 10, 2005, 3:24 amRe: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL
Posts(2)May 9, 2005, 8:24 pm"Hash index" vs. "b-tree index" (PostgreSQL 8.0)
Posts(1)May 9, 2005, 1:23 pmRe: ORDER BY Optimization
Posts(2)May 9, 2005, 11:24 amRe: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL 8.0)
Posts(10)May 9, 2005, 3:24 amsequence scan on PK
Posts(13)May 8, 2005, 1:23 pmRe: COPY vs INSERT
Posts(7)May 8, 2005, 7:23 amRe: Bad choice of query plan from PG 7.3.6 to PG 7.3.9
Posts(2)May 7, 2005, 8:23 pmRe: [SQL] ORDER BY Optimization
Posts(1)May 6, 2005, 3:24 amRe: Bad choice of query plan from PG 7.3.6 to PG 7.3.9
Posts(2)May 5, 2005, 8:24 pmTable stats
Posts(2)May 5, 2005, 11:24 amBad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1
Posts(1)May 5, 2005, 7:24 amRe: COPY vs INSERT
Posts(1)May 4, 2005, 8:24 pmRe: COPY vs INSERT
Posts(1)May 4, 2005, 8:24 pmRe: COPY vs INSERT
Posts(1)May 4, 2005, 7:24 amRe:
Posts(5)May 4, 2005, 3:25 amKernel Resources and max_connections
Posts(6)May 4, 2005, 3:25 amRe: [HACKERS] Bad n_distinct estimation; hacks suggested?
Posts(1)May 4, 2005, 3:25 amKernel Resources Solved
Posts(15)May 3, 2005, 8:24 pmbatch inserts are "slow"
Posts(1)May 3, 2005, 8:24 pmRe: COPY vs INSERT
Posts(1)May 3, 2005, 1:24 pmBad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1b
Posts(1)May 3, 2005, 1:24 pmTesting list access
Posts(1)May 3, 2005, 1:24 pmBad choice of query plan from PG 7.3.6 to PG 7.3.9 part 2
Posts(1)May 3, 2005, 11:24 amRe:
Posts(2)May 3, 2005, 11:24 amForeign key constraints compile faster in 7.4
Posts(1)May 2, 2005, 11:23 amCitation for "Bad n_distinct estimation; hacks suggested?"
Posts(3)May 1, 2005, 8:27 pmRe: BLOB's bypassing the OS Filesystem for better Image


Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com