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: Postgre SQL 7.1 cygwin performance issue.
  2. [8.1.4] Help optimizing query
  3. stats reset during pg_restore?
  4. Changing max_connections without restart ?
  5. Related to Inserting into the database from XML file
  6. select max(column) from parent table very slow
  7. adtx
  8. Is this way of testing a bad idea?
  9. Re: Query tuning
  10. Which benchmark to use for testing FS?
  11. Re: Query tuning
  12. Heavy load and slow queries
  13. Re: Query tuning
  14. Moving a tablespace
  15. Query tuning
  16. PowerEdge 2950 questions
  17. Benchmarks
  18. VACUUM FULL needed sometimes to prevent transaction ID wraparound?
  19. query planner: automatic rescribe of LIKE to BETWEEN ?
  20. Re: How to get higher tps
  21. Re: Vacuum not identifying rows for removal..
  22. Re: How to get higher tps
  23. Re: How to get higher tps
  24. Postgre SQL 7.1 cygwin performance issue.
  25. Re: Storage Options
  26. Forcing index usage without 'enable_hashjoin = FALSE'
  27. Re: Big diference in response time (query plan question)
  28. Big diference in response time (query plan question)
  29. Re: Dell PowerEdge 2950 performance
  30. Inner Join of the same table
  31. Re: Dell PowerEdge 2950 performance
  32. Re: setting up foreign keys
  33. Re: slow transfer speeds with PostgreSQL
  34. Re: slow transfer speeds with PostgreSQL
  35. Re: slow transfer speeds with PostgreSQL
  36. Re: [BUGS] BUG #2567: High IOWAIT
  37. Slow access to PostgreSQL server
  38. Re: Beginner optimization questions, esp. regarding Tsearch2
  39. setting up foreign keys
  40. Dell PowerEdge 2950 performance
  41. 3-table query optimization
  42. unsubscribe
  43. Re: Postgresql Performance on an HP DL385 and
  44. Re: Postgresql Performance on an HP DL385 and
  45. Re: Postgresql Performance on an HP DL385 and
  46. Re: Postgresql Performance on an HP DL385 and
  47. most bang for buck with ~ $20,000
  48. Optimizing queries
  49. Re: Postgresql Performance on an HP DL385 and
  50. shared_buffer optimization
  51. vacuuming
  52. Postgresql Performance on an HP DL385 and SmartArray 642
  53. Hardware upgraded but performance still ain't good enough
  54. Re: [NOVICE] 7.3.2 pg_restore very slow
  55. Re: [NOVICE] 7.3.2 pg_restore very slow
  56. Slow transfer speeds
  57. Re: 7.3.2 pg_restore very slow
  58. High Context-Switches on Linux 8.1.4 Server
  59. Query Plan - Bitmap Index Scan and Views
  60. Re: RAID stripe size question
  61. Migrating data from DB2 to SQL Server
  62. Re:
  63. Re:
  64. unsubscribe
  65. Re: XFS filessystem for Datawarehousing
  66. Re: RAID stripe size question
  67. Re: XFS filessystem for Datawarehousing
  68. FW: XFS filessystem for Datawarehousing -2
  69. XFS filessystem for Datawarehousing
  70. How to speed up this "translation" query?
  71. Query/database optimization
  72. Re: Performances with new Intel Core* processors
  73. Are there any performance penalty for opposite edian platform combinations....
  74. Performances with new Intel Core* processors
  75. Partitioning / constrain exlusion not working with %-operator
  76. directory tree query with big planner variation
  77. Query 200x slower on server [PART 2]
  78. Strange behaviour
  79. How to increase performance?
  80. sub select performance due to seq scans
  81. Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
  82. PostgreSQL scalability on Sun UltraSparc T1
  83. Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
  84. Re: index usage
  85. index usage
  86. Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
  87. Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
  88. Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
  89. Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
  90. Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
  91. Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200
  92. Disk writes
  93. Savepoint performance
  94. performance issue with a specific query
  95. Is it possible to speed this query up?
  96. loading increase into huge table with 50.000.000 records
  97. Re: BUG #2543: Performance delay acrros the same day
  98. Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
  99. Partitioned tables in queries
  100. Bad Planner Statistics for Uneven distribution.
  101. postgres benchmarks
  102. Re: Forcing using index instead of sequential scan?
  103. Re: Forcing using index instead of sequential scan?
  104. Forcing using index instead of sequential scan?
  105. There is a good photo website
  106. Performance penalty for remote access of postgresql (8.1.3)? any experiance?
  107. Re: RAID stripe size question
  108. Re: RAID stripe size question
  109. Re: RAID stripe size question
  110. Temporary table retains old contents on update eventually causing slow temp file usage.
  111. Re: Temporary table retains old contents on update eventually causing slow temp file usage.
  112. Re: RAID stripe size question
  113. Re: RAID stripe size question
  114. Re: RAID stripe size question
  115. Re: RAID stripe size question
  116. Re: RAID stripe size question
  117. Re: RAID stripe size question
  118. RAID stripe size question
  119. increment Rows in an SQL Result Set postgresql
  120. Big differences in plans between 8.0 and 8.1
  121. Self-join query and index usage
  122. Re: hyper slow after upgrade to 8.1.4
  123. PostgreSQL performance charts/comparison
  124. Re: hyper slow after upgrade to 8.1.4
  125. Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
  126. Re: Commit slower on faster PC
  127. hyper slow after upgrade to 8.1.4
  128. [Fwd: Delivery Status Notification (Failure)]
  129. size of pg_dump files containing bytea values
  130. Commit slower on faster PC
  131. Performance Problem between Ora 10g and Psql
  132. Out of Memory Problem.
  133. =?iso-8859-1?Q?Unsubscribe?=
  134. Kill a session
  135. High CPU Usage - PostgreSQL 7.3
  136. VACUUM vs. REINDEX
  137. Delete is very slow; PG not using existing index to check foreign keys
  138. Re: suggested RAID controller for FreeBSD 6.1 +
  139. longest prefix match querries
  140. Update INSERT RULE while running for Partitioning
  141. Query plan issue when upgrading to postgres 8.14 (from postgres 8.12 or 7.4)
  142. Query plan issue when upgrading to postgres 8.14 (from postgres 8.12 or 7.4)
  143. Update Statement Very Slow
  144. victory!
  145. unsubscribe
  146. unsubscribe
  147. getting better performance
  148. suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1
  149. Opteron/FreeBSD/PostgreSQL performance poor
  150. managing database with thousands of tables
  151. Problem with bitmap-index-scan plan
  152. how to tune this query.
  153. Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode?
  154. Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode?
  155. optimizing LIKE '%2345' queries
  156. Re: [pgadmin-support] 100% CPU
  157. Re: FWD: Update touches unrelated indexes?
  158. newly created database makes queries run 300% faster
  159. Index Being Ignored?
  160. FWD: Update touches unrelated indexes?
  161. Sort order in sub-select
  162. Calling a SP from Curosor loop
  163. unregister
  164. unregister
  165. Large index scan perfomance and indexCorrelation (PG 8.1.4 Win32)
  166. unsubscribe
  167. Re: Occupation bloc in pages of table
  168. Re: Occupation bloc in pages of table
  169. Re: Occupation bloc in pages of table
  170. Temporary table
  171. Occupation bloc in pages of table
  172. why group expressions cause query to run forever
  173. Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL
  174. Tuning New Server (slow function)
  175. Tuning New Server (slow function)
  176. Why is my (empty) partial index query slow?
  177. Regarding ERROR: fmgr_info: function 2720768: cache lookup failed
  178. Poor performance - fixed by restart
  179. Tuning New Server (slow function)
  180. Quick question about top...
  181. Performance of DOMAINs
  182. Speeding up query, Joining 55mil and 43mil records.
  183. Help tuning autovacuum - seeing lots of relation bloat
  184. MAKE UNLIMITED MONEY USING PAYPAL!!! $5.00 ONE TIME FEE!!!
  185. ACL cleanup
  186. Curson prbolem
  187. Big array speed issues
  188. Some performance numbers, with thoughts
  189. Re: Question about clustering multiple columns
  190. Re: SAN performance mystery
  191. Delete operation VERY slow...
  192. SAN performance mystery
  193. Optimizer internals
  194. How to analyze function performance
  195. Re: Is it possible to start two instances of postgresql?
  196. Re: Is it possible to start two instances of postgresql?
  197. Is it possible to start two instances of postgresql?
  198. Postgres fsync off (not needed) with NetApp
  199. Re: Which processor runs better for Postgresql?
  200. Postgres consuming way too much memory???
  201. Re: Which processor runs better for Postgresql?
  202. Performance of pg_dump on PGSQL 8.0
  203. Precomputed constants?
  204. how to partition disks
  205. Re: Which processor runs better for Postgresql?
  206. Which processor runs better for Postgresql?
  207. Confirmation of bad query plan generated by 7.4 tree
  208. OT - select + must have from - sql standard syntax?
  209. 64-bit vs 32-bit performance ... backwards?
  210. Posrgres speed problem
  211. function not called if part of aggregate
  212. Variation between query runtimes
  213. pg_xlog on data partition with BBU RAID
  214. pgsql_tmp and postgres settings
  215. Why date index is not used
  216. JOIN with inherited table ignores indexes
  217. Regarding pg_dump utility
  218. Curious sorting puzzle
  219. Regarding ALTER Command
  220. Problem: query becomes slow when calling a fast user defined function.
  221. How to force Postgres to use index on ILIKE
  222. Some queries starting to hang
  223. psql -A (unaligned format) eats too much memory
  224. Re: psql -A (unaligned format) eats too much memory
  225. INSERT OR UPDATE WITHOUT SELECT
  226. Re: =?utf-8?B?UsOpcG9uZHJl?=
  227. scaling up postgres
  228. Initial database loading and IDE x SCSI
  229. help me problems with pg_clog file
  230. vacuuming problems continued
  231. Re: Optimizing a huge_table/tiny_table join
  232. INSERT OU UPDATE WITHOUT SELECT?
  233. Split select completes, single select doesn't and becomes IO bound!
  234. Bulk loading/merging
  235. Why the 8.1 plan is worst than 7.4?
  236. Re: pg_dump issue
  237. Re: Adding and filling new column on big table
  238. Re: pg_dump issue
  239. pg_dump issue
  240. Speedup hint needed, if available? :)
  241. select with "like" from another table
  242. App very unresponsive while performing simple update
  243. column totals
  244. is it possible to make this faster?
  245. Re: Optimizing a huge_table/tiny_table join
  246. lowering priority automatically at connection
  247. Optimizing a huge_table/tiny_table join
  248. Re: Getting even more insert performance (250m+rows/day)
  249. Re: Getting even more insert performance (250m+rows/day)
  250. Getting even more insert performance (250m+rows/day)