pgsql-performance - November 2005

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 6 7 8 9 10 11 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Nov. 1, 2005

Thread Author Time
Re: 8.1beta3 performance Steinar H. Gunderson 02:00
Re: 8.1beta3 performance Neil Conway 02:06
pgbench results interpretation? Joost Kraaijeveld 08:03
Re: pgbench results interpretation? Gavin Sherry 09:16
Re: pgbench results interpretation? Joost Kraaijeveld 10:05
Re: 8.x index insert performance Kelly Burkhart 13:33
Re: 8.x index insert performance Tom Lane 13:45
solutions for new Postgresql application testing Geoffrey 14:14
Re: 8.1beta3 performance Jon Brisbin 14:50
Re: 8.x index insert performance Ron Peacetree 15:37
Re: 8.1beta3 performance Dave Page 15:49
Re: 8.1beta3 performance Tom Lane 17:24
improvise callbacks in plpgsql Merlin Moncure 19:00
Re: solutions for new Postgresql application testing Merlin Moncure 19:39
Re: improvise callbacks in plpgsql Tom Lane 21:29
Re: improvise callbacks in plpgsql Merlin Moncure 22:13
Re: improvise callbacks in plpgsql Jim C. Nasby 23:04
Re: solutions for new Postgresql application testing Geoffrey 23:12
Joining views disables indexes? Mitch Pirtle 23:16
Re: Joining views disables indexes? Jim C. Nasby 23:23
Re: Joining views disables indexes? Steinar H. Gunderson 23:28
Re: Joining views disables indexes? Tom Lane 23:28

Nov. 2, 2005

Thread Author Time
Re: performance of implicit join vs. explicit conditions on inet queries? Qingqing Zhou 01:19
Re: performance of implicit join vs. explicit conditions on inet queries? Tom Lane 04:20
Re: 8.1beta3 performance PostgreSQL 09:32
Re: pgbench results interpretation? Gavin Sherry 10:16
Re: insert performance for win32 Merlin Moncure 13:36
Re: improvise callbacks in plpgsql Merlin Moncure 13:45
Re: insert performance for win32 Magnus Hagander 13:54
Re: 8.1beta3 performance Tom Lane 14:41
Re: pgbench results interpretation? Joost Kraaijeveld 14:41
Re: insert performance for win32 Marc Cousin 14:47
Re: insert performance for win32 Tom Lane 15:11
Performance difference between sql and pgsql function... Cristian Prieto 15:32
Re: improvise callbacks in plpgsql Merlin Moncure 16:47
Re: improvise callbacks in plpgsql Merlin Moncure 17:04
Re: 8.x index insert performance Greg Stark 17:26
Trigger Rowsets Ralph Mason 23:34
Re: [PERFORM] improvise callbacks in plpgsql Jim C. Nasby 23:44
Re: Trigger Rowsets Jim C. Nasby 23:50

Nov. 3, 2005

Thread Author Time
Re: [PERFORM] improvise callbacks in plpgsql David Fetter 02:52
Sorted union Scott Lamb 05:13
Re: Sorted union Scott Lamb 05:27
Re: insert performance for win32 Qingqing Zhou 07:11
Re: Sorted union Merlin Moncure 13:53
Re: [PERFORM] improvise callbacks in plpgsql Merlin Moncure 14:01
Function with table%ROWTYPE globbing Sven Willenberger 15:14
Re: Function with table%ROWTYPE globbing Merlin Moncure 15:37
Re: Sorted union Scott Lamb 15:41
Re: Sorted union Merlin Moncure 16:20
Re: Sorted union Scott Lamb 18:02
Re: insert performance for win32 Merlin Moncure 18:03
Re: Sorted union Merlin Moncure 18:21
Re: Sorted union Kevin Grittner 18:32
Re: Sorted union Merlin Moncure 18:37
Re: insert performance for win32 Merlin Moncure 18:42
Re: insert performance for win32 Merlin Moncure 18:47
Re: Sorted union Scott Lamb 18:49
Re: insert performance for win32 Magnus Hagander 19:04
Re: Sorted union Kevin Grittner 19:11
Re: insert performance for win32 Qingqing Zhou 20:25
Re: insert performance for win32 Magnus Hagander 20:30
Re: insert performance for win32 Qingqing Zhou 20:34
Re: insert performance for win32 Magnus Hagander 20:39
Re: insert performance for win32 Merlin Moncure 21:04
Re: insert performance for win32 Qingqing Zhou 21:06
Re: insert performance for win32 Magnus Hagander 21:15
Re: insert performance for win32 Qingqing Zhou 21:46
Encoding on 8.0.4 Don Drake 22:35
Re: insert performance for win32 Qingqing Zhou 23:30
Re: insert performance for win32 📎 Tom Lane 23:56

Nov. 4, 2005

Thread Author Time
Re: insert performance for win32 Qingqing Zhou 07:29
Searching union views not using indices Michal Taborsky 11:38
Re: insert performance for win32 📎 Merlin Moncure 13:49
Re: insert performance for win32 Merlin Moncure 14:08
Re: insert performance for win32 Tom Lane 14:59
Re: Searching union views not using indices Richard Huxton 15:01
Re: Searching union views not using indices Merlin Moncure 15:07
Re: insert performance for win32 Merlin Moncure 15:12
Re: Searching union views not using indices Michael Fuhr 15:12
Re: insert performance for win32 Tom Lane 15:21
Re: insert performance for win32 Merlin Moncure 15:31
Re: Searching union views not using indices Tom Lane 15:31
Re: insert performance for win32 Tom Lane 15:36
Re: insert performance for win32 Merlin Moncure 15:41
Re: Searching union views not using indices Michal Taborsky 15:55
Re: insert performance for win32 Merlin Moncure 16:16
Re: insert performance for win32 Tom Lane 16:33
Re: Searching union views not using indices Tom Lane 17:53
Re: insert performance for win32 Merlin Moncure 17:56
Re: insert performance for win32 Tom Lane 18:01
Re: insert performance for win32 Merlin Moncure 18:07
Re: [PERFORM] insert performance for win32 David Fetter 18:14
Re: insert performance for win32 Tom Lane 18:14
Re: insert performance for win32 Bruce Momjian 18:15
Re: [HACKERS] insert performance for win32 Tom Lane 18:19
Re: insert performance for win32 Magnus Hagander 18:21
Re: [HACKERS] insert performance for win32 Bruce Momjian 18:21
Re: [HACKERS] insert performance for win32 Magnus Hagander 18:30
Re: insert performance for win32 Qingqing Zhou 18:30
Re: insert performance for win32 Qingqing Zhou 22:17

Nov. 6, 2005

Thread Author Time
Re: [HACKERS] insert performance for win32 Simon Riggs 09:00
8.1 iss PostgreSQL 09:55
Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian?? Joost Kraaijeveld 13:30
Re: 8.1 iss Tom Lane 16:31
Re: [PERFORM] insert performance for win32 Andrew Dunstan 17:10
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian?? Tom Lane 17:17
Performance problem with pg8.0 Jeroen van Iddekinge 18:02
Re: 8.1 iss Greg Stark 19:24
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld 19:33
Re: 8.1 iss Luke Lonergan 20:19
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Tom Lane 20:26

Nov. 7, 2005

Thread Author Time
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld 04:25
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Christopher Kings-Lynne 04:37
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld 05:04
Re: 8.1 iss Dennis Bjorklund 05:44
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld 05:46
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Dave Page 08:51
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld 09:02
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Dave Page 09:17
Re: Performance problem with pg8.0 Richard Huxton 09:46
Re: Temporary Table Alvaro Herrera 11:07
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian?? Alex Turner 14:47
FW: Used Memory Christian Paul B. Cosinas 15:34
Temporary Table Christian Paul B. Cosinas 15:35
Re: 8.1 iss PostgreSQL 17:22
Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Andreas Pflug 17:45
Index + mismatching datatypes [WAS: index on custom function; explain] Enrico Weigelt 18:07
Re: Index + mismatching datatypes [WAS: index on custom Neil Conway 20:45
Figuring out which command failed Ralph Mason 21:30
Re: Temporary Table Ralph Mason 21:40

Nov. 8, 2005

Thread Author Time
Expensive function and the optimizer Craig A. James 01:58
Re: Temporary Table Joshua D. Drake 02:10
Re: Temporary Table Christopher Kings-Lynne 02:14
Re: Temporary Table Christopher Kings-Lynne 02:15
Re: Temporary Table Jeff Frost 02:22
Re: Temporary Table Christopher Kings-Lynne 02:24
Re: Temporary Table Andrew McMillan 02:35
Re: Expensive function and the optimizer Tom Lane 04:12
Sort performance on large tables Charlie Savage 07:05
Re: Temporary Table Christian Paul B. Cosinas 10:04
Re: Temporary Table Christian Paul B. Cosinas 10:09
Re: Temporary Table Christian Paul B. Cosinas 10:22
Re: 8.1 iss Mario Weilguni 10:34
Re: Sort performance on large tables Richard Huxton 11:14
Re: Sort performance on large tables Marc Morin 13:19
Re: Sort performance on large tables Luke Lonergan 16:21
Re: Sort performance on large tables Stephan Szabo 17:38
Re: Sort performance on large tables Luke Lonergan 19:09
Re: Sort performance on large tables Stephan Szabo 20:48
Re: Sort performance on large tables Charlie Savage 22:06
Re: Sort performance on large tables Tom Lane 22:26
Re: Figuring out which command failed Thomas F. O'Connell 23:26
Re: Sort performance on large tables Charlie Savage 23:47

Nov. 9, 2005

Thread Author Time
Re: Sort performance on large tables Christopher Kings-Lynne 01:49
[No subject] William Lai 02:23
Re: Sort performance on large tables Charlie Savage 05:49
Re: Sort performance on large tables Simon Riggs 09:35
Improving performance on multicolumn query Jan Kesten 12:08
Re: Improving performance on multicolumn query Steinar H. Gunderson 12:44
Re: Improving performance on multicolumn query Richard Huxton 12:54
Re: Improving performance on multicolumn query Steinar H. Gunderson 13:00
Re: Improving performance on multicolumn query Christopher Kings-Lynne 13:19
Re: Sort performance on large tables Charlie Savage 17:13
Re: Improving performance on multicolumn query Jan Kesten 17:31
Re: Sort performance on large tables Ron Peacetree 18:26
Outer Join performance in PostgreSQL Ashok Agrawal 19:59
Some help on buffers and other performance tricks 📎 Yves Vindevogel 20:11
(View and SQL) VS plpgsql Eric Lauzon 20:43
Re: Outer Join performance in PostgreSQL Michael Alan Dorman 20:45
Re: Some help on buffers and other performance tricks Ron Peacetree 21:24
Re: Outer Join performance in PostgreSQL Stephan Szabo 22:47
Re: Some help on buffers and other performance tricks Alvaro Herrera 23:07
Re: Some help on buffers and other performance tricks Frank Wiles 23:53

Nov. 10, 2005

Thread Author Time
Re: Some help on buffers and other performance tricks Alvaro Herrera 00:43
Re: Some help on buffers and other performance tricks Frank Wiles 00:54
Re: Some help on buffers and other performance tricks Ron Peacetree 04:20
Re: (View and SQL) VS plpgsql Nörder-Tuitje 08:45
WAL sync behaviour Steinar H. Gunderson 13:32
same plan, add 1 condition, 1900x slower Mitch Skinner 13:42
Re: WAL sync behaviour Richard Huxton 14:14
Re: WAL sync behaviour Steinar H. Gunderson 14:25
Re: WAL sync behaviour Michael Stone 14:43
Re: Some help on buffers and other performance tricks Scott Marlowe 15:16
Re: Some help on buffers and other performance tricks Frank Wiles 15:25
Re: Some help on buffers and other performance tricks Merlin Moncure 15:43
Re: Some help on buffers and other performance tricks Scott Marlowe 15:51
Re: WAL sync behaviour Scott Marlowe 15:52
Re: WAL sync behaviour Michael Stone 16:00
Re: Sort performance on large tables Ron Peacetree 16:23
Re: Sort performance on large tables Alex Turner 16:34
Re: WAL sync behaviour Tom Lane 16:39
Re: WAL sync behaviour mark 16:53
Index Scan Costs versus Sort Charlie Savage 16:59
Re: WAL sync behaviour Scott Marlowe 17:00
Re: same plan, add 1 condition, 1900x slower Tom Lane 17:23
Re: WAL sync behaviour Tom Lane 17:44
Re: WAL sync behaviour Steinar H. Gunderson 17:58
Re: Index Scan Costs versus Sort Tom Lane 18:04
Re: Outer Join performance in PostgreSQL Ashok Agrawal 18:17

Browse Archives

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