PDA

View Full Version : Pgsql Performance

Pages : 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 15 16
  1. PG8.2.1 choosing slow seqscan over idx scan
  2. Table Size
  3. Re: Caching in PostgreSQL
  4. Caching in PostgreSQL
  5. FiberChannel cards for FreeBSD on AMD64
  6. pg_trgm performance
  7. Re: max() versus order/limit (WAS: High update
  8. Re: max() versus order/limit (WAS: High update activity, PostgreSQL vs BigDBMS)
  9. Re:
  10. Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
  11. Performance of Parser?
  12. Physical separation of tables and indexes - where pg_xlogshould go?
  13. Large table performance
  14. Partitioning
  15. Planner statistics, correlations
  16. Improving SQL performance
  17. unusual performance for vac following 8.2 upgrade
  18. Does it matters the column order in indexes and constraints creation?
  19. Slow inner join, but left join is fast
  20. Re: group by will not use an index?
  21. group by will not use an index?
  22. High inserts, bulk deletes - autovacuum vs scheduled vacuum
  23. Re: Horribly slow query/ sequential scan
  24. Running PG on cluster files systems
  25. Re: Horribly slow query/ sequential scan
  26. Horribly slow query/ sequential scan
  27. MI5 Persecution: Security Service Tribunal Denies
  28. tweaking under repeatable load
  29. table partioning performance
  30. Missing the point of autovacuum
  31. Re: Partitioning
  32. Partitioning
  33. Slow Query on Postgres 8.2
  34. MI5 Persecution: Communications with Security Service Tribunal in 1999
  35. PostgreSQL to host e-mail?
  36. MI5 Persecution: Eye Say, and Lord Gnome Answers
  37. MI5 Persecution: Counter-surveillance sweep by Nationwide Investigations Group
  38. Trivial function query optimized badly
  39. Performance of PostgreSQL on Windows vs Linux
  40. More 8.2 client issues (Was: [Slow dump?)
  41. Max Connections to a New Hardware
  42. Slow dump?
  43. Config parameters
  44. what work_mem needs a query needs?
  45. glibc double-free error
  46. Worse perfomance on 8.2.0 than on 7.4.14
  47. Re: Worse perfomance on 8.2.0 than on 7.4.14
  48. Re: Backup/Restore too slow
  49. Postgresql Configutation and overflow
  50. performance implications of binary placement
  51. Postgresql Configutation and overflow
  52. High update activity, PostgreSQL vs BigDBMS
  53. Re: [GENERAL] Need Help
  54. Re: [NOVICE] Partitioning
  55. Questions about planner methods
  56. What you would consider as heavy traffic?
  57. URGENT: Out of disk space pg_xlog
  58. Question: Clustering & Load Balancing
  59. GROUP BY vs DISTINCT
  60. max_fsm_pages and check_points
  61. Inner join vs where-clause subquery
  62. Query plan changing when queried data does not
  63. transaction ID wrap limit
  64. Optimizing timestamp queries? Inefficient Overlaps?
  65. Scaling concerns
  66. partition text/varchar check problem
  67. opportunity to benchmark a quad core Xeon
  68. Dell 2900/Xeon 5000 ?
  69. unsubscribe
  70. EXPLAIN ANALYZE on 8.2
  71. Two tables in one
  72. Optimizing a query
  73. strange query behavior
  74. Insertion to temp table deteriorating over time
  75. Slow update with simple query
  76. really quick multiple inserts can use COPY?
  77. Re: really quick multiple inserts can use COPY?
  78. Re: really quick multiple inserts can use COPY?
  79. Looking for hw suggestions for high concurrency OLTP app
  80. Re: Postgresql - Threshold value.
  81. Re: Postgresql - Threshold value.
  82. Postgresql - Threshold value.
  83. New to PostgreSQL, performance considerations
  84. Re: Low throughput of binary inserts from windows to linux
  85. Advice on selecting good values for work_mem?
  86. Re: Advice on selecting good values for work_mem?
  87. How to determine if my setting for shared_buffers is too high?
  88. One table is very slow, but replicated table (same data) is fine
  89. SQL_CALC_FOUND_ROWS in POSTGRESQL / Some one can helpe me.
  90. Core 2 or Opteron
  91. How to organize users, documents and premissions for BEST PERFORMANCE
  92. How to organize users, documents and premissions for BEST PERFORMANCE
  93. How to organize users, documents and premissions for BEST PERFORMANCE
  94. advise HW for "best" DB
  95. Disk storage and san questions (was File Systems Compared)
  96. Problems with an update-from statement and pg-8.1.4
  97. Re: Locking in PostgreSQL?
  98. VACUUM FULL does not works.......
  99. Re: File Systems Compared
  100. File Systems Compared
  101. Re: Locking in PostgreSQL?
  102. Re: max/min and index usage
  103. Re: max/min and index usage
  104. Re: shared_buffers > 284263 on OS X
  105. Restart time
  106. Performance of ORDER BY
  107. single transaction vs multiple transactions
  108. Re: single transaction vs multiple transactions
  109. Re: Configuration settings for 32GB RAM server
  110. JOIN work somehow strange on simple query
  111. pgsql upgrade
  112. How to move pg_xlog to another drive on Windows????
  113. Configuration settings for 32GB RAM server
  114. 8.2rc1 (much) slower than 8.2dev?
  115. Is Vacuum/analyze destroying my performance?
  116. Enabling constraint_exclusion does not avoid scanning all child partitions
  117. Re: Enabling constraint_exclusion does not avoid scanning all child partitions
  118. Propagating outer join conditions
  119. Which query analiser tools are available?
  120. Re: Regex performance issue
  121. Regex performance issue
  122. Dump performance problems following server crash
  123. Performance of Perc 5i
  124. Re: Defining performance.
  125. Re: Defining performance.
  126. Re: Defining performance.
  127. Bad iostat numbers
  128. Defining performance.
  129. Fw: [GENERAL] Including unique users in huge data warehouse in Postgresql...
  130. OT - how to size/match multiple databases/apps for a single server
  131. NAMEDATALEN and performance
  132. Re: RES: Priority to a mission critical transaction
  133. Re: BUG #2784: Performance serious degrades over a period
  134. Plattform comparison (lies, damn lies and benchmarks)
  135. Re: Priority to a mission critical transaction
  136. Re: availability of SATA vendors
  137. Re: availability of SATA vendors
  138. When to vacuum a table?
  139. planner optomization: merge join VS hash join VS nested loop join
  140. Re: Massive delete of rows, how to proceed?
  141. Massive delete of rows, how to proceed?
  142. TPC-H Benchmark
  143. Re: Postgres scalability and performance on windows
  144. Re: Postgres scalability and performance on windows
  145. Re: Direct I/O issues
  146. Different plan between distinct and group by
  147. query on conversion
  148. BitMapScan performance degradation
  149. start up cost estimate
  150. shared_buffers > 284263 on OS X
  151. Re: Optimicing Postgres for SunSolaris10 on V240
  152. availability of SATA vendors
  153. Multi-column indexes. Which "direction" to order columns?
  154. Hundreds of database and FSM
  155. Slow SELECT on three or more clients
  156. SQL Procedure Optimisation
  157. 10x rowcount mis-estimation favouring merge over nestloop
  158. Re: Easy read-heavy benchmark kicking around?
  159. Keeping processes open for re-use
  160. Re: Help w/speeding up range queries?
  161. Re: Easy read-heavy benchmark kicking around?
  162. Easy read-heavy benchmark kicking around?
  163. Which OS provides the _fastest_ PostgreSQL performance?
  164. Context switching
  165. Yet another question on LIMIT performance :/
  166. Re: Setting "nice" values
  167. Re: Setting "nice" values
  168. Re: Setting "nice" values
  169. EXISTS optimization
  170. Re: Setting "nice" values
  171. Context switch storm
  172. profiling PL/pgSQL?
  173. Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs
  174. Re: Locking vs. Exceptions
  175. partitioned table performance
  176. Re: query produces 1 GB temp file
  177. Re: query produces 1 GB temp file
  178. Re: query produces 1 GB temp file
  179. client crashes in PQfinish
  180. Index ignored with "is not distinct from", 8.2 beta2
  181. Re: query slows down drastically with increased number of
  182. query slows down drastically with increased number of fields
  183. Stored procedure slower than sql?
  184. Re: commit so slow program looks frozen
  185. VACUUMs take twice as long across all nodes
  186. Re: Configuration Issue ?
  187. Re: Configuration Issue ?
  188. Configuration Issue ?
  189. Re: commit so slow program looks frozen
  190. Re: Best COPY Performance
  191. commit so slow program looks frozen
  192. Best practices of configuring postgresql database based on hardware specs
  193. Problems using a function in a where clause
  194. Copy database performance issue
  195. Optimizing disk throughput on quad Opteron
  196. Slow functional indexes?
  197. Jdbc/postgres performance
  198. Re: [HACKERS] Hints proposal
  199. Is ODBC that slow?
  200. VACUUM Performance
  201. Best COPY Performance
  202. Re: Swappiness setting on a linux pg server
  203. pgBench on Windows
  204. New hardware thoughts
  205. Vacuum and Memory Loss
  206. Re: Swappiness setting on a linux pg server
  207. Re: Swappiness setting on a linux pg server
  208. Re: Swappiness setting on a linux pg server
  209. Re: Swappiness setting on a linux pg server
  210. Re: Swappiness setting on a linux pg server
  211. Re: Swappiness setting on a linux pg server
  212. Swappiness setting on a linux pg server
  213. VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
  214. DB Performance decreases due to often written/accessed table
  215. Re: [GENERAL] UDF and cache
  216. Postgresql 8.1.4 - performance issues for select on view using max
  217. ACCESS EXCLUSIVE lock
  218. Re: Jdbc/postgres performance
  219. Re: Jdbc/postgres performance
  220. Index on two columns not used
  221. Jdbc/postgres performance
  222. Regarding Bitmap Scan
  223. Optimization of this SQL sentence
  224. measuring shared memory usage on Windows
  225. Re: [ADMIN] autovacuum on a -mostly- r/o table
  226. Hints proposal
  227. FW: Simple join optimized badly?
  228. Very heavy write operations on file pgstats_stat
  229. Scrub one large table against another
  230. long running transactions
  231. Postgre 8.0 Installation - Issues
  232. Re: Simple join optimized badly?
  233. Re: Simple join optimized badly?
  234. odd variances in count(*) times
  235. Re: autovacuum not working?
  236. Re: autovacuum not working?
  237. Re: Simple join optimized badly?
  238. Simple join optimized badly?
  239. pg_trgm indexes giving bad estimations?
  240. Multi-key index not beeing used - bug?
  241. UPDATE becomes mired / win32
  242. Re: Unsubscribe
  243. Re: Unsubscribe
  244. Unsubscribe
  245. simple case using index on windows but not on linux
  246. Re: BUG #2658: Query not using index
  247. Poor performance on very simple query ?
  248. Performance Optimization for Dummies 2 - the SQL
  249. How much memory in 32 bits Architecture to Shared Buffers is Possible
  250. Re: PostgreSQL runs a query much slower than BDE and