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