pgsql-performance - October 2006

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 28 29 30 31

Oct. 2, 2006

Thread Author Time
selecting data from information_schema.columns performance. Steve Martin 02:26
Re: selecting data from information_schema.columns performance. Tom Lane 03:01
Re: PostgreSQL runs a query much slower than BDE and Simon Riggs 13:06
Re: any hope for my big query? Shaun Thomas 15:32
How much memory in 32 bits Architecture to Shared Buffers is Possible Marcelo Costa 15:49
Re: Optimizing queries Simon Riggs 16:08
Re: archive wal's failure and load increase. Simon Riggs 16:25
Re: How much memory in 32 bits Architecture to Shared Buffers Joshua D. Drake 16:26
Re: How much memory in 32 bits Architecture to Shared Buffers is Possible Marcelo Costa 16:31
Unsubscribe uwcssa 17:36
Re: Table not getting vaccumed. Jim C. Nasby 19:08
Re: selecting data from information_schema.columns performance. Jim C. Nasby 19:11
Re: Unsubscribe Markus Schaber 22:36
Re: selecting data from information_schema.columns Steve Martin 23:31

Oct. 3, 2006

Thread Author Time
Re: BUG #2658: Query not using index Bruno Wolff III 00:01
Re: selecting data from information_schema.columns Jim Nasby 01:49
Re: Performace Optimization for Dummies Carlo Stonebanks 02:43
Re: Performace Optimization for Dummies Carlo Stonebanks 03:01
Re: Performace Optimization for Dummies Carlo Stonebanks 03:01
Re: Performace Optimization for Dummies Carlo Stonebanks 03:03
Re: Forcing the use of particular execution plans Tim Truman 03:59
Re: Forcing the use of particular execution plans Tom Lane 04:19
Re: Forcing the use of particular execution plans Tim Truman 06:51
Re: High CPU Load Jérôme BENOIS 07:36
Re: Performace Optimization for Dummies Markus Schaber 08:15
Re: Performace Optimization for Dummies Markus Schaber 08:20
Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks 08:33
Re: Performace Optimization for Dummies Carlo Stonebanks 09:32
Re: Performace Optimization for Dummies Carlo Stonebanks 09:36
Poor performance on very simple query ? Arnaud Lesauvage 11:25
Re: Poor performance on very simple query ? Steinar H. Gunderson 12:00
Re: Poor performance on very simple query ? Arnaud Lesauvage 12:04
Re: Poor performance on very simple query ? Alexander Staubo 12:08
Re: Poor performance on very simple query ? Tobias Brox 12:10
Re: Poor performance on very simple query ? Tobias Brox 12:11
Re: Poor performance on very simple query ? Arnaud Lesauvage 12:13
Re: Poor performance on very simple query ? Tobias Brox 12:17
Re: Poor performance on very simple query ? Arnaud Lesauvage 12:25
Re: Poor performance on very simple query ? Guillaume Cottenceau 12:27
Re: Poor performance on very simple query ? Tom Lane 14:35
Re: Unsubscribe Geoffrey 14:49
Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure 15:04
Re: Poor performance on very simple query ? Darcy Buskermolen 15:10
Re: Performance Optimization for Dummies 2 - the SQL Alex Stapleton 15:16
Re: Poor performance on very simple query ? Darcy Buskermolen 15:35
Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks 16:58
Re: Unsubscribe felix 17:29
Re: Unsubscribe Carlo Stonebanks 17:54
Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks 18:07
Re: BUG #2658: Query not using index Graham Davis 18:20
Re: BUG #2658: Query not using index Chris Browne 19:02
Re: BUG #2658: Query not using index Graham Davis 19:10
Re: BUG #2658: Query not using index Graham Davis 19:13
Re: BUG #2658: Query not using index Chris Browne 19:18
Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure 19:21
Re: BUG #2658: Query not using index Graham Davis 20:32
Re: BUG #2658: Query not using index Tom Lane 20:48
Re: BUG #2658: Query not using index Bruno Wolff III 20:48
Re: BUG #2658: Query not using index Graham Davis 20:52
Re: BUG #2658: Query not using index Mark Lewis 21:06
Re: BUG #2658: Query not using index Graham Davis 21:23
Re: BUG #2658: Query not using index Mark Lewis 21:34
Re: BUG #2658: Query not using index Graham Davis 21:35
PostgreSQL Caching Adnan DURSUN 21:49
Re: BUG #2658: Query not using index Mark Lewis 21:54
Re: PostgreSQL Caching Tomeh, Husam 22:11
Re: BUG #2658: Query not using index Tom Lane 22:39
Re: PostgreSQL Caching Adnan DURSUN 23:53

Oct. 4, 2006

Thread Author Time
Re: Forcing the use of particular execution plans Ron Mayer 00:10
Re: Forcing the use of particular execution plans Jim C. Nasby 00:55
Re: PostgreSQL Caching Tomeh, Husam 01:29
Re: PostgreSQL Caching Adnan DURSUN 02:24
simple case using index on windows but not on linux simon godden 07:48
Unsubscribe Luc Delgado 08:03
Re: simple case using index on windows but not on linux Heikki Linnakangas 09:11
Re: simple case using index on windows but not on linux simon godden 09:19
Re: simple case using index on windows but not on linux Richard Huxton 09:36
Re: simple case using index on windows but not on linux simon godden 09:40
Re: simple case using index on windows but not on linux Richard Huxton 10:39
Re: slow queue-like empty table Tobias Brox 10:59
Re: Performance Optimization for Dummies 2 - the SQL Markus Schaber 12:11
Re: PostgreSQL Caching Dave Dutcher 12:38
Re: PostgreSQL Caching Brad Nicholson 13:47
Re: simple case using index on windows but not on linux Richard Huxton 13:47
Re: simple case using index on windows but not on linux simon godden 13:47
Re: PostgreSQL Caching Brad Nicholson 13:52
Re: simple case using index on windows but not on linux Richard Huxton 14:07
Re: simple case using index on windows but not on linux Dave Dutcher 14:12
Re: simple case using index on windows but not on linux simon godden 14:46
Re: simple case using index on windows but not on linux simon godden 14:48
Re: Unsubscribe Joshua D. Drake 15:30
Re: Unsubscribe Bruno Wolff III 15:33
Re: Unsubscribe Tobias Brox 15:44
Re: Unsubscribe Nolan Cafferky 15:47
Re: Unsubscribe Joshua D. Drake 15:54
Re: Unsubscribe Joshua D. Drake 16:00
Re: Unsubscribe Csaba Nagy 16:02
Re: Unsubscribe D'Arcy J.M. Cain 16:19
Re: Unsubscribe Joshua D. Drake 16:24
Re: Unsubscribe Joshua D. Drake 16:26
Re: Unsubscribe Mark Lewis 16:26
Re: Unsubscribe Bruno Wolff III 16:28
Re: Unsubscribe Csaba Nagy 16:35
Re: Unsubscribe Steve Atkins 16:44
Re: Unsubscribe Geoffrey 16:48
Re: Poor performance on very simple query ? Markus Schaber 17:10
UPDATE becomes mired / win32 Steve Peterson 17:54
Multi-key index not beeing used - bug? Tobias Brox 18:12
Re: UPDATE becomes mired / win32 me 18:13
Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks 18:22
Re: Multi-key index not beeing used - bug? Graham Davis 18:22
Re: Unsubscribe Michael Stone 19:19
Re: UPDATE becomes mired / win32 Tom Lane 20:28
Re: Multi-key index not beeing used - bug? Tom Lane 20:33
Re: Multi-key index not beeing used - bug? Tobias Brox 20:41
Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure 21:07
Re: any hope for my big query? Ben 21:40
Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks 22:41

Oct. 5, 2006

Thread Author Time
pg_trgm indexes giving bad estimations? Ben 01:35
Re: pg_trgm indexes giving bad estimations? Tom Lane 01:54
Re: UPDATE becomes mired / win32 Steve Peterson 04:56
Re: UPDATE becomes mired / win32 Steve Peterson 05:06
Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure 06:26
Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks 07:33
Re: UPDATE becomes mired / win32 Tom Lane 13:19
Re: Performance Optimization for Dummies 2 - the SQL Tom Lane 13:24
Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure 13:30
Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks 16:29
Re: Performance Optimization for Dummies 2 - the SQL Tom Lane 16:35
Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks 17:46

Oct. 6, 2006

Thread Author Time
Re: slow queue-like empty table Jim Nasby 03:42
Re: Unsubscribe Jim Nasby 03:47
Re: Unsubscribe Jim Nasby 03:49
Re: Unsubscribe Jim Nasby 03:52
Re: any hope for my big query? Jim Nasby 04:02
Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks 16:44
Re: Performance Optimization for Dummies 2 - the SQL Scott Marlowe 16:53
Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure 18:53
Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks 20:45

Oct. 7, 2006

Thread Author Time
Simple join optimized badly? Craig A. James 06:34
Re: Simple join optimized badly? Tom Lane 15:51

Oct. 8, 2006

Thread Author Time
Re: Simple join optimized badly? Denis Lussier 01:50
Re: Simple join optimized badly? Jim Nasby 17:17
Re: Performance Optimization for Dummies 2 - the SQL Jim C. Nasby 20:34
Re: Performance Optimization for Dummies 2 - the SQL Jim C. Nasby 20:36
Re: Simple join optimized badly? Josh Berkus 23:05
Re: Simple join optimized badly? Tom Lane 23:16

Oct. 9, 2006

Thread Author Time
Re: Simple join optimized badly? Craig A. James 01:07
Re: Simple join optimized badly? Bruce Momjian 02:12
Re: Simple join optimized badly? Mark Kirkwood 02:41
Re: Simple join optimized badly? Craig A. James 02:42
Re: Simple join optimized badly? Craig A. James 02:46
Re: Simple join optimized badly? Chris Browne 02:58
Re: Simple join optimized badly? Mark Kirkwood 03:38
Re: Simple join optimized badly? Tom Lane 04:43
autovacuum not working? 📎 Medora Schauer 13:38
Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure 13:49
Re: autovacuum not working? Bill Moran 14:11
Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure 14:19
Re: autovacuum not working? Medora Schauer 14:27
Re: Simple join optimized badly? Josh Berkus 17:12
Re: Simple join optimized badly? Tom Lane 17:41
Re: Simple join optimized badly? Chris Browne 18:07
odd variances in count(*) times Merlin Moncure 18:17
Re: odd variances in count(*) times Stephen Frost 18:30
Re: odd variances in count(*) times Merlin Moncure 18:41
Re: odd variances in count(*) times Steinar H. Gunderson 18:45
Re: Simple join optimized badly? Scott Marlowe 20:30
Re: Simple join optimized badly? Jim C. Nasby 21:18
Re: odd variances in count(*) times Jim C. Nasby 21:23
Re: autovacuum not working? Jim C. Nasby 21:26
Re: Simple join optimized badly? Tobias Brox 21:33
Re: Simple join optimized badly? Jim C. Nasby 22:30
Re: Simple join optimized badly? Tom Lane 22:39
Re: Simple join optimized badly? Joshua D. Drake 22:41
Re: Simple join optimized badly? Tom Lane 22:45

Oct. 10, 2006

Thread Author Time
Re: Simple join optimized badly? Brian Herlihy 01:10
Re: Simple join optimized badly? Craig A. James 03:16
Re: Simple join optimized badly? Joshua D. Drake 03:22
Re: odd variances in count(*) times Merlin Moncure 06:30
Postgre 8.0 Installation - Issues Ravindran G - TLS, Chennai. 10:47
Re: Simple join optimized badly? Jim C. Nasby 14:00
Re: Simple join optimized badly? Jim C. Nasby 14:02
Re: Simple join optimized badly? Jim C. Nasby 14:07
Re: Simple join optimized badly? Tom Lane 14:14
Re: [PERFORM] Postgre 8.0 Installation - Issues Jim C. Nasby 14:15
Re: Simple join optimized badly? Steinar H. Gunderson 14:16
Re: Simple join optimized badly? Jim C. Nasby 14:21
Re: Simple join optimized badly? Joshua D. Drake 14:23
Re: Simple join optimized badly? Joshua D. Drake 14:24
Re: Simple join optimized badly? Joshua D. Drake 14:25
Re: [PERFORM] Postgre 8.0 Installation - Issues Joshua D. Drake 14:28
Re: [PERFORM] Postgre 8.0 Installation - Issues Bill Moran 14:34
Re: [PERFORM] Postgre 8.0 Installation - Issues AgentM 14:39
Re: [PERFORM] Postgre 8.0 Installation - Issues Joshua D. Drake 15:20
Re: [PERFORM] Postgre 8.0 Installation - Issues Dave Page 15:26
Re: [PERFORM] Postgre 8.0 Installation - Issues Bill Moran 15:26
long running transactions Tobias Brox 16:10
Re: [PERFORM] Postgre 8.0 Installation - Issues Joshua D. Drake 16:10
Re: [PERFORM] Postgre 8.0 Installation - Issues Joshua D. Drake 16:11

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 28 29 30 31