Home > Archive > PostgreSQL Performance > April 2005










Posts(2)April 29, 2005, 3:26 amindex on different types
Posts(2)April 29, 2005, 3:26 amRe: Distinct-Sampling (Gibbons paper) for Postgres
Posts(2)April 28, 2005, 1:26 pmRe: [HACKERS] Bad n_distinct estimation; hacks suggested?
Posts(3)April 28, 2005, 11:24 amSuggestions for a data-warehouse migration routine
Posts(10)April 28, 2005, 7:24 amWhy is this system swapping?
Posts(19)April 28, 2005, 3:25 amFinal decision
Posts(2)April 28, 2005, 3:25 amODBC driver overpopulation (was Re: Final decision)
Posts(17)April 27, 2005, 8:25 pmRe: Joel's Performance Issues WAS : Opteron vs Xeon
Posts(1)April 27, 2005, 9:24 amRe: What needs to be done for real Partitioning?
Posts(2)April 26, 2005, 8:24 pmRe: Table Partitioning: Will it be supported in Future?
Posts(1)April 26, 2005, 8:24 pmRe: [HACKERS] Bad n_distinct estimation; hacks suggested?
Posts(1)April 26, 2005, 8:24 pmRe: What needs to be done for real Partitioning?
Posts(5)April 26, 2005, 8:24 pmspeed up query with max() and odd estimates
Posts(2)April 26, 2005, 8:24 pmRe: [HACKERS] Bad n_distinct estimation; hacks suggested?
Posts(4)April 26, 2005, 1:24 pmRe: Table Partitioning: Will it be supported in Future?
Posts(10)April 26, 2005, 1:24 pmpgbench Comparison of 7.4.7 to 8.0.2
Posts(16)April 26, 2005, 11:25 amtwo queries and dual cpu (perplexed)
Posts(3)April 26, 2005, 3:25 amhalf the query time in an unnecessary(?) sort?
Posts(1)April 26, 2005, 3:25 amTable Partitioning: Will it be supported in Future? (splitting large
Posts(1)April 25, 2005, 8:25 pmRe: [HACKERS] Bad n_distinct estimation; hacks suggested?
Posts(2)April 25, 2005, 8:25 pmRe: Joel's Performance Issues WAS : Opteron vs Xeon
Posts(1)April 25, 2005, 9:28 amRe: Joel's Performance Issues WAS : Opteron vs Xeon
Posts(1)April 25, 2005, 9:28 amRe: [ODBC] Joel's Performance Issues WAS : Opteron vs Xeon
Posts(3)April 25, 2005, 3:24 amRe: [HACKERS] Bad n_distinct estimation; hacks suggested?
Posts(16)April 25, 2005, 3:24 amDisk filling, CPU filling, renegade inserts and deletes?
Posts(1)April 23, 2005, 8:24 pmflattening the file might work for me here is the analyze.
Posts(12)April 23, 2005, 1:24 pmRe: Joel's Performance Issues WAS : Opteron vs Xeon
Posts(9)April 23, 2005, 3:24 amBad n_distinct estimation; hacks suggested?
Posts(25)April 23, 2005, 3:24 amIndex bloat problem?
Posts(1)April 23, 2005, 3:24 amInteresting numbers on a CREATE INDEX
Posts(2)April 22, 2005, 8:24 pmUpdating table, precautions?
Posts(18)April 22, 2005, 7:24 amimmutable functions vs. join for lookups ?
Posts(13)April 22, 2005, 7:24 amWhen are index scans used over seq scans?
Posts(2)April 22, 2005, 3:24 amforeign key performance
Posts(4)April 21, 2005, 8:24 pmindex not used
Posts(3)April 21, 2005, 1:25 pmHow can an index be larger than a table
Posts(1)April 21, 2005, 11:24 amRe: Joel's Performance Issues WAS : Opteron vs Xeon
Posts(2)April 21, 2005, 11:24 amRe: Joel's Performance Issues WAS : Opteron vs Xeon
Posts(1)April 21, 2005, 9:24 amRe: Joel's Performance Issues WAS : Opteron vs Xeon
Posts(1)April 21, 2005, 3:24 amRe: Opteron vs Xeon
Posts(3)April 21, 2005, 3:24 amRe: How to improve db performance with $7K?
Posts(4)April 20, 2005, 8:24 pmpostgres slowdown question
Posts(6)April 20, 2005, 8:24 pmSlow copy with little CPU/disk usage
Posts(1)April 20, 2005, 8:24 pmRe: Joel's Performance Issues WAS : Opteron vs Xeon
Posts(2)April 20, 2005, 8:24 pmRe: Disk filling, CPU filling, renegade inserts and
Posts(1)April 20, 2005, 8:24 pmRe: How to improve db performance with $7K?
Posts(7)April 20, 2005, 8:24 pmRe: Opteron vs Xeon (Was: What to do with 6 disks?)
Posts(1)April 20, 2005, 8:24 pmRe: How to improve db performance with $7K?
Posts(2)April 20, 2005, 1:24 pmRe: Opteron vs Xeon (Was: What to do with 6 disks?)
Posts(1)April 20, 2005, 1:24 pmRe: How to improve db performance with $7K?
Posts(3)April 20, 2005, 1:24 pmRe: How to improve db performance with $7K?
Posts(1)April 20, 2005, 11:24 amRe: How to improve db performance with $7K?
Posts(4)April 20, 2005, 11:24 amRe: Opteron vs Xeon (Was: What to do with 6 disks?)
Posts(3)April 20, 2005, 7:23 amRe: How to improve db performance with $7K?
Posts(2)April 20, 2005, 3:24 amHow to tell what your postgresql server is doing
Posts(4)April 20, 2005, 3:24 amWhat to do with 6 disks?
Posts(3)April 19, 2005, 8:24 pmHow to improve postgres performace
Posts(4)April 19, 2005, 8:24 pmRe: How to improve db performance with $7K?
Posts(25)April 19, 2005, 8:24 pmRe: How to improve db performance with $7K?
Posts(6)April 19, 2005, 8:24 pmRe: How to improve db performance with $7K?
Posts(2)April 19, 2005, 8:24 pmRe: How to improve db performance with $7K?
Posts(1)April 19, 2005, 8:24 pmRe: [HACKERS] PLM pulling from CVS nightly for testing in STP
Posts(12)April 19, 2005, 1:24 pmQuestion on REINDEX
Posts(1)April 19, 2005, 11:24 amRe: How to improve db performance with $7K?
Posts(6)April 19, 2005, 11:23 amPostgresql works too slow
Posts(2)April 19, 2005, 3:24 amForeign key slows down copy/insert
Posts(2)April 19, 2005, 3:24 amrefcurosr vs. setof
Posts(7)April 19, 2005, 3:24 amRe: How to improve db performance with $7K?
Posts(18)April 19, 2005, 3:24 amRe: How to improve db performance with $7K?
Posts(3)April 19, 2005, 3:24 amRe: [Fwd: Re: Functionscan estimates]
Posts(1)April 19, 2005, 12:21 ampostgresql faster in Linux than FreeBSD?
Posts(2)April 18, 2005, 8:24 pmQuestion on vacuumdb
Posts(7)April 18, 2005, 1:24 pmCompressing WAL
Posts(1)April 18, 2005, 1:24 pmRES: RES: How to improve postgres performace
Posts(2)April 18, 2005, 1:24 pmRES: How to improve postgres performace
Posts(2)April 18, 2005, 9:24 amFW: speed of querry?
Posts(18)April 18, 2005, 9:24 amspeed of querry?
Posts(1)April 18, 2005, 9:24 amFW: speed of querry?
Posts(1)April 18, 2005, 9:24 amFW: speed of querry?
Posts(1)April 18, 2005, 3:24 amUNSUBSCRIBE
Posts(6)April 17, 2005, 8:24 pmplperl vs plpgsql
Posts(3)April 16, 2005, 7:23 amRe: Query Optimizer Failure / Possible Bug
Posts(3)April 15, 2005, 8:24 pmRe: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How
Posts(1)April 15, 2005, 8:24 pmRe: clear function cache (WAS: SQL function inlining)
Posts(1)April 15, 2005, 1:24 pmRe: How to improve db performance with $7K?
Posts(1)April 15, 2005, 1:23 pmRe: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How
Posts(3)April 15, 2005, 1:23 pmRe: How to improve db performance with $7K?
Posts(1)April 15, 2005, 11:24 amRe: Intel SRCS16 SATA raid? (somewhat OT)
Posts(1)April 15, 2005, 11:24 amSpend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How to Improve w/7K$?
Posts(21)April 15, 2005, 9:24 amForeign key slows down copy/insert
Posts(2)April 14, 2005, 8:24 pm8.0.1 much slower than 7.4.2?
Posts(1)April 14, 2005, 8:24 pmRe: How to improve db performance with $7K?
Posts(4)April 14, 2005, 8:24 pmRe: How to improve db performance with $7K?
Posts(1)April 14, 2005, 1:24 pmRe: How to improve db performance with $7K?
Posts(3)April 14, 2005, 1:24 pmrecovery after long delete
Posts(1)April 14, 2005, 11:27 amRe: How to improve db performance with $7K?
Posts(2)April 14, 2005, 9:24 amUse of data within indexes
Posts(4)April 14, 2005, 3:24 amRe: How to improve db performance with $7K?
Posts(1)April 13, 2005, 8:24 pmRe: [NOVICE] Many connections lingering
Posts(1)April 13, 2005, 8:24 pmRe: [NOVICE] Many connections lingering
Posts(1)April 13, 2005, 8:24 pmStrange serialization problem
Posts(1)April 13, 2005, 8:24 pmProblem with slow query (caused by improper nestloop?)
Posts(2)April 13, 2005, 1:24 pmRe: [NOVICE] Many connections lingering
Posts(1)April 13, 2005, 1:24 pmRe: [NOVICE] Many connections lingering
Posts(2)April 13, 2005, 11:24 amForeign keys and partial indexes
Posts(7)April 13, 2005, 3:24 amperformance hit for replication
Posts(7)April 12, 2005, 1:24 pm4 way JOIN using aliases
Posts(6)April 12, 2005, 11:25 amSlow update
Posts(6)April 12, 2005, 11:25 amprofiling postgresql queries?
Posts(4)April 12, 2005, 3:24 amRe: [sfpug] DATA directory on network attached storage
Posts(2)April 11, 2005, 8:25 pmIs there somthing I need to do on my production server?
Posts(4)April 11, 2005, 8:25 pmServer crashing
Posts(3)April 11, 2005, 9:23 amperformance - triggers, row existence etc.
Posts(2)April 11, 2005, 7:25 amNever ending delete story
Posts(3)April 11, 2005, 7:25 amIs Indexed View Supported in psql 7.1.3??
Posts(2)April 11, 2005, 7:25 amhelp on explain analyse
Posts(1)April 11, 2005, 7:25 amDATA directory on network attached storage
Posts(1)April 11, 2005, 7:25 amRe: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very ineffi
Posts(12)April 10, 2005, 7:23 amFunctionscan estimates
Posts(3)April 9, 2005, 8:26 pmPostgresql vs SQLserver for this application ?
Posts(12)April 9, 2005, 8:26 pmAny way to speed this up?
Posts(1)April 9, 2005, 8:26 pmRe: [sfpug] DATA directory on network attached storage
Posts(3)April 9, 2005, 10:09 amRe: Functionscan estimates
Posts(1)April 9, 2005, 10:09 amRe: Functionscan estimates
Posts(1)April 8, 2005, 7:02 amRe: multi-line copy (was: Re: COPY Hacks)
Posts(5)April 8, 2005, 7:02 amhelp on explain analyse in psql 7.1.3 (linux)
Posts(5)April 8, 2005, 7:02 amCOPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?)
Posts(1)April 7, 2005, 8:03 pmRe: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very ineffi
Posts(1)April 7, 2005, 8:03 pmRe: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very ineffi
Posts(1)April 7, 2005, 8:03 pmRe: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be v
Posts(2)April 7, 2005, 8:03 pmBuilding postmaster with Profiling Support WAS "Tweaking a C Function I wrote"
Posts(2)April 7, 2005, 7:03 amRe: How to improve db performance with $7K?
Posts(2)April 7, 2005, 7:03 amhelp on time calculation
Posts(9)April 7, 2005, 7:03 amFollow-Up: How to improve db performance with $7K?
Posts(1)April 7, 2005, 7:03 amRe: How to improve db performance with $7K?
Posts(3)April 7, 2005, 7:03 amTweaking a C Function I wrote
Posts(1)April 7, 2005, 7:03 amRe: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this
Posts(1)April 6, 2005, 8:03 pmRe: How to improve db performance with $7K?
Posts(1)April 6, 2005, 8:03 pmRe: [HACKERS] Recognizing range constraints (was Re: Plan
Posts(10)April 6, 2005, 8:03 pmPlan for relatively simple query seems to be very inefficient
Posts(1)April 6, 2005, 8:03 pmRe: Réf
Posts(1)April 6, 2005, 8:03 pmRe: Réf
Posts(1)April 6, 2005, 8:03 pmRe: Réf
Posts(2)April 6, 2005, 8:03 pmRe: RE : RE: Postgresql vs SQLserver for thisapplication ?
Posts(1)April 6, 2005, 8:03 pmRe: Réf
Posts(1)April 6, 2005, 8:03 pmRéf. : Re: RE : RE: Postgresql vs
Posts(1)April 6, 2005, 8:03 pmRe: Réf. : Re: RE : RE: Postgresql
Posts(4)April 6, 2005, 8:03 pmRE : RE: Postgresql vs SQLserver for this application ?
Posts(1)April 6, 2005, 8:03 pmRe: RE : RE: Postgresql vs SQLserver for this application
Posts(1)April 6, 2005, 8:03 pmRe: How to improve db performance with $7K?
Posts(1)April 6, 2005, 8:03 pmRe: RE : RE: Postgresql vs SQLserver for this
Posts(44)April 6, 2005, 7:02 amSustained inserts per sec ... ?
Posts(3)April 5, 2005, 7:02 amBulk COPY end of copy delimiter
Posts(1)April 4, 2005, 8:05 pmRe: How to improve db performance with $7K?
Posts(1)April 4, 2005, 8:05 pmRe: How to improve db performance with $7K?
Posts(1)April 4, 2005, 8:05 pmRe: [JDBC] 8.0.1 performance question.
Posts(1)April 4, 2005, 8:05 pmRe: [JDBC] 8.0.1 performance question.
Posts(2)April 4, 2005, 8:05 pm8.0.1 performance question.
Posts(1)April 4, 2005, 8:05 pmRe: How to improve db performance with $7K?
Posts(3)April 4, 2005, 7:02 amCorrecting Hash Join Estimates
Posts(1)April 3, 2005, 8:02 pmRe: coalesce alternative
Posts(2)April 3, 2005, 7:01 amRe: Delete query takes exorbitant amount of time
Posts(1)April 3, 2005, 7:01 amRe: Delete query takes exorbitant amount of time
Posts(1)April 3, 2005, 7:01 amRe: How to improve db performance with $7K?
Posts(1)April 3, 2005, 7:01 amRe: Delete query takes exorbitant amount of time
Posts(6)April 2, 2005, 8:02 pmdate - range
Posts(1)April 1, 2005, 8:03 pmTriggers with FOR EACH STATEMENT
Posts(4)April 1, 2005, 8:03 pmenable_XXX options
Posts(1)April 1, 2005, 8:03 pmTuning PostgreSQL
Posts(4)April 1, 2005, 7:02 amHow to speed up word count in tsearch2?


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

Copyright 2008 droptable.com