Home > Archive > PostgreSQL Performance > August 2005










Posts(4)August 31, 2005, 8:24 pmSwapping
Posts(6)August 31, 2005, 9:29 am'Real' auto vacuum?
Posts(14)August 31, 2005, 3:25 amRAID Configuration Sugestion
Posts(12)August 30, 2005, 8:28 pmHigh load and iowait but no disk access
Posts(2)August 30, 2005, 8:28 pmObservation about db response time
Posts(6)August 30, 2005, 1:26 pmNeed indexes on empty tables for good performance ?
Posts(5)August 30, 2005, 9:29 amOSX & Performance
Posts(2)August 30, 2005, 3:25 amHow to improve Postgres performance
Posts(15)August 29, 2005, 8:26 pmWeird performance drop after VACUUM
Posts(2)August 29, 2005, 8:26 pmgetting an index to work with partial indices ...
Posts(6)August 29, 2005, 8:26 pmPerformance for relative large DB
Posts(17)August 29, 2005, 8:26 pmLimit + group + join
Posts(2)August 28, 2005, 8:24 pmPlanner improvement suggestion
Posts(2)August 28, 2005, 8:24 pmBitmap scan when it is not needed
Posts(2)August 28, 2005, 8:24 pmintarray is broken ? (8.1b1)
Posts(6)August 28, 2005, 11:23 amRe: Inefficient queryplan for query with intersectable
Posts(1)August 27, 2005, 11:23 amRe: Inefficient queryplan for query with
Posts(5)August 26, 2005, 8:24 pmSending a select to multiple servers.
Posts(5)August 26, 2005, 8:24 pmdifference in plan between 8.0 and 8.1?
Posts(2)August 26, 2005, 8:24 pmHow does the planner execute unions?
Posts(5)August 26, 2005, 1:24 pmPerformance indexing of a simple query
Posts(1)August 26, 2005, 7:24 amInefficient queryplan for query with intersectable subselects/joins
Posts(2)August 26, 2005, 7:24 ampostmaster memory keep going up????
Posts(1)August 25, 2005, 8:25 pmRe: Read/Write block sizes
Posts(2)August 25, 2005, 8:25 pmRe: Read/Write block sizes
Posts(3)August 25, 2005, 8:25 pmWhat *_mem to increase when running CLUSTER
Posts(2)August 25, 2005, 8:25 pmRe: Read/Write block sizes
Posts(30)August 25, 2005, 7:24 amCaching by Postgres
Posts(6)August 25, 2005, 3:37 amSome ideas for comment
Posts(1)August 24, 2005, 8:25 pmRAID arrays (and vendors)
Posts(5)August 24, 2005, 8:25 pmRe: Read/Write block sizes
Posts(1)August 24, 2005, 8:25 pmRe: Read/Write block sizes
Posts(1)August 24, 2005, 8:25 pmRe: Read/Write block sizes
Posts(6)August 24, 2005, 1:26 pmperformance drop on RAID5
Posts(6)August 24, 2005, 1:26 pmRe: Read/Write block sizes
Posts(2)August 24, 2005, 9:24 amRe: Read/Write block sizes
Posts(1)August 24, 2005, 3:24 amRe: Read/Write block sizes
Posts(3)August 23, 2005, 8:25 pmRe: Read/Write block sizes (Was: Caching by Postgres)
Posts(2)August 23, 2005, 8:25 pmRe: Read/Write block sizes
Posts(1)August 23, 2005, 8:25 pmRe: Read/Write block sizes
Posts(6)August 23, 2005, 8:24 pmcomplex query performance assistance request
Posts(2)August 23, 2005, 11:24 amfake condition causes far better plan
Posts(3)August 23, 2005, 9:24 ampgbench
Posts(40)August 23, 2005, 7:24 amextremly low memory usage
Posts(3)August 23, 2005, 3:24 amunused item pointers?
Posts(16)August 22, 2005, 8:25 pmNeed for speed
Posts(3)August 22, 2005, 8:25 pmRe: MemoryContextSwitchTo during table scan?
Posts(7)August 22, 2005, 8:25 pmLooking for a large database for testing
Posts(3)August 22, 2005, 8:25 pmMemoryContextSwitchTo during table scan?
Posts(22)August 22, 2005, 1:23 pmFinding bottleneck
Posts(18)August 22, 2005, 7:24 amsustained update load of 1-2k/sec
Posts(1)August 21, 2005, 8:24 pmRe: (Re)-indexing on updates
Posts(3)August 20, 2005, 11:23 amindex as large as table
Posts(6)August 20, 2005, 7:23 amQuery plan looks OK, but slow I/O - settings advice?
Posts(3)August 19, 2005, 1:26 pmLEFT JOIN ON vs. LEFT JOIN USING performance
Posts(1)August 19, 2005, 1:26 pmRe: I'm configuraing a new system (Bigish) and need some
Posts(1)August 19, 2005, 3:26 amI'm configuraing a new system (Bigish) and need some advice.
Posts(16)August 19, 2005, 3:26 amPerformance pb vs SQLServer.
Posts(1)August 19, 2005, 3:26 amRe: I'm configuraing a new system (Bigish) and need some advice.
Posts(3)August 18, 2005, 8:25 pmFW: Tx forecast improving harware capabilities.
Posts(4)August 18, 2005, 8:25 pmlimit number of concurrent callers to a stored proc?
Posts(1)August 18, 2005, 3:24 amRe: limit number of concurrent callers to a stored
Posts(1)August 17, 2005, 8:25 pmRe: [HACKERS] bitmap scan issues 8.1 devel
Posts(1)August 17, 2005, 8:25 pmRe: [HACKERS] bitmap scan issues 8.1 devel
Posts(4)August 17, 2005, 8:25 pmRe: Insert performance (OT?)
Posts(2)August 17, 2005, 8:25 pmTuning Effective Cache Question
Posts(11)August 17, 2005, 8:25 pmPG8 Tuning
Posts(1)August 17, 2005, 8:25 pmbitmap scan issues 8.1 devel
Posts(1)August 17, 2005, 1:24 pmRe: Tuning Effective Cache Question
Posts(1)August 17, 2005, 1:24 pmRe: Data Selection Slow From VB 6.0
Posts(1)August 17, 2005, 9:31 amRe: Data Selection Slow From VB 6.0
Posts(1)August 17, 2005, 3:24 amRe: Performance problem using V3 protocol in jdbc driver
Posts(11)August 17, 2005, 3:24 amchoosing RAID level for xlogs
Posts(1)August 16, 2005, 1:27 pmRe: [SPAM?] Re: PG8 Tuning
Posts(5)August 16, 2005, 1:27 pmRe: [SPAM?] Re: PG8 Tuning
Posts(1)August 16, 2005, 1:27 pmRe. : Need for speed
Posts(2)August 16, 2005, 1:27 pmdatabase encoding with index search problem
Posts(1)August 15, 2005, 8:25 pmRe: I'm configuraing a new system (Bigish) and need some advice.
Posts(5)August 15, 2005, 11:24 amOdd Locking Problem
Posts(4)August 15, 2005, 3:24 amHow many views is ok?
Posts(1)August 14, 2005, 8:24 pmRe: [Fwd: PG8 Tuning]
Posts(1)August 12, 2005, 8:25 pmRe: Mostly read performance (2 replies)
Posts(5)August 12, 2005, 3:24 amMostly read performance
Posts(1)August 11, 2005, 8:25 pmRe: [SPAM?] Re: PG8 Tuning
Posts(2)August 11, 2005, 1:28 pmBG writer question?
Posts(12)August 11, 2005, 1:28 pmSpeedier count(*)
Posts(8)August 11, 2005, 1:28 pmPlanner doesn't look at LIMIT?
Posts(3)August 11, 2005, 1:28 pmWhy is not using the index
Posts(3)August 11, 2005, 3:25 amit is always delete temp table will slow down the postmaster?
Posts(4)August 11, 2005, 3:25 ampartial index regarded more expensive
Posts(10)August 9, 2005, 8:26 pmTable locking problems?
Posts(18)August 9, 2005, 8:26 pmWhy hash join instead of nested loop?
Posts(3)August 9, 2005, 3:25 amQRY seems not using indexes
Posts(8)August 8, 2005, 11:25 amSlow update statement
Posts(3)August 5, 2005, 9:25 amPerformance problems on 4-way AMD Opteron 875 (dual core)
Posts(1)August 5, 2005, 9:25 amRe: Performance problems on 4-way AMD Opteron 875 (dual
Posts(33)August 4, 2005, 8:24 pmRe: Performance problems testing with Spamassassin 3.1.0
Posts(7)August 4, 2005, 1:26 pm"nice"/low priority Query
Posts(3)August 4, 2005, 7:24 amIndexed views.
Posts(2)August 3, 2005, 11:24 amIs There A Windows Version of Performance Tuning Documents?
Posts(8)August 3, 2005, 7:24 amPlanner incorrectly choosing seq scan over index scan
Posts(1)August 2, 2005, 1:24 pmpg_dump for table with bytea takes a long time
Posts(1)August 1, 2005, 8:25 pmRe: [PATCHES] COPY FROM performance improvements
Posts(1)August 1, 2005, 11:25 amRe: [PATCHES] COPY FROM performance improvements


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

Copyright 2008 droptable.com