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

Aug. 1, 2005

Thread Author Time
Re: Performance problems testing with Spamassassin 3.1.0 Michael Parker 04:04
Re: Performance problems testing with Spamassassin 3.1.0 Tom Lane 04:42
Re: Performance problems testing with Spamassassin 3.1.0 Tom Lane 04:53
Re: [PATCHES] COPY FROM performance improvements Tom Lane 16:32
Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher 17:08
Re: [PATCHES] COPY FROM performance improvements Alon Goldshuv 19:48
Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher 20:04
Re: Performance problems testing with Spamassassin 3.1.0 PFC 21:18
Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher 21:28
Re: Performance problems testing with Spamassassin 3.1.0 Jim C. Nasby 21:49
Re: Performance problems testing with Spamassassin 3.1.0 Michael Parker 22:09
Planner incorrectly choosing seq scan over index scan Meetesh Karia 22:19
Re: Planner incorrectly choosing seq scan over index scan Tobias Brox 22:37
Re: Planner incorrectly choosing seq scan over index scan John Arbash Meinel 23:16
Re: Planner incorrectly choosing seq scan over index scan Meetesh Karia 23:30
Re: [PERFORM] COPY FROM performance improvements Tom Lane 23:51
Re: Planner incorrectly choosing seq scan over index scan Meetesh Karia 23:56

Aug. 2, 2005

Thread Author Time
Re: Planner incorrectly choosing seq scan over index scan Tom Lane 00:15
Re: Planner incorrectly choosing seq scan over index scan Meetesh Karia 07:05
Re: COPY FROM performance improvements 📎 Alon Goldshuv 14:59
Re: [PERFORM] COPY FROM performance improvements Alon Goldshuv 15:03
"nice"/low priority Query Tobias Brox 16:04
Re: "nice"/low priority Query Tom Lane 16:19
Re: "nice"/low priority Query Richard Huxton 16:54
Re: "nice"/low priority Query Jim C. Nasby 17:25
pg_dump for table with bytea takes a long time Sailer, Denis (YBUSA-CDR) 18:57
Re: "nice"/low priority Query Tobias Brox 19:59

Aug. 3, 2005

Thread Author Time
Re: "nice"/low priority Query Richard Huxton 08:53
Re: Planner incorrectly choosing seq scan over index scan Meetesh Karia 12:48
Is There A Windows Version of Performance Tuning Documents? Lane Van Ingen 13:15
Re: Is There A Windows Version of Performance Tuning Documents? John A Meinel 15:07

Aug. 4, 2005

Thread Author Time
Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher 08:13
Indexed views. prasanna s 08:24
Re: Indexed views. Christopher Kings-Lynne 08:37
Re: Performance problems testing with Spamassassin 3.1.0 PFC 08:45
Re: Indexed views. Laszlo Hornyak 08:52
Re: Performance problems testing with Spamassassin 3.1.0 John A Meinel 14:10
Re: Performance problems testing with Spamassassin 3.1.0 Tom Lane 14:37
Re: Performance problems testing with Spamassassin 3.1.0 📎 John A Meinel 15:08
Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher 16:13
Re: Performance problems testing with Spamassassin 3.1.0 Tom Lane 16:16
Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher 16:17
Re: "nice"/low priority Query Neil Conway 17:32
Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher 17:35
Re: Performance problems testing with Spamassassin 3.1.0 John A Meinel 19:36
Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher 22:37
Re: Performance problems testing with Spamassassin 3.1.0 John A Meinel 22:42

Aug. 5, 2005

Thread Author Time
Performance problems on 4-way AMD Opteron 875 (dual core) Dirk Lutzebäck 11:11
Re: Performance problems on 4-way AMD Opteron 875 (dual core) Michael Stone 12:27
Re: Performance problems on 4-way AMD Opteron 875 (dual Dirk Lutzebäck 12:56
Re: Performance problems on 4-way AMD Opteron 875 (dual core) Tom Lane 13:53
Why hash join instead of nested loop? Rhett Garber 18:35
Re: Why hash join instead of nested loop? Havasvölgyi Ottó 22:13
Re: Why hash join instead of nested loop? Rhett Garber 23:16

Aug. 6, 2005

Thread Author Time
Re: Why hash join instead of nested loop? Tom Lane 05:03
Slow update statement Patrick Hatcher 13:16
Re: Slow update statement John A Meinel 13:34
Re: Slow update statement Tom Lane 14:12
Re: COPY FROM performance improvements Tom Lane 21:04

Aug. 7, 2005

Thread Author Time
Re: COPY FROM performance improvements Luke Lonergan 02:33
Re: COPY FROM performance improvements Luke Lonergan 02:54
Re: COPY FROM performance improvements 📎 Luke Lonergan 03:25
Re: COPY FROM performance improvements Tom Lane 04:08
Re: COPY FROM performance improvements Luke Lonergan 05:21

Aug. 8, 2005

Thread Author Time
Re: Slow update statement Patrick Hatcher 02:00
Re: Slow update statement Patrick Hatcher 02:09
Re: Slow update statement Tom Lane 03:48
Re: Slow update statement Patrick Hatcher 04:35
Re: Finding bottleneck Kari Lavikka 12:03
Re: Finding bottleneck Tom Lane 14:39
Re: Slow update statement Tom Lane 15:18
Re: Finding bottleneck Merlin Moncure 15:24
Re: Finding bottleneck Tom Lane 15:37
Re: Finding bottleneck Kari Lavikka 16:19
Re: Finding bottleneck Tom Lane 16:56
Re: Why hash join instead of nested loop? Rhett Garber 17:00
Re: Finding bottleneck Kari Lavikka 17:54
Re: Finding bottleneck Tom Lane 19:27

Aug. 9, 2005

Thread Author Time
Re: Why hash join instead of nested loop? Tom Lane 00:58
Re: Why hash join instead of nested loop? Steinar H. Gunderson 01:08
Re: QRY seems not using indexes Qingqing Zhou 04:30
Re: QRY seems not using indexes Mark Kirkwood 05:05
Re: Why hash join instead of nested loop? Michael Fuhr 05:11
Re: Why hash join instead of nested loop? Ian Westmacott 12:15
Re: Why hash join instead of nested loop? Tom Lane 14:33
Re: Why hash join instead of nested loop? Ian Westmacott 14:43
Re: Why hash join instead of nested loop? Rhett Garber 16:51
Re: Why hash join instead of nested loop? Tom Lane 17:12
Table locking problems? Dan Harris 18:04
Re: Why hash join instead of nested loop? Rhett Garber 18:10
Re: Table locking problems? Joshua D. Drake 18:33
Re: Why hash join instead of nested loop? Tom Lane 18:37
Re: Why hash join instead of nested loop? Rhett Garber 18:51
Re: Table locking problems? Michael Fuhr 18:52
Re: Why hash join instead of nested loop? Tom Lane 19:00
Re: Table locking problems? Tom Lane 19:08
Re: Why hash join instead of nested loop? Rhett Garber 19:11
Re: Table locking problems? Dan Harris 20:42
Re: Table locking problems? Dan Harris 20:51
Re: Table locking problems? John A Meinel 21:51
Re: Table locking problems? Dan Harris 22:05
Re: Table locking problems? John A Meinel 22:30

Aug. 10, 2005

Thread Author Time
Re: COPY FROM performance improvements Alon Goldshuv 00:41
Re: COPY FROM performance improvements Andrew Dunstan 01:01
Re: COPY FROM performance improvements Luke Lonergan 04:39
Re: COPY FROM performance improvements Luke Lonergan 04:48
Re: Table locking problems? Steve Poe 06:49
Re: COPY FROM performance improvements Simon Riggs 08:15
Re: COPY FROM performance improvements Tom Lane 15:29
partial index regarded more expensive Tobias Brox 17:52
Re: partial index regarded more expensive PFC 18:15
Re: partial index regarded more expensive Tobias Brox 18:31
Re: Planner doesn't look at LIMIT? Ian Westmacott 21:03
Re: Planner doesn't look at LIMIT? Tom Lane 22:55
Speedier count(*) Dan Harris 23:37

Aug. 11, 2005

Thread Author Time
Re: Speedier count(*) Joshua D. Drake 00:23
Re: Speedier count(*) Michael Fuhr 00:36
Re: Speedier count(*) John A Meinel 01:07
Re: partial index regarded more expensive Tom Lane 03:14
it is always delete temp table will slow down the postmaster? Chun Yit(Chronos) 03:37
Re: Speedier count(*) Gavin Sherry 03:52
Re: Speedier count(*) Mark Cotner 04:40
Re: it is always delete temp table will slow down the postmaster? Qingqing Zhou 06:37
Re: it is always delete temp table will slow down the postmaster? Chun Yit(Chronos) 07:03
Re: Speedier count(*) Tino Wildenhain 07:24
Re: Speedier count(*) Gavin Sherry 10:36
Re: Speedier count(*) Tino Wildenhain 10:52
Why is not using the index Luis Cornide Arce 11:33
Re: Speedier count(*) PFC 12:08
PG8 Tuning Paul Johnson 12:23
Re: Speedier count(*) Tino Wildenhain 12:34
Re: Why is not using the index Richard Huxton 12:49
Re: PG8 Tuning Richard Huxton 12:55
Performance pb vs SQLServer. Stéphane COEZ 13:19
Re: Planner doesn't look at LIMIT? Ian Westmacott 13:26
Re: Why is not using the index Luis Cornide Arce 13:59
Re: PG8 Tuning Michael Stone 14:07
Re: [Fwd: PG8 Tuning] Jignesh Shah 14:30
BG writer question? Alan Stange 15:25
Re: Speedier count(*) Dan Harris 15:33
Re: BG writer question? Alvaro Herrera 16:43
Re: [SPAM?] Re: PG8 Tuning Jeffrey W. Baker 16:58
Re: PG8 Tuning Mark Lewis 17:18
Re: [SPAM?] Re: PG8 Tuning Tom Arthurs 18:00
Odd Locking Problem John A Meinel 20:36
Re: PG8 Tuning Merlin Moncure 20:38
Re: Odd Locking Problem Alvaro Herrera 21:08
Re: Odd Locking Problem John A Meinel 21:11
Mostly read performance Jeffrey Tenny 22:21
Re: Mostly read performance John A Meinel 22:38
Re: Mostly read performance Jeffrey Tenny 23:13
Re: Odd Locking Problem John A Meinel 23:30
Re: PG8 Tuning Michael Stone 23:54

Aug. 12, 2005

Thread Author Time
Re: Mostly read performance Michael Stone 00:30
How many views is ok? Petr Kavan 06:53
Re: Mostly read performance Greg Stark 07:32
[SPAM?] Re: PG8 Tuning Steve Poe 08:47
Re: [SPAM?] Re: PG8 Tuning Jeff Trout 12:18
Re: Mostly read performance (2 replies) Jeffrey Tenny 22:37

Aug. 15, 2005

Thread Author Time
Re: How many views is ok? John Arbash Meinel 00:22
Re: Performance pb vs SQLServer. John Arbash Meinel 00:27
Re: How many views is ok? Tom Lane 00:38
Re: Performance pb vs SQLServer. Steinar H. Gunderson 01:01
Re: Performance pb vs SQLServer. Steinar H. Gunderson 01:04
Re: Performance pb vs SQLServer. John Arbash Meinel 01:05
Re: Performance pb vs SQLServer. Tom Lane 01:18
Re: Performance pb vs SQLServer. Steinar H. Gunderson 01:37
Re: How many views is ok? Petr Kavan 05:23
Re: Performance pb vs SQLServer. dario_d_s 05:51
Re: Performance pb vs SQLServer. Magnus Hagander 08:18
Re: Performance pb vs SQLServer. Magnus Hagander 08:25
Re: Performance pb vs SQLServer. Stéphane COEZ 09:05
Re: Performance pb vs SQLServer. Stéphane COEZ 09:08
Re: Performance pb vs SQLServer. Stéphane COEZ 09:08
Re: Odd Locking Problem Manfred Koizar 15:19
Re: Performance pb vs SQLServer. Alvaro Herrera 16:18
I'm configuraing a new system (Bigish) and need some advice. Jeremiah Jahn 16:24
Re: I'm configuraing a new system (Bigish) and need some advice. Jeremiah Jahn 16:29
Re: I'm configuraing a new system (Bigish) and need some advice. Jeremiah Jahn 16:29
choosing RAID level for xlogs Anjan Dave 20:35

Aug. 16, 2005

Thread Author Time
database encoding with index search problem wisan watcharinporn 07:01
Looking for a large database for testing Sebastian Hennebrueder 07:29
Re: Looking for a large database for testing Tino Wildenhain 08:07
Re: Looking for a large database for testing Sebastian Hennebrueder 08:23
Re: database encoding with index search problem Richard Huxton 08:23
Re: Looking for a large database for testing Mark Rae 08:39
Re: Looking for a large database for testing Oleg Bartunov 09:38
Need for speed Ulrich Wisser 15:39
Re. : Need for speed bsimon 16:02
Re: Need for speed Richard Huxton 16:03
Re: Need for speed John A Meinel 16:12
Re: [SPAM?] Re: PG8 Tuning Josh Berkus 16:12
Re: [SPAM?] Re: PG8 Tuning Alvaro Herrera 16:25
Re: [SPAM?] Re: PG8 Tuning Joshua D. Drake 16:31
Re: PG8 Tuning John A Meinel 16:33
Re: Need for speed Jeffrey W. Baker 16:43
Re: Need for speed Roger Hand 17:01
Re: [SPAM?] Re: PG8 Tuning Michael Stone 17:30
Query plan looks OK, but slow I/O - settings advice? Roger Hand 17:46
Re: Need for speed Alex Turner 17:59

Browse Archives

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