PDA

View Full Version : Pgsql Performance

Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
  1. "append" takes a lot of time in a query
  2. Creating indexes
  3. Re: [GENERAL] Ubuntu question
  4. Creating a foreign key
  5. =?WINDOWS-1252?Q?Query_Optimization_with_Kruskal=92s_Algorit hm?=
  6. pgfouine - commit details?
  7. Possible Redundancy/Performance Solution
  8. What constitutes a complex query
  9. multiple joins + Order by + LIMIT query performance issue
  10. Seqscan problem
  11. plan difference between set-returning function with ROWS within IN() and a plain join
  12. need to speed up query
  13. Backup causing poor performance - suggestions
  14. Fastest way / best practice to calculate "next birthdays"
  15. Very slow INFORMATION_SCHEMA
  16. Re: Pros and Cons of 8.3.1
  17. Re: Pros and Cons of 8.3.1
  18. two memory-consuming postgres processes
  19. Pros and Cons of 8.3.1
  20. pgPool query cache
  21. Please ignore ...
  22. Postgres replication
  23. Understanding histograms
  24. SSD database benchmarks
  25. Vacuum statistics
  26. Postgres Benchmark looking for maintainer
  27. Very poor performance loading 100M of sql data using copy
  28. shared_buffer/DRBD performances
  29. Where do a novice do to make it run faster?
  30. Replication Syatem
  31. Simple JOIN problem
  32. Re: [pgsql-advocacy] Benchmarks WAS: Sun Talks about MySQL
  33. Re: Best practice to load a huge table from ORACLE to PG
  34. Best practice to load a huge table from ORACLE to PG
  35. Planner won't use composite index if there is an order by ????
  36. Re: off-topic: SPAM
  37. Question about disk IO an index use and seeking advice
  38. Optimizer's issue
  39. mysterious difference in speed when combining two queries with OR
  40. SELECT 'DBD::Pg ping test'
  41. [PERFORMANCE] Error loading 37G CSV file "invalid string enlargement request size 65536"
  42. Suspicious top output
  43. CPU bound at 99%
  44. Re: [HACKERS] [COMMITTERS] pgsql: FixTransactionIdIsCurrentTransactionId() to use binary search
  45. Performance of the Materialize operator in a query plan
  46. connections slowing everything down?
  47. Re: Group by more efficient than distinct?
  48. corrupted shared memory message
  49. Re: Group by more efficient than distinct?
  50. Re: Group by more efficient than distinct?
  51. Re: Exact index overhead
  52. Query running slow
  53. Anybody using the Dell Powervault MD3000 array?
  54. Re: Performance increase with elevator=deadline
  55. SQL Function Slowness, 8.3.0
  56. Background writer underemphasized ...
  57. Oddly slow queries
  58. Re: Performance is low Postgres+Solaris
  59. Re: Cached Query Plans
  60. db size
  61. shared_buffers performance
  62. Re: Performance increase with elevator=deadline
  63. Partitioned tables - planner wont use indexes
  64. Re: Performance is low Postgres+Solaris
  65. Re: Performance is low Postgres+Solaris
  66. Re: Performance increase with elevator=deadline
  67. shared_buffers in 8.2.x
  68. Creating large database of MD5 hash values
  69. varchar index joins not working?
  70. EXPLAIN detail
  71. Re: EXPLAIN detail
  72. Re: EXPLAIN detail
  73. large tables and simple "= constant" queries using indexes
  74. bulk data loading
  75. bulk insert performance problem
  76. recommendations for web/db connection pooling or DBD::Gofer reviews
  77. performance using table partitions in Postgres 8.2.6
  78. what worked: performance improvements for geo-spatial searching onFreeBSD
  79. Performance with temporary table
  80. slow pgsql tables - need to vacuum?
  81. Partitioned tables - planner wont use indexes
  82. Forcing more agressive index scans for BITMAP AND
  83. Severe performance problems for simple query
  84. Looking for bottleneck during load test
  85. [Fwd: Re: Max shared_buffers]
  86. Forcing more agressive index scans for BITMAP AND
  87. Query plan excluding index on view
  88. Too many commands in a transaction
  89. SSDs
  90. Re: Bad prepare performance
  91. check performance parameters
  92. Insert time
  93. Cursors and different settings for default_statistics_target
  94. Performance Implications of Using Exceptions
  95. Bad prepare performance
  96. optimizing query performance
  97. POSIX file updates
  98. using like in a prepare doesnt' use the right index
  99. Planning a new server - help needed
  100. Re: PostgreSQL NetApp and NFS
  101. Preparing statements on connection startup
  102. 1-/2-dimensional indexes for common columns, rationale?
  103. Query Optimization
  104. how can a couple of expensive queries drag my system down?
  105. vacuum in Postgresql 8.0.x slowing down the database
  106. "Slow" query or just "Bad hardware"?
  107. what is the maximum number of rows in a table in postgresql 8.1
  108. postgresql is slow with larger table even it is in RAM
  109. Re: slow pg_connect()
  110. Turn correlated in subquery into join
  111. Planning hot/live backups?
  112. increasing shared buffer slow downs query performance.
  113. waiting for harddisk
  114. Re: PostgreSQL NetApp and NFS
  115. Re: PostgreSQL NetApp and NFS
  116. Re: PG writes a lot to the disk
  117. Having MANY MANY empty columns in database
  118. slow pg_connect()
  119. Views and functions returning sets of records
  120. performance tools
  121. Live Webcam broadcasts. Contain erotic content.
  122. best way to run maintenance script
  123. What is the best way to storage music files in Postgresql
  124. Adaptec 5805 SAS Raid
  125. The "many nulls" problem
  126. Re: Lots of "semop" calls under load
  127. Re: Recomendations on raid controllers raid 1+0
  128. temp tables
  129. ER diagram tool
  130. partial index + select query performance
  131. Are piped columns indexable
  132. Repeated execution of identical subqueries
  133. Recomendations on raid controllers raid 1+0
  134. 8.3 write performance
  135. 8.3 write performance
  136. Hardware question for a DB server
  137. Can SQL 2000 32bit run on 64 bit os?
  138. Re: list user created triggers
  139. migration of 7.4 to 8.1
  140. list user created triggers
  141. how many index can have????
  142. join query performance
  143. =?ISO-8859-1?Q?Confirma=E7=E3o_de_envio_/_Sending_con?= =?ISO-8859-1?Q?firmation_(captchaid:13266b402bd3)?=
  144. Re: Re: =?iso-8859-1?Q?Confirma?==?iso-8859-1?B?5+M=?==?iso-8859-1?Q?o?= de envio / Sending confirmation
  145. Re: UPDATE 66k rows too slow
  146. Re: UPDATE 66k rows too slow
  147. Utility functions for enabling/disabling fkey triggers
  148. Re: UPDATE 66k rows too slow
  149. Very slow (2 tuples/second) sequential scan after bulk insert; speedreturns to ~500 tuples/second after commit
  150. Joins and DELETE FROM
  151. Improve Full text rank in a query
  152. database design for large data.
  153. Toast space grows
  154. Nested loop vs merge join: inconsistencies between estimated andactual time
  155. index usage makes problem
  156. =?ISO-8859-1?Q?Confirma=E7=E3o_de_envio_/_Sending_con?= =?ISO-8859-1?Q?firmation_(captchaid:13266b203c28)?=
  157. =?ISO-8859-1?Q?Confirma=E7=E3o_de_envio_/_Sending_con?= =?ISO-8859-1?Q?firmation_(captchaid:13266b1124bc)?=
  158. =?ISO-8859-1?Q?Confirma=E7=E3o_de_envio_/_Sending_con?= =?ISO-8859-1?Q?firmation_(captchaid:13266b203e23)?=
  159. =?ISO-8859-1?Q?Confirma=E7=E3o_de_envio_/_Sending_con?= =?ISO-8859-1?Q?firmation_(captchaid:13266b20536d)?=
  160. =?ISO-8859-1?Q?Confirma=E7=E3o_de_envio_/_Sending_con?= =?ISO-8859-1?Q?firmation_(captchaid:13266b2056e4)?=
  161. oid...any optimizations
  162. postgresql Explain command output
  163. Why the difference in plans ?
  164. count * performance issue
  165. Optimisation help
  166. =?ISO-8859-1?Q?Confirma=E7=E3o_de_envio_/_Sending_con?= =?ISO-8859-1?Q?firmation_(captchaid:13266b111e1d)?=
  167. postgresql performance
  168. Ramifications of turning off Nested Loops for slow queries
  169. PostgreSQL performance on a virtual host
  170. Performance problems deleting data
  171. Performance tuning on FreeBSD
  172. which is more important? freq of checkpoints or the duration of them?
  173. You can find new hookups with the hottest men, women and couples.
  174. How to choose a disc array for Postgresql?
  175. Bypassing useless ORDER BY in a VIEW
  176. 12 disks raid setup
  177. how to identify expensive steps in an explain analyze output
  178. questions about CLUSTER
  179. Optimizing t1.col like '%t2.col%'
  180. t1.col like '%t2.col%'
  181. disabling an index without deleting it?
  182. PG planning randomly ?
  183. multi-threaded pgloader needs your tests
  184. Re: LISTEN / NOTIFY performance in 8.3
  185. Re: LISTEN / NOTIFY performance in 8.3
  186. response time when querying via JDBC and via psql differs
  187. when is a DELETE FK trigger planned?
  188. Very simple query, plan goes badly wrong
  189. date; q=dns/txt; s=mail; bh=VJAfUBalD9Zqq+rAD+bu/vgvY7o=; b=RVmU7bJ9fNBG6FG9MbPZzlVn8PEL6Q8c4LVJ7e2D36L7H9U5 Xsna2I1lbiRdWzICZgZbeFJLqSrGaSYVPkoeohDuP7vTfIVtkb x6ciOY7EsDTui+u6YlbN5qcNOfX5yqvKWG5Xv/TgN1twRmBWwCv87CEoQKrfBblEM5bjGF7a0=
  190. LISTEN / NOTIFY performance in 8.3
  191. config settings, was: 4s query want to run faster
  192. store A LOT of 3-tuples for comparisons
  193. CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
  194. Q on views and performance
  195. 4s query want to run faster
  196. Re: 7 hrs for a pg_restore?
  197. Re: 7 hrs for a pg_restore?
  198. Question about shared_buffers and cpu usage
  199. planner favors seq scan too early
  200. Re: mis-estimate in nested query causes slow runtimes
  201. Re: 7 hrs for a pg_restore?
  202. Re: Anyone using a SAN?
  203. Re: 7 hrs for a pg_restore?
  204. Re: Anyone using a SAN?
  205. Re: Anyone using a SAN?
  206. Need Help selecting Large Data From PQSQL
  207. Re: 7 hrs for a pg_restore?
  208. nested sets model UPDATEs
  209. Re: JDBC/Stored procedure performance issue
  210. Re: How do I bulk insert to a table withoutaffecting read performance on that table?
  211. Storage space usage
  212. slow 8.2.6 with 50 connections
  213. Benchmark Data requested
  214. Configuration settings (shared_buffers, etc) in Linux: puzzled
  215. *_cost recommendation with 8.3 and a fully cached db
  216. planner chooses unoptimal plan on joins with complex key
  217. Vacuum and FSM page size
  218. Postgres 8.2 memory weirdness
  219. Optimizing queries that use temporary tables
  220. Workaround for cross column stats dependency
  221. Making the most of memory?
  222. scheduler
  223. 8.3 synchronous_commit
  224. Slow performance with left outer join
  225. Slow set-returning functions
  226. Re: strange pauses
  227. [OT] RAID controllers blocking one another?
  228. strange pauses
  229. Seq scans on indexed columns.
  230. Saving result set of SELECT to table column
  231. Tuning Postgresql on Windows XP Pro 32 bit [was on HACKERS list]
  232. Re: Simple select, but takes long time
  233. Inheritance, unique keys and performance
  234. Simple select, but takes long time
  235. Re: Best way to index IP data?
  236. not exists clause
  237. Evaluating boolean formula: slow performance
  238. Best way to index IP data?
  239. After Vacuum Analyse - Procedure performance not improved - Innner select is faster
  240. big database performance
  241. Search for fixed set of keywords
  242. Loss of cache when persistent connexion is closed
  243. Performance of aggregates over set-returning functions
  244. Create Index (Hash) on a Large Table Taking Days...
  245. concurrent inserts into two separate tables are very slow
  246. M'I.5,Perse cution Haras sment t hrough the Radio
  247. M,I-5 Pers ecution Thr ee Years of MI5 P ersecution Fax es
  248. M`I 5`Pe rsecution . MI5 Wan t Me to Send Yo u the se Fa xes
  249. M I.5 Perse cution MI 5 Insi st tha t th ese Fax es mu st Continu e
  250. M I`5'Pers ecution , 22, 544 + 837 = 23,38 1