pgsql-performance - December 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 22 23 24 26 27 28 29 30 31

Dec. 1, 2006

Thread Author Time
Re: Defining performance. Tobias Brox 00:05
Re: Defining performance. Tom Lane 00:26
Re: Defining performance. nospam 00:37
Re: Defining performance. Scott Marlowe 00:43
Bad iostat numbers Carlos H. Reimer 00:44
Re: Defining performance. Jeff Davis 00:57
Re: Defining performance. Tobias Brox 01:07
Re: Defining performance. Tobias Brox 01:15
Re: Bad iostat numbers Mark Kirkwood 01:47
Re: Bad iostat numbers David Boreham 02:24
Re: Bad iostat numbers Mark Kirkwood 03:00
Re: Defining performance. Chris 03:32
Re: Defining performance. Tobias Brox 04:03
Re: NAMEDATALEN and performance Alessandro Baretta 08:55
Re: Defining performance. Heikki Linnakangas 10:36
RES: Bad iostat numbers Carlos H. Reimer 14:29
RES: Bad iostat numbers Carlos H. Reimer 14:47
Re: NAMEDATALEN and performance Tom Lane 15:16
Re: RES: Bad iostat numbers David Boreham 15:32
Performance of Perc 5i Alex Turner 16:34
Re: Performance of Perc 5i Bucky Jordan 17:06

Dec. 2, 2006

Thread Author Time
Dump performance problems following server crash Kim 15:50
Re: Dump performance problems following server crash Tom Lane 17:13
Re: Dump performance problems following server crash Kim 17:29
Regex performance issue Alexandru Coseru 19:00
Re: Regex performance issue Dave Dutcher 20:36
Re: Regex performance issue Alexandru Coseru 20:48
Re: Regex performance issue Oleg Bartunov 20:54
Re: Regex performance issue Heikki Linnakangas 22:04
Re: Regex performance issue Alexandru Coseru 22:13
Re: Regex performance issue Heikki Linnakangas 22:35

Dec. 3, 2006

Thread Author Time
Re: Regex performance issue Alexandru Coseru 00:53
Re: Regex performance issue Alexandru Coseru 00:55
Re: Regex performance issue Scott Marlowe 01:31
Re: Regex performance issue Tom Lane 04:05
Re: Regex performance issue Oleg Bartunov 07:05
Which query analiser tools are available? Joost Kraaijeveld 08:59
Re: Which query analiser tools are available? Andreas Kretschmer 09:57
Re: Regex performance issue Alexandru Coseru 11:11
Propagating outer join conditions Aaron Birkland 15:11
Re: Propagating outer join conditions Jonathan Blitz 15:25
Re: Propagating outer join conditions Aaron Birkland 16:30
Hardware advice Alexandru Coseru 17:29
Re: Propagating outer join conditions Tom Lane 18:24
Re: Hardware advice Josh Berkus 20:11
Re: Hardware advice Alexandru Coseru 21:38
Enabling constraint_exclusion does not avoid scanning all child partitions Fayza Sultan 22:21
Re: Enabling constraint_exclusion does not avoid scanning all child partitions Tom Lane 22:25
Re: Enabling constraint_exclusion does not avoid scanning all child partitions Fayza Sultan 22:37

Dec. 4, 2006

Thread Author Time
Is Vacuum/analyze destroying my performance? Carlo Stonebanks 05:16
Re: Bad iostat numbers Greg Smith 05:44
Re: Is Vacuum/analyze destroying my performance? Carlo Stonebanks 05:49
Re: Bad iostat numbers Alex Turner 07:17
8.2rc1 (much) slower than 8.2dev? Arjen van der Meijden 07:44
Re: Is Vacuum/analyze destroying my performance? Matthew O'Connor 14:35
Re: 8.2rc1 (much) slower than 8.2dev? Tom Lane 14:53
Re: Bad iostat numbers Scott Marlowe 16:25
Re: Bad iostat numbers Scott Marlowe 16:37
Re: 8.2rc1 (much) slower than 8.2dev? Arjen van der Meijden 16:41
Re: Is Vacuum/analyze destroying my performance? Carlo Stonebanks 17:08
Configuration settings for 32GB RAM server Mark Lonsdale 17:10
Re: Bad iostat numbers Alex Turner 17:37
Re: Configuration settings for 32GB RAM server Jeff Davis 17:42
Re: Bad iostat numbers Michael Stone 17:43
How to move pg_xlog to another drive on Windows???? Joost Kraaijeveld 17:48
Re: Bad iostat numbers Alex Turner 17:52
Re: Bad iostat numbers Michael Stone 18:03
Re: Bad iostat numbers Scott Marlowe 18:05
Re: Bad iostat numbers Scott Marlowe 18:13
Re: Configuration settings for 32GB RAM server Vivek Khera 18:44
Re: How to move pg_xlog to another drive on Windows???? Anthony Presley 18:46
Re: Configuration settings for 32GB RAM server Joshua Marsh 18:57
Re: How to move pg_xlog to another drive on Windows???? Merlin Moncure 19:04
Re: Configuration settings for 32GB RAM server Scott Marlowe 19:23
pgsql upgrade Matt Chambers 21:58
Re: Configuration settings for 32GB RAM server Dave Cramer 23:28

Dec. 5, 2006

Thread Author Time
Re: How to move pg_xlog to another drive on K C Lau 04:02
Re: Bad iostat numbers Greg Smith 04:10
Re: Is Vacuum/analyze destroying my performance? Matthew T. O'Connor 05:11
Re: Bad iostat numbers Alex Turner 06:21
JOIN work somehow strange on simple query Anton 09:05
Re: JOIN work somehow strange on simple query Anton 09:38
Re: Hardware advice Sven Geisler 09:57
Re: Configuration settings for 32GB RAM server Mark Lonsdale 11:14
Re: JOIN work somehow strange on simple query Richard Huxton 12:00
Re: Bad iostat numbers Michael Stone 12:15
Re: Bad iostat numbers Alex Turner 12:57
Re: Bad iostat numbers Craig A. James 14:46
Re: Bad iostat numbers Michael Stone 14:49
single transaction vs multiple transactions Sven Geisler 15:26
Re: single transaction vs multiple transactions Heikki Linnakangas 15:30
Re: single transaction vs multiple transactions Sven Geisler 15:35
Re: single transaction vs multiple transactions Heikki Linnakangas 15:42
Re: single transaction vs multiple transactions Jens Schipkowski 15:45
Re: single transaction vs multiple transactions Sven Geisler 15:58
Re: single transaction vs multiple transactions Tom Lane 16:54
Restart time Jean Arnaud 17:08
Performance of ORDER BY Glenn Sullivan 17:12
Re: Performance of ORDER BY Luke Lonergan 17:36
Re: Performance of ORDER BY Tom Lane 18:02
Re: Restart time Tom Lane 18:16
Re: Performance of ORDER BY Steinar H. Gunderson 18:17
Re: Performance of ORDER BY A. Kretschmer 18:20
Re: Performance of ORDER BY Tom Lane 18:39
Re: Restart time Rajesh Kumar Mallah 19:32
Re: Restart time Tom Lane 19:39
Re: Performance of ORDER BY Stefan Kaltenbrunner 19:55
Re: Performance of ORDER BY 📎 Glenn Sullivan 20:42
Re: Hardware advice Alexandru Coseru 21:44
Re: shared_buffers > 284263 on OS X Brian Wipf 23:06
Re: shared_buffers > 284263 on OS X Tom Lane 23:10

Dec. 6, 2006

Thread Author Time
Re: shared_buffers > 284263 on OS X Brian Wipf 00:06
max/min and index usage Tobias Brox 03:01
Re: max/min and index usage Tobias Brox 03:17
Re: max/min and index usage Tom Lane 03:29
Re: max/min and index usage Tobias Brox 03:35
Re: Hardware advice Alex Turner 04:24
Re: Bad iostat numbers Greg Smith 04:54
Re: Restart time Rajesh Kumar Mallah 06:20
Locking in PostgreSQL? Joost Kraaijeveld 07:04
Re: Locking in PostgreSQL? Markus Schiltknecht 07:11
Re: Restart time Jean Arnaud 08:44
Re: Hardware advice Sven Geisler 09:09
Re: Hardware advice Gregory S. Williamson 09:21
Re: [PERFORM] Locking in PostgreSQL? Dave Cramer 12:29
Re: [PERFORM] Locking in PostgreSQL? Jens Schipkowski 13:20
Re: [PERFORM] Locking in PostgreSQL? Dave Cramer 13:26
Re: Locking in PostgreSQL? Steinar H. Gunderson 13:31
Re: [PERFORM] Locking in PostgreSQL? Markus Schiltknecht 13:42
Re: [PERFORM] Locking in PostgreSQL? Martijn van Oosterhout 13:45
File Systems Compared Brian Wipf 15:40
Re: File Systems Compared Brian Hurt 16:02
Re: File Systems Compared Alexander Staubo 16:05
Re: Bad iostat numbers Steve Atkins 16:19
Re: File Systems Compared Luke Lonergan 16:21
Re: File Systems Compared Markus Schiltknecht 16:31
Re: File Systems Compared Joshua D. Drake 16:34
Re: File Systems Compared Brian Hurt 16:40
Re: File Systems Compared Steinar H. Gunderson 16:43
Re: File Systems Compared Florian Weimer 16:44
Re: File Systems Compared Mark Lewis 16:55
VACUUM FULL does not works....... asif ali 17:07
Re: VACUUM FULL does not works....... Jean-Max Reymond 17:13
Re: VACUUM FULL does not works....... Scott Marlowe 17:20
Re: File Systems Compared Luke Lonergan 17:40
Re: File Systems Compared Markus Schiltknecht 17:45
Re: VACUUM FULL does not works....... Rajesh Kumar Mallah 17:47
Re: [PERFORM] Locking in PostgreSQL? Casey Duncan 17:58
Re: File Systems Compared Arnaud Lesauvage 17:59
[offtopic] Word wrapping Steinar H. Gunderson 18:08
Re: [PERFORM] Locking in PostgreSQL? Erik Jones 18:09
Re: File Systems Compared Michael Stone 18:11
Re: VACUUM FULL does not works....... asif ali 18:37
Re: [offtopic] File Systems Compared Brian Wipf 18:47
Problems with an update-from statement and pg-8.1.4 Rafael Martinez 19:10
Re: Problems with an update-from statement and pg-8.1.4 Stephan Szabo 19:20
Re: Problems with an update-from statement and pg-8.1.4 Ted Allen 19:55
Re: VACUUM FULL does not works....... Tom Lane 19:55
Re: Problems with an update-from statement and pg-8.1.4 Rafael Martinez 20:10
Re: File Systems Compared Merlin Moncure 20:12
Disk storage and san questions (was File Systems Compared) Matthew Schumacher 20:12
Re: Problems with an update-from statement and pg-8.1.4 Erik Jones 20:19
Re: File Systems Compared Brian Hurt 20:24
Re: Problems with an update-from statement and pg-8.1.4 Rafael Martinez 20:29
Re: File Systems Compared Bruno Wolff III 20:31
Re: Problems with an update-from statement and pg-8.1.4 Erik Jones 20:31
Re: File Systems Compared Ron 20:52
Re: File Systems Compared Brian Wipf 21:47
Re: VACUUM FULL does not works....... asif ali 21:53
Re: VACUUM FULL does not works....... Scott Marlowe 22:13
Re: Areca 1260 Performance (was: File Systems Compared) Brian Wipf 22:30
Re: Areca 1260 Performance (was: File Systems Ron 23:25
Re: Areca 1260 Performance Brian Wipf 23:40

Dec. 7, 2006

Thread Author Time
Re: VACUUM FULL does not works....... asif ali 00:19
Re: Areca 1260 Performance Ron 00:26
Re: 8.2rc1 (much) slower than 8.2dev? Jim C. Nasby 06:01
Re: Configuration settings for 32GB RAM server Jim C. Nasby 06:03
Re: File Systems Compared Greg Smith 06:17
Re: VACUUM FULL does not works....... Rajesh Kumar Mallah 06:58
Re: Areca 1260 Performance Brian Wipf 08:37
Re: 8.2rc1 (much) slower than 8.2dev? Arjen van der Meijden 09:13
Core 2 or Opteron Mindaugas 10:18
Re: Core 2 or Opteron Arjen van der Meijden 10:29
Re: Core 2 or Opteron Claus Guttesen 10:44
Re: Core 2 or Opteron Mindaugas 11:05
Re: Core 2 or Opteron Arjen van der Meijden 11:18
Re: Areca 1260 Performance Ron 12:34
SQL_CALC_FOUND_ROWS in POSTGRESQL / Some one can helpe me. 📎 Marcos Borges 13:19
Re: 8.2rc1 (much) slower than 8.2dev? Tom Lane 15:38
Re: Areca 1260 Performance Shane Ambler 15:43
Re: Areca 1260 Performance Gene 16:02
Advice on selecting good values for work_mem? Bill Moran 16:35
How to determine if my setting for shared_buffers is too high? Bill Moran 16:42
Re: Advice on selecting good values for work_mem? Tom Lane 17:02
Re: How to determine if my setting for shared_buffers is too high? Tom Lane 17:04
Re: Advice on selecting good values for work_mem? Stephen Frost 18:16
Re: File Systems Compared Merlin Moncure 21:23

Dec. 8, 2006

Thread Author Time
Re: Disk storage and san questions (was File Systems Compared) Bucky Jordan 00:07
Re: Areca 1260 Performance Ron 00:11
Re: One table is very slow, but replicated table (same data) is fine Chris Browne 03:33

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 22 23 24 26 27 28 29 30 31