pgsql-performance since 2005-12-04 00:00

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 29 30

Dec. 4, 2005

Thread Author Time
Re: Faster db architecture for a twisted table. Mitchell Skinner 00:02
Re: Database restore speed David Lang 01:17
Re: Faster db architecture for a twisted table. Hélder M. Vieira 01:33
Re: Very slow queries - please help Thomas F. O'Connell 06:40
Re: 15,000 tables - next step William Yu 09:21
Re: 15,000 tables - next step Michael Riess 09:33
Re: Faster db architecture for a twisted table. Andreas Pflug 11:56
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 13:24
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane 18:31
Re: Faster db architecture for a twisted table. Klint Gore 22:24
Dividing up a single 250GB RAID10 server for postgres Rory Campbell-Lange 23:49

Dec. 5, 2005

Thread Author Time
Query Fails with error calloc - Cannot alocate memory Howard Oblowitz 07:42
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 10:28
BLCKSZ Olleg Samoylov 13:47
Re: two disks - best way to use them? Olleg Samoylov 13:56
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane 14:32
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 14:44
Re: BLCKSZ Tom Lane 15:02
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane 15:11
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 15:40
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 15:45
Re: two disks - best way to use them? Thomas Harold 15:48
Re: two disks - best way to use them? David Lang 16:15
Re: Best hardware Mirjam (sent by Nabble.com) 16:24
Re: two disks - best way to use them? Thomas Harold 16:45
Performance degradation after successive UPDATE's Assaf Yaari 17:05
Re: Performance degradation after successive UPDATE's Bruno Wolff III 20:36
Re: BLCKSZ Olleg 21:32
Missed index opportunity for outer join? rm_pg 22:13
Re: Missed index opportunity for outer join? Tom Lane 22:38
Re: Missed index opportunity for outer join? rm_pg 23:05

Dec. 6, 2005

Thread Author Time
Re: BLCKSZ Alvaro Herrera 00:07
Re: BLCKSZ Ron 01:21
Re: 15,000 tables - next step Jan Wieck 03:07
Re: two disks - best way to use them? David Lang 03:54
Re: BLCKSZ Tom Lane 05:51
Re: two disks - best way to use them? Thomas Harold 05:52
Re: two disks - best way to use them? Ron 08:12
need help Jenny 08:38
Re: need help Tino Wildenhain 08:54
Re: Performance degradation after successive UPDATE's Assaf Yaari 09:08
Memory Leakage Problem Kathy Lo 09:22
LVM and Postgres Rory Campbell-Lange 09:38
need help (not anymore) Jenny 09:41
Can this query go faster??? Joost Kraaijeveld 09:43
Re: Can this query go faster??? Michael Riess 09:51
Re: Performance degradation after successive UPDATE's Pandurangan R S 09:52
Re: Can this query go faster??? Csaba Nagy 09:52
Re: Can this query go faster??? Markus Wollny 09:54
Re: Can this query go faster??? Joost Kraaijeveld 10:21
Re: Can this query go faster??? Tino Wildenhain 10:32
Re: BLCKSZ Olleg 10:40
Re: need help Alban Hertroys 10:45
Re: BLCKSZ Steinar H. Gunderson 10:59
Re: Can this query go faster??? Joost Kraaijeveld 11:21
Re: Can this query go faster??? Tino Wildenhain 11:36
Re: BLCKSZ David Lang 11:39
Re: Can this query go faster??? Joost Kraaijeveld 12:20
Re: Can this query go faster??? Tino Wildenhain 12:30
Re: Can this query go faster??? Csaba Nagy 12:32
Re: Performance degradation after successive UPDATE's Jan Wieck 12:34
Re: Can this query go faster??? Ron 13:41
Re: Can this query go faster??? Merlin Moncure 13:58
Re: Memory Leakage Problem Tom Lane 14:45
Re: two disks - best way to use them? Thomas Harold 16:00
postgresql performance tuning Ameet Kini 16:14
Re: 8.1 count(*) distinct: IndexScan/SeqScan Pailloncy Jean-Gerard 16:19
TSearch2 vs. Apache Lucene Joshua Kramer 16:47
Re: Missed index opportunity for outer join? Tom Lane 16:57
Re: TSearch2 vs. Apache Lucene Michael Riess 16:59
Re: TSearch2 vs. Apache Lucene Russell Garrett 17:00
Re: TSearch2 vs. Apache Lucene Oleg Bartunov 17:14
Re: TSearch2 vs. Apache Lucene Bruce Momjian 17:27
postgresql performance tuning Ameet Kini 17:44
Re: Memory Leakage Problem Scott Marlowe 17:48
Re: TSearch2 vs. Apache Lucene Tom Lane 18:02
Re: postgresql performance tuning Tom Lane 18:03
Re: TSearch2 vs. Apache Lucene Michael Riess 18:28
Re: TSearch2 vs. Apache Lucene Bruce Momjian 18:32
Re: postgresql performance tuning Vivek Khera 18:33
Re: High context switches occurring Anjan Dave 19:04
Re: High context switches occurring Vivek Khera 19:25
Re: postgresql performance tuning Vivek Khera 20:07
Re: LVM and Postgres August Zajonc 20:12
Re: Missed index opportunity for outer join? Ron Mayer 20:17
Join the same row Edison Azzi 20:22
Re: Missed index opportunity for outer join? Tom Lane 20:33
Re: Performance degradation after successive UPDATE's Bruno Wolff III 20:44
Re: postgresql performance tuning Alan Stange 20:48
Re: Can this query go faster??? Bruno Wolff III 20:50
Context switching and Xeon processors Brandon Metcalf 21:01
Re: postgresql performance tuning Michael Riess 21:02
Re: Missed index opportunity for outer join? Ron Mayer 21:15
Re: postgresql performance tuning Tom Lane 21:20
Re: Missed index opportunity for outer join? Tom Lane 21:24
Re: LVM and Postgres Rory Campbell-Lange 21:36
Re: Context switching and Xeon processors Tom Lane 21:36
Re: postgresql performance tuning Alan Stange 21:39
Re: Missed index opportunity for outer join? Ron Mayer 21:42
Re: Context switching and Xeon processors Brandon Metcalf 21:45
Re: Context switching and Xeon processors Steinar H. Gunderson 21:52
Re: two disks - best way to use them? David Lang 21:57
Re: postgresql performance tuning Ameet Kini 22:03
Re: High context switches occurring Tom Lane 23:45

Dec. 7, 2005

Thread Author Time
Re: postgresql performance tuning Michael Stone 00:23
Re: LVM and Postgres Michael Stone 00:25
Re: LVM and Postgres Alex Turner 00:52
Re: LVM and Postgres Michael Stone 01:31
Re: TSearch2 vs. Apache Lucene Christopher Kings-Lynne 01:40
table partitioning: effects of many sub-tables (was COPY too slow...) Rick Schumeyer 03:06
Re: LVM and Postgres Kevin Brown 04:14
Re: Query Fails with error calloc - Cannot alocate memory Christopher Kings-Lynne 04:18
Re: High context switches occurring Bruce Momjian 04:34
Re: Effects of cascading references in foreign keys Bruce Momjian 04:41
Re: High context switches occurring Tom Lane 04:49
Re: Query Fails with error calloc - Cannot alocate memory Neil Conway 06:31
Re: High context switches occurring Tatsuo Ishii 07:26
Re: TSearch2 vs. Apache Lucene Michael Riess 07:56
Re: TSearch2 vs. Apache Lucene Christopher Kings-Lynne 08:20
Re: TSearch2 vs. Apache Lucene Michael Riess 08:28
Re: Join the same row Richard Huxton 09:27
First query is slow, subsequent queries fast Stephan Vollmer 10:46
Re: First query is slow, subsequent queries fast Oleg Bartunov 10:55
Re: Performance degradation after successive UPDATE's Assaf Yaari 12:14
Re: postgresql performance tuning Vivek Khera 15:50
Re: High context switches occurring Anjan Dave 15:54
Re: High context switches occurring Scott Marlowe 16:24
Re: First query is slow, subsequent queries fast Stephan Vollmer 18:33
Re: Join the same row Edison Azzi 18:45
Re: Join the same row Richard Huxton 18:55
Re: Performance degradation after successive UPDATE's Bruno Wolff III 20:04
Re: Memory Leakage Problem Scott Marlowe 21:33

Dec. 8, 2005

Thread Author Time
Re: Memory Leakage Problem Kathy Lo 02:25
view of view Keith Worthington 02:47
Re: Memory Leakage Problem Mike Rylander 03:46
Re: Memory Leakage Problem Tom Lane 04:38
INSERTs becoming slower and slower 08:36
Re: INSERTs becoming slower and slower Christopher Kings-Lynne 08:44
Re: INSERTs becoming slower and slower Matteo Beccati 10:59
Should Oracle outperform PostgreSQL on a complex multidimensional query? Pål Stenslet 11:26
Re: LVM and Postgres Rory Campbell-Lange 11:28
Disk tests for a new database server Rory Campbell-Lange 12:12
Re: view of view Merlin Moncure 13:13
Re: view of view Rich Doughty 13:46
Re: Memory Leakage Problem Mike Rylander 14:00
Re: Performance degradation after successive UPDATE's Assaf Yaari 14:29
Re: Disk tests for a new database server Steve Poe 15:06
opinion on disk speed Vivek Khera 16:52
Joining 2 tables with 300 million rows Amit V Shah 16:59
Re: opinion on disk speed Dave Page 17:03
slow COMMITs Evgeny Gridasov 17:10
Re: opinion on disk speed Scott Marlowe 17:50
Re: Joining 2 tables with 300 million rows Dmitri Bichko 18:47
Re: opinion on disk speed Jeffrey W. Baker 19:21
Re: Joining 2 tables with 300 million rows Amit V Shah 22:01
Re: Disk tests for a new database server Rory Campbell-Lange 22:56
Re: opinion on disk speed David Lang 23:43

Dec. 9, 2005

Thread Author Time
Query not using index Kaloyan Iliev 09:36
Re: opinion on disk speed Jeremy Haile 14:15
Re: Query not using index Jaime Casanova 15:06
Re: Joining 2 tables with 300 million rows Jeff Trout 15:32
Re: opinion on disk speed Frank Wiles 15:47
Re: opinion on disk speed Andreas Pflug 15:50
Re: opinion on disk speed Frank Wiles 15:50
Re: opinion on disk speed Frank Wiles 15:58
Re: Query not using index Kaloyan Iliev 16:38
Re: Query not using index Kaloyan Iliev 16:39

Dec. 10, 2005

Thread Author Time
Is RAID10 the best choice? Carlos Benkendorf 11:34
Clustered tables and seqscan disabled Henrique Engelmann 15:29
Executing a shell command from a PG function 📎 Yves Vindevogel 15:55
Re: Executing a shell command from a PG function Jaime Casanova 16:14
Re: Executing a shell command from a PG function Michael Fuhr 16:22
Re: Executing a shell command from a PG function 📎 Yves Vindevogel 16:53
Re: Clustered tables and seqscan disabled Tom Lane 16:53
Bitmasks Ivan Voras 17:12
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Manfred Koizar 17:14

Dec. 11, 2005

Thread Author Time
Re: Bitmasks Greg Stark 06:12
How much expensive are row level statistics? Carlos Benkendorf 11:53
Re: How much expensive are row level statistics? Michael Fuhr 19:44
Re: Join the same row Tom Lane 20:36
Re: Should Oracle outperform PostgreSQL on a complex multidimensional query? Tom Lane 20:38
Re: Should Oracle outperform PostgreSQL on a complex Luke Lonergan 21:15

Dec. 12, 2005

Thread Author Time
Table Partitions / Partial Indexes Mike C 02:07
Re: Table Partitions / Partial Indexes Tom Lane 02:39
Re: Table Partitions / Partial Indexes Mike C 02:49
Re: Is RAID10 the best choice? Alex Turner 04:45
7.4.7 vs. 8.1 Szabolcs BALLA 08:54
2 phase commit: performance implications? Andy Ballingall 09:13
Re: 7.4.7 vs. 8.1 Steinar H. Gunderson 12:04
Re: How much expensive are row level statistics? Alvaro Herrera 13:23
Re: Very slow queries - please help Bealach-na Bo 16:24
Re: Should Oracle outperform PostgreSQL on a complex Luke Lonergan 18:30
Re: How much expensive are row level statistics? Merlin Moncure 18:33
Re: opinion on disk speed Vivek Khera 18:42
Re: How much expensive are row level statistics? Michael Fuhr 18:50
Re: Memory Leakage Problem Will Glynn 20:19
Re: How much expensive are row level statistics? Michael Fuhr 20:37
Re: Memory Leakage Problem Mike Rylander 20:48
Re: opinion on disk speed Vivek Khera 21:59
Re: opinion on disk speed J. Andrew Rogers 22:16

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 29 30