PDA

View Full Version : Pgsql Performance

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 [13] 14 15 16
  1. tricky query
  2. Re: Too slow querying a table of 15 million records
  3. Re: Postgresql7.4.5 running slow on plpgsql function
  4. Re: LIKE search with ending % not optimized in v8
  5. Re: How are text columns stored?
  6. Re: Too slow querying a table of 15 million records
  7. How can I speed up this function?
  8. Faster drives for WAL than for data?
  9. Performance analysis of plpgsql code
  10. Forcing use of a particular index
  11. Poor index choice -- multiple indexes of the same columns
  12. perl garbage collector
  13. Re: [HACKERS] How two perform TPC-H test on postgresql-8.0.2
  14. Re: PERFORMANCE ISSUE ODBC x LIBPQ C++ Application
  15. Re: PERFORMANCE ISSUE ODBC x LIBPQ C++ Application
  16. PERFORMANCE ISSUE ODBC x LIBPQ C++ Application
  17. Re: Performance - moving from oracle to postgresql
  18. Re: Insert performance vs Table size
  19. Re: Speed with offset clause
  20. Re: Performance Tuning Article
  21. Performance - moving from oracle to postgresql
  22. Re: Speed with offset clause
  23. Re: Speed with offset clause
  24. max_connections / shared_buffers / effective_cache_size questions
  25. Postgres 8 vs Postgres 7.4/cygwin
  26. ETL optimization
  27. select distinct on varchar - wild performance differences!
  28. Re: parameterized LIKE does not use index
  29. parameterized LIKE does not use index
  30. Re: Limit clause not using index
  31. Performance Tuning Article
  32. Forums & tsearch2 - best practices reg. concurrency
  33. Re: Configurator project launched
  34. Prepared statements vs. Stored Procedures
  35. Querying 19million records very slowly
  36. Configurator project launched
  37. Re: Trying to figure out pgbench
  38. Trying to figure out pgbench
  39. Re: Do Views execute underlying query everytime ??
  40. Re: Another question on indexes (drop and recreate)
  41. Re: Do Views execute underlying query everytime ??
  42. Re: Limit clause not using index
  43. Re: Limit clause not using index
  44. Re: Limit clause not using index
  45. Do Views execute underlying query everytime ??
  46. investigating slow queries through pg_stat_activity
  47. autovacuum suggestions for 500,000,000+ row tables?
  48. Re: How to determine whether to VACUUM or CLUSTER
  49. Re: Fwd: Multiple disks: RAID 5 or PG Cluster
  50. Re: Multiple disks: RAID 5 or PG Cluster
  51. Re: Multiple disks: RAID 5 or PG Cluster
  52. Re: could not send data to client:
  53. could not send data to client:
  54. How does the transaction buffer work?
  55. How to determine whether to VACUUM or CLUSTER
  56. Needed: Simplified guide to optimal memory configuration
  57. SELECT LIMIT 1 VIEW Performance Issue
  58. regular expression search
  59. System Requirement
  60. Re: Index ot being used
  61. Re: Index ot being used
  62. Re: Fwd: Updates on large tables are extremely slow
  63. Re: Index ot being used
  64. Re: Help with rewriting query
  65. PostgreSQL using the wrong Index
  66. Re: View not using index
  67. Re: Updates on large tables are extremely slow
  68. Resource Requirements
  69. Re: Updates on large tables are extremely slow
  70. Re: Help with rewriting query
  71. faster search
  72. Index ot being used
  73. Re: Whence the Opterons?
  74. Re: Importing from pg_dump slow, low Disk IO
  75. Cleaning bloated pg_attribute
  76. Re: Importing from pg_dump slow, low Disk IO
  77. Re: Importing from pg_dump slow, low Disk IO
  78. random_page_cost = 1?
  79. Re: Recommendations for configuring a 200 GB
  80. Re: [Npgsql-general] index out of range
  81. postgresql.conf runtime statistics default
  82. pg_autovacuum settings
  83. Query plan changes after pg_dump / pg_restore
  84. How to find the size of a database - reg.
  85. Re: Help with rewriting query
  86. Re: Importing from pg_dump slow, low Disk IO
  87. Recommendations for configuring a 200 GB database
  88. Help with rewriting query
  89. Help specifying new web server/database machine
  90. Performance problems, bad estimates and plan
  91. full outer performance problem
  92. Importing from pg_dump slow, low Disk IO
  93. Re: Performance nightmare with dspam (urgent)
  94. Re: Postgresql and Software RAID/LVM
  95. Postgresql on an AMD64 machine
  96. slow growing table
  97. Re: Need help to decide Mysql vs Postgres
  98. Re: Need help to decide Mysql vs Postgres
  99. Re: Need help to decide Mysql vs Postgres
  100. Re: Performance nightmare with dspam (urgent) (resolved)
  101. Re: Most effective tuning choices for busy website?
  102. SELECT DISTINCT Performance Issue
  103. Best hardware
  104. Re: Query plan for very large number of joins
  105. strategies for optimizing read on rather large tables
  106. Re: Need help to decide Mysql vs Postgres
  107. Insert slow down on empty database
  108. Postgresql and Software RAID/LVM
  109. Re: Query plan for very large number of joins
  110. Re: Query plan for very large number of joins
  111. Re: Query plan for very large number of joins
  112. Filesystem
  113. Query plan for very large number of joins
  114. Re: Specific query performance problem help requested - postgresql 7.4
  115. Re: Moving pg_xlog
  116. Adaptec/LSI/?? RAID
  117. Forcing use of specific index
  118. Moving pg_xlog
  119. How to avoid database bloat
  120. 'Fastest' PC's are slowest in the house
  121. SURVEY: who is running postgresql on 8 or more CPUs?
  122. very large table
  123. Index on a NULL-value
  124. Re: poor performance involving a small table
  125. Re: poor performance involving a small table
  126. Re: tuning
  127. Re: poor performance involving a small table
  128. Re: Postgresql and xeon.
  129. Index not used on join with inherited tables
  130. Postgresql and xeon.
  131. timestamp indexing
  132. OID vs overall system performances on high load
  133. sequential scan performance
  134. Redundant indexes?
  135. OID vs overall system performances on high load databases.
  136. postgresql-8.0.1 performance tuning
  137. slow queries, possibly disk io
  138. Re: slow queries, possibly disk io
  139. Re: Specific query performance problem help requested - postgresql 7.4
  140. Specific query performance problem help requested - postgresql 7.4
  141. Optimising queries involving unions
  142. Re: [PORTS] Which library has these symbols? -- Eureka
  143. test - pls delete and ignore
  144. Inner join on two OR conditions dont use index
  145. Can anyone explain this: duplicate dbs.
  146. Re: Select performance vs. mssql
  147. Re: Need help to decide Mysql vs Postgres
  148. Re: Need help to decide Mysql vs Postgres
  149. Need help to decide Mysql vs Postgres
  150. Re: Select performance vs. mssql
  151. Re: Select performance vs. mssql
  152. Select performance vs. mssql
  153. Re: seqential vs random io
  154. seqential vs random io
  155. Re: Fwd: Index on table when using DESC clause
  156. Re: Fwd: Index on table when using DESC clause
  157. cant seem to post the explain
  158. performance on a querry with many group by's any way to speed it up?
  159. Optimizing for writes. Data integrity not critical
  160. Which is better, correlated subqueries or joins?
  161. Re: PostgreSQL strugling during high load
  162. Re: PostgreSQL strugling during high load
  163. Re: Tuning planner cost estimates
  164. Re: [pgsql-benchmarks] Error when try installing pgbench ?
  165. Why is it taking so long?
  166. checkpoint segments
  167. Re: Swapping and Kernel 2.6
  168. Postgresql Performance via the LSI MegaRAID 2x Card
  169. Re: Whence the Opterons?
  170. Re: ok you all win what is best opteron (I dont want a hosed system again)
  171. ok you all win what is best opteron (I dont want a hosed system again)
  172. PostgreSQL strugling during high load
  173. Recommendations for set statistics
  174. Optimize complex join to use where condition before join
  175. Re: Partitioning / Clustering
  176. tuning Postgres for large data import (using Copy from)
  177. AND OR combination: index not being used
  178. Bad plan after vacuum analyze
  179. Optimizer wrongly picks Nested Loop Left Join
  180. Re: Prefetch - OffTopic
  181. Prefetch - OffTopic
  182. =?iso-8859-1?Q?RE:__Partitioning_/_Clustering?=
  183. Prefetch
  184. Partitioning / Clustering
  185. full outer performance problem
  186. Configing 8 gig box.
  187. Re: Whence the Opterons?
  188. Re: PGSQL Capacity
  189. PGSQL Capacity
  190. Re: Whence the Opterons?
  191. Re: Whence the Opterons?
  192. "Hash index" vs. "b-tree index" (PostgreSQL 8.0)
  193. Query tuning help
  194. sequence scan on PK
  195. Whence the Opterons?
  196. Re: [SQL] ORDER BY Optimization
  197. Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1
  198. Table stats
  199. Kernel Resources Solved
  200. Kernel Resources and max_connections
  201. Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1b
  202. Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 2
  203. Re:
  204. Re: batch inserts are "slow"
  205. Re: batch inserts are "slow"
  206. batch inserts are "slow"
  207. index on different types
  208. Re: Final decision
  209. Re: Why is this system swapping?
  210. Re: Why is this system swapping?
  211. Re: Final decision
  212. Re: Why is this system swapping?
  213. Why is this system swapping?
  214. Re: Final decision
  215. Suggestions for a data-warehouse migration routine
  216. Re: [HACKERS] Bad n_distinct estimation; hacks suggested?
  217. Re: Final decision
  218. Final decision
  219. Re: [HACKERS] Bad n_distinct estimation; hacks suggested?
  220. Re: What needs to be done for real Partitioning?
  221. speed up query with max() and odd estimates
  222. Re: Table Partitioning: Will it be supported in Future?
  223. Re: two queries and dual cpu (perplexed)
  224. Re: two queries and dual cpu (perplexed)
  225. BLOB's bypassing the OS Filesystem for better Image loading speed?
  226. Table Partitioning: Will it be supported in Future? (splitting largeTables)
  227. half the query time in an unnecessary(?) sort?
  228. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  229. Re: [ODBC] Joel's Performance Issues WAS : Opteron vs Xeon
  230. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  231. flattening the file might work for me here is the analyze.
  232. Interesting numbers on a CREATE INDEX
  233. Updating table, precautions?
  234. Re: two queries and dual cpu (perplexed)
  235. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  236. Re: two queries and dual cpu (perplexed)
  237. foreign key performance
  238. Re: Index bloat problem?
  239. Re: index not used
  240. index not used
  241. Re: Index bloat problem?
  242. Re: Index bloat problem?
  243. Index bloat problem?
  244. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  245. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  246. Re: Joel's Performance Issues WAS : Opteron vs Xeon
  247. two queries and dual cpu (perplexed)
  248. How can an index be larger than a table
  249. Re: postgres slowdown question
  250. Re: Joel's Performance Issues WAS : Opteron vs Xeon