Home > Archive > PostgreSQL Performance > January 2006










Posts(3)January 31, 2006, 1:24 pmDelete me
Posts(5)January 30, 2006, 8:25 pmQuery planner issue
Posts(2)January 30, 2006, 3:24 amDesperate: View not using indexes (very slow)
Posts(1)January 27, 2006, 3:24 amRe: [GENERAL] Creation of tsearch2 index is very
Posts(1)January 27, 2006, 3:24 amRe: [GENERAL] Creation of tsearch2 index is very
Posts(1)January 27, 2006, 3:24 amRe: [GENERAL] Creation of tsearch2 index is very
Posts(1)January 26, 2006, 8:23 pmRe: [GENERAL] Creation of tsearch2 index is very
Posts(1)January 26, 2006, 8:23 pmRe: [GENERAL] Creation of tsearch2 index is very
Posts(1)January 26, 2006, 8:23 pmRe: [GENERAL] Creation of tsearch2 index is very
Posts(7)January 26, 2006, 5:00 pmIncorrect Total runtime Reported by Explain Analyze!?
Posts(6)January 26, 2006, 5:00 pmQuery optimization with X Y JOIN
Posts(2)January 26, 2006, 5:00 pmPostgreSQL Solaris packages now in beta
Posts(2)January 26, 2006, 5:00 pmPhysical column size
Posts(5)January 26, 2006, 5:00 pmDB responce during DB dump
Posts(5)January 25, 2006, 3:27 amInconsistant query plan
Posts(7)January 24, 2006, 8:24 pmInvestigating IO Saturation
Posts(1)January 23, 2006, 8:24 pmunsubscribe
Posts(11)January 23, 2006, 1:24 pmRe: [PERFORMANCE] Stored Procedures
Posts(2)January 23, 2006, 1:24 pmSlow queries consisting inner selects and order bys & hack to speed up
Posts(29)January 23, 2006, 7:24 amSuspending SELECTs
Posts(1)January 23, 2006, 7:24 amENC: RES: pg_dump slow - Solution
Posts(3)January 22, 2006, 8:24 pmtsearch2 headline and postgresql.conf
Posts(2)January 21, 2006, 8:24 pmlibpq vs. unixODBC performance
Posts(1)January 21, 2006, 8:24 pmRe: [GENERAL] Creation of tsearch2 index is very
Posts(1)January 21, 2006, 8:24 pmRe: [GENERAL] Creation of tsearch2 index is very
Posts(26)January 21, 2006, 8:24 pmRe: [GENERAL] Creation of tsearch2 index is very slow
Posts(1)January 21, 2006, 1:23 pmRe: [GENERAL] Creation of tsearch2 index is very
Posts(1)January 21, 2006, 11:23 amRe: [GENERAL] Creation of tsearch2 index is very
Posts(1)January 21, 2006, 11:23 amRe: [GENERAL] Creation of tsearch2 index is very
Posts(1)January 21, 2006, 9:23 amRe: [GENERAL] Creation of tsearch2 index is very
Posts(1)January 21, 2006, 9:23 amRe: SELECT MIN, MAX took longer time than SELECT
Posts(1)January 21, 2006, 9:23 amRe: [GENERAL] Creation of tsearch2 index is very slow
Posts(1)January 21, 2006, 9:23 amRe: SELECT MIN, MAX took longer time than SELECT
Posts(1)January 21, 2006, 7:23 amRe: [GENERAL] Creation of tsearch2 index is very
Posts(1)January 20, 2006, 8:24 pmRe: [GENERAL] Creation of tsearch2 index is very slow
Posts(1)January 20, 2006, 8:24 pmRe: [GENERAL] Creation of tsearch2 index is very slow
Posts(2)January 20, 2006, 8:24 pmSudden slowdown of Pg server
Posts(2)January 20, 2006, 1:24 pmquery stopped working after tables > 50000 records
Posts(2)January 20, 2006, 1:24 pmStored Procedures
Posts(13)January 20, 2006, 1:24 pmRe: Autovacuum / full vacuum (off-topic?)
Posts(3)January 20, 2006, 1:24 pmSELECT MIN, MAX took longer time than SELECT COUNT, MIN, MAX
Posts(14)January 20, 2006, 11:24 amExtremely irregular query performance
Posts(3)January 20, 2006, 9:24 amRetaining execution plans between connections?
Posts(6)January 19, 2006, 7:24 amUse of Stored Procedures and
Posts(10)January 18, 2006, 8:24 pm3WARE Card performance boost?
Posts(30)January 18, 2006, 8:24 pmAutovacuum / full vacuum
Posts(2)January 18, 2006, 8:24 pmSimple Question of Performance ILIKE or Lower
Posts(12)January 18, 2006, 8:24 pmMultiple Order By Criteria
Posts(21)January 18, 2006, 1:24 pmSAN/NAS options
Posts(3)January 18, 2006, 9:24 amwildcard search performance with "like"
Posts(2)January 18, 2006, 3:24 amGetting pg to use index on an inherited table (8.1.1)
Posts(2)January 17, 2006, 8:24 pmsum of left join greater than its parts
Posts(3)January 17, 2006, 8:24 pmEnsuring data integrity with fsync=off
Posts(6)January 17, 2006, 8:24 pmbig databases & hospitals
Posts(1)January 17, 2006, 11:24 amPerformance issue when retrieving n last items
Posts(3)January 17, 2006, 11:24 am>= forces row compare and not index elements compare when possible
Posts(1)January 17, 2006, 11:24 amRe: new to postgres (and db management) and performance
Posts(8)January 17, 2006, 11:24 amRe: new to postgres (and db management) and performance already a problem :-(
Posts(1)January 17, 2006, 11:24 amRe: new to postgres (and db management) and performance
Posts(2)January 16, 2006, 8:24 pmUse of * affect the performance
Posts(1)January 16, 2006, 8:24 pmRe: new to postgres (and db management) and performance already a problem :-(
Posts(1)January 16, 2006, 8:24 pmnew to postgres (and db management) and performance already a problem
Posts(4)January 16, 2006, 11:29 amMaterialized Views
Posts(2)January 14, 2006, 1:23 pmHanging Query
Posts(1)January 14, 2006, 3:23 amPostgres8.0 Planner chooses WRONG plan.
Posts(1)January 14, 2006, 3:23 amExtremely irregular query performance
Posts(5)January 13, 2006, 8:24 pmStable function being evaluated more than once in a single query
Posts(10)January 13, 2006, 8:24 pmThrowing unnecessary joins away
Posts(4)January 13, 2006, 8:24 pminsert without oids
Posts(6)January 13, 2006, 8:24 pmSlow query with joins
Posts(6)January 13, 2006, 1:24 pmPlease Help: PostgreSQL performance Optimization
Posts(1)January 12, 2006, 9:24 amquery slower on 8.1 than 7.3
Posts(9)January 12, 2006, 3:25 amindexes on primary and foreign keys
Posts(11)January 12, 2006, 3:25 amIndex isn't used during a join.
Posts(26)January 11, 2006, 8:24 pmNOT LIKE much faster than LIKE?
Posts(2)January 11, 2006, 8:24 pmShowing Column Statistics Number
Posts(4)January 11, 2006, 1:24 pmPostgres8.0 planner chooses WRONG plan
Posts(10)January 11, 2006, 1:24 pmImproving Inner Join Performance
Posts(3)January 11, 2006, 7:24 amRe: 500x speed-down: Wrong statistics!
Posts(2)January 11, 2006, 3:24 amLeft Join Performance vs Inner Join Performance
Posts(13)January 11, 2006, 3:24 amhelp tuning queries on large database
Posts(2)January 11, 2006, 3:24 amHow to handle a large DB and simultaneous accesses?
Posts(3)January 9, 2006, 8:26 pm[PERFORMANCE] Beetwen text and varchar field
Posts(1)January 9, 2006, 8:26 pmRe: [ADMIN] Memory Usage Question
Posts(1)January 9, 2006, 1:24 pmMemory Usage Question
Posts(7)January 9, 2006, 1:24 pm500x speed-down: Wrong query plan?
Posts(1)January 7, 2006, 1:23 pmrevised comp.databases.postgresql.performance charter
Posts(1)January 7, 2006, 1:23 pmRe: improving write performance for logging
Posts(3)January 6, 2006, 8:24 pmRe: Slow query. Any way to speed up?
Posts(4)January 6, 2006, 8:24 pmRe: improving write performance for logging
Posts(1)January 6, 2006, 1:24 pmRe: improving write performance for logging
Posts(1)January 6, 2006, 9:25 amRe: improving write performance for logging
Posts(2)January 6, 2006, 9:25 ameffizient query with jdbc
Posts(2)January 6, 2006, 3:24 amRe: Help in avoiding a query 'Warm-Up' period/shared buffer
Posts(4)January 6, 2006, 3:24 amHelp in avoiding a query 'Warm-Up' period/shared buffer cache
Posts(1)January 5, 2006, 8:25 pmSlow query. Any way to speed up?
Posts(54)January 5, 2006, 11:24 amWhat's the best hardver for PostgreSQL 8.1?
Posts(6)January 5, 2006, 7:24 amInvulnerable VACUUM process thrashing everything
Posts(14)January 4, 2006, 8:25 pmimproving write performance for logging application
Posts(1)January 4, 2006, 9:24 amRe: improving write performance for logging
Posts(2)January 3, 2006, 11:23 amMaterialize Subplan and push into inner index conditions
Posts(1)January 1, 2006, 1:23 pmCHRIST: THE ARRIVAL
Posts(1)January 1, 2006, 1:23 pmCHRIST: THE ARRIVAL
Posts(1)January 1, 2006, 2:46 amCracked software fastest download!


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

Copyright 2008 droptable.com