PDA

View Full Version : Pgsql Performance

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 [14] 15 16
  1. Disk filling, CPU filling, renegade inserts and deletes?
  2. postgres slowdown question
  3. Re: How to improve db performance with $7K?
  4. Re: How to improve db performance with $7K?
  5. Re: How to improve db performance with $7K?
  6. Re: Opteron vs Xeon (Was: What to do with 6 disks?)
  7. Re: How to improve db performance with $7K?
  8. Re: Opteron vs Xeon (Was: What to do with 6 disks?)
  9. When are index scans used over seq scans?
  10. How to tell what your postgresql server is doing
  11. Slow copy with little CPU/disk usage
  12. Re: [HACKERS] PLM pulling from CVS nightly for testing in STP
  13. Re: Bad n_distinct estimation; hacks suggested?
  14. Bad n_distinct estimation; hacks suggested?
  15. Re: How to improve db performance with $7K?
  16. Re: How to improve db performance with $7K?
  17. Re: How to improve db performance with $7K?
  18. Re: How to improve db performance with $7K?
  19. Re: postgresql faster in Linux than FreeBSD?
  20. Re: Question on REINDEX
  21. Re: Foreign key slows down copy/insert
  22. Question on vacuumdb
  23. Question on REINDEX
  24. Re: How to improve db performance with $7K?
  25. Re: Sort and index
  26. Sort and index
  27. Re: How to improve db performance with $7K?
  28. How to improve postgres performace
  29. Re: speed of querry?
  30. FW: speed of querry?
  31. FW: speed of querry?
  32. FW: speed of querry?
  33. Re: immutable functions vs. join for lookups ?
  34. UNSUBSCRIBE
  35. Postgresql works too slow
  36. refcurosr vs. setof
  37. pgbench Comparison of 7.4.7 to 8.0.2
  38. immutable functions vs. join for lookups ?
  39. Re: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How
  40. Re: How to improve db performance with $7K?
  41. Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How to Improve w/7K$?
  42. Re: Intel SRCS16 SATA raid?
  43. Re: Intel SRCS16 SATA raid?
  44. plperl vs plpgsql
  45. Re: 8.0.1 much slower than 7.4.2?
  46. Re: speed of querry?
  47. Re: How to improve db performance with $7K?
  48. Re: How to improve db performance with $7K?
  49. Re: How to improve db performance with $7K?
  50. Re: [Fwd: Re: Functionscan estimates]
  51. Re: Intel SRCS16 SATA raid?
  52. Re: How to improve db performance with $7K?
  53. recovery after long delete
  54. Re: Intel SRCS16 SATA raid?
  55. Re: How to improve db performance with $7K?
  56. Intel SRCS16 SATA raid?
  57. Foreign key slows down copy/insert
  58. Use of data within indexes
  59. Problem with slow query (caused by improper nestloop?)
  60. Foreign keys and partial indexes
  61. speed of querry?
  62. Re: performance hit for replication
  63. Re: [NOVICE] Many connections lingering
  64. Re: 4 way JOIN using aliases
  65. performance hit for replication
  66. Slow update
  67. Re: 4 way JOIN using aliases
  68. profiling postgresql queries?
  69. Is there somthing I need to do on my production server?
  70. Re: performance - triggers, row existence etc.
  71. Re: Never ending delete story
  72. Re: Is Indexed View Supported in psql 7.1.3??
  73. Re: Is Indexed View Supported in psql 7.1.3??
  74. Re: help on explain analyse
  75. Server crashing
  76. performance - triggers, row existence etc.
  77. Functionscan estimates
  78. Building postmaster with Profiling Support WAS "Tweaking a C Function I wrote"
  79. Any way to speed this up?
  80. 4 way JOIN using aliases
  81. help on time calculation
  82. help on explain analyse in psql 7.1.3 (linux)
  83. Tweaking a C Function I wrote
  84. Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?)
  85. Re: Plan for relatively simple query seems to be very inefficient
  86. =?iso-8859-1?Q?R=E9f=2E_=3A_Re=3A_RE_=3A_RE=3A__Postgresql_vs ?=SQLserver for this
  87. Plan for relatively simple query seems to be very inefficient
  88. Re: RE : RE: Postgresql vs SQLserver for thisapplication ?
  89. Re: RE : RE: Postgresql vs SQLserver for this application ?
  90. Re: RE : RE: Postgresql vs SQLserver for this application ?
  91. RE : RE: Postgresql vs SQLserver for this application ?
  92. Compressing WAL
  93. Bulk COPY end of copy delimiter
  94. 8.0.1 performance question.
  95. Postgresql vs SQLserver for this application ?
  96. Correcting Hash Join Estimates
  97. Sustained inserts per sec ... ?
  98. Re: enable_XXX options
  99. Triggers with FOR EACH STATEMENT
  100. enable_XXX options
  101. Tuning PostgreSQL
  102. date - range
  103. How to speed up word count in tsearch2?
  104. Postgresql.conf setting recommendations for 8.0.1
  105. Very long time to execute and Update, suggestions?
  106. How to speed up word count with tsearch2?
  107. fine tuning for logging server
  108. Re: Reading recommendations
  109. Left Outer Join much faster than non-outer Join?
  110. Re: Weird index scan
  111. Dynamic query perormance
  112. Re: Reading recommendations
  113. Re: Reading recommendations
  114. Weird index scan
  115. Reading recommendations
  116. VACUUM on duplicate DB gives FSM and total pages discrepancies
  117. Million of rows
  118. Re: Delete query takes exorbitant amount of time
  119. coalesce alternative
  120. JDBC best practice
  121. Re: Delete query takes exorbitant amount of time
  122. Re: Delete query takes exorbitant amount of time
  123. Sluggish server performance
  124. Re: Delete query takes exorbitant amount of time
  125. NFS RAID 0/5
  126. Re: [BUGS] BUG #1552: massive performance hit between 7.4
  127. Re: How to improve db performance with $7K?
  128. How to improve db performance with $7K?
  129. Re: [BUGS] BUG #1552: massive performance hit
  130. Delete query takes exorbitant amount of time
  131. Configuration/Tuning of server/DB
  132. Preventing query from hogging server
  133. pg_autovacuum not having enough suction ?
  134. Re: View columns calculated
  135. Query Optimizer Failure / Possible Bug
  136. SQL function inlining (was: View vs function)
  137. Hardware questions
  138. Re: What about utility to calculate planner cost constants?
  139. Re: What about utility to calculate planner cost constants?
  140. PostgreSQL on Solaris 8 and ufs
  141. Re: [ADMIN] Too slow
  142. CPU 0.1% IOWAIT 99% for decisonnal queries
  143. Planner issue
  144. Tsearch2 performance on big database
  145. best practices with index on varchar column
  146. What about utility to calculate planner cost constants?
  147. Re: Hardware impact on performances
  148. View vs function
  149. What needs to be done for real Partitioning?
  150. Building a DB with performance in mind
  151. queries on huge tables
  152. TOP 10 SQL commands and more
  153. 2 rows expected on a primary key
  154. Join method influences scan method?
  155. Help to find out problem with joined tables
  156. Re: Speeding up select distinct
  157. Re: Speeding up select distinct
  158. Speeding up select distinct
  159. multi-column index
  160. Which one is faster: one way reading ="single pass reading"
  161. Re: cpu_tuple_cost
  162. Re: Slow loads when indexes added.
  163. Performance problem on delete from for 10k rows. May takes 20 minutesthrough JDBC interface
  164. Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
  165. interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
  166. Re: One tuple per transaction
  167. Re: One tuple per transaction
  168. Re: cpu_tuple_cost
  169. Re: Postgres on RAID5
  170. Bad Performance[2]
  171. column name is "LIMIT"
  172. Postgres on RAID5
  173. Re: Postgres on RAID5
  174. Re: One tuple per transaction
  175. How to read query plan
  176. Re: Index use and slow queries
  177. One tuple per transaction
  178. Postgres on RAID5
  179. Re: Questions about 2 databases.
  180. Re: Query performance
  181. Re: Query performance
  182. Query performance
  183. Performance tuning
  184. cpu_tuple_cost
  185. What is the number of rows in explain?
  186. Statistics not working??
  187. more execution time
  188. What's better: Raid 0 or disk for seperate pg_xlog
  189. Multi-line requests in COPY ... FROM STDIN
  190. How to speed up tsearch2 indexing
  191. 64bit Opteron multi drive raid. Help with best config settings
  192. vacuum full, why multiple times ?
  193. Query Optimization
  194. Why would writes to pgsql_tmp bottleneck at 1mb/s?
  195. index scan on =, but not < ?
  196. pl/pgsql faster than raw SQL?
  197. bad plan
  198. Re: [pgsql-hackers-win32] Help with tuning this query (with
  199. performance problems
  200. Help with slow running query
  201. Re: [pgsql-hackers-win32] Help with tuning this query (with
  202. Re: [pgsql-hackers-win32] Help with tuning this query (with
  203. Re: [pgsql-hackers-win32] Help with tuning this query (with
  204. adding 'limit' leads to very slow query
  205. Re: [pgsql-hackers-win32] Help with tuning this query (with explain analyze finally)
  206. Re: [pgsql-hackers-win32] Help with tuning this query (with
  207. Re: Tuning, configuration for 7.3.5 on a Sun E4500
  208. Help trying to tune query that executes 40x slower than in SqlServer
  209. Re: [pgsql-hackers-win32] Help with tuning this query (with explain analyze finally)
  210. Re: [pgsql-hackers-win32] Help with tuning this query (with explain analyze finally)
  211. How to Partition?
  212. MAIN vs. PLAIN
  213. Select in FOR LOOP Performance
  214. Query's fast standalone - slow as a subquery.
  215. Re: name search query speed
  216. name search query speed
  217. Re: Help with tuning this query (with explain analyze finally)
  218. Performance tradeoff
  219. Help with tuning this query
  220. What is the postgres sql command for last_user_id ???
  221. Confusion about locales and 'like' indexes
  222. Re: multi billion row tables: possible or insane?
  223. multi billion row tables: possible or insane?
  224. Inheritence versus delete from
  225. wal_sync_methods
  226. PG block sizes
  227. Possible interesting extra information for explain analyze?
  228. Re: Peformance Tuning Opterons/ Hard Disk Layout
  229. IS NULL vs IS NOT NULL
  230. gah! sudden slowdown??
  231. Peformance Tuning Opterons/ Hard Disk Layout
  232. Re: Peformance Tuning Opterons/ Hard Disk Layout
  233. Re: Problem with 7.4.5 and webmin 1.8 in grant function
  234. Peformance Tuning Opterons/ Hard Disk Layout
  235. Re: PostgreSQL is extremely slow on Windows
  236. Re: PostgreSQL is extremely slow on Windows
  237. Re: Help me please !
  238. Re: Joins, Deletes and Indexes
  239. Re: PostgreSQL is extremely slow on Windows
  240. Re: Help me please !
  241. join vs. subquery
  242. subquery vs join on 7.4.5
  243. PostgreSQL is extremely slow on Windows
  244. Joins, Deletes and Indexes
  245. Inefficient Query Plans
  246. is pg_autovacuum so effective ?
  247. Re: PostgreSQL is extremely slow on Windows
  248. PostgreSQL is extremely slow on Windows
  249. Re: seq scan cache vs. index cache smackdown
  250. Re: seq scan cache vs. index cache smackdown