Home > Archive > PostgreSQL Performance > December 2005










Posts(1)December 30, 2005, 3:24 amunsubscribe
Posts(6)December 30, 2005, 3:24 amCPU and RAM
Posts(1)December 29, 2005, 8:24 pmProcess executing COPY opens and reads every table on the system
Posts(7)December 29, 2005, 11:23 amHow import big amounts of data?
Posts(4)December 27, 2005, 1:23 pmPerformance problems with 8.1.1 compared to 7.4.7
Posts(3)December 27, 2005, 9:23 amBitmap indexes etc.
Posts(4)December 26, 2005, 8:24 pmPerformance hit on large row counts
Posts(1)December 26, 2005, 7:23 amFwd: vacuuming template0 gave ERROR
Posts(7)December 23, 2005, 8:24 pmOrder by behaviour
Posts(6)December 23, 2005, 11:24 amRe: MySQL is faster than PgSQL but a large margin in
Posts(2)December 23, 2005, 11:24 amDELETE, INSERT vs SELECT, UPDATE || INSERT
Posts(3)December 22, 2005, 11:24 ameffizient query with jdbc
Posts(5)December 22, 2005, 11:24 amORDER BY costs
Posts(11)December 22, 2005, 9:23 amSpeed of different procedural language
Posts(4)December 22, 2005, 7:24 amWrong index used when ORDER BY LIMIT 1
Posts(1)December 22, 2005, 3:25 amRe: MySQL is faster than PgSQL but a large margin in
Posts(1)December 22, 2005, 3:25 amRe: MySQL is faster than PgSQL but a large margin in my
Posts(2)December 22, 2005, 3:25 amRe: MySQL is faster than PgSQL but a large margin in my program... any ideas why?
Posts(1)December 21, 2005, 8:25 pmMySQL is faster than PgSQL but a large margin in my program... any
Posts(5)December 21, 2005, 1:24 pmWindows performance again
Posts(3)December 21, 2005, 7:24 am2 phase commit: performance implications?
Posts(2)December 21, 2005, 7:24 amRe: [GENERAL] need help
Posts(4)December 21, 2005, 7:24 amSAN/NAS options
Posts(19)December 21, 2005, 3:24 amSimple Join
Posts(1)December 21, 2005, 3:24 amRe: [postgis-users] Is my query planner failing me,or vice versa?
Posts(1)December 21, 2005, 3:24 ameffizient query with jdbc
Posts(1)December 21, 2005, 3:24 ameffizient query with jdbc
Posts(3)December 20, 2005, 8:25 pmRe: Any way to optimize GROUP BY queries?
Posts(7)December 20, 2005, 8:25 pmfilesystem performance with lots of files
Posts(4)December 20, 2005, 8:25 pmseparate drives for WAL or pgdata files
Posts(21)December 20, 2005, 8:25 pmPostgreSQL and Ultrasparc T1
Posts(27)December 20, 2005, 8:25 pmHigh context switches occurring
Posts(41)December 20, 2005, 1:24 pmOverriding the optimizer
Posts(7)December 20, 2005, 1:24 pmmake bulk deletes faster?
Posts(13)December 20, 2005, 11:24 amRead only transactions - Commit or Rollback
Posts(1)December 20, 2005, 7:23 amunsubscribe
Posts(2)December 20, 2005, 3:24 amIs the optimizer choice right?
Posts(21)December 18, 2005, 8:24 pmRe: Should Oracle outperform PostgreSQL on a complex
Posts(1)December 17, 2005, 8:24 pmRe: PostgreSQL performance question. [OT]
Posts(1)December 17, 2005, 8:24 pmRe: PostgreSQL performance question.
Posts(15)December 17, 2005, 3:24 amHow much expensive are row level statistics?
Posts(2)December 16, 2005, 8:24 pmLots of postmaster processes (fwd)
Posts(2)December 16, 2005, 8:24 pm8.1 - pg_autovacuum question
Posts(2)December 16, 2005, 9:23 amALTER TABLE SET TABLESPACE and pg_toast
Posts(4)December 16, 2005, 9:23 amCrashing DB or Server?
Posts(3)December 15, 2005, 7:24 amRe: [postgis-users] Is my query planner failing me, or vice versa?
Posts(1)December 15, 2005, 7:24 amRe: [postgis-users] Is my query planner failing me, or vice versa?
Posts(1)December 15, 2005, 3:24 amRe: PostgreSQL performance question.
Posts(1)December 14, 2005, 8:26 pmRe: PostgreSQL performance question.
Posts(4)December 14, 2005, 8:25 pmAuto-tuning a VIEW?
Posts(2)December 14, 2005, 11:24 amConvert IN sublink to join
Posts(1)December 13, 2005, 8:25 pmRe: Should Oracle outperform PostgreSQL on a complex
Posts(5)December 13, 2005, 8:25 pmTable Partitions / Partial Indexes
Posts(5)December 13, 2005, 8:25 pmquery from partitions
Posts(1)December 13, 2005, 8:25 pmRe: Should Oracle outperform PostgreSQL on a complex
Posts(3)December 13, 2005, 11:24 amSmall table or partial index?
Posts(2)December 13, 2005, 7:24 amRe: partitioning
Posts(1)December 13, 2005, 7:24 amRe: partitioning
Posts(16)December 12, 2005, 8:25 pmopinion on disk speed
Posts(5)December 12, 2005, 8:25 pmJoining 2 tables with 300 million rows
Posts(1)December 12, 2005, 1:24 pmRe: Should Oracle outperform PostgreSQL on a complex
Posts(3)December 12, 2005, 11:24 amRe: Very slow queries - please help
Posts(2)December 12, 2005, 7:24 am7.4.7 vs. 8.1
Posts(2)December 12, 2005, 3:24 amIs RAID10 the best choice?
Posts(1)December 11, 2005, 8:24 pmRe: Should Oracle outperform PostgreSQL on a complex
Posts(2)December 11, 2005, 8:24 pmShould Oracle outperform PostgreSQL on a complex multidimensional query?
Posts(5)December 11, 2005, 8:24 pmJoin the same row
Posts(4)December 11, 2005, 1:23 pmQuery not using index
Posts(2)December 11, 2005, 3:23 amBitmasks
Posts(2)December 10, 2005, 11:24 amClustered tables and seqscan disabled
Posts(13)December 10, 2005, 11:24 amQueries taking ages in PG 8.1, have been much faster in PG<=8.0
Posts(4)December 10, 2005, 11:23 amExecuting a shell command from a PG function
Posts(1)December 9, 2005, 3:50 amFTP DOWNLOAD! Best cracked software supplied!
Posts(3)December 8, 2005, 8:25 pmDisk tests for a new database server
Posts(1)December 8, 2005, 11:24 amslow COMMITs
Posts(9)December 8, 2005, 9:24 amPerformance degradation after successive UPDATE's
Posts(3)December 8, 2005, 9:24 amINSERTs becoming slower and slower
Posts(3)December 8, 2005, 9:24 amview of view
Posts(8)December 8, 2005, 7:25 amLVM and Postgres
Posts(3)December 7, 2005, 1:25 pmFirst query is slow, subsequent queries fast
Posts(8)December 7, 2005, 11:24 ampostgresql performance tuning
Posts(1)December 7, 2005, 10:42 am!!Famous Software ftp download 2006!!
Posts(1)December 7, 2005, 3:40 amtable partitioning: effects of many sub-tables (was COPY too slow...)
Posts(12)December 7, 2005, 3:40 amTSearch2 vs. Apache Lucene
Posts(3)December 7, 2005, 3:40 amQuery Fails with error calloc - Cannot alocate memory
Posts(13)December 7, 2005, 3:40 amEffects of cascading references in foreign keys
Posts(6)December 7, 2005, 3:40 amFaster db architecture for a twisted table.
Posts(4)December 6, 2005, 8:26 pmContext switching and Xeon processors
Posts(11)December 6, 2005, 8:26 pmtwo disks - best way to use them?
Posts(9)December 6, 2005, 8:26 pmMissed index opportunity for outer join?
Posts(4)December 6, 2005, 8:26 pmpostgresql performance tuning
Posts(14)December 6, 2005, 8:26 pmCan this query go faster???
Posts(3)December 6, 2005, 1:24 pmMemory Leakage Problem
Posts(12)December 6, 2005, 11:24 am8.1 count(*) distinct: IndexScan/SeqScan
Posts(9)December 6, 2005, 7:24 amBLCKSZ
Posts(10)December 6, 2005, 3:24 am15,000 tables - next step
Posts(3)December 5, 2005, 8:26 pmBest hardware
Posts(1)December 5, 2005, 3:24 amDividing up a single 250GB RAID10 server for postgres
Posts(25)December 3, 2005, 8:24 pmDatabase restore speed
Posts(31)December 2, 2005, 8:25 pm15,000 tables
Posts(6)December 2, 2005, 8:25 pmNetwork permormance under windows
Posts(2)December 2, 2005, 11:24 amRe: Open request for benchmarking input (fwd)
Posts(4)December 2, 2005, 11:24 ampg_dump slow
Posts(2)December 2, 2005, 7:23 amRe: COPY into table too slow with index: now an I/O
Posts(2)December 2, 2005, 3:24 amRe: COPY into table too slow with index: now an I/O
Posts(1)December 2, 2005, 3:24 amRe: COPY into table too slow with index: now an I/O question
Posts(1)December 1, 2005, 8:25 pmRe: COPY into table too slow with index: now an I/O question
Posts(2)December 1, 2005, 1:24 pmInsert performance slows down in large batch
Posts(1)December 1, 2005, 1:23 pmCOPY into table too slow with index
Posts(1)December 1, 2005, 1:23 pmpg_stat* values ...
Posts(3)December 1, 2005, 11:24 amslow insert into very large table
Posts(2)December 1, 2005, 11:24 amRe: About the relation between fragmentation of file and
Posts(2)December 1, 2005, 7:24 amAbout the relation between fragmentation of file and VACUUM
Posts(1)December 1, 2005, 7:24 amRe: About the relation between fragmentation of file and
Posts(5)December 1, 2005, 3:24 amRES: pg_dump slow
Posts(2)December 1, 2005, 3:24 amQuery is 800 times slower when running in function!


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

Copyright 2008 droptable.com