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: 8.1 iss
  2. Performance problem with pg8.0
  3. Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian??
  4. 8.1 iss
  5. Re: [HACKERS] insert performance for win32
  6. Re: insert performance for win32
  7. Re: [HACKERS] insert performance for win32
  8. Re: insert performance for win32
  9. Re: insert performance for win32
  10. Re: insert performance for win32
  11. Re: insert performance for win32
  12. Re: insert performance for win32
  13. Re: insert performance for win32
  14. Re: insert performance for win32
  15. Re: Searching union views not using indices
  16. Re: insert performance for win32
  17. Searching union views not using indices
  18. Re: insert performance for win32
  19. Re: insert performance for win32
  20. Encoding on 8.0.4
  21. Re: insert performance for win32
  22. Re: insert performance for win32
  23. Re: insert performance for win32
  24. Re: insert performance for win32
  25. Re: Sorted union
  26. Re: Sorted union
  27. Re: Sorted union
  28. Re: insert performance for win32
  29. Re: Sorted union
  30. Re: insert performance for win32
  31. Re: Sorted union
  32. Re: Sorted union
  33. multi-layered view join performance oddities
  34. Effects of cascading references in foreign keys
  35. Re: Simple query: how to optimize
  36. Simple query: how to optimize
  37. Best way to check for new data.
  38. How long it takes to vacuum a big table
  39. Re: How much memory?
  40. How much memory?
  41. Update using primary key slow
  42. how postgresql request the computer resources
  43. Re: browsing table with 2 million records
  44. performance on query
  45. browsing table with 2 million records
  46. Performance issues with custom functions
  47. Perfomance of views
  48. Re: zero performance on query
  49. Re: zero performance on query
  50. zero performance on query
  51. blue prints please
  52. Re: Temporary Table
  53. Re: Outer join query plans and performance
  54. Why different execution times for different instances for the same query?
  55. Re: impact of stats_command_string
  56. Re: Inefficient escape codes.
  57. Reindex - Is this necessary after a vacuum?
  58. insertion of bytea
  59. Re: Strange planner decision on quite simple select
  60. Outer join query plans and performance
  61. How to merge table faster
  62. Strange planner decision on quite simple select
  63. Why Index is not working on date columns.
  64. FW: Used Memory
  65. Temporary Table
  66. Re: Is There Any Way ....
  67. Re: Inefficient escape codes.
  68. Re: Used Memory
  69. performance of implicit join vs. explicit conditions on inet queries?
  70. Problem analyzing explain analyze output
  71. Re: Need help in setting optimal configuration for a huge
  72. Re: Need help in setting optimal configuration for a huge
  73. prepared transactions that persist across sessions?
  74. Re: Need help in setting optimal configuration for a huge database.
  75. Re: Need help in setting optimal configuration for a huge
  76. Re: Need help in setting optimal configuration for a huge database.
  77. Using LIMIT 1 in plpgsql PERFORM statements
  78. What gets cached?
  79. impact of stats_command_string
  80. Re: cached plans in plpgsql
  81. cached plans in plpgsql
  82. Re: Deleting Records
  83. Re: Inefficient escape codes.
  84. Materializing a sequential scan
  85. Re: Inefficient escape codes.
  86. tuning seqscan costs
  87. Inefficient escape codes.
  88. tsearch2/GIST performance factors?
  89. tsearch2/GIST performance factors?
  90. Bytea poor performance
  91. Best way to get all different values in a column
  92. Re: Optimizer misconfigured ?
  93. slow update
  94. Re: Help tuning postgres
  95. Re: Help tuning postgres
  96. Optimizer misconfigured ?
  97. Sequential scan on FK join
  98. Re: Help tuning postgres
  99. Re: Help tuning postgres
  100. Help tuning postgres
  101. Re: SELECT LIMIT 1 VIEW Performance Issue
  102. effective cache size on FreeBSD (WAS: Performance on SUSE w/ reiserfs)
  103. Massive delete performance
  104. XFS External Log on Pg 7.4.8 Pg_xlog drives?
  105. Performance on SUSE w/ reiserfs
  106. Query performance on ILIKE with AND operator...
  107. Compression of text columns
  108. Server misconfiguration???
  109. What's the cost of a few extra columns?
  110. Re: [HACKERS] A Better External Sort?
  111. Re: count(*) using index scan in "query often, update rarely" environment
  112. Re: Status of Opteron vs Xeon
  113. count(*) using index scan in "query often, update rarely" environment
  114. Status of Opteron vs Xeon
  115. Need Some Suggestions
  116. Re: [HACKERS] A Better External Sort?
  117. functions and execution plan caching
  118. Re: Ultra-cheap NVRAM device
  119. Text/Varchar performance...
  120. Re: [HACKERS] A Better External Sort?
  121. Re: Is There Any Way ....
  122. Re: [HACKERS] A Better External Sort?
  123. Re: Indexes on ramdisk
  124. Re: Is There Any Way ....
  125. wal_buffers
  126. Re: SELECT LIMIT 1 VIEW Performance Issue
  127. Re: [HACKERS] A Better External Sort?
  128. Re: Query in SQL statement
  129. Re: Query in SQL statement
  130. Re: Is There Any Way ....
  131. Re: Is There Any Way ....
  132. Indexes on ramdisk
  133. Re: Is There Any Way ....
  134. Re: [HACKERS] A Better External Sort?
  135. Re: [HACKERS] A Better External Sort?
  136. Re: [HACKERS] A Better External Sort?
  137. Re: Ultra-cheap NVRAM device
  138. Alternative to a temporary table
  139. index on custom function; explain
  140. Ultra-cheap NVRAM device
  141. Which one FreeBSD or Linux
  142. Re: [HACKERS] Query in SQL statement
  143. Re: [HACKERS] A Better External Sort?
  144. Re: [HACKERS] A Better External Sort?
  145. Lists or external TABLE?
  146. Re: Comparative performance
  147. Re: [HACKERS] A Better External Sort?
  148. Re: [HACKERS] A Better External Sort?
  149. Re: [HACKERS] A Better External Sort?
  150. Is There Any Way ....
  151. How to Trigger An Automtic Vacuum on Selected Tables
  152. SQL Function performance
  153. Re: [HACKERS] A Better External Sort?
  154. Re: [HACKERS] Query in SQL statement
  155. Re: Sequential I/O Cost (was Re: A Better External Sort?)
  156. Re: Comparative performance
  157. Re: [HACKERS] A Better External Sort?
  158. Comparative performance
  159. Re: [HACKERS] A Better External Sort?
  160. Re: [HACKERS] A Better External Sort?
  161. Re: Logarithmic change (decrease) in performance
  162. Logarithmic change (decrease) in performance
  163. Re: [HACKERS] A Better External Sort?
  164. Monitoring Postgresql performance
  165. Slow concurrent update of same row in a given table
  166. database bloat, but vacuums are done, and fsm seems to be setup ok
  167. The need for full vacuum / reindex
  168. Re: [HACKERS] A Better External Sort?
  169. Re: [HACKERS] A Better External Sort?
  170. PostgreSQL overall design
  171. Index not used on group by
  172. Re: [HACKERS] A Better External Sort?
  173. Re: [HACKERS] A Better External Sort?
  174. Re: [GENERAL] Index use in BETWEEN statement...
  175. [HACKERS] A Better External Sort?
  176. int2 vs int4 in Postgres
  177. Re: Advice on RAID card
  178. Query seem to slow if table have more than 200 million rows
  179. Re: Advice on RAID card
  180. Multiple insert performance trick or performance misunderstanding?
  181. Re: Advice on RAID card
  182. Re: [HACKERS] Releasing memory during External sorting?
  183. Index use in BETWEEN statement...
  184. Re: Releasing memory during External sorting?
  185. Re: Releasing memory during External sorting?
  186. Re: Releasing memory during External sorting?
  187. slow database, queries accumulating
  188. Re: [HACKERS] Releasing memory during External sorting?
  189. Re: SELECT LIMIT 1 VIEW Performance Issue
  190. Re: tsearch2 seem very slow
  191. How to determine cause of performance problem?
  192. optimization downgrade perfomance?
  193. tsearch2 seem very slow
  194. FW: Deadlock Issue with PostgreSQL
  195. Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
  196. Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
  197. Fw: Queries 15 times slower on 8.1 beta 2 than on 8.0
  198. Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
  199. Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
  200. Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
  201. Queries 15 times slower on 8.1 beta 2 than on 8.0
  202. Re: SELECT LIMIT 1 VIEW Performance Issue
  203. Re: SELECT LIMIT 1 VIEW Performance Issue
  204. Re: SELECT LIMIT 1 VIEW Performance Issue
  205. Query slower on 8.0.3 (Windows) vs 7.3 (cygwin)
  206. Re: Deadlock Issue with PostgreSQL
  207. unsubscribe
  208. Re: RAID Stripe size
  209. unsubscribe
  210. Index Selection: ORDER BY vs. PRIMARY KEY
  211. Nested Loop trouble : Execution time increases more 1000 time (long)
  212. How can this be?
  213. Test. Sorry.
  214. RAID Stripe size
  215. Re: [ODBC] ODBC Driver on Windows 64 bit
  216. Re: Battery Backed Cache for RAID
  217. Re: Battery Backed Cache for RAID
  218. Battery Backed Cache for RAID
  219. Re: Low performance on Windows problem
  220. Re: Low performance on Windows problem
  221. Any other idea for better performance?
  222. About method of PostgreSQL's Optimizer
  223. Help with performance on current status column
  224. How many tables is too many tables?
  225. unsubscribe
  226. Re: Low performance on Windows problem
  227. Re: Low performance on Windows problem
  228. Re: Low performance on Windows problem
  229. Re: Low performance on Windows problem
  230. Opencms6 ans Postgres8
  231. Low performance on Windows problem
  232. Re: Performance considerations for very heavy INSERT
  233. Performance considerations for very heavy INSERT traffic
  234. Slow update
  235. LEFT JOIN optimization
  236. Index not used with prepared statement
  237. performance discrepancy indexing one column versus two columns
  238. CHECK vs REFERENCES
  239. Too slow query, do you have an idea to optimize?
  240. please comment on cpu 32 bit or 64 bit
  241. Query take 101 minutes, help, please
  242. Re: insert performance for win32
  243. Re: insert performance for win32
  244. log_duration times
  245. Re: insert performance for win32
  246. Re: insert performance for win32
  247. Poor performance of delete by primary key
  248. Re: insert performance for win32
  249. Re: Improving performance of a query
  250. insert performance for win32