PDA

View Full Version : Pgsql Performance

Pages : 1 2 3 4 5 6 7 8 9 10 11 [12] 13 14 15 16
  1. Re: Improving performance of a query
  2. Re: Need for speed 3
  3. Postgresql Hardware - Recommendations
  4. Re: Poor SQL performance
  5. Query slow after VACUUM ANALYZE
  6. poor VACUUM performance on large tables
  7. Improving performance of a query
  8. Poor SQL performance
  9. Advise about how to delete entries
  10. ORDER BY and LIMIT not propagated on inherited tables / UNIONs
  11. (NONE)
  12. Update is more affected( taking more time) than Select ( if Auto vacuum isnot running)
  13. Avoid using swap in a cluster
  14. Prepared statement not using index
  15. Re: Massive performance issues
  16. Re: Massive performance issues
  17. Re: Massive performance issues
  18. Re: Massive performance issues
  19. Massive performance issues
  20. Re: Need for speed 3
  21. Re: Need for speed 3
  22. Need for speed 3
  23. Poor performance on HP Package Cluster
  24. Big question on insert performance/using COPY FROM
  25. Swapping
  26. 'Real' auto vacuum?
  27. When to do a vacuum for highly active table
  28. Re: High load and iowait but no disk access
  29. Re: High load and iowait but no disk access
  30. Re: Need indexes on empty tables for good performance ?
  31. Observation about db response time
  32. High load and iowait but no disk access
  33. Observation about db response time
  34. RAID Configuration Sugestion
  35. How to improve Postgres performance
  36. getting an index to work with partial indices ...
  37. Re: Limit + group + join
  38. shared buffers
  39. Planner improvement suggestion
  40. Bitmap scan when it is not needed
  41. intarray is broken ? (8.1b1)
  42. Need indexes on empty tables for good performance ?
  43. Weird performance drop after VACUUM
  44. How does the planner execute unions?
  45. OSX & Performance
  46. Re: Sending a select to multiple servers.
  47. Re: difference in plan between 8.0 and 8.1?
  48. Sending a select to multiple servers.
  49. Re: Limit + group + join
  50. difference in plan between 8.0 and 8.1?
  51. Inefficient queryplan for query with intersectable subselects/joins
  52. postmaster memory keep going up????
  53. Limit + group + join
  54. Re: Need for speed 2
  55. RAID arrays (and vendors)
  56. Re: Read/Write block sizes
  57. Re: Read/Write block sizes
  58. Performance indexing of a simple query
  59. Re: Some ideas for comment
  60. Some ideas for comment
  61. Re: performance drop on RAID5
  62. performance drop on RAID5
  63. Re: Read/Write block sizes (Was: Caching by Postgres)
  64. Caching by Postgres
  65. fake condition causes far better plan
  66. Performance for relative large DB
  67. unused item pointers?
  68. pgbench
  69. Re: Finding bottleneck
  70. MemoryContextSwitchTo during table scan?
  71. Re: Finding bottleneck
  72. Re: extremly low memory usage
  73. Re: (Re)-indexing on updates
  74. complex query performance assistance request
  75. Re: extremly low memory usage
  76. index as large as table
  77. Re: Finding bottleneck
  78. LEFT JOIN ON vs. LEFT JOIN USING performance
  79. Re: Finding bottleneck
  80. sustained update load of 1-2k/sec
  81. Re: Query plan looks OK, but slow I/O - settings advice?
  82. I'm configuraing a new system (Bigish) and need some advice.
  83. Re: I'm configuraing a new system (Bigish) and need some advice.
  84. Query plan looks OK, but slow I/O - settings advice?
  85. Re: Need for speed
  86. Re: limit number of concurrent callers to a stored proc?
  87. FW: Tx forecast improving harware capabilities.
  88. extremly low memory usage
  89. limit number of concurrent callers to a stored proc?
  90. bitmap scan issues 8.1 devel
  91. Re: Need for speed
  92. Tuning Effective Cache Question
  93. Re: Tuning Effective Cache Question
  94. Re: Data Selection Slow From VB 6.0
  95. Re: Data Selection Slow From VB 6.0
  96. Re: Performance problem using V3 protocol in jdbc driver
  97. Re: Finding bottleneck
  98. Re: choosing RAID level for xlogs
  99. Re: choosing RAID level for xlogs
  100. Re: choosing RAID level for xlogs
  101. Re. : Need for speed
  102. Need for speed
  103. Looking for a large database for testing
  104. database encoding with index search problem
  105. choosing RAID level for xlogs
  106. Re: I'm configuraing a new system (Bigish) and need some advice.
  107. Re: Performance pb vs SQLServer.
  108. Re: Performance pb vs SQLServer.
  109. Re: Performance pb vs SQLServer.
  110. Re: [Fwd: PG8 Tuning]
  111. Performance pb vs SQLServer.
  112. How many views is ok?
  113. Re: Mostly read performance (2 replies)
  114. Mostly read performance
  115. Odd Locking Problem
  116. Re: PG8 Tuning
  117. BG writer question?
  118. PG8 Tuning
  119. Why is not using the index
  120. it is always delete temp table will slow down the postmaster?
  121. Speedier count(*)
  122. partial index regarded more expensive
  123. Table locking problems?
  124. Re: Finding bottleneck
  125. Slow update statement
  126. Why hash join instead of nested loop?
  127. Performance problems on 4-way AMD Opteron 875 (dual core)
  128. Indexed views.
  129. Is There A Windows Version of Performance Tuning Documents?
  130. QRY seems not using indexes
  131. pg_dump for table with bytea takes a long time
  132. "nice"/low priority Query
  133. Planner incorrectly choosing seq scan over index scan
  134. Re: [PATCHES] COPY FROM performance improvements
  135. Re: [PATCHES] COPY FROM performance improvements
  136. ltree <@ operator selectivity causes very slow plan
  137. Performance problems on 4/8way Opteron (dualcore) HP DL585
  138. Re: Performance problems testing with Spamassassin
  139. Two queries are better than one?
  140. Unable to explain DB error
  141. Fwd: Help with view performance problem
  142. Re: Finding bottleneck
  143. Re: Performance problems testing with Spamassassin 3.1.0 Bayes module.
  144. Finding bottleneck
  145. Left joining against two empty tables makes a query SLOW
  146. Performance problems testing with Spamassassin 3.1.0 Bayes module.
  147. Re: "Vacuum Full Analyze" taking so long
  148. Inherited Table Query Planning (fwd)
  149. [IMPORTANT] - My application performance
  150. Re: [Bizgres-general] Re: faster INSERT with possible
  151. faster INSERT with possible pre-existing row?
  152. Cheap RAM disk?
  153. Re: COPY insert performance
  154. Re: COPY insert performance
  155. Re: COPY insert performance
  156. Re: "Vacuum Full Analyze" taking so long
  157. Re: "Vacuum Full Analyze" taking so long
  158. COPY insert performance
  159. "Vacuum Full Analyze" taking so long
  160. Mirroring PostgreSQL database
  161. Coraid/AoE device experience?
  162. Size of empty varchar and size of index
  163. Re: Looking for tips
  164. Re: re: performance decrease after reboot
  165. re: performance decrease after reboot
  166. Re: [PATCHES] COPY FROM performance improvements
  167. Re: [PATCHES] COPY FROM performance improvements
  168. Another index question
  169. Planner doesn't look at LIMIT?
  170. Re: What is best way to stream terabytes of data into
  171. What is best way to stream terabytes of data into postgresql?
  172. Optimizer seems to be way off, why?
  173. performance decrease after reboot
  174. Re: Looking for tips
  175. Re: Looking for tips
  176. context-switching issue on Xeon
  177. Looking for tips
  178. Re: Insert performance (OT?)
  179. Re: join and query planner
  180. Re: join and query planner
  181. Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?
  182. Re: Huge performance problem between 7.4.1 and 8.0.3 -
  183. Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?
  184. Re: Huge performance problem between 7.4.1 and 8.0.3 -
  185. Impact of checkpoint_segments under continual load conditions
  186. Questions about temporary tables and performance
  187. more filesystem benchmarks
  188. Really bad diskio
  189. What's a lot of connections?
  190. slow joining very large table to smaller ones
  191. PostgresSQL vs. Firebird
  192. Re: JFS fastest filesystem for PostgreSQL?
  193. JFS fastest filesystem for PostgreSQL?
  194. Profiler for PostgreSQL
  195. lots of updates on small table
  196. Slow Query
  197. performance problems ... 100 cpu utilization
  198. Quad Opteron stuck in the mud
  199. (pas de sujet)
  200. large table vs multiple smal tables
  201. size of cache
  202. General DB Tuning
  203. Re: Projecting currentdb to more users
  204. Re: Projecting currentdb to more users
  205. Re: join and query planner
  206. Sorting on longer key is faster ?
  207. Re: Data Warehousing Tuning
  208. Re: Question
  209. Re: Question
  210. Question
  211. Re: How to revoke a password
  212. How to revoke a password
  213. Re: Mount database on RAM disk?
  214. cost-based vacuum
  215. Mount database on RAM disk?
  216. Need suggestion high-level suggestion on how to solve a performanceproblem
  217. Re:
  218. Surprizing performances for Postgres on Centrino
  219. How to speed up delete
  220. Re: Data Warehousing Tuning
  221. join and query planner
  222. CURSOR slowes down a WHERE clause 100 times?
  223. ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number
  224. Re: Storing data and indexes in different disks
  225. Storing data and indexes in different disks
  226. Data Warehousing Tuning
  227. Heavy virtual memory usage on production system
  228. plain inserts and deletes very slow
  229. B-Tree index not being used
  230. Planner constants for RAM resident databases
  231. planner picking more expensive plan
  232. ported application having performance issues
  233. start time very high
  234. Re: ODBC driver over network very slow
  235. Re: ODBC driver over network very slow
  236. Re: slow simple update?
  237. ODBC driver over network very slow
  238. Vacuum becomes slow
  239. Exclusive lock question
  240. could not receive data from client: Connection timed out Error
  241. Re: tricky query
  242. Re: tricky query
  243. Re: Too slow querying a table of 15 million records
  244. read block size
  245. Re: tricky query
  246. Re: tricky query
  247. Re: tricky query
  248. Re: tricky query
  249. =?iso-8859-1?Q?R=E9f=2E_=3A__tricky_query?=
  250. (NONE)