Home > Archive > PostgreSQL Performance > June 2005










Posts(4)June 30, 2005, 8:24 pmstart time very high
Posts(4)June 30, 2005, 9:24 amODBC driver over network very slow
Posts(2)June 30, 2005, 9:24 amVacuum becomes slow
Posts(2)June 30, 2005, 7:25 amslow simple update?
Posts(2)June 29, 2005, 11:24 amExclusive lock question
Posts(3)June 29, 2005, 7:24 amPostgresql7.4.5 running slow on plpgsql function
Posts(2)June 29, 2005, 7:24 amcould not receive data from client: Connection timed out Error
Posts(19)June 29, 2005, 3:24 amtricky query
Posts(5)June 29, 2005, 3:24 amoptimized counting of web statistics
Posts(4)June 28, 2005, 8:25 pmperl garbage collector
Posts(6)June 28, 2005, 1:24 pmToo slow querying a table of 15 million records
Posts(1)June 28, 2005, 1:24 pmRe: Poor index choice -- multiple indexes of the same
Posts(3)June 28, 2005, 1:24 pmread block size
Posts(8)June 28, 2005, 11:24 amInsert performance vs Table size
Posts(1)June 28, 2005, 11:24 amRéf. : tricky query
Posts(1)June 28, 2005, 9:24 am(NONE)
Posts(3)June 28, 2005, 7:24 amPoor index choice -- multiple indexes of the same columns
Posts(13)June 28, 2005, 3:24 amHow can I speed up this function?
Posts(2)June 28, 2005, 3:24 amLIKE search with ending % not optimized in v8
Posts(2)June 28, 2005, 3:24 amHow are text columns stored?
Posts(1)June 28, 2005, 3:24 amindex selection by query planner
Posts(1)June 28, 2005, 3:24 amindex selection by query planner
Posts(1)June 28, 2005, 3:24 amselect distinct on varchar -- wild performance differences!
Posts(1)June 28, 2005, 3:24 amparameterized LIKE does not use index
Posts(7)June 28, 2005, 3:24 amPerformance analysis of plpgsql code
Posts(1)June 28, 2005, 3:24 amRe: Poor index choice -- multiple indexes of the same
Posts(1)June 27, 2005, 8:24 pmRe: Poor index choice -- multiple indexes of the same
Posts(1)June 27, 2005, 8:24 pmFaster drives for WAL than for data?
Posts(2)June 27, 2005, 8:24 pmForcing use of a particular index
Posts(1)June 27, 2005, 1:24 pmRe: [HACKERS] How two perform TPC-H test on postgresql-8.0.2
Posts(7)June 27, 2005, 1:24 pmETL optimization
Posts(3)June 27, 2005, 9:24 amPERFORMANCE ISSUE ODBC x LIBPQ C++ Application
Posts(4)June 27, 2005, 7:24 amPerformance - moving from oracle to postgresql
Posts(1)June 25, 2005, 7:23 amRe: Speed with offset clause
Posts(7)June 25, 2005, 3:24 amConfigurator project launched
Posts(6)June 24, 2005, 8:24 pmparameterized LIKE does not use index
Posts(13)June 24, 2005, 8:24 pmPerformance Tuning Article
Posts(8)June 24, 2005, 8:24 pmNeeded: Simplified guide to optimal memory configuration
Posts(2)June 24, 2005, 8:24 pmmax_connections / shared_buffers / effective_cache_size questions
Posts(1)June 24, 2005, 8:24 pmRe: max_connections / shared_buffers /
Posts(1)June 24, 2005, 8:24 pmRe: max_connections / shared_buffers / effective_cache_size
Posts(1)June 24, 2005, 8:24 pmRe: Speed with offset clause
Posts(1)June 24, 2005, 8:24 pmRe: Speed with offset clause
Posts(3)June 24, 2005, 9:24 amPostgres 8 vs Postgres 7.4/cygwin
Posts(3)June 23, 2005, 1:23 pmselect distinct on varchar - wild performance differences!
Posts(17)June 23, 2005, 11:24 amQuerying 19million records very slowly
Posts(1)June 22, 2005, 11:23 amRe: Limit clause not using index
Posts(2)June 22, 2005, 7:24 amForums & tsearch2 - best practices reg. concurrency
Posts(3)June 22, 2005, 3:24 amPrepared statements vs. Stored Procedures
Posts(6)June 22, 2005, 3:24 amRe: Limit clause not using index
Posts(8)June 21, 2005, 8:24 pmautovacuum suggestions for 500,000,000+ row tables?
Posts(3)June 21, 2005, 8:24 pmTrying to figure out pgbench
Posts(9)June 21, 2005, 1:24 pmDo Views execute underlying query everytime ??
Posts(3)June 21, 2005, 1:24 pmRe: Another question on indexes (drop and recreate)
Posts(6)June 21, 2005, 11:23 amslow growing table
Posts(2)June 21, 2005, 11:23 amRe: Limit clause not using index
Posts(1)June 21, 2005, 9:24 amRe: Limit clause not using index
Posts(1)June 20, 2005, 1:23 pmRe: investigating slow queries through
Posts(1)June 20, 2005, 11:24 amRe: autovacuum suggestions for 500,000,000+ row
Posts(2)June 20, 2005, 3:23 amHow to determine whether to VACUUM or CLUSTER
Posts(1)June 19, 2005, 3:25 amRe: Fwd: Multiple disks: RAID 5 or PG Cluster
Posts(1)June 19, 2005, 3:25 amRe: Multiple disks: RAID 5 or PG Cluster
Posts(4)June 19, 2005, 3:25 amMost effective tuning choices for busy website?
Posts(1)June 18, 2005, 8:24 pmRe: Fwd: Multiple disks: RAID 5 or PG Cluster
Posts(1)June 18, 2005, 11:25 amRe: Multiple disks: RAID 5 or PG Cluster
Posts(2)June 18, 2005, 11:25 amRe: Multiple disks: RAID 5 or PG Cluster
Posts(1)June 17, 2005, 8:25 pmRe: Multiple disks: RAID 5 or PG Cluster
Posts(4)June 17, 2005, 11:25 amRe: Needed: Simplified guide to optimal memory
Posts(2)June 17, 2005, 7:26 amcould not send data to client:
Posts(6)June 17, 2005, 3:26 amHow does the transaction buffer work?
Posts(2)June 17, 2005, 3:26 amHow to determine whether to VACUUM or CLUSTER
Posts(31)June 15, 2005, 1:25 pmIndex ot being used
Posts(2)June 14, 2005, 8:26 pmregular expression search
Posts(4)June 14, 2005, 9:24 amSystem Requirement
Posts(2)June 13, 2005, 8:24 pmResource Requirements
Posts(1)June 13, 2005, 8:24 pmRe: Updates on large tables are extremely slow
Posts(1)June 13, 2005, 8:24 pmPseudo-Solved was: (Re: Index ot being used)
Posts(1)June 13, 2005, 1:24 pmRe: Updates on large tables are extremely slow
Posts(3)June 13, 2005, 1:24 pmHow to enhance the chance that data is in disk cache
Posts(1)June 13, 2005, 1:24 pmRe: Updates on large tables are extremely slow
Posts(1)June 13, 2005, 11:24 amRe: Fwd: Updates on large tables are extremely slow
Posts(6)June 13, 2005, 11:24 amPostgreSQL using the wrong Index
Posts(2)June 13, 2005, 9:24 amRe: Updates on large tables are extremely slow
Posts(13)June 13, 2005, 9:24 amHelp with rewriting query
Posts(3)June 13, 2005, 9:24 amRe: View not using index
Posts(1)June 13, 2005, 3:24 amRe: Updates on large tables are extremely slow
Posts(1)June 12, 2005, 1:23 pmRe: Updates on large tables are extremely slow
Posts(15)June 11, 2005, 1:23 pmfaster search
Posts(23)June 10, 2005, 11:24 amWhence the Opterons?
Posts(2)June 10, 2005, 7:24 amCleaning bloated pg_attribute
Posts(5)June 10, 2005, 7:24 amImporting from pg_dump slow, low Disk IO
Posts(4)June 10, 2005, 3:24 ampostgresql.conf runtime statistics default
Posts(11)June 9, 2005, 8:24 pmHelp specifying new web server/database machine
Posts(8)June 9, 2005, 8:24 pmtimestamp indexing
Posts(2)June 9, 2005, 1:23 pmrandom_page_cost = 1?
Posts(11)June 9, 2005, 11:24 amQuery plan changes after pg_dump / pg_restore
Posts(2)June 9, 2005, 11:24 amRe: Recommendations for configuring a 200 GB
Posts(1)June 9, 2005, 9:24 amRe: [Npgsql-general] index out of range
Posts(1)June 9, 2005, 7:24 ampg_autovacuum settings
Posts(2)June 9, 2005, 3:24 amRecommendations for configuring a 200 GB database
Posts(2)June 9, 2005, 3:24 amHow to find the size of a database - reg.
Posts(24)June 8, 2005, 8:24 pmPostgresql on an AMD64 machine
Posts(7)June 8, 2005, 8:24 pmfull outer performance problem
Posts(5)June 8, 2005, 1:24 pmPerformance problems, bad estimates and plan
Posts(6)June 8, 2005, 11:24 amSELECT DISTINCT Performance Issue
Posts(9)June 8, 2005, 9:24 amFilesystem
Posts(6)June 7, 2005, 11:24 amPostgresql and Software RAID/LVM
Posts(2)June 7, 2005, 7:24 amPerformance nightmare with dspam (urgent)
Posts(1)June 6, 2005, 1:24 pmRe: Performance nightmare with dspam (urgent) (resolved)
Posts(2)June 6, 2005, 11:24 amRe: Performance nightmare with dspam (urgent) (resolved)
Posts(4)June 6, 2005, 11:24 amRe: Performance nightmare with dspam (urgent) (resolved)
Posts(12)June 6, 2005, 11:24 amHow to avoid database bloat
Posts(4)June 4, 2005, 9:23 amForcing use of specific index
Posts(7)June 4, 2005, 7:23 amstrategies for optimizing read on rather large tables
Posts(11)June 4, 2005, 7:23 amQuery plan for very large number of joins
Posts(2)June 3, 2005, 8:24 pmInsert slow down on empty database
Posts(2)June 3, 2005, 9:24 amQuery limitations (size, number of UNIONs ...)
Posts(3)June 3, 2005, 7:24 amSHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning)
Posts(1)June 3, 2005, 7:24 amRe: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance
Posts(8)June 3, 2005, 3:24 amAdaptec/LSI/?? RAID
Posts(1)June 3, 2005, 3:24 amRe: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance
Posts(2)June 2, 2005, 8:25 pmRe: Adaptec/LSI/?? RAID (what about JBOD?)
Posts(1)June 2, 2005, 8:25 pmRe: Adaptec/LSI/?? RAID (what about JBOD?)
Posts(5)June 2, 2005, 11:24 amSURVEY: who is running postgresql on 8 or more CPUs?
Posts(4)June 2, 2005, 11:24 amSpecific query performance problem help requested - postgresql 7.4
Posts(10)June 2, 2005, 9:24 amMoving pg_xlog
Posts(13)June 2, 2005, 9:24 ampostgresql-8.0.1 performance tuning
Posts(2)June 2, 2005, 3:24 am'Fastest' PC's are slowest in the house
Posts(2)June 1, 2005, 9:25 amTIP 9: the planner will ignore... & datatypes
Posts(12)June 1, 2005, 7:24 amslow queries, possibly disk io
Posts(3)June 1, 2005, 7:24 amvery large table
Posts(12)June 1, 2005, 3:24 amIndex on a NULL-value


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

Copyright 2008 droptable.com