Home > Archive > PostgreSQL Performance > September 2005










Posts(1)September 30, 2005, 8:24 pmRe: [GENERAL] database bloat, but vacuums are done, and fsm seems to be setup ok
Posts(2)September 29, 2005, 8:24 pmHow to Trigger An Automtic Vacuum on Selected Tables
Posts(8)September 29, 2005, 8:24 pmMonitoring Postgresql performance
Posts(18)September 29, 2005, 11:24 amAdvice on RAID card
Posts(1)September 29, 2005, 9:24 amRe: [HACKERS] Query in SQL statement
Posts(1)September 29, 2005, 9:24 amRe: Delete query takes exorbitant amount of time
Posts(2)September 29, 2005, 3:24 amSequential I/O Cost (was Re: A Better External Sort?)
Posts(1)September 28, 2005, 3:25 amdatabase bloat, but vacuums are done, and fsm seems to be setup ok
Posts(2)September 28, 2005, 3:25 amThe need for full vacuum / reindex
Posts(8)September 27, 2005, 1:24 pmVACUUM FULL vs CLUSTER
Posts(2)September 27, 2005, 11:24 amslow database, queries accumulating
Posts(6)September 27, 2005, 11:24 amIndex not used on group by
Posts(3)September 27, 2005, 11:24 amPostgreSQL overall design
Posts(6)September 26, 2005, 8:25 pmint2 vs int4 in Postgres
Posts(1)September 26, 2005, 8:25 pmRe: [GENERAL] Index use in BETWEEN statement...
Posts(8)September 26, 2005, 8:25 pmQuery slower on 8.0.3 (Windows) vs 7.3 (cygwin)
Posts(10)September 25, 2005, 8:24 pmtsearch2 seem very slow
Posts(3)September 25, 2005, 1:23 pmRe: Releasing memory during External sorting?
Posts(2)September 24, 2005, 8:24 pmMultiple insert performance trick or performance misunderstanding?
Posts(1)September 24, 2005, 7:23 amRe: [HACKERS] Releasing memory during External sorting?
Posts(3)September 24, 2005, 3:23 amoptimization downgrade perfomance?
Posts(1)September 23, 2005, 8:24 pmRe: Releasing memory during External sorting?
Posts(1)September 23, 2005, 8:24 pmIndex use in BETWEEN statement...
Posts(1)September 23, 2005, 8:24 pmRe: Releasing memory during External sorting?
Posts(14)September 23, 2005, 11:24 amHow to determine cause of performance problem?
Posts(1)September 23, 2005, 11:24 amRe: [HACKERS] Releasing memory during External sorting?
Posts(1)September 23, 2005, 9:23 amRe: [HACKERS] Releasing memory during External sorting?
Posts(2)September 23, 2005, 3:24 amFW: Deadlock Issue with PostgreSQL
Posts(20)September 23, 2005, 3:24 amQueries 15 times slower on 8.1 beta 2 than on 8.0
Posts(1)September 22, 2005, 8:25 pmFw: Queries 15 times slower on 8.1 beta 2 than on 8.0
Posts(2)September 22, 2005, 1:24 pmRe: Nested Loop trouble : Execution time increases more
Posts(2)September 22, 2005, 11:24 amNested Loop trouble : Execution time increases more 1000 time (long)
Posts(1)September 22, 2005, 7:23 amRe: Nested Loop trouble : Execution time increases more
Posts(14)September 21, 2005, 1:26 pmPerformance considerations for very heavy INSERT traffic
Posts(5)September 21, 2005, 11:24 amCHECK vs REFERENCES
Posts(1)September 21, 2005, 3:24 amRe: Deadlock Issue with PostgreSQL
Posts(2)September 20, 2005, 8:24 pmPlanner statistics vs. count(*)
Posts(1)September 20, 2005, 8:24 pmunsubscribe
Posts(10)September 20, 2005, 11:24 amRAID Stripe size
Posts(6)September 20, 2005, 11:24 amNeed for speed 2
Posts(1)September 20, 2005, 9:24 amunsubscribe
Posts(3)September 20, 2005, 3:24 amIndex Selection: ORDER BY vs. PRIMARY KEY
Posts(4)September 20, 2005, 3:24 amHow many tables is too many tables?
Posts(3)September 19, 2005, 8:25 pmHow can this be?
Posts(1)September 16, 2005, 1:23 pmTest. Sorry.
Posts(1)September 15, 2005, 9:24 amRe: [ODBC] ODBC Driver on Windows 64 bit
Posts(8)September 14, 2005, 8:25 pmBattery Backed Cache for RAID
Posts(12)September 14, 2005, 1:24 pmLow performance on Windows problem
Posts(3)September 14, 2005, 9:23 amHelp with performance on current status column
Posts(8)September 14, 2005, 3:24 amAbout method of PostgreSQL's Optimizer
Posts(1)September 13, 2005, 8:24 pmAny other idea for better performance?
Posts(1)September 13, 2005, 8:24 pmunsubscribe
Posts(1)September 13, 2005, 8:24 pmunsubscribe
Posts(2)September 13, 2005, 1:24 pmRe: Performance considerations for very heavy INSERT
Posts(1)September 13, 2005, 11:24 amRe: Performance considerations for very heavy INSERT
Posts(1)September 13, 2005, 7:24 amOpencms6 ans Postgres8
Posts(1)September 13, 2005, 3:24 amRe: Performance considerations for very heavy INSERT
Posts(7)September 12, 2005, 11:24 amPrepared statement not using index
Posts(4)September 12, 2005, 9:25 amSlow update
Posts(5)September 12, 2005, 7:26 amLEFT JOIN optimization
Posts(6)September 12, 2005, 7:26 amAdvise about how to delete entries
Posts(8)September 11, 2005, 9:23 amshared buffers
Posts(3)September 11, 2005, 7:23 amIndex not used with prepared statement
Posts(1)September 11, 2005, 3:23 amperformance discrepancy indexing one column versus two columns
Posts(1)September 11, 2005, 3:23 amRe: performance discrepancy indexing one column versus
Posts(3)September 10, 2005, 3:23 amplease comment on cpu 32 bit or 64 bit
Posts(2)September 9, 2005, 3:24 amToo slow query, do you have an idea to optimize?
Posts(8)September 7, 2005, 8:25 pmPoor performance of delete by primary key
Posts(5)September 7, 2005, 8:25 pmQuery take 101 minutes, help, please
Posts(1)September 7, 2005, 11:24 amRe: [pgsql-hackers-win32] insert performance for win32
Posts(5)September 6, 2005, 8:24 pmpoor VACUUM performance on large tables
Posts(1)September 6, 2005, 8:24 pmlog_duration times
Posts(33)September 6, 2005, 1:26 pmMassive performance issues
Posts(3)September 6, 2005, 1:26 pmPostgresql Hardware - Recommendations
Posts(5)September 6, 2005, 1:26 pmImproving performance of a query
Posts(7)September 6, 2005, 9:24 amWhen to do a vacuum for highly active table
Posts(4)September 6, 2005, 3:24 amObservation about db response time
Posts(6)September 6, 2005, 3:24 amNeed for speed 3
Posts(3)September 6, 2005, 3:24 amQuery slow after VACUUM ANALYZE
Posts(2)September 6, 2005, 3:24 amPoor SQL performance
Posts(7)September 4, 2005, 1:25 pmPoor performance on HP Package Cluster
Posts(1)September 2, 2005, 8:25 pmRe: ORDER BY and LIMIT not propagated on inherited
Posts(2)September 2, 2005, 8:25 pmRe: ORDER BY and LIMIT not propagated on inherited
Posts(1)September 2, 2005, 11:24 amRe: ORDER BY and LIMIT not propagated on inherited
Posts(4)September 2, 2005, 11:24 amRe: ORDER BY and LIMIT not propagated on inherited
Posts(3)September 2, 2005, 7:25 amAvoid using swap in a cluster
Posts(1)September 2, 2005, 7:25 amRe: Update is more affected( taking more time) than Select
Posts(1)September 2, 2005, 7:25 amORDER BY and LIMIT not propagated on inherited tables / UNIONs
Posts(1)September 2, 2005, 3:28 amUpdate is more affected( taking more time) than Select ( if Auto vacuum is
Posts(1)September 2, 2005, 3:28 am(NONE)
Posts(10)September 1, 2005, 8:25 pmlots of updates on small table
Posts(2)September 1, 2005, 7:25 amBig question on insert performance/using COPY FROM


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

Copyright 2008 droptable.com