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

Sept. 1, 2005

Thread Author Time
Re: Big question on insert performance/using COPY FROM Richard Huxton 10:45
Need for speed 3 Ulrich Wisser 13:25
Re: Poor performance on HP Package Cluster Ron 13:27
Re: Need for speed 3 Merlin Moncure 13:42
Re: Need for speed 3 Ulrich Wisser 14:06
Poor performance on HP Package Cluster Ernst Einstein 14:16
Re: Need for speed 3 Merlin Moncure 15:28
Re: Need for speed 3 Luke Lonergan 16:37
Re: Need for speed 3 Nicholas E. Wakefield 17:30
Massive performance issues Matthew Sackman 17:42
Re: Massive performance issues Merlin Moncure 18:04
Re: Massive performance issues Merlin Moncure 18:10
Re: Massive performance issues Joel Fradkin 18:42
Re: Massive performance issues Tom Lane 18:47
Re: Massive performance issues Matthew Sackman 18:52
Re: Massive performance issues Matthew Sackman 19:08
Re: Massive performance issues Alvaro Herrera 19:33
Re: Massive performance issues Ron 19:43
Re: Massive performance issues Merlin Moncure 19:51
Re: Massive performance issues Alvaro Herrera 19:53
Re: Massive performance issues Steinar H. Gunderson 20:09
Re: Poor performance on HP Package Cluster Luke Lonergan 20:24
Re: Massive performance issues Tom Lane 20:25
Re: Massive performance issues Sebastian Hennebrueder 20:39
Re: Massive performance issues Arjen van der Meijden 20:54
Re: Massive performance issues Ron 21:05
Re: Massive performance issues Matthew Sackman 21:06
Re: Massive performance issues Matthew Sackman 21:13
Re: Massive performance issues Jeff Frost 21:26
Re: Massive performance issues Steinar H. Gunderson 21:52
Re: Massive performance issues Matthew Sackman 22:00
Re: Massive performance issues Matthew Sackman 22:01
Re: Massive performance issues Ron 22:05
Re: Massive performance issues Matthew Sackman 22:22
Re: Massive performance issues Michael Fuhr 22:34
Re: Poor performance on HP Package Cluster Dan Harris 23:02
Prepared statement not using index Guido Neitzer 23:09
Re: Massive performance issues Ron 23:09
Re: lots of updates on small table Alison Winters 23:23

Sept. 2, 2005

Thread Author Time
Avoid using swap in a cluster Ricardo Humphreys 01:04
Re: Massive performance issues Mark Kirkwood 03:19
Update is more affected( taking more time) than Select ( if Auto vacuum is not running) Hemant Pandey 03:51
Re: Massive performance issues Mark Kirkwood 04:24
Re: Poor performance on HP Package Cluster Luke Lonergan 04:54
[No subject] [email protected] 05:12
Re: Massive performance issues Akshay Mathur 09:23
Re: Avoid using swap in a cluster Richard Huxton 09:42
Re: Update is more affected( taking more time) than Select Richard Huxton 09:48
ORDER BY and LIMIT not propagated on inherited tables / UNIONs 📎 Matteo Beccati 10:20
Re: Avoid using swap in a cluster Alex Stapleton 11:18
Advise about how to delete entries Arnau 11:43
Re: ORDER BY and LIMIT not propagated on inherited Simon Riggs 12:35
Re: ORDER BY and LIMIT not propagated on inherited Matteo Beccati 12:54
Re: Advise about how to delete entries Michael Fuhr 13:36
Re: ORDER BY and LIMIT not propagated on inherited Tom Lane 14:40
Re: ORDER BY and LIMIT not propagated on inherited Matteo Beccati 15:00
Re: ORDER BY and LIMIT not propagated on inherited Jens-Wolfhard Schicke 15:09
Poor SQL performance Patrick Hatcher 16:12
Re: Advise about how to delete entries PFC 16:47
Re: Massive performance issues Josh Berkus 16:50
Re: ORDER BY and LIMIT not propagated on inherited Simon Riggs 17:54
Re: Massive performance issues Chris Travers 18:00
Re: ORDER BY and LIMIT not propagated on inherited Matteo Beccati 18:33
Re: ORDER BY and LIMIT not propagated on inherited Ramesh kumar 20:08
Re: Poor SQL performance Alexander Kirpa 22:56

Sept. 3, 2005

Thread Author Time
Re: Massive performance issues Mark Kirkwood 01:22
Improving performance of a query Carlos Benkendorf 21:02
Re: Improving performance of a query Michael Fuhr 22:11

Sept. 4, 2005

Thread Author Time
poor VACUUM performance on large tables Jan Peterson 06:16
Re: poor VACUUM performance on large tables Thomas F. O'Connell 14:58
Re: Poor performance on HP Package Cluster Ernst Einstein 15:47
Re: Poor performance on HP Package Cluster Luke Lonergan 17:19
Re: poor VACUUM performance on large tables Tom Lane 23:01

Sept. 5, 2005

Thread Author Time
Re: shared buffers Martin Nickel 02:56
Re: Advise about how to delete entries Arnau 09:26
Postgresql Hardware - Recommendations Christian.Kastner 13:50

Sept. 6, 2005

Thread Author Time
Re: Query slow after VACUUM ANALYZE Tom Lane 03:53
Re: Postgresql Hardware - Recommendations J. Andrew Rogers 07:03
Re: Advise about how to delete entries Kevin 11:05
Re: When to do a vacuum for highly active table Chris Browne 12:48
Re: Improving performance of a query Merlin Moncure 12:59
Re: Improving performance of a query Stephan Szabo 14:09
insert performance for win32 Marc Cousin 14:12
Re: Improving performance of a query Merlin Moncure 14:47
Re: insert performance for win32 Merlin Moncure 14:56
Poor performance of delete by primary key Brian Choate 15:04
Re: Postgresql Hardware - Recommendations Matthew Nuzum 15:09
Re: insert performance for win32 Marc Cousin 15:13
Re: Poor performance of delete by primary key Tom Lane 15:32
Re: Poor performance of delete by primary key Matthew Sackman 15:43
Re: Poor performance of delete by primary key Richard Huxton 15:51
Re: Massive performance issues Matthew Sackman 15:51
Re: insert performance for win32 Merlin Moncure 16:16
Re: Poor performance of delete by primary key Mark Lewis 17:04
Re: insert performance for win32 Merlin Moncure 17:11
Re: Poor performance of delete by primary key Tom Lane 17:42
log_duration times Carlos Henrique Reimer 20:34

Sept. 7, 2005

Thread Author Time
Re: poor VACUUM performance on large tables Jan Peterson 00:54
Re: poor VACUUM performance on large tables Tom Lane 01:07
Re: Poor performance of delete by primary key Christopher Kings-Lynne 03:07
Re: Postgresql Hardware - Recommendations Christian.Kastner 09:04
Re: insert performance for win32 Marc Cousin 12:02
Re: insert performance for win32 Merlin Moncure 12:04
Re: [PERFORM] insert performance for win32 Merlin Moncure 13:08
Re: [PERFORM] insert performance for win32 Tom Lane 15:02
Query take 101 minutes, help, please Christian Compagnon 16:22
Re: Query take 101 minutes, help, please Steinar H. Gunderson 16:57
Re: Query take 101 minutes, help, please Meetesh Karia 17:09
Re: Query take 101 minutes, help, please Tom Lane 17:57
Re: Query take 101 minutes, help, please Alex Hayward 18:40
Re: Poor performance of delete by primary key Jim C. Nasby 21:38

Sept. 9, 2005

Thread Author Time
please comment on cpu 32 bit or 64 bit wisan watcharinporn 05:54
Too slow query, do you have an idea to optimize? Choe, Cheng-Dae 06:32
Re: please comment on cpu 32 bit or 64 bit Tom Lane 06:58
Re: Too slow query, do you have an idea to optimize? Christopher Kings-Lynne 07:00

Sept. 10, 2005

Thread Author Time
CHECK vs REFERENCES Marc G. Fournier 03:23
Re: CHECK vs REFERENCES Michael Fuhr 03:49
Re: CHECK vs REFERENCES Marc G. Fournier 04:03
Re: please comment on cpu 32 bit or 64 bit Chris Browne 05:21
Re: CHECK vs REFERENCES Michael Fuhr 13:06

Sept. 11, 2005

Thread Author Time
performance discrepancy indexing one column versus two columns Mark Dilger 07:43
Re: performance discrepancy indexing one column versus Gavin Sherry 08:05
Index not used with prepared statement Guido Neitzer 08:29
Re: Index not used with prepared statement Andreas Seltenreich 09:03
Re: Index not used with prepared statement Guido Neitzer 10:35
Re: shared buffers John A Meinel 12:35
LEFT JOIN optimization Ksenia Marasanova 17:12
Re: LEFT JOIN optimization Stephen Frost 21:00
Re: LEFT JOIN optimization Ksenia Marasanova 21:47

Sept. 12, 2005

Thread Author Time
Re: LEFT JOIN optimization Stephen Frost 00:34
Re: Prepared statement not using index John A Meinel 04:58
Re: Advise about how to delete entries John A Meinel 05:06
Slow update Hilary Forbes 09:14
Re: LEFT JOIN optimization Manfred Koizar 10:41
Re: Slow update Richard Huxton 10:51
Re: Prepared statement not using index Dave Cramer 12:38
Re: Prepared statement not using index Guido Neitzer 13:22
Re: Prepared statement not using index Greg Sabino Mullane 13:26
Re: Slow update Bruno Wolff III 13:34
Re: Slow update Tom Lane 14:07
Re: Prepared statement not using index Dave Cramer 15:28
Re: Prepared statement not using index Dave Cramer 15:30
Performance considerations for very heavy INSERT traffic Brandon Black 21:04
Re: Performance considerations for very heavy INSERT traffic PFC 21:24
Re: Performance considerations for very heavy INSERT traffic Alex Turner 21:45
Re: Performance considerations for very heavy INSERT traffic Brandon Black 22:02

Sept. 13, 2005

Thread Author Time
Re: Performance considerations for very heavy INSERT traffic Qingqing Zhou 00:37
Re: Performance considerations for very heavy INSERT traffic Alan Stange 00:38
Re: Performance considerations for very heavy INSERT traffic Greg Stark 03:07
Re: Performance considerations for very heavy INSERT traffic Christopher Petrilli 03:39
Re: Performance considerations for very heavy INSERT traffic Brandon Black 03:44
Re: Performance considerations for very heavy INSERT traffic Brandon Black 03:53
Re: Performance considerations for very heavy INSERT Ron Peacetree 05:02
Low performance on Windows problem Dalibor Sramek 11:05
Opencms6 ans Postgres8 Bouchard Sylvie 11:17
Re: Low performance on Windows problem Merlin Moncure 11:58
Re: Low performance on Windows problem Dalibor Sramek 13:49
Re: Performance considerations for very heavy INSERT traffic Stephen Frost 14:10
Re: Low performance on Windows problem Merlin Moncure 14:20
Re: Low performance on Windows problem Dalibor Sramek 14:34
Re: Low performance on Windows problem Kevin Grittner 15:01
Re: Low performance on Windows problem Merlin Moncure 15:05
Re: Performance considerations for very heavy INSERT evgeny gridasov 15:26
Re: Performance considerations for very heavy INSERT traffic Brandon Black 15:30
Re: Low performance on Windows problem Tom Lane 15:32
Re: Performance considerations for very heavy INSERT Ian Westmacott 16:16
Re: Performance considerations for very heavy INSERT Alvaro Herrera 17:22
Re: Low performance on Windows problem Dalibor Sramek 19:21
unsubscribe Luiz Cesar de Lara 20:01
How many tables is too many tables? [email protected] 20:23
Help with performance on current status column Chris Kratz 21:08
unsubscribe li li 22:28
About method of PostgreSQL's Optimizer Pryscila B Guttoski 22:50
Re: About method of PostgreSQL's Optimizer Neil Conway 23:16
Re: About method of PostgreSQL's Optimizer Joshua D. Drake 23:23
Re: About method of PostgreSQL's Optimizer Cristian Prieto 23:31
Any other idea for better performance? Cristian Prieto 23:34

Sept. 14, 2005

Thread Author Time
Re: About method of PostgreSQL's Optimizer Pryscila B Guttoski 00:40
About method of PostgreSQL's Optimizer Pryscila B Guttoski 00:41
Re: About method of PostgreSQL's Optimizer Neil Conway 01:34
Re: About method of PostgreSQL's Optimizer Tom Lane 02:26
Re: About method of PostgreSQL's Optimizer Jonah H. Harris 03:08
Re: About method of PostgreSQL's Optimizer Pryscila B Guttoski 03:20
Re: Help with performance on current status column Richard Huxton 09:13
Re: Low performance on Windows problem Dalibor Sramek 13:02
Re: Help with performance on current status column Chris Kratz 13:35
Re: Low performance on Windows problem Kevin Grittner 14:23
Re: About method of PostgreSQL's Optimizer Josh Berkus 15:44
Re: About method of PostgreSQL's Optimizer Pryscila B Guttoski 15:52
Re: About method of PostgreSQL's Optimizer Jonah H. Harris 16:36
Re: Low performance on Windows problem Merlin Moncure 17:10
Re: About method of PostgreSQL's Optimizer Tom Lane 17:54
Battery Backed Cache for RAID Peter Darley 18:25
Re: Battery Backed Cache for RAID Jeffrey W. Baker 18:28
Re: Battery Backed Cache for RAID Alvaro Herrera 20:03
Re: Battery Backed Cache for RAID Merlin Moncure 20:17
Re: Battery Backed Cache for RAID John A Meinel 20:40
Re: Battery Backed Cache for RAID Welty, Richard 20:46
Re: Battery Backed Cache for RAID Arjen van der Meijden 20:47
Re: Battery Backed Cache for RAID mudfoot 21:58

Browse Archives

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