pgsql-performance since 2006-11-29 00:00

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

Nov. 29, 2006

Thread Author Time
Re: RES: Priority to a mission critical transaction Mark Kirkwood 01:11
Re: RES: Priority to a mission critical transaction Ron Mayer 01:20
Re: RES: Priority to a mission critical transaction Mark Kirkwood 01:27
Re: RES: Priority to a mission critical transaction Ron Mayer 10:55
NAMEDATALEN and performance Alessandro Baretta 11:31
Re: RES: Priority to a mission critical transaction Brian Hurt 13:25
Re: RES: Priority to a mission critical transaction Mark Lewis 15:03
Re: RES: Priority to a mission critical transaction Brian Hurt 15:17
Re: NAMEDATALEN and performance Tom Lane 15:50
Re: RES: Priority to a mission critical transaction Ron Mayer 16:43
Re: RES: Priority to a mission critical transaction Brian Hurt 17:21
OT - how to size/match multiple databases/apps for a single server Kevin Kempter 18:03
Re: RES: Priority to a mission critical transaction Ron Mayer 18:47
Fw: [GENERAL] Including unique users in huge data warehouse in Postgresql... Mark Jensen 19:43
Re: Fw: [GENERAL] Including unique users in huge data Luke Lonergan 21:55

Nov. 30, 2006

Thread Author Time
Re: RES: Priority to a mission critical transaction Josh Berkus 04:29
Defining performance. Paul Lathrop 22:59

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

Browse Archives

Prev | Next