PDA

View Full Version : Pgsql Performance

Pages : 1 2 [3] 4 5 6 7 8 9 10 11 12 13 14 15 16
  1. REPOST: Performance improves only after repeated VACUUM/ANALYZE
  2. Re: Low CPU Usage
  3. Re: Tablespaces and NFS
  4. Re: Tablespaces and NFS
  5. Query works when kludged, but would prefer "best practice" solution
  6. DELETE queries slow down
  7. update command question?
  8. Watch Satellite TV On Your PC
  9. Regarding COPY command from Postgres 8.2.0
  10. Index files
  11. Long Running Commits - Not Checkpoints
  12. Clustered tables improves perfs ?
  13. Index usage when bitwise operator is used
  14. db performance/design question
  15. pg_dump blocking create database?
  16. efficient pattern queries (using LIKE, ~)
  17. 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running
  18. More Vacuum questions...
  19. Barcelona vs Tigerton
  20. [Again] Postgres performance problem
  21. What to vacuum after deleting lots of tables
  22. random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
  23. Re: DRBD and Postgres: how to improve the perfomance?
  24. DRBD and Postgres: how to improve the perfomance?
  25. postgres memory management issues?
  26. How planner decides left-anchored LIKE can use index
  27. Reasonable amount of indices
  28. postgres memory management issues?
  29. Re: Hardware spec]
  30. Re: [ADMIN] ADO -PostgreSQL OLE DB Provider
  31. SAN vs Internal Disks
  32. Hardware spec
  33. GIST performance (PostGIS): the_geom vs. Envelope(the_geom)
  34. utilising multi-cpu/core machines?
  35. Re : optimize query with a maximum(date) extraction
  36. optimize query with a maximum(date) extraction
  37. Performance on 8CPU's and 32GB of RAM
  38. join tables vs. denormalization by trigger
  39. About autovacuum
  40. Vacum Analyze problem
  41. Re: [GENERAL] Performance issue with nested loop
  42. Slow Query
  43. schemas to limit data access
  44. schemas to limit data access
  45. 8.2 Autovacuum BUG ?
  46. Transaction Log
  47. Transaction Log
  48. LIKE query verses =
  49. Performance issue with nested loop
  50. Performance problem with table containing a lot of text (blog)
  51. Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
  52. 8.2 Query 10 times slower than 8.1 (view-heavy)
  53. 8.2.4 Chooses Bad Query Plan
  54. Bitmap Heap Scan before using index
  55. Performance issue
  56. Performance across multiple schemas
  57. index & Bitmap Heap Scan
  58. server performance issues - suggestions for tuning
  59. Performance issue
  60. Postgres performance problem
  61. Shared memory usage
  62. MI5 Persecution: Neil Fox (March/1998) (5999)
  63. MI5 Persecution: Capital Radio (11/April/1997) (4776)
  64. MI5 Persecution: GLR: David Hepworth (9/May/1997) (3553)
  65. MI5 Persecution: GLR: David Hepworth (21/Feb/1997) (2330)
  66. MI5 Persecution: Life is so hard (1107)
  67. MI5 Persecution: BBC1 TV News - 18/Dec/2002 (8445)
  68. MI5 Persecution: Channel Four TV News - 10/April/2002 (7222)
  69. MI5 Persecution: BBC-TV See You, See Me - 7/Dec/2001 (5999)
  70. MI5 Persecution: C4 SnowMail - January/2001 (4776)
  71. MI5 Persecution: England expects every man to do his duty (3553)
  72. MI5 Persecution: Nicholas Witchell - 10/April/1999 (2330)
  73. MI5 Persecution: Chris Tarrant - 10/March/1999 (1107)
  74. Partioning tsearch2 a table into chunks and accessing via views
  75. significant vacuum issues - looking for suggestions
  76. partitioned table and ORDER BY indexed_field DESC LIMIT 1
  77. deadlock_timeout parameter in Postgresql.cof
  78. deadlock_timeout parameter in Postgresql.cof
  79. long-running query - needs tuning
  80. Installing PostgreSQL
  81. asynchronous commit feature
  82. Re: Long running transaction in pg_activity_log
  83. Long running transaction in pg_activity_log
  84. Fast tsearch2, trigram matching on short phrases
  85. io storm on checkpoints, postgresql 8.2.4, linux
  86. Poor Performance after Upgrade
  87. Optimising "in" queries
  88. Re: Autovacuum is running forever
  89. Autovacuum is running forever
  90. MI5 Persecution: Channel Four TV News - 12/Feb/1999 (5999)
  91. MI5 Persecution: Dimbleby / John Major, April 1997 (4776)
  92. MI5 Persecution: Ken Clarke (2), April 1997 (3553)
  93. MI5 Persecution: Ken Clarke (1), April 1997 (2330)
  94. MI5 Persecution: Overview (1107)
  95. MI5 Persecution: David Hepworth (2) 16/5/97 (18229)
  96. MI5 Persecution: Victor Lewis-Smith 9/5/97 (17006)
  97. MI5 Persecution: Continuing Silence 9/5/97 (15783)
  98. Re: Terminology Question
  99. MI5 Persecution: Peak Practice 26/4/97 (14560)
  100. MI5 Persecution: I am being ignored 17/4/97 (13337)
  101. MI5 Persecution: Striking out action 10/3/97 (12114)
  102. MI5 Persecution: David Hepworth (1) 26/2/97 (10891)
  103. MI5 Persecution: No Justice 20/11/96 (9668)
  104. MI5 Persecution: WTGROMT 18/11/96 (8445)
  105. MI5 Persecution: Excellent web page 19/10/96 (7222)
  106. MI5 Persecution: Usual targets of such abuse 10/10/96 (5999)
  107. MI5 Persecution: Just too crazy 30/9/96 (4776)
  108. MI5 Persecution: Latest technology 31/7/96 (3553)
  109. MI5 Persecution: BBC+ITN=MI5 23/7/96 (2330)
  110. MI5 Persecution: Silly-billy 6/7/96 (1107)
  111. MI5 Persecution: Silly-billy 6/7/96 (5999)
  112. MI5 Persecution: Old_500 5/7/96 (4776)
  113. MI5 Persecution: alt.fan.mike-corley 6/6/96 (3553)
  114. MI5 Persecution: Bernard Levin 1/6/96 (2330)
  115. MI5 Persecution: Fitted up 26/4/96 (1107)
  116. Re: [pgsql-jobs] Looking for database hosting
  117. Re: [pgsql-jobs] Looking for database hosting
  118. MI5 Persecution: Fitted up 26/4/96 (1107)
  119. schema design question
  120. Re: Help optimize view
  121. Re: Help optimize view
  122. Re: Fwd: Table Partitioning
  123. Performance Solaris vs Linux
  124. Raid Configurations
  125. Stable function optimisation
  126. Bad planner decision - bitmap scan instead of index
  127. Integrated perc 5/i
  128. Indexscan is only used if we use "limit n"
  129. RAID 10 or RAID 10 + RAID 1
  130. Stable function optimisation
  131. Proposal: Pluggable Optimizer Interface
  132. Re: Performance on writable views
  133. Bitmap Index Scan optimization opportunity
  134. Re: Help optimize view
  135. Performance of CREATE INDEX
  136. Dell Hardware Recommendations
  137. mid 2007 "best bang for the buck" hardware opinions
  138. How to ENABLE SQL capturing???
  139. select count(*) performance
  140. Update table performance
  141. Planner making wrong decisions 8.2.4. Insane cost calculations.
  142. Extreme slow select query 8.2.4
  143. Default Performance between 8.0 and 8.1
  144. Postgres optimizer
  145. Performance problems with large telemetric datasets on 7.4.2
  146. Why are distinct and group by choosing different plans?
  147. cpu throttling
  148. Semantics of PostgreSQL Server Log Stats
  149. Using EXECUTE in a function
  150. Seq scan on join table despite index and high statistics
  151. one left join screws up the query
  152. Query optimization....
  153. Re: Postgres configuration for 64 CPUs, 128 GB RAM...
  154. Questions on Tags table schema
  155. Re: Slow query with backwards index scan
  156. select on 1milion register = 6s
  157. Re: Slow query with backwards index scan
  158. Vacuum looping?
  159. Slow query with backwards index scan
  160. Re: update, truncate and vacuum
  161. update, truncate and vacuum
  162. disk filling up
  163. performance of postgresql in replication using slony
  164. Insert Statements Hanging
  165. Affect of Reindexing on Vacuum Times
  166. Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
  167. Performance issue with 8.2.3 - "C" application
  168. Re: 8.2 -> 8.3 performance numbers
  169. Re: Table Statistics with pgAdmin III
  170. index over timestamp not being used
  171. Table Statistics with pgAdmin III
  172. Query performance issue
  173. Re: multicolumn index column order
  174. Re: multicolumn index column order
  175. Second SpecJAppserver2004 with PostgreSQL
  176. multicolumn index column order
  177. Simple select hangs while CPU close to 100%
  178. Slow select performance when filter with function
  179. Simple query showing 270 hours of CPU time
  180. Problems with posting
  181. Improving select peformance
  182. Trying to tune postgres, how is this config?
  183. Is it possible to know where is the "deadlock"
  184. User concurrency thresholding: where do I look?
  185. Optmal tags design?
  186. When/if to Reindex
  187. Re: Parrallel query execution for UNION ALL Queries
  188. How to use a trigger to write rows to a remote server
  189. Closed ports hanging around on Windows
  190. ionice to make vacuum friendier?
  191. importance of fast disks with pg
  192. insert vs select into performance
  193. large number of connected connections to postgres database (v8.0)
  194. Postgres configuration for 64 CPUs, 128 GB RAM...
  195. slony over VPN and LAN
  196. slony over LAN and VPN
  197. Vacuum full considered useful ;)
  198. FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
  199. Database Statistics???
  200. one column from huge view
  201. Estimating WAL volume
  202. TRUNCATE TABLE
  203. bitmap-index-scan slower than normal index scan
  204. Weird row estimate
  205. Two questions.. shared_buffers and long reader issue
  206. TIMING A QUERY ???
  207. WALL on controller without battery?
  208. Re: PostgreSQL publishes first real benchmark
  209. best use of an EMC SAN
  210. tuning a function to insert/retrieve values from a reference table
  211. Query Analyser
  212. PostgreSQL publishes first real benchmark
  213. Advice about how to delete
  214. Performance of PostgreSQL and Oracle
  215. Direct I/O
  216. Best query approach
  217. improvement suggestions for performance design
  218. Query is taking 5 HOURS to Complete on 8.1 version
  219. Filesystem Direct I/O and WAL sync option
  220. Delete Cascade FK speed issue
  221. poor use of indexes / feature: add OnlyUseIndex join/query plan hint?
  222. Join with lower/upper limits doesn't scale well
  223. kill off idle connections?
  224. Resource to learn code and share code and knowledge
  225. slow query
  226. [PERFORMANCE] is it possible to force an index to be held in memory?
  227. How to install Postgresql 8.2.x on windows XP silently
  228. Re: PostgreSQL 8.0 occasionally slow down
  229. PostgreSQL 8.0 occasionally slow down
  230. update query taking too long
  231. High IOWAIT times, low iops? Need Help with configuration
  232. rtree/gist index taking enormous amount of space in 8.2.3
  233. Re:
  234. Re:
  235. Non-optimal query plan with 8.2
  236. startup caching suggestions
  237. Is AIX Concurrent IO safe with PostgreSQL?
  238. Re: PREPARE and stuff
  239. PREPARE and stuff
  240. MI5 Persecution: Stasi 21/4/96 (16304)
  241. MI5 Persecution: Leant On 7/4/96 (14790)
  242. MI5 Persecution: Shoot to Kill 4/4/96 (13276)
  243. MI5 Persecution: Email Cruelty 11/3/96 (11762)
  244. MI5 Persecution: Jeff Rooker MP 5/3/96 (10248)
  245. MI5 Persecution: Flight or fight 7/1/96 (8734)
  246. MI5 Persecution: A new Kafka? 3/10/95 (5706)
  247. MI5 Persecution: Do they fear truth? 3/10/95 (4192)
  248. MI5 Persecution: Grievous Bodily Harm 2/10/95 (2678)
  249. MI5 Persecution: Goldfish and Piranha 29/9/95 (1164)
  250. Slow join query