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: Tuning planner cost estimates
  2. Re: [pgsql-benchmarks] Error when try installing pgbench ?
  3. Why is it taking so long?
  4. checkpoint segments
  5. Re: Swapping and Kernel 2.6
  6. Postgresql Performance via the LSI MegaRAID 2x Card
  7. Re: Whence the Opterons?
  8. Re: ok you all win what is best opteron (I dont want a hosed system again)
  9. ok you all win what is best opteron (I dont want a hosed system again)
  10. PostgreSQL strugling during high load
  11. Recommendations for set statistics
  12. Optimize complex join to use where condition before join
  13. Re: Partitioning / Clustering
  14. tuning Postgres for large data import (using Copy from)
  15. AND OR combination: index not being used
  16. Bad plan after vacuum analyze
  17. Optimizer wrongly picks Nested Loop Left Join
  18. Re: Prefetch - OffTopic
  19. Prefetch - OffTopic
  20. =?iso-8859-1?Q?RE:__Partitioning_/_Clustering?=
  21. Prefetch
  22. Partitioning / Clustering
  23. full outer performance problem
  24. Configing 8 gig box.
  25. Re: Whence the Opterons?
  26. Re: PGSQL Capacity
  27. PGSQL Capacity
  28. Re: Whence the Opterons?
  29. Re: Whence the Opterons?
  30. "Hash index" vs. "b-tree index" (PostgreSQL 8.0)
  31. Query tuning help
  32. sequence scan on PK
  33. Whence the Opterons?
  34. Re: [SQL] ORDER BY Optimization
  35. Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1
  36. Table stats
  37. Kernel Resources Solved
  38. Kernel Resources and max_connections
  39. Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1b
  40. Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 2
  41. Re:
  42. Re: batch inserts are "slow"
  43. Re: batch inserts are "slow"
  44. batch inserts are "slow"
  45. index on different types
  46. Re: Final decision
  47. Re: Why is this system swapping?
  48. Re: Why is this system swapping?
  49. Re: Final decision
  50. Re: Why is this system swapping?
  51. Why is this system swapping?
  52. Re: Final decision
  53. Suggestions for a data-warehouse migration routine
  54. Re: [HACKERS] Bad n_distinct estimation; hacks suggested?
  55. Re: Final decision
  56. Final decision
  57. Re: [HACKERS] Bad n_distinct estimation; hacks suggested?
  58. Re: What needs to be done for real Partitioning?
  59. speed up query with max() and odd estimates
  60. Re: Table Partitioning: Will it be supported in Future?
  61. Re: two queries and dual cpu (perplexed)
  62. Re: two queries and dual cpu (perplexed)
  63. BLOB's bypassing the OS Filesystem for better Image loading speed?
  64. Table Partitioning: Will it be supported in Future? (splitting largeTables)
  65. half the query time in an unnecessary(?) sort?
  66. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  67. Re: [ODBC] Joel's Performance Issues WAS : Opteron vs Xeon
  68. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  69. flattening the file might work for me here is the analyze.
  70. Interesting numbers on a CREATE INDEX
  71. Updating table, precautions?
  72. Re: two queries and dual cpu (perplexed)
  73. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  74. Re: two queries and dual cpu (perplexed)
  75. foreign key performance
  76. Re: Index bloat problem?
  77. Re: index not used
  78. index not used
  79. Re: Index bloat problem?
  80. Re: Index bloat problem?
  81. Index bloat problem?
  82. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  83. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  84. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  85. two queries and dual cpu (perplexed)
  86. How can an index be larger than a table
  87. Re: postgres slowdown question
  88. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  89. Disk filling, CPU filling, renegade inserts and deletes?
  90. postgres slowdown question
  91. Re: How to improve db performance with $7K?
  92. Re: How to improve db performance with $7K?
  93. Re: How to improve db performance with $7K?
  94. Re: Opteron vs Xeon (Was: What to do with 6 disks?)
  95. Re: How to improve db performance with $7K?
  96. Re: Opteron vs Xeon (Was: What to do with 6 disks?)
  97. When are index scans used over seq scans?
  98. How to tell what your postgresql server is doing
  99. Slow copy with little CPU/disk usage
  100. Re: [HACKERS] PLM pulling from CVS nightly for testing in STP
  101. Re: Bad n_distinct estimation; hacks suggested?
  102. Bad n_distinct estimation; hacks suggested?
  103. Re: How to improve db performance with $7K?
  104. Re: How to improve db performance with $7K?
  105. Re: How to improve db performance with $7K?
  106. Re: How to improve db performance with $7K?
  107. Re: postgresql faster in Linux than FreeBSD?
  108. Re: Question on REINDEX
  109. Re: Foreign key slows down copy/insert
  110. Question on vacuumdb
  111. Question on REINDEX
  112. Re: How to improve db performance with $7K?
  113. Re: Sort and index
  114. Sort and index
  115. Re: How to improve db performance with $7K?
  116. How to improve postgres performace
  117. Re: speed of querry?
  118. FW: speed of querry?
  119. FW: speed of querry?
  120. FW: speed of querry?
  121. Re: immutable functions vs. join for lookups ?
  122. UNSUBSCRIBE
  123. Postgresql works too slow
  124. refcurosr vs. setof
  125. pgbench Comparison of 7.4.7 to 8.0.2
  126. immutable functions vs. join for lookups ?
  127. Re: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How
  128. Re: How to improve db performance with $7K?
  129. Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How to Improve w/7K$?
  130. Re: Intel SRCS16 SATA raid?
  131. Re: Intel SRCS16 SATA raid?
  132. plperl vs plpgsql
  133. Re: 8.0.1 much slower than 7.4.2?
  134. Re: speed of querry?
  135. Re: How to improve db performance with $7K?
  136. Re: How to improve db performance with $7K?
  137. Re: How to improve db performance with $7K?
  138. Re: [Fwd: Re: Functionscan estimates]
  139. Re: Intel SRCS16 SATA raid?
  140. Re: How to improve db performance with $7K?
  141. recovery after long delete
  142. Re: Intel SRCS16 SATA raid?
  143. Re: How to improve db performance with $7K?
  144. Intel SRCS16 SATA raid?
  145. Foreign key slows down copy/insert
  146. Use of data within indexes
  147. Problem with slow query (caused by improper nestloop?)
  148. Foreign keys and partial indexes
  149. speed of querry?
  150. Re: performance hit for replication
  151. Re: [NOVICE] Many connections lingering
  152. Re: 4 way JOIN using aliases
  153. performance hit for replication
  154. Slow update
  155. Re: 4 way JOIN using aliases
  156. profiling postgresql queries?
  157. Is there somthing I need to do on my production server?
  158. Re: performance - triggers, row existence etc.
  159. Re: Never ending delete story
  160. Re: Is Indexed View Supported in psql 7.1.3??
  161. Re: Is Indexed View Supported in psql 7.1.3??
  162. Re: help on explain analyse
  163. Server crashing
  164. performance - triggers, row existence etc.
  165. Functionscan estimates
  166. Building postmaster with Profiling Support WAS "Tweaking a C Function I wrote"
  167. Any way to speed this up?
  168. 4 way JOIN using aliases
  169. help on time calculation
  170. help on explain analyse in psql 7.1.3 (linux)
  171. Tweaking a C Function I wrote
  172. Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?)
  173. Re: Plan for relatively simple query seems to be very inefficient
  174. =?iso-8859-1?Q?R=E9f=2E_=3A_Re=3A_RE_=3A_RE=3A__Postgresql_vs ?=SQLserver for this
  175. Plan for relatively simple query seems to be very inefficient
  176. Re: RE : RE: Postgresql vs SQLserver for thisapplication ?
  177. Re: RE : RE: Postgresql vs SQLserver for this application ?
  178. Re: RE : RE: Postgresql vs SQLserver for this application ?
  179. RE : RE: Postgresql vs SQLserver for this application ?
  180. Compressing WAL
  181. Bulk COPY end of copy delimiter
  182. 8.0.1 performance question.
  183. Postgresql vs SQLserver for this application ?
  184. Correcting Hash Join Estimates
  185. Sustained inserts per sec ... ?
  186. Re: enable_XXX options
  187. Triggers with FOR EACH STATEMENT
  188. enable_XXX options
  189. Tuning PostgreSQL
  190. date - range
  191. How to speed up word count in tsearch2?
  192. Postgresql.conf setting recommendations for 8.0.1
  193. Very long time to execute and Update, suggestions?
  194. How to speed up word count with tsearch2?
  195. fine tuning for logging server
  196. Re: Reading recommendations
  197. Left Outer Join much faster than non-outer Join?
  198. Re: Weird index scan
  199. Dynamic query perormance
  200. Re: Reading recommendations
  201. Re: Reading recommendations
  202. Weird index scan
  203. Reading recommendations
  204. VACUUM on duplicate DB gives FSM and total pages discrepancies
  205. Million of rows
  206. Re: Delete query takes exorbitant amount of time
  207. coalesce alternative
  208. JDBC best practice
  209. Re: Delete query takes exorbitant amount of time
  210. Re: Delete query takes exorbitant amount of time
  211. Sluggish server performance
  212. Re: Delete query takes exorbitant amount of time
  213. NFS RAID 0/5
  214. Re: [BUGS] BUG #1552: massive performance hit between 7.4
  215. Re: How to improve db performance with $7K?
  216. How to improve db performance with $7K?
  217. Re: [BUGS] BUG #1552: massive performance hit
  218. Delete query takes exorbitant amount of time
  219. Configuration/Tuning of server/DB
  220. Preventing query from hogging server
  221. pg_autovacuum not having enough suction ?
  222. Re: View columns calculated
  223. Query Optimizer Failure / Possible Bug
  224. SQL function inlining (was: View vs function)
  225. Hardware questions
  226. Re: What about utility to calculate planner cost constants?
  227. Re: What about utility to calculate planner cost constants?
  228. PostgreSQL on Solaris 8 and ufs
  229. Re: [ADMIN] Too slow
  230. CPU 0.1% IOWAIT 99% for decisonnal queries
  231. Planner issue
  232. Tsearch2 performance on big database
  233. best practices with index on varchar column
  234. What about utility to calculate planner cost constants?
  235. Re: Hardware impact on performances
  236. View vs function
  237. What needs to be done for real Partitioning?
  238. Building a DB with performance in mind
  239. queries on huge tables
  240. TOP 10 SQL commands and more
  241. 2 rows expected on a primary key
  242. Join method influences scan method?
  243. Help to find out problem with joined tables
  244. Re: Speeding up select distinct
  245. Re: Speeding up select distinct
  246. Speeding up select distinct
  247. multi-column index
  248. Which one is faster: one way reading ="single pass reading"
  249. Re: cpu_tuple_cost
  250. Re: Slow loads when indexes added.