PDA

View Full Version : Pgsql Performance

Pages : 1 2 3 [4] 5 6 7 8 9 10 11 12 13 14 15 16
  1. PITR Backups
  2. Very long SQL strings
  3. Database-wide VACUUM ANALYZE
  4. vacuum a lot of data when insert only
  5. Data transfer very slow when connected via DSL
  6. Slow indexscan
  7. cached entities
  8. Short row header
  9. to partition or not to partition
  10. PostgreSQL Configuration Tool for Dummies
  11. PostgreSQL Configuration Tool for Dummies
  12. PostgreSQL Configuration Tool for Dummies
  13. Maintenance question / DB size anomaly...
  14. Hardware suggestions
  15. Regarding Timezone
  16. Performance query about large tables, lots of concurrent access
  17. Re: [ADMIN] Postgres VS Oracle
  18. Volunteer to build a configuration tool
  19. determining maxsize for character varying
  20. Re: Replication
  21. Variable (degrading) perfomance
  22. Replication
  23. Replication
  24. Parsing VACUUM VERBOSE
  25. Update table performance problem
  26. [PG 8.1.0 / AIX 5.3] Vacuum processes freezing
  27. WAL shipping and ever expanding pg_xlog
  28. Optimize slow query
  29. Performance Testing Utility
  30. VACUUM vs auto-vacuum daemon
  31. How much memory PostgreSQL is going to use?
  32. Re: test / live environment, major performance difference
  33. Best use of second controller with faster disks?
  34. Variable (degrading) performance
  35. test / live environment, major performance difference
  36. pg_statistic doesnt contain details for specific table
  37. How much ram is too much
  38. Please help me understand these numbers
  39. Re: [ADMIN] reclaiming disk space after major updates
  40. MI5 Persecution: Goldfish and Piranha 29/9/95 (5706)
  41. MI5 Persecution: Watch Out, Forger About 27/9/95 (4192)
  42. MI5 Persecution: Question and Answer 27/9/95 (2678)
  43. MI5 Persecution: Options 21/9/95 (1164)
  44. Database size
  45. Best way to delete unreferenced rows?
  46. Getting Slow
  47. How Are The Variables Related?
  48. copy from performance on large tables with indexes
  49. Weird 8.2.4 performance
  50. Is this true?
  51. VERY slow queries at random
  52. pgsql performance
  53. weird query plan
  54. MARS in SQL Server 2005
  55. Performance Problem
  56. Performance Problem
  57. Question about SQL performance
  58. postgresql running on a virtual cluster
  59. PostgreSQL not fully utilizing system resources?
  60. Thousands of tables versus on table?
  61. dbt2 NOTPM numbers
  62. Auto Vacuum question?
  63. Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  64. Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  65. upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  66. Seq Scan
  67. Some info to share: db_STRESS Benchmark results
  68. DB cluster sharing between 32 and 64 bit software versions
  69. Re: Append table
  70. Database connection for Tbl_B established
  71. Re: setting up raid10 with more than 4 drives
  72. Bad RAID1 read performance
  73. Very slow left outer join
  74. setting up raid10 with more than 4 drives
  75. Vacuum takes forever
  76. PITR performance costs
  77. Peformance Tuning using INCLUDE index
  78. ECC RAM really needed?
  79. Adding disks/xlog & index
  80. Re: general PG network slowness (possible cure) (repost)
  81. Performance problem on 8.2.4, but not 8.2.3
  82. Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13))
  83. Re: general PG network slowness (possible cure) (repost)
  84. Big problem with sql update operation
  85. How PostgreSQL handles multiple DDBB instances?
  86. Performance Problem with Vacuum of bytea table (PG 8.0.13)
  87. general PG network slowness (possible cure) (repost)
  88. Memory allocation and Vacuum abends
  89. Auto-ANALYZE?
  90. Re: Drop table vs Delete record
  91. Re: does VACUUM ANALYZE complete with this error?
  92. Simulate database fragmentation
  93. Re: does VACUUM ANALYZE complete with this error?
  94. max_fsm_pages, shared_buffers and checkpoint_segments
  95. LIKE search and performance
  96. does VACUUM ANALYZE complete with this error?
  97. Become MCSD Certified
  98. Re: Tips & Tricks for validating hardware/os
  99. Re: Drop table vs Delete record
  100. Drop table vs Delete record
  101. Domains versus Check Constraints
  102. Tips & Tricks for validating hardware/os
  103. Performace comparison of indexes over timestamp fields
  104. is file size relevant in choosing index or table scan?
  105. Key/Value reference table generation: INSERT/UPDATE performance
  106. Feature suggestion : FAST CLUSTER
  107. Increasing Shared_buffers = slow commits?
  108. Rewriting DISTINCT and losing performance
  109. Re: Postgres Benchmark Results
  110. Postgres Benchmark Results
  111. QP Problem
  112. Efficient recursion
  113. Slow queries on big table
  114. choosing fillfactor
  115. 121+ million record table perf problems
  116. reading large BYTEA type is slower than expected
  117. Re: performance drop on 8.2.4, reverting to 8.1.4
  118. CPU Intensive query
  119. Re: Ever Increasing IOWAIT
  120. performance drop on 8.2.4, reverting to 8.1.4
  121. Re: Ever Increasing IOWAIT
  122. Re: Ever Increasing IOWAIT
  123. WAL log performance/efficiency question
  124. any way to get rid of Bitmap Heap Scan recheck?
  125. Re: New performance documentation released
  126. Re: [PATCHES] Automatic adjustment of bgwriter_lru_maxpages
  127. How to Run a pg_stats Query
  128. Disk Fills Up and fsck "Compresses" it
  129. [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal
  130. bitmap index and IS NULL predicate
  131. Many to many join seems slow?
  132. Re: Transaction prioritization from java possible?
  133. pg_stats how-to?
  134. Kernel cache vs shared_buffers
  135. 500 requests per second
  136. Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
  137. PostGreSQL ignoring my rules in select query
  138. Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
  139. REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
  140. Background vacuum
  141. Re: Performance Woes
  142. Re: Performance Woes
  143. Vacuum Times - Verbose and maintenance_work_mem
  144. Poor performance with queries using clause: sth IN (...)
  145. Cannot make GIN intarray index be used by the planner
  146. Apparently useless bitmap scans
  147. Re:
  148. FW:
  149. FW:
  150. FW:
  151. Re:
  152. Re:
  153. Re:
  154. What's The Difference Between VACUUM and VACUUM ANALYZE?
  155. Throttling PostgreSQL's CPU usage
  156. DISTINCT Question
  157. Re: specific query (not all) on Pg8 MUCH slower than Pg7
  158. Nested loops overpriced
  159. specific query (not all) on Pg8 MUCH slower than Pg7
  160. estimating the need for VACUUM FULL and REINDEX
  161. truncate a table instead of vaccum full when count(*) is 0
  162. Best OS for Postgres 8.2
  163. Merging large volumes of data
  164. How to Find Cause of Long Vacuum Times - NOOB Question
  165. Diminishing bandwidth performance with multiple quad core X5355s
  166. Index not being used in sorting of simple table
  167. pg_stat_* collection
  168. Join vs Subquery
  169. Intermitent slow queries
  170. sytem log audit/reporting and psql
  171. Query performance problems with partitioned tables
  172. Re: Redundant sub query triggers slow nested loop left join
  173. Re: Redundant sub query triggers slow nested loop left join
  174. Very specific server situation
  175. Re: [Fwd: ] How
  176. How can fixed and variable width columns perform similarly?
  177. Usage up to 50% CPU
  178. Re: Simple query, 10 million records...MySQL tentimes faster
  179. Re: [GENERAL] PostgreSQL Performance Tuning
  180. Re: [GENERAL] Fw: PostgreSQL Performance Tuning
  181. Re: [GENERAL] Fw: PostgreSQL Performance Tuning
  182. Re: Fw: PostgreSQL Performance Tuning
  183. Re: What`s wrong with JFS configuration?
  184. Fragmentation of WAL files
  185. What`s wrong with JFS configuration?
  186. Simple query, 10 million records...MySQL ten times faster
  187. View is not using a table index
  188. Warm - standby system.
  189. index usage
  190. Hardware Configuration advice
  191. Re: Redundant sub query triggers slow nested loop left join
  192. postgres: 100% CPU utilization
  193. seeking advise on char vs text or varchar in search table
  194. Odd problem with planner choosing seq scan
  195. Help with TOAST Compression
  196. Re: Redundant sub query triggers slow nested loop left join
  197. Redundant sub query triggers slow nested loop left join
  198. not using indexes on large table
  199. Odd problem with planner choosing seq scan
  200. TPC-H Scaling Factors X PostgreSQL Cluster Command
  201. how to output column names
  202. Foreign Key Deadlocking
  203. FK triggers misused?
  204. Basic Q on superfluous primary keys
  205. Finding bloated indexes?
  206. local selectivity estimation - computing frequency of predicates
  207. Slow Postgresql server
  208. Submit Resume to 10,000+ Corp-Corp Recruiters
  209. Work with 10,000+ Corp-Corp Recruiters and share Resources
  210. Long running transactions again ...
  211. Do I need to rebuild php-pgsql for 8.2.3
  212. how to efficiently update tuple in many-to-many relationship?
  213. Please humor me ...
  214. FK triggers misused?
  215. DELETE with filter on ctid
  216. join to view over custom aggregate seems like it should be faster
  217. Beginner Question
  218. fast DISTINCT or EXIST
  219. postgres 8.2 seems to prefer Seq Scan
  220. more on high load on postgres 7.4.16
  221. High Load on Postgres 7.4.16 Server
  222. Premature view materialization in 8.2?
  223. What do the adminpack functions do? (8.2.3)
  224. a question about Direct I/O and double buffering
  225. Slow Seq Scans - Help Needed!
  226. Large objetcs performance
  227. Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY""MAX_ROWS=1000"
  228. SCSI vs SATA
  229. FKs misused?
  230. Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
  231. Nested loop slowing down a query and annoying gettimeofday
  232. Cache hit ratio
  233. postgres 7.4 vs 8.x redux: query plans
  234. postgres 7.4 vs. 8.x redux
  235. How to determine which indexes are not using or using seldom in database
  236. What's wrong with my database
  237. scalablility problem
  238. Wrong plan sequential scan instead of an index one
  239. Scaling SELECT:s with the number of disks on a stripe
  240. Weird performance drop
  241. Re-ordering of multi-column index in partitioned table
  242. Re: Sunfire X4500 recommendations
  243. Planner doing seqscan before indexed join
  244. Shared buffers, db transactions commited, and write IO on Solaris
  245. Improving performance on system catalog
  246. Re: Sunfire X4500 recommendations
  247. How to enable jdbc???
  248. Nested Loop
  249. slow checkpoint question
  250. Optimization postgresql 8.1.4 FC 6 X64 ?