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: Parrallel query execution for UNION ALL Queries
  2. How to use a trigger to write rows to a remote server
  3. Closed ports hanging around on Windows
  4. ionice to make vacuum friendier?
  5. importance of fast disks with pg
  6. insert vs select into performance
  7. large number of connected connections to postgres database (v8.0)
  8. Postgres configuration for 64 CPUs, 128 GB RAM...
  9. slony over VPN and LAN
  10. slony over LAN and VPN
  11. Vacuum full considered useful ;)
  12. FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
  13. Database Statistics???
  14. one column from huge view
  15. Estimating WAL volume
  16. TRUNCATE TABLE
  17. bitmap-index-scan slower than normal index scan
  18. Weird row estimate
  19. Two questions.. shared_buffers and long reader issue
  20. TIMING A QUERY ???
  21. WALL on controller without battery?
  22. Re: PostgreSQL publishes first real benchmark
  23. best use of an EMC SAN
  24. tuning a function to insert/retrieve values from a reference table
  25. Query Analyser
  26. PostgreSQL publishes first real benchmark
  27. Advice about how to delete
  28. Performance of PostgreSQL and Oracle
  29. Direct I/O
  30. Best query approach
  31. improvement suggestions for performance design
  32. Query is taking 5 HOURS to Complete on 8.1 version
  33. Filesystem Direct I/O and WAL sync option
  34. Delete Cascade FK speed issue
  35. poor use of indexes / feature: add OnlyUseIndex join/query plan hint?
  36. Join with lower/upper limits doesn't scale well
  37. kill off idle connections?
  38. Resource to learn code and share code and knowledge
  39. slow query
  40. [PERFORMANCE] is it possible to force an index to be held in memory?
  41. How to install Postgresql 8.2.x on windows XP silently
  42. Re: PostgreSQL 8.0 occasionally slow down
  43. PostgreSQL 8.0 occasionally slow down
  44. update query taking too long
  45. High IOWAIT times, low iops? Need Help with configuration
  46. rtree/gist index taking enormous amount of space in 8.2.3
  47. Re:
  48. Re:
  49. Non-optimal query plan with 8.2
  50. startup caching suggestions
  51. Is AIX Concurrent IO safe with PostgreSQL?
  52. Re: PREPARE and stuff
  53. PREPARE and stuff
  54. MI5 Persecution: Stasi 21/4/96 (16304)
  55. MI5 Persecution: Leant On 7/4/96 (14790)
  56. MI5 Persecution: Shoot to Kill 4/4/96 (13276)
  57. MI5 Persecution: Email Cruelty 11/3/96 (11762)
  58. MI5 Persecution: Jeff Rooker MP 5/3/96 (10248)
  59. MI5 Persecution: Flight or fight 7/1/96 (8734)
  60. MI5 Persecution: A new Kafka? 3/10/95 (5706)
  61. MI5 Persecution: Do they fear truth? 3/10/95 (4192)
  62. MI5 Persecution: Grievous Bodily Harm 2/10/95 (2678)
  63. MI5 Persecution: Goldfish and Piranha 29/9/95 (1164)
  64. Slow join query
  65. PITR Backups
  66. Very long SQL strings
  67. Database-wide VACUUM ANALYZE
  68. vacuum a lot of data when insert only
  69. Data transfer very slow when connected via DSL
  70. Slow indexscan
  71. cached entities
  72. Short row header
  73. to partition or not to partition
  74. PostgreSQL Configuration Tool for Dummies
  75. PostgreSQL Configuration Tool for Dummies
  76. PostgreSQL Configuration Tool for Dummies
  77. Maintenance question / DB size anomaly...
  78. Hardware suggestions
  79. Regarding Timezone
  80. Performance query about large tables, lots of concurrent access
  81. Re: [ADMIN] Postgres VS Oracle
  82. Volunteer to build a configuration tool
  83. determining maxsize for character varying
  84. Re: Replication
  85. Variable (degrading) perfomance
  86. Replication
  87. Replication
  88. Parsing VACUUM VERBOSE
  89. Update table performance problem
  90. [PG 8.1.0 / AIX 5.3] Vacuum processes freezing
  91. WAL shipping and ever expanding pg_xlog
  92. Optimize slow query
  93. Performance Testing Utility
  94. VACUUM vs auto-vacuum daemon
  95. How much memory PostgreSQL is going to use?
  96. Re: test / live environment, major performance difference
  97. Best use of second controller with faster disks?
  98. Variable (degrading) performance
  99. test / live environment, major performance difference
  100. pg_statistic doesnt contain details for specific table
  101. How much ram is too much
  102. Please help me understand these numbers
  103. Re: [ADMIN] reclaiming disk space after major updates
  104. MI5 Persecution: Goldfish and Piranha 29/9/95 (5706)
  105. MI5 Persecution: Watch Out, Forger About 27/9/95 (4192)
  106. MI5 Persecution: Question and Answer 27/9/95 (2678)
  107. MI5 Persecution: Options 21/9/95 (1164)
  108. Database size
  109. Best way to delete unreferenced rows?
  110. Getting Slow
  111. How Are The Variables Related?
  112. copy from performance on large tables with indexes
  113. Weird 8.2.4 performance
  114. Is this true?
  115. VERY slow queries at random
  116. pgsql performance
  117. weird query plan
  118. MARS in SQL Server 2005
  119. Performance Problem
  120. Performance Problem
  121. Question about SQL performance
  122. postgresql running on a virtual cluster
  123. PostgreSQL not fully utilizing system resources?
  124. Thousands of tables versus on table?
  125. dbt2 NOTPM numbers
  126. Auto Vacuum question?
  127. Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  128. Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  129. upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
  130. Seq Scan
  131. Some info to share: db_STRESS Benchmark results
  132. DB cluster sharing between 32 and 64 bit software versions
  133. Re: Append table
  134. Database connection for Tbl_B established
  135. Re: setting up raid10 with more than 4 drives
  136. Bad RAID1 read performance
  137. Very slow left outer join
  138. setting up raid10 with more than 4 drives
  139. Vacuum takes forever
  140. PITR performance costs
  141. Peformance Tuning using INCLUDE index
  142. ECC RAM really needed?
  143. Adding disks/xlog & index
  144. Re: general PG network slowness (possible cure) (repost)
  145. Performance problem on 8.2.4, but not 8.2.3
  146. Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13))
  147. Re: general PG network slowness (possible cure) (repost)
  148. Big problem with sql update operation
  149. How PostgreSQL handles multiple DDBB instances?
  150. Performance Problem with Vacuum of bytea table (PG 8.0.13)
  151. general PG network slowness (possible cure) (repost)
  152. Memory allocation and Vacuum abends
  153. Auto-ANALYZE?
  154. Re: Drop table vs Delete record
  155. Re: does VACUUM ANALYZE complete with this error?
  156. Simulate database fragmentation
  157. Re: does VACUUM ANALYZE complete with this error?
  158. max_fsm_pages, shared_buffers and checkpoint_segments
  159. LIKE search and performance
  160. does VACUUM ANALYZE complete with this error?
  161. Become MCSD Certified
  162. Re: Tips & Tricks for validating hardware/os
  163. Re: Drop table vs Delete record
  164. Drop table vs Delete record
  165. Domains versus Check Constraints
  166. Tips & Tricks for validating hardware/os
  167. Performace comparison of indexes over timestamp fields
  168. is file size relevant in choosing index or table scan?
  169. Key/Value reference table generation: INSERT/UPDATE performance
  170. Feature suggestion : FAST CLUSTER
  171. Increasing Shared_buffers = slow commits?
  172. Rewriting DISTINCT and losing performance
  173. Re: Postgres Benchmark Results
  174. Postgres Benchmark Results
  175. QP Problem
  176. Efficient recursion
  177. Slow queries on big table
  178. choosing fillfactor
  179. 121+ million record table perf problems
  180. reading large BYTEA type is slower than expected
  181. Re: performance drop on 8.2.4, reverting to 8.1.4
  182. CPU Intensive query
  183. Re: Ever Increasing IOWAIT
  184. performance drop on 8.2.4, reverting to 8.1.4
  185. Re: Ever Increasing IOWAIT
  186. Re: Ever Increasing IOWAIT
  187. WAL log performance/efficiency question
  188. any way to get rid of Bitmap Heap Scan recheck?
  189. Re: New performance documentation released
  190. Re: [PATCHES] Automatic adjustment of bgwriter_lru_maxpages
  191. How to Run a pg_stats Query
  192. Disk Fills Up and fsck "Compresses" it
  193. [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal
  194. bitmap index and IS NULL predicate
  195. Many to many join seems slow?
  196. Re: Transaction prioritization from java possible?
  197. pg_stats how-to?
  198. Kernel cache vs shared_buffers
  199. 500 requests per second
  200. Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
  201. PostGreSQL ignoring my rules in select query
  202. Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
  203. REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
  204. Background vacuum
  205. Re: Performance Woes
  206. Re: Performance Woes
  207. Vacuum Times - Verbose and maintenance_work_mem
  208. Poor performance with queries using clause: sth IN (...)
  209. Cannot make GIN intarray index be used by the planner
  210. Apparently useless bitmap scans
  211. Re:
  212. FW:
  213. FW:
  214. FW:
  215. Re:
  216. Re:
  217. Re:
  218. What's The Difference Between VACUUM and VACUUM ANALYZE?
  219. Throttling PostgreSQL's CPU usage
  220. DISTINCT Question
  221. Re: specific query (not all) on Pg8 MUCH slower than Pg7
  222. Nested loops overpriced
  223. specific query (not all) on Pg8 MUCH slower than Pg7
  224. estimating the need for VACUUM FULL and REINDEX
  225. truncate a table instead of vaccum full when count(*) is 0
  226. Best OS for Postgres 8.2
  227. Merging large volumes of data
  228. How to Find Cause of Long Vacuum Times - NOOB Question
  229. Diminishing bandwidth performance with multiple quad core X5355s
  230. Index not being used in sorting of simple table
  231. pg_stat_* collection
  232. Join vs Subquery
  233. Intermitent slow queries
  234. sytem log audit/reporting and psql
  235. Query performance problems with partitioned tables
  236. Re: Redundant sub query triggers slow nested loop left join
  237. Re: Redundant sub query triggers slow nested loop left join
  238. Very specific server situation
  239. Re: [Fwd: ] How
  240. How can fixed and variable width columns perform similarly?
  241. Usage up to 50% CPU
  242. Re: Simple query, 10 million records...MySQL tentimes faster
  243. Re: [GENERAL] PostgreSQL Performance Tuning
  244. Re: [GENERAL] Fw: PostgreSQL Performance Tuning
  245. Re: [GENERAL] Fw: PostgreSQL Performance Tuning
  246. Re: Fw: PostgreSQL Performance Tuning
  247. Re: What`s wrong with JFS configuration?
  248. Fragmentation of WAL files
  249. What`s wrong with JFS configuration?
  250. Simple query, 10 million records...MySQL ten times faster