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: BETWEEN optimizer problems with single-value range
  2. Background writer configuration
  3. Slow SELECTS after large update cycle
  4. Re: !! DOWNLOAD THE MOST POPULAR 2006's CRACKED SOFTWARE(CAD/CAE/CAM/EDA/PCB/GIS/FEA/CNC/
  5. Re: BETWEEN optimizer problems with single-value range
  6. VACUUM FULL hangs
  7. Re: Vacuum template databases, Urgent: Production probl
  8. Re: firebird X postgresql 8.1.2 windows, performance comparison
  9. Re: firebird X postgresql 8.1.2 windows, performance comparison
  10. Re: Vacuum template databases, Urgent: Production probl
  11. Vacuum template databases, Urgent: Production problem
  12. Re: firebird X postgresql 8.1.2 windows, performance comparison
  13. Re: PG Statistics
  14. Re: PG Statistics
  15. Re: import performance
  16. import performance
  17. PG Statistics
  18. Re: firebird X postgresql 8.1.2 windows, performance
  19. Re: firebird X postgresql 8.1.2 windows, performance comparison
  20. No vacuum for insert-only database?
  21. help needed asap....
  22. firebird X postgresql 8.1.2 windows, performance comparison
  23. Re: Trouble managing planner for timestamptz columns
  24. Re: Hanging queries on dual CPU windows
  25. Trouble managing planner for timestamptz columns
  26. Re: Hanging queries on dual CPU windows
  27. Re: Hanging queries on dual CPU windows
  28. Re: Query time
  29. FW: x206-x226
  30. Query time
  31. x206-x225
  32. Re: Hanging queries on dual CPU windows
  33. how to speedup huge insert from an ODBC app
  34. Process Time X200
  35. Using materialized views for commonly-queried subsets
  36. Re: Hanging queries on dual CPU windows
  37. Re: pg_reset_stats + cache I/O %
  38. pgCluster and postgres 8.1
  39. Re: Postgres and Ingres R3 / SAN
  40. Re: pg_reset_stats + cache I/O %
  41. Is good idea an array of 365 elements in a cell of a table, in orderto perform searchs?
  42. Re: pg_reset_stats + cache I/O %
  43. Re: firebird X postgresql 8.1.2 windows, performance comparison
  44. Re: Can anyone explain this pgbench results?
  45. Re: Can anyone explain this pgbench results?
  46. pg_reset_stats + cache I/O %
  47. Re: firebird X postgresql 8.1.2 windows, performance
  48. Re: firebird X postgresql 8.1.2 windows, performance comparison
  49. Re: firebird X postgresql 8.1.2 windows, performance comparison
  50. Re: Can anyone explain this pgbench results?
  51. Re: Can anyone explain this pgbench results?
  52. Re: Can anyone explain this pgbench results?
  53. Help understanding indexes, explain, and optimizing a query
  54. Sequencial scan instead of using index
  55. Re: Can anyone explain this pgbench results?
  56. Can anyone explain this pgbench results?
  57. Hanging queries and I/O exceptions
  58. Postgres on VPS - how much is enough?
  59. t1000/t2000 sun-servers
  60. Beautiful Note girl team brief introduction
  61. Problems In Creating a Table
  62. Problems In Creating a Table
  63. Planner enhancement suggestion.
  64. How to query and index for customer with lastname and city
  65. Bad row estimates
  66. Beautiful Note girl team
  67. Beautiful Note girl team
  68. Re: Like 'name%' is not using index
  69. Like 'name%' is not using index
  70. Views vs. Functions
  71. Re: [HACKERS] temporary indexes
  72. Bad plan on a view
  73. How to get the matching columns from a table for each row in another table?
  74. Re: triggers, performance Was: Re: [GENERAL] rotate records
  75. Re: [HACKERS] temporary indexes
  76. Re: [HACKERS] temporary indexes
  77. vacuum, analyze and reindex
  78. Re: rotate records
  79. The trigger can be specified to fire on time condition?
  80. Large Table With Only a Few Rows
  81. neverending vacuum
  82. Setting the shared buffers
  83. fsync and battery-backed caches
  84. Re: Reliability recommendations
  85. Schema vs Independant Databases, ACLS,Overhead,pg_hba.conf
  86. nested query on last n rows of huge table
  87. Really really slow query. What's a better way?
  88. Re: 0ut of Memory Error during Vacuum Analyze and
  89. Re: 0ut of Memory Error during Vacuum Analyze and
  90. Looking for a tool to "*" pg tables as ERDs
  91. how to interpret/improve bad row estimates
  92. Re:
  93. Created Index is not used
  94. Re: Large Database Design Help
  95. Slow query
  96. Re: Joins and full index scans...mysql vs postgres?
  97. Re: Joins and full index scans...mysql vs postgres?
  98. Re: Joins and full index scans...mysql vs postgres?
  99. Joins and full index scans...mysql vs postgres?
  100. Good News re count(*) in 8.1
  101. Re:
  102. Re: LIKE query on indexes
  103. Re: --pls reply ASAP
  104. Re:
  105. Re:
  106. Re: Help with nested loop left join performance
  107. Cost Issue - How do I force a Hash Join
  108. Creating a correct and real benchmark
  109. How to optimize a JOIN with BETWEEN?
  110. Question about query planner
  111. IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...
  112. Force another plan.
  113. Measuring Lock Performance
  114. Index Choice Problem
  115. Future of Table Partitioning
  116. Stored proc and optimizer question
  117. Re: SQL Function Performance
  118. Re: SQL Function Performance
  119. Re: Why does not perform index combination
  120. Why does not perform index combination
  121. Strange Create Index behaviour
  122. Re: explain hashAggregate
  123. out of memory
  124. Stored proc and optimizer question
  125. Re: copy and postgresql.conf
  126. Re: copy and postgresql.conf
  127. Re: copy and postgresql.conf
  128. Re: could not send data to client: Broken pipe
  129. Re: 0ut of Memory Error during Vacuum Analyze and
  130. Re: SQL Function Performance
  131. Re: 0ut of Memory Error during Vacuum Analyze and
  132. 8.2.1 on FreeBSD 5.4-RELEASE
  133. Re: copy and postgresql.conf
  134. 0ut of Memory Error during Vacuum Analyze
  135. Postgres slower than MS ACCESS
  136. out of memory
  137. Re: out of memory
  138. Re: copy and postgresql.conf
  139. copy and postgresql.conf
  140. Re: SQL Function Performance
  141. Re: SQL Function Performance
  142. Re: SQL Function Performance
  143. Re: SQL Function Performance
  144. Re: SQL Function Performance
  145. Re: joining two tables slow due to sequential scan
  146. Re: SQL Function Performance
  147. SQL Function Performance
  148. Re: 10+hrs vs 15min because of just one index
  149. postgresql geqo optimization
  150. Re: joining two tables slow due to sequential scan
  151. Re: joining two tables slow due to sequential scan
  152. Re: joining two tables slow due to sequential scan
  153. Re: joining two tables slow due to sequential scan
  154. Re: joining two tables slow due to sequential scan
  155. Re: joining two tables slow due to sequential scan
  156. joining two tables slow due to sequential scan
  157. help required in design of database
  158. Optimizing performance of a like '%...%' condition
  159. Re: Basic Database Performance
  160. Basic Database Performance
  161. 10+hrs vs 15min because of just one index
  162. Large Database Design Help
  163. Help with optimizing a sql statement
  164. Sane configuration options for a WinXP laptop 8.1 install?
  165. Size and performance hit from using UTF8 vs. ASCII?
  166. optimizing away join when querying view
  167. Re: partitioning and locking problems
  168. taking advantage of 16 GB of RAM
  169. Re: partitioning and locking problems
  170. Index occupancy
  171. pgbench output
  172. Default autovacuum settings too conservative
  173. Index Usage using IN
  174. Planner reluctant to start from subquery
  175. Re: execution plan : Oracle vs PostgreSQL
  176. Re: partitioning and locking problems
  177. execution plan : Oracle vs PostgreSQL
  178. Sequential scan being used despite indexes
  179. partitioning and locking problems
  180. Storing Digital Video
  181. Delete me
  182. Query planner issue
  183. Desperate: View not using indexes (very slow)
  184. Where is my bottleneck?
  185. Re: Huge Data sets, simple queries
  186. Huge Data sets, simple queries
  187. Re: Incorrect Total runtime Reported by Explain Analyze!?
  188. Re: Incorrect Total runtime Reported by Explain Analyze!?
  189. Incorrect Total runtime Reported by Explain Analyze!?
  190. Physical column size
  191. PostgreSQL Solaris packages now in beta
  192. Inconsistant query plan
  193. Investigating IO Saturation
  194. unsubscribe
  195. Re: Slow queries consisting inner selects and order bys & hack to speed up
  196. ENC: RES: pg_dump slow - Solution
  197. tsearch2 headline and postgresql.conf
  198. libpq vs. unixODBC performance
  199. Sudden slowdown of Pg server
  200. Re: [GENERAL] Creation of tsearch2 index is very slow
  201. Re: [PERFORMANCE] Stored Procedures
  202. query stopped working after tables > 50000 records
  203. Retaining execution plans between connections?
  204. SELECT MIN, MAX took longer time than SELECT COUNT, MIN, MAX
  205. Stored Procedures
  206. 3WARE Card performance boost?
  207. Simple Question of Performance ILIKE or Lower
  208. Getting pg to use index on an inherited table (8.1.1)
  209. Multiple Order By Criteria
  210. wildcard search performance with "like"
  211. sum of left join greater than its parts
  212. Performance issue when retrieving n last items
  213. Re: Autovacuum / full vacuum
  214. Use of Stored Procedures and
  215. Autovacuum / full vacuum
  216. new to postgres (and db management) and performance already a problem
  217. Use of * affect the performance
  218. Materialized Views
  219. Suspending SELECTs
  220. Re: SAN/NAS options
  221. Ensuring data integrity with fsync=off
  222. big databases & hospitals
  223. Postgres8.0 Planner chooses WRONG plan.
  224. Extremely irregular query performance
  225. insert without oids
  226. Re: Extremely irregular query performance
  227. Re: Please Help: PostgreSQL performance Optimization
  228. query slower on 8.1 than 7.3
  229. Throwing unnecessary joins away
  230. Stable function being evaluated more than once in a single query
  231. Please Help: PostgreSQL performance Optimization
  232. indexes on primary and foreign keys
  233. Extremely irregular query performance
  234. Showing Column Statistics Number
  235. Postgres8.0 planner chooses WRONG plan
  236. Slow query with joins
  237. Left Join Performance vs Inner Join Performance
  238. How to handle a large DB and simultaneous accesses?
  239. Index isn't used during a join.
  240. NOT LIKE much faster than LIKE?
  241. Memory Usage Question
  242. Re: help tuning queries on large database
  243. >= forces row compare and not index elements compare when possible
  244. 500x speed-down: Wrong query plan?
  245. [PERFORMANCE] Beetwen text and varchar field
  246. Hanging Query
  247. help tuning queries on large database
  248. Slow query. Any way to speed up?
  249. Improving Inner Join Performance
  250. Help in avoiding a query 'Warm-Up' period/shared buffer cache