Home > Archive > PostgreSQL Performance > March 2006










Posts(2)March 31, 2006, 11:30 amun-'vacuum analyse'
Posts(16)March 31, 2006, 11:30 amsimple join uses indexes, very slow
Posts(8)March 31, 2006, 11:30 amIndexes with descending date columns
Posts(11)March 31, 2006, 3:31 amRe: Decide between Postgresql and Mysql (help of
Posts(5)March 30, 2006, 8:28 pmCREATE INDEX rather sluggish
Posts(6)March 30, 2006, 1:31 pmRe: Decide between Postgresql and Mysql (help of
Posts(16)March 30, 2006, 11:30 amIndex scan startup time
Posts(1)March 30, 2006, 9:34 amAutomatic tuning of postgresql.conf parameters?
Posts(1)March 30, 2006, 3:27 am$30,000 INCOME EVERY DAY GUARANTEED FOR ONE YEAR
Posts(7)March 30, 2006, 3:27 amDatabase possible corruption , unsolvable mystery
Posts(13)March 29, 2006, 8:28 pmSlow performance on Windows .NET and OleDb
Posts(4)March 29, 2006, 11:31 amRe: Decide between Postgresql and Mysql (help of
Posts(3)March 29, 2006, 11:31 amDecide between Postgresql and Mysql (help of comunity)
Posts(1)March 29, 2006, 9:32 amRe: Decide between Postgresql and Mysql (help of
Posts(3)March 29, 2006, 3:31 amMVCC intro and benefits docs?
Posts(6)March 28, 2006, 1:32 pmMassive Inserts Strategies
Posts(10)March 28, 2006, 11:32 amRe: count(*) performance
Posts(7)March 27, 2006, 8:28 pmcount(*) performance
Posts(2)March 27, 2006, 9:40 amQuery parallelism
Posts(1)March 27, 2006, 7:41 amRe: [GENERAL] experiences needed - how does Itanium2/1.5GHz(4MB) compare to AMD and Intel CPUs as f
Posts(7)March 27, 2006, 3:29 amArray performance
Posts(2)March 25, 2006, 7:45 amQuery plan from hell
Posts(3)March 24, 2006, 8:27 pmlimitation using LIKE on ANY(array)
Posts(8)March 24, 2006, 8:27 pmRe: Scaling up PostgreSQL in Multiple CPU / Dual Core
Posts(5)March 24, 2006, 8:27 pmPerformance problems with multiple layers of functions
Posts(1)March 24, 2006, 8:27 pmRe: Scaling up PostgreSQL in Multiple CPU / Dual Core
Posts(7)March 24, 2006, 11:42 amPostmaster using only 4-5% CPU
Posts(4)March 24, 2006, 9:32 amProblem with query, server totally unresponsive
Posts(16)March 24, 2006, 9:32 amWAL logging of SELECT ... INTO command
Posts(2)March 23, 2006, 1:33 pmRe: Scaling up PostgreSQL in Multiple CPU / Dual Core
Posts(1)March 23, 2006, 1:33 pmRe: Scaling up PostgreSQL in Multiple CPU / Dual Core
Posts(1)March 23, 2006, 1:33 pmProblem with query, forget previous message
Posts(2)March 23, 2006, 7:46 amScaling up PostgreSQL in Multiple CPU / Dual Core Powered Servers
Posts(2)March 22, 2006, 11:32 amIntel C/C++ Compiler Tests
Posts(8)March 22, 2006, 11:32 amRe: planner with index scan cost way off actual cost,
Posts(3)March 22, 2006, 9:31 amRe: Migration study, step 1: bulk write performanceoptimization
Posts(1)March 22, 2006, 7:33 amRe: Migration study, step 1: bulk write performanceoptimization
Posts(5)March 22, 2006, 7:33 amPoor performance o
Posts(7)March 22, 2006, 7:33 amSequence Scan vs. Index scan
Posts(1)March 22, 2006, 7:33 amRe: Migration study, step 1: bulk write
Posts(7)March 22, 2006, 3:29 amQuery Feromance
Posts(8)March 22, 2006, 3:29 amRe: Best OS & Configuration for Dual Xeon w/4GB &
Posts(1)March 22, 2006, 3:29 ammotherboard recommendations
Posts(2)March 21, 2006, 8:33 pmRe: Migration study, step 1: bulk write performance
Posts(1)March 21, 2006, 8:33 pmRe: Migration study, step 1: bulk write performance
Posts(1)March 21, 2006, 8:33 pmRe: planner with index scan cost way off actual cost,
Posts(2)March 21, 2006, 8:33 pmRe: Migration study, step 1: bulk write performance
Posts(7)March 21, 2006, 8:33 pmRe: Best OS & Configuration for Dual Xeon w/4GB & Adaptec
Posts(1)March 21, 2006, 8:33 pmRe: Migration study, step 1: bulk write performance
Posts(1)March 21, 2006, 8:33 pmRe: qsort again (was Re: Strange Create Index behaviour)
Posts(10)March 21, 2006, 1:32 pmplanner with index scan cost way off actual cost, advices to tweak cost constants?
Posts(7)March 21, 2006, 1:32 pmupdate == delete + insert?
Posts(17)March 21, 2006, 11:33 amPostgreSQL and Xeon MP
Posts(1)March 21, 2006, 11:33 amRe: Best OS & Configuration for Dual Xeon w/4GB & Adaptec
Posts(3)March 21, 2006, 11:33 amPerfomance test figures
Posts(1)March 21, 2006, 7:28 amRe: Migration study, step 1: bulk write performance
Posts(1)March 21, 2006, 7:28 amRe: Best OS & Configuration for Dual Xeon w/4GB & Adaptec
Posts(3)March 21, 2006, 7:28 amRe: Migration study, step 1: bulk write performance
Posts(2)March 21, 2006, 7:28 amRe: Best OS & Configuration for Dual Xeon w/4GB & Adaptec
Posts(6)March 21, 2006, 7:28 amRe: Migration study, step 1: bulk write performance
Posts(1)March 21, 2006, 7:28 amRe: Migration study, step 1: bulk write performance
Posts(2)March 21, 2006, 7:28 amAuto performance tuning?
Posts(3)March 21, 2006, 7:28 amdata doesnt get saved in the database / idle in transaction
Posts(4)March 21, 2006, 7:28 amRe: Best OS & Configuration for Dual Xeon w/4GB &
Posts(9)March 21, 2006, 7:28 amBest OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S
Posts(2)March 21, 2006, 7:28 amRe: Best OS & Configuration for Dual Xeon w/4GB &
Posts(2)March 21, 2006, 7:28 ampartitioning
Posts(2)March 21, 2006, 7:28 ampartial indexes and inference
Posts(1)March 21, 2006, 3:34 amRe: Best OS & Configuration for Dual Xeon w/4GB &
Posts(5)March 21, 2006, 3:34 amMigration study, step 1: bulk write performance optimization
Posts(21)March 21, 2006, 3:34 am1 TB of memory
Posts(2)March 21, 2006, 3:34 amRe: Best OS & Configuration for Dual Xeon w/4GB &
Posts(1)March 21, 2006, 3:34 amRe: Best OS & Configuration for Dual Xeon w/4GB & Adaptec
Posts(1)March 21, 2006, 3:34 amRe: Best OS & Configuration for Dual Xeon w/4GB & Adaptec
Posts(1)March 21, 2006, 3:34 amRe: Best OS & Configuration for Dual Xeon w/4GB &
Posts(1)March 21, 2006, 3:34 amRe: Best OS & Configuration for Dual Xeon w/4GB &
Posts(1)March 21, 2006, 3:34 amRe: Best OS & Configuration for Dual Xeon w/4GB &
Posts(4)March 21, 2006, 3:34 amdatabase model tshirt sizes
Posts(1)March 19, 2006, 11:11 amRe: Best OS & Configuration for Dual Xeon w/4GB &
Posts(6)March 19, 2006, 11:11 amn00b autovacuum question
Posts(15)March 19, 2006, 11:10 amHelp optimizing a slow index scan
Posts(3)March 19, 2006, 11:10 amfirebird X postgresql 8.1.2 windows, performance comparison
Posts(1)March 17, 2006, 8:33 pmRe: Best OS & Configuration for Dual Xeon w/4GB &
Posts(1)March 17, 2006, 8:33 pmRe: Best OS & Configuration for Dual Xeon w/4GB &
Posts(14)March 17, 2006, 1:24 pmBackground writer configuration
Posts(1)March 17, 2006, 3:27 am$25,000.00 WEEKLY INCOME.MAGAZINE FRANCHISE.WORK AT HOME
Posts(5)March 16, 2006, 8:25 pmRe: BETWEEN optimizer problems with single-value
Posts(1)March 16, 2006, 8:25 pmRe: BETWEEN optimizer problems with single-value
Posts(1)March 16, 2006, 8:25 pmRe: BETWEEN optimizer problems with single-value
Posts(1)March 16, 2006, 8:25 pmRe: BETWEEN optimizer problems with single-value
Posts(1)March 16, 2006, 7:31 amRe: BETWEEN optimizer problems with single-value
Posts(4)March 15, 2006, 8:24 pmSlow SELECTS after large update cycle
Posts(1)March 15, 2006, 8:24 pmRe: BETWEEN optimizer problems with single-value
Posts(1)March 15, 2006, 8:24 pmRe: [HACKERS] BETWEEN optimizer problems with single-value
Posts(1)March 15, 2006, 8:24 pmRe: BETWEEN optimizer problems with single-value range
Posts(1)March 15, 2006, 8:24 pmRe: [HACKERS] BETWEEN optimizer problems with single-value range
Posts(3)March 15, 2006, 8:24 pmRe: BETWEEN optimizer problems with single-value
Posts(3)March 15, 2006, 1:25 pmVACUUM FULL hangs
Posts(1)March 15, 2006, 1:25 pmRe: BETWEEN optimizer problems with single-value range
Posts(1)March 15, 2006, 1:22 pm!! DOWNLOAD THE MOST POPULAR 2006's CRACKED SOFTWARE(CAD/CAE/CAM/EDA/PCB/GIS/FEA/CNC/
Posts(14)March 15, 2006, 7:31 amx206-x225
Posts(3)March 14, 2006, 8:25 pmRe: Vacuum template databases, Urgent: Production probl
Posts(2)March 14, 2006, 8:25 pmRe: Vacuum template databases, Urgent: Production probl
Posts(3)March 14, 2006, 8:25 pmVacuum template databases, Urgent: Production problem
Posts(3)March 14, 2006, 8:25 pmfirebird X postgresql 8.1.2 windows, performance comparison
Posts(2)March 14, 2006, 8:25 pmfirebird X postgresql 8.1.2 windows, performance comparison
Posts(11)March 14, 2006, 8:25 pmProcess Time X200
Posts(5)March 14, 2006, 9:24 amPG Statistics
Posts(12)March 14, 2006, 3:24 amimport performance
Posts(1)March 13, 2006, 8:24 pmRe: firebird X postgresql 8.1.2 windows, performance
Posts(6)March 13, 2006, 1:24 pmNo vacuum for insert-only database?
Posts(2)March 13, 2006, 1:24 pmfirebird X postgresql 8.1.2 windows, performance comparison
Posts(1)March 13, 2006, 7:25 amunsubscribe
Posts(8)March 13, 2006, 3:23 amQuery time
Posts(3)March 12, 2006, 8:24 pmhelp needed asap....
Posts(2)March 11, 2006, 8:23 pmRe: Postgres and Ingres R3 / SAN
Posts(4)March 10, 2006, 8:24 pmTrouble managing planner for timestamptz columns
Posts(3)March 10, 2006, 8:24 pmRe: Hanging queries on dual CPU windows
Posts(2)March 10, 2006, 1:24 pmRe: one-field index vs. multi-field index planner
Posts(2)March 10, 2006, 11:24 amone-field index vs. multi-field index planner estimates
Posts(2)March 10, 2006, 11:24 amRe: Hanging queries on dual CPU windows
Posts(8)March 10, 2006, 9:25 ampg_reset_stats + cache I/O %
Posts(2)March 10, 2006, 9:25 amUsing materialized views for commonly-queried subsets
Posts(4)March 10, 2006, 9:25 amRe: Hanging queries on dual CPU windows
Posts(1)March 10, 2006, 9:25 amRe: Hanging queries on dual CPU windows
Posts(1)March 10, 2006, 7:25 amFW: x206-x226
Posts(1)March 10, 2006, 3:24 amhow to speedup huge insert from an ODBC app
Posts(1)March 10, 2006, 3:24 amBECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K.
Posts(6)March 9, 2006, 8:24 pmfirebird X postgresql 8.1.2 windows, performance comparison
Posts(1)March 9, 2006, 8:24 pmRe: Hanging queries on dual CPU windows
Posts(2)March 9, 2006, 8:24 pmpgCluster and postgres 8.1
Posts(4)March 9, 2006, 8:24 pmRe: Hanging queries on dual CPU windows
Posts(1)March 9, 2006, 8:24 pmBECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K.
Posts(1)March 8, 2006, 1:24 pmRe: Is good idea an array of 365 elements in a cell of a table, in order to perform searchs?
Posts(8)March 8, 2006, 1:24 pmBad row estimates
Posts(1)March 8, 2006, 9:25 amIs good idea an array of 365 elements in a cell of a table, in order
Posts(9)March 7, 2006, 8:24 pmPostgres on VPS - how much is enough?
Posts(12)March 7, 2006, 8:24 pmCan anyone explain this pgbench results?
Posts(3)March 7, 2006, 8:24 pmRe: firebird X postgresql 8.1.2 windows, performance
Posts(1)March 7, 2006, 1:24 pmRe: Postgres and Ingres R3 / SAN
Posts(1)March 7, 2006, 1:24 pmRe: Postgres and Ingres R3 / SAN
Posts(1)March 7, 2006, 1:24 pmRe: Postgres and Ingres R3 / SAN
Posts(6)March 7, 2006, 1:24 pmt1000/t2000 sun-servers
Posts(4)March 7, 2006, 1:24 pmPlanner enhancement suggestion.
Posts(2)March 7, 2006, 11:24 amRe: firebird X postgresql 8.1.2 windows, performance
Posts(4)March 7, 2006, 11:24 amRe: Help understanding indexes, explain, and optimizing
Posts(1)March 7, 2006, 11:24 amRe: firebird X postgresql 8.1.2 windows, performance comparison
Posts(3)March 7, 2006, 3:24 amSequencial scan instead of using index
Posts(1)March 7, 2006, 3:24 amWe Pay 50%--100% Returns Monthly For 1 yearr on investment. You need to know this!
Posts(1)March 6, 2006, 7:18 pmHelp understanding indexes, explain, and optimizing a query
Posts(1)March 6, 2006, 7:18 pmHanging queries and I/O exceptions
Posts(1)March 6, 2006, 7:24 amBeautiful Note girl team brief introduction
Posts(1)March 5, 2006, 8:41 pmProblems In Creating a Table
Posts(1)March 5, 2006, 8:41 pmProblems In Creating a Table
Posts(4)March 5, 2006, 8:41 pmHow to query and index for customer with lastname and city
Posts(1)March 5, 2006, 8:41 pmRe: How to query and index for customer with lastname
Posts(1)March 5, 2006, 8:41 pmBeautiful Note girl team
Posts(4)March 5, 2006, 8:41 pmLike 'name%' is not using index
Posts(1)March 5, 2006, 8:41 pmBeautiful Note girl team
Posts(1)March 5, 2006, 8:41 pmViews vs. Functions
Posts(6)March 5, 2006, 8:41 pmBad plan on a view
Posts(2)March 5, 2006, 8:41 pmRe: triggers, performance Was: Re: [GENERAL] rotate records
Posts(3)March 5, 2006, 8:41 pmLooking for a tool to "*" pg tables as ERDs
Posts(1)March 5, 2006, 8:41 pmRe: [HACKERS] temporary indexes
Posts(1)March 5, 2006, 8:41 pmHow to get the matching columns from a table for each row in another table?
Posts(6)March 5, 2006, 8:41 pmwal sync method
Posts(3)March 5, 2006, 8:41 pmnested query on last n rows of huge table
Posts(4)March 5, 2006, 8:41 pmLarge Table With Only a Few Rows
Posts(1)March 5, 2006, 8:41 pmEARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US


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

Copyright 2008 droptable.com