PDA

View Full Version : Pgsql Performance

Pages : 1 2 3 4 5 6 7 8 9 [10] 11 12 13 14 15 16
  1. Avoiding cartesian product
  2. improving write performance for logging application
  3. Materialize Subplan and push into inner index conditions
  4. Re: Cracked software fastest download!
  5. unsubscribe
  6. Invulnerable VACUUM process thrashing everything
  7. Process executing COPY opens and reads every table on the system
  8. How import big amounts of data?
  9. Performance problems with 8.1.1 compared to 7.4.7
  10. Bitmap indexes etc.
  11. Performance hit on large row counts
  12. Fwd: vacuuming template0 gave ERROR
  13. Re: What's the best hardver for PostgreSQL 8.1?
  14. Re: Order by behaviour
  15. Order by behaviour
  16. DELETE, INSERT vs SELECT, UPDATE || INSERT
  17. Re: ORDER BY costs
  18. Re: Speed of different procedural language
  19. Re: MySQL is faster than PgSQL but a large margin in
  20. MySQL is faster than PgSQL but a large margin in my program... anyideas why?
  21. CPU and RAM
  22. Re: Speed of different procedural language
  23. Re: Windows performance again
  24. ORDER BY costs
  25. Wrong index used when ORDER BY LIMIT 1
  26. Windows performance again
  27. Re: SAN/NAS options
  28. effizient query with jdbc
  29. effizient query with jdbc
  30. effizient query with jdbc
  31. Re: High context switches occurring
  32. What's the best hardver for PostgreSQL 8.1?
  33. Re: PostgreSQL and Ultrasparc T1
  34. Re: Read only transactions - Commit or Rollback
  35. unsubscribe
  36. Re: Read only transactions - Commit or Rollback
  37. Read only transactions - Commit or Rollback
  38. Re: High context switches occurring
  39. Re: SAN/NAS options
  40. Re: Any way to optimize GROUP BY queries?
  41. Is the optimizer choice right?
  42. separate drives for WAL or pgdata files
  43. Re: PostgreSQL and Ultrasparc T1
  44. Re: PostgreSQL and Ultrasparc T1
  45. PostgreSQL and Ultrasparc T1
  46. make bulk deletes faster?
  47. Speed of different procedural language
  48. Re: How much expensive are row level statistics?
  49. 8.1 - pg_autovacuum question
  50. Re: How much expensive are row level statistics?
  51. ALTER TABLE SET TABLESPACE and pg_toast
  52. Crashing DB or Server?
  53. Re: SAN/NAS options
  54. Re: SAN/NAS options
  55. Changes since 7.2
  56. Re: [postgis-users] Is my query planner failing me, or vice versa?
  57. Re: PostgreSQL performance question.
  58. Re: PostgreSQL performance question.
  59. Re: [postgis-users] Is my query planner failing me, or vice versa?
  60. Simple Join
  61. Auto-tuning a VIEW?
  62. Convert IN sublink to join
  63. Re: SAN/NAS options
  64. SAN/NAS options
  65. Re: Should Oracle outperform PostgreSQL on a complex
  66. Re: Should Oracle outperform PostgreSQL on a complex
  67. Lots of postmaster processes (fwd)
  68. using an index slows down a query??
  69. query from partitions
  70. Re: partitioning
  71. Re: How much expensive are row level statistics?
  72. Re: Should Oracle outperform PostgreSQL on a complex
  73. 7.4.7 vs. 8.1
  74. 2 phase commit: performance implications?
  75. Table Partitions / Partial Indexes
  76. Re: Should Oracle outperform PostgreSQL on a complex
  77. Should Oracle outperform PostgreSQL on a complex multidimensional query?
  78. How much expensive are row level statistics?
  79. Bitmasks
  80. Executing a shell command from a PG function
  81. Clustered tables and seqscan disabled
  82. Is RAID10 the best choice?
  83. Re: opinion on disk speed
  84. Re: FTP DOWNLOAD! Best cracked software supplied!
  85. Query not using index
  86. Re: Joining 2 tables with 300 million rows
  87. Re: Joining 2 tables with 300 million rows
  88. Joining 2 tables with 300 million rows
  89. Re: opinion on disk speed
  90. opinion on disk speed
  91. Re: Performance degradation after successive UPDATE's
  92. Re: view of view
  93. Disk tests for a new database server
  94. INSERTs becoming slower and slower
  95. view of view
  96. Re: !!Famous Software ftp download 2006!!
  97. Re: High context switches occurring
  98. Re: Performance degradation after successive UPDATE's
  99. First query is slow, subsequent queries fast
  100. table partitioning: effects of many sub-tables (was COPY too slow...)
  101. Query Fails with error calloc - Cannot alocate memory
  102. Join the same row
  103. Context switching and Xeon processors
  104. postgresql performance tuning
  105. Re: High context switches occurring
  106. postgresql performance tuning
  107. TSearch2 vs. Apache Lucene
  108. Re: Can this query go faster???
  109. Re: Can this query go faster???
  110. Can this query go faster???
  111. LVM and Postgres
  112. Memory Leakage Problem
  113. Re: Performance degradation after successive UPDATE's
  114. Re: [GENERAL] need help
  115. Missed index opportunity for outer join?
  116. Performance degradation after successive UPDATE's
  117. Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  118. Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  119. Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  120. BLCKSZ
  121. Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  122. Dividing up a single 250GB RAID10 server for postgres
  123. Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  124. Faster db architecture for a twisted table.
  125. Re: Database restore speed
  126. Small table or partial index?
  127. 15,000 tables - next step
  128. two disks - best way to use them?
  129. Re: pg_dump slow
  130. Re: pg_dump slow
  131. Re: Network permormance under windows
  132. Network permormance under windows
  133. Re: Database restore speed
  134. Re: Open request for benchmarking input (fwd)
  135. Re: Database restore speed
  136. Re: COPY into table too slow with index: now an I/O
  137. Database restore speed
  138. Re: 15,000 tables
  139. Insert performance slows down in large batch
  140. COPY into table too slow with index
  141. pg_stat* values ...
  142. Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  143. Re: pg_dump slow
  144. Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  145. filesystem performance with lots of files
  146. 15,000 tables
  147. slow insert into very large table
  148. About the relation between fragmentation of file and VACUUM
  149. Query is 800 times slower when running in function!
  150. Re: RES: pg_dump slow
  151. Query runs fast on one machine and slow on the other
  152. Select with grouping plan question
  153. Re: pg_dump slow
  154. pg_dump slow
  155. index auto changes after copying data ?
  156. Please help with this explain analyse...
  157. Re: Hardware/OS recommendations for large databases (
  158. Re: Hardware/OS recommendations for large databases (
  159. Re: Newbie question: ultra fast count(*)
  160. Re: Hardware/OS recommendations for large databases (
  161. Re: Hardware/OS recommendations for large databases (
  162. Re: Hardware/OS recommendations for large databases (
  163. Open request for benchmarking input
  164. Re: Open request for benchmarking input
  165. Re: Open request for benchmarking input
  166. Open request for benchmarking input
  167. Re: FTP DOWNLOAD! Best cracked software supplied!
  168. Newbie question: ultra fast count(*)
  169. Re: xlog flush request error
  170. Very slow queries - please help
  171. Re: Very slow queries - please help
  172. Very slow queries - please help.
  173. xlog flush request error
  174. Re: 8.1 count(*) distinct: IndexScan/SeqScan
  175. 8.1 count(*) distinct: IndexScan/SeqScan
  176. Re: High context switches occurring
  177. Re: High context switches occurring
  178. Binary Refcursor possible?
  179. Re: High context switches occurring
  180. Re: High context switches occurring
  181. Re: High context switches occurring
  182. Re: Stored Procedure
  183. Re: Stored Procedure
  184. High context switches occurring
  185. System queue
  186. Re: Hardware/OS recommendations for large databases (
  187. VERY slow after many updates
  188. What is the max number of database I can create in an instance of pgsql?
  189. ERROR: no value found for parameter 1 with JDBC and Explain Analyze
  190. Re: Hardware/OS recommendations for large databases (
  191. Re: Hardware/OS recommendations for large databases (
  192. Re: Hardware/OS recommendations for large databases (
  193. Re: Hardware/OS recommendations for large databases (
  194. Re: Hardware/OS recommendations for large databases (
  195. Re: Hardware/OS recommendations for large databases (
  196. weird performances problem
  197. unsubscribe
  198. Re: Hardware/OS recommendations for large databases (
  199. Re: [pgsql-www] Help speeding up delete
  200. Re: [pgsql-www] Help speeding up delete
  201. Strange query plan invloving a view
  202. PgPool and Postgresql sessions...
  203. Re: Hardware/OS recommendations for large databases (
  204. Re: Hardware/OS recommendations for large databases (
  205. Re: Hardware/OS recommendations for large databases (
  206. Re: Hardware/OS recommendations for large databases ( 5TB)
  207. Too Many OR's?
  208. Re: Hardware/OS recommendations for large databases (
  209. Re: Hardware/OS recommendations for large databases ( 5TB)
  210. Re: Hardware/OS recommendations for large databases ( 5TB)
  211. Re: Hardware/OS recommendations for large databases (
  212. Re: Hardware/OS recommendations for large databases (
  213. Re: Hardware/OS recommendations for large databases (
  214. Re: Hardware/OS recommendations for large databases (5TB)
  215. Re: Hardware/OS recommendations for large databases (
  216. Re: Help speeding up delete
  217. Hardware/OS recommendations for large databases (5TB)
  218. Help speeding up delete
  219. Postgres recovery time
  220. Re: FTP DOWNLOAD! Best cracked software supplied!
  221. Re: IO Error
  222. Re: 8.x index insert performance
  223. slow queries after ANALYZE
  224. Re: 8.x index insert performance
  225. Re: 8.x index insert performance
  226. Re: 8.x index insert performance
  227. Index Scan Costs versus Sort
  228. same plan, add 1 condition, 1900x slower
  229. Re: Sort performance on large tables
  230. Re: Some help on buffers and other performance tricks
  231. WAL sync behaviour
  232. Re: (View and SQL) VS plpgsql
  233. Re: Some help on buffers and other performance tricks
  234. Re: Some help on buffers and other performance tricks
  235. (View and SQL) VS plpgsql
  236. Re: Sort performance on large tables
  237. Outer Join performance in PostgreSQL
  238. Improving performance on multicolumn query
  239. Re: FTP DOWNLOAD! Best cracked software supplied!
  240. Re: Sort performance on large tables
  241. Re: Sort performance on large tables
  242. Sort performance on large tables
  243. Expensive function and the optimizer
  244. Re: Temporary Table
  245. Re: Temporary Table
  246. Figuring out which command failed
  247. Re: Performance PG 8.0 on dual opteron / 4GB / 3ware
  248. Re: Performance PG 8.0 on dual opteron / 4GB / 3ware
  249. Temporary Table
  250. FW: Used Memory