PDA

View Full Version : Pgsql Performance

Pages : 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 15 16
  1. SQL_CALC_FOUND_ROWS in POSTGRESQL / Some one can helpe me.
  2. Core 2 or Opteron
  3. How to organize users, documents and premissions for BEST PERFORMANCE
  4. How to organize users, documents and premissions for BEST PERFORMANCE
  5. How to organize users, documents and premissions for BEST PERFORMANCE
  6. advise HW for "best" DB
  7. Disk storage and san questions (was File Systems Compared)
  8. Problems with an update-from statement and pg-8.1.4
  9. Re: Locking in PostgreSQL?
  10. VACUUM FULL does not works.......
  11. Re: File Systems Compared
  12. File Systems Compared
  13. Re: Locking in PostgreSQL?
  14. Re: max/min and index usage
  15. Re: max/min and index usage
  16. Re: shared_buffers > 284263 on OS X
  17. Restart time
  18. Performance of ORDER BY
  19. single transaction vs multiple transactions
  20. Re: single transaction vs multiple transactions
  21. Re: Configuration settings for 32GB RAM server
  22. JOIN work somehow strange on simple query
  23. pgsql upgrade
  24. How to move pg_xlog to another drive on Windows????
  25. Configuration settings for 32GB RAM server
  26. 8.2rc1 (much) slower than 8.2dev?
  27. Is Vacuum/analyze destroying my performance?
  28. Enabling constraint_exclusion does not avoid scanning all child partitions
  29. Re: Enabling constraint_exclusion does not avoid scanning all child partitions
  30. Propagating outer join conditions
  31. Which query analiser tools are available?
  32. Re: Regex performance issue
  33. Regex performance issue
  34. Dump performance problems following server crash
  35. Performance of Perc 5i
  36. Re: Defining performance.
  37. Re: Defining performance.
  38. Re: Defining performance.
  39. Bad iostat numbers
  40. Defining performance.
  41. Fw: [GENERAL] Including unique users in huge data warehouse in Postgresql...
  42. OT - how to size/match multiple databases/apps for a single server
  43. NAMEDATALEN and performance
  44. Re: RES: Priority to a mission critical transaction
  45. Re: BUG #2784: Performance serious degrades over a period
  46. Plattform comparison (lies, damn lies and benchmarks)
  47. Re: Priority to a mission critical transaction
  48. Re: availability of SATA vendors
  49. Re: availability of SATA vendors
  50. When to vacuum a table?
  51. planner optomization: merge join VS hash join VS nested loop join
  52. Re: Massive delete of rows, how to proceed?
  53. Massive delete of rows, how to proceed?
  54. TPC-H Benchmark
  55. Re: Postgres scalability and performance on windows
  56. Re: Postgres scalability and performance on windows
  57. Re: Direct I/O issues
  58. Different plan between distinct and group by
  59. query on conversion
  60. BitMapScan performance degradation
  61. start up cost estimate
  62. shared_buffers > 284263 on OS X
  63. Re: Optimicing Postgres for SunSolaris10 on V240
  64. availability of SATA vendors
  65. Multi-column indexes. Which "direction" to order columns?
  66. Hundreds of database and FSM
  67. Slow SELECT on three or more clients
  68. SQL Procedure Optimisation
  69. 10x rowcount mis-estimation favouring merge over nestloop
  70. Re: Easy read-heavy benchmark kicking around?
  71. Keeping processes open for re-use
  72. Re: Help w/speeding up range queries?
  73. Re: Easy read-heavy benchmark kicking around?
  74. Easy read-heavy benchmark kicking around?
  75. Which OS provides the _fastest_ PostgreSQL performance?
  76. Context switching
  77. Yet another question on LIMIT performance :/
  78. Re: Setting "nice" values
  79. Re: Setting "nice" values
  80. Re: Setting "nice" values
  81. EXISTS optimization
  82. Re: Setting "nice" values
  83. Context switch storm
  84. profiling PL/pgSQL?
  85. Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs
  86. Re: Locking vs. Exceptions
  87. partitioned table performance
  88. Re: query produces 1 GB temp file
  89. Re: query produces 1 GB temp file
  90. Re: query produces 1 GB temp file
  91. client crashes in PQfinish
  92. Index ignored with "is not distinct from", 8.2 beta2
  93. Re: query slows down drastically with increased number of
  94. query slows down drastically with increased number of fields
  95. Stored procedure slower than sql?
  96. Re: commit so slow program looks frozen
  97. VACUUMs take twice as long across all nodes
  98. Re: Configuration Issue ?
  99. Re: Configuration Issue ?
  100. Configuration Issue ?
  101. Re: commit so slow program looks frozen
  102. Re: Best COPY Performance
  103. commit so slow program looks frozen
  104. Best practices of configuring postgresql database based on hardware specs
  105. Problems using a function in a where clause
  106. Copy database performance issue
  107. Optimizing disk throughput on quad Opteron
  108. Slow functional indexes?
  109. Jdbc/postgres performance
  110. Re: [HACKERS] Hints proposal
  111. Is ODBC that slow?
  112. VACUUM Performance
  113. Best COPY Performance
  114. Re: Swappiness setting on a linux pg server
  115. pgBench on Windows
  116. New hardware thoughts
  117. Vacuum and Memory Loss
  118. Re: Swappiness setting on a linux pg server
  119. Re: Swappiness setting on a linux pg server
  120. Re: Swappiness setting on a linux pg server
  121. Re: Swappiness setting on a linux pg server
  122. Re: Swappiness setting on a linux pg server
  123. Re: Swappiness setting on a linux pg server
  124. Swappiness setting on a linux pg server
  125. VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
  126. DB Performance decreases due to often written/accessed table
  127. Re: [GENERAL] UDF and cache
  128. Postgresql 8.1.4 - performance issues for select on view using max
  129. ACCESS EXCLUSIVE lock
  130. Re: Jdbc/postgres performance
  131. Re: Jdbc/postgres performance
  132. Index on two columns not used
  133. Jdbc/postgres performance
  134. Regarding Bitmap Scan
  135. Optimization of this SQL sentence
  136. measuring shared memory usage on Windows
  137. Re: [ADMIN] autovacuum on a -mostly- r/o table
  138. Hints proposal
  139. FW: Simple join optimized badly?
  140. Very heavy write operations on file pgstats_stat
  141. Scrub one large table against another
  142. long running transactions
  143. Postgre 8.0 Installation - Issues
  144. Re: Simple join optimized badly?
  145. Re: Simple join optimized badly?
  146. odd variances in count(*) times
  147. Re: autovacuum not working?
  148. Re: autovacuum not working?
  149. Re: Simple join optimized badly?
  150. Simple join optimized badly?
  151. pg_trgm indexes giving bad estimations?
  152. Multi-key index not beeing used - bug?
  153. UPDATE becomes mired / win32
  154. Re: Unsubscribe
  155. Re: Unsubscribe
  156. Unsubscribe
  157. simple case using index on windows but not on linux
  158. Re: BUG #2658: Query not using index
  159. Poor performance on very simple query ?
  160. Performance Optimization for Dummies 2 - the SQL
  161. How much memory in 32 bits Architecture to Shared Buffers is Possible
  162. Re: PostgreSQL runs a query much slower than BDE and
  163. selecting data from information_schema.columns performance.
  164. Table not getting vaccumed.
  165. Re: Postgres locking up?
  166. cont. how to optimize postgres 8.1
  167. Postgres locking up?
  168. how to optimize postgres 8.1
  169. any hope for my big query?
  170. archive wal's failure and load increase.
  171. RES: Performace Optimization for Dummies
  172. Performace Optimization for Dummies
  173. Performace Optimization for Dummies
  174. VACUUM ANALYZE vs VACUUM FULL
  175. slow queue-like empty table
  176. Problems with inconsistant query performance.
  177. autovacuum on a -mostly- r/o table
  178. Re: Forcing the use of particular execution plans
  179. Forcing the use of particular execution plans
  180. Merge Join vs Nested Loop
  181. Performance like vs =
  182. Performance like vs =
  183. Decreasing BLKSZ
  184. Multi-processor question
  185. IN not handled very well?
  186. Why is it choosing a different plan?
  187. (non)removable row versions
  188. recommended benchmarks
  189. Confusion and Questions about blocks read
  190. Opteron vs. Xeon "benchmark"
  191. PostgreSQL and sql-bench
  192. Re: PostgreSQL and sql-bench
  193. Re: PostgreSQL and sql-bench
  194. Re: PostgreSQL and sql-bench
  195. Re: PostgreSQL and sql-bench
  196. running benchmark test on a 50GB database
  197. Update on high concurrency OLTP application and Postgres 8 tuning
  198. Pipelined functions in Postgres
  199. Optimizing DELETE
  200. LIKE query problem
  201. Re: Optimize SQL
  202. Partition elimination problem
  203. Lanzamiento www.PortalTPV.com
  204. Re: Performance of IN (...) vs. = ANY array[...]
  205. Optimize SQL
  206. Re: RAID 0 not as fast as expected
  207. Why the difference in plans ??
  208. Re: RAID 0 not as fast as expected
  209. RAID 0 not as fast as expected
  210. Vacuums on large busy databases
  211. High CPU Load
  212. Unsubscribe
  213. Re: Poor performance on seq scan
  214. Unsubscribe
  215. sql-bench
  216. Re:
  217. Performance With Joins on Large Tables
  218. Re: Poor performance on seq scan
  219. [Fwd: Re: Performance problem with Sarge compared withWoody]
  220. Reg - Autovacuum
  221. Re: Poor performance on seq scan
  222. Poor performance on seq scan
  223. Performance problem with Sarge compared with Woody
  224. Abysmal hash join
  225. unsubscribe me
  226. Performance problem with joins
  227. Performance in a 7 TB database.
  228. Configuring System for Speed
  229. Xeon Woodcrest/Dempsey vs Opteron Socket F/940 with postgresql andsome SAS raid-figures
  230. Re: [PATCHES] Template0 age is increasing speedily.
  231. Lists (In) performance
  232. many tables vs one table
  233. 64bit vs 32bit build on amd64
  234. Hanging queries on Windows 2003 SP1
  235. Simple update speed versus Oracle
  236. increasing shared buffers: how much should be removed from OS filesystem cache?
  237. database bloat,non removovable rows, slow query etc...
  238. Postgress memory leak with JBoss3.2.6 and large DB
  239. High concurrency OLTP database performance tuning
  240. Re: PostgreSQL performance issues
  241. Re: PostgreSQL performance issues
  242. performance problems.
  243. slow, when two foreign key references to the same column
  244. PostgreSQL performance issues
  245. Internal Operations on LIMIT & OFFSET clause
  246. slow i/o
  247. Identifying bloated tables
  248. Re: Identifying bloated tables
  249. Re: Postgre SQL 7.1 cygwin performance issue.
  250. perf pb solved only after pg_dump and restore