pgsql-performance since 2005-12-18 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
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 29 30

Dec. 18, 2005

Thread Author Time
Speed of different procedural language Ben Trewern 01:10
Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood 02:02
Re: PostgreSQL performance question. Harry Jackson 02:11
Re: PostgreSQL performance question. [OT] Steinar H. Gunderson 02:18
Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood 04:07
make bulk deletes faster? James Klo 05:10
Re: Should Oracle outperform PostgreSQL on a complex Greg Stark 06:50
Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs 10:27
Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs 13:48
PostgreSQL and Ultrasparc T1 Juan Casero 16:35
Re: PostgreSQL and Ultrasparc T1 Christopher Petrilli 17:12
Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs 17:53
Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood 22:04
Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood 22:10
Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood 22:13
Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs 22:21
Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs 22:28

Dec. 19, 2005

Thread Author Time
Re: make bulk deletes faster? Michael Fuhr 02:36
Re: PostgreSQL and Ultrasparc T1 Scott Marlowe 06:25
Re: PostgreSQL and Ultrasparc T1 Luke Lonergan 07:21
Re: make bulk deletes faster? James Klo 08:17
Re: make bulk deletes faster? Mitch Skinner 10:39
Re: PostgreSQL and Ultrasparc T1 Jignesh K. Shah 14:27
Re: make bulk deletes faster? Ang Chin Han 14:47
Re: PostgreSQL and Ultrasparc T1 Anjan Dave 15:21
Re: PostgreSQL and Ultrasparc T1 Luke Lonergan 17:30
Any way to optimize GROUP BY queries? Cristian Prieto 17:30
Re: make bulk deletes faster? James Klo 19:10
Re: PostgreSQL and Ultrasparc T1 Jignesh Shah 19:29
Re: PostgreSQL and Ultrasparc T1 Luke Lonergan 19:37
separate drives for WAL or pgdata files Anjan Dave 20:04
Re: PostgreSQL and Ultrasparc T1 Jignesh Shah 20:21
Is the optimizer choice right? Carlos Benkendorf 20:22
Re: Any way to optimize GROUP BY queries? Greg Stark 20:47
Re: Is the optimizer choice right? Greg Stark 20:54

Dec. 20, 2005

Thread Author Time
Re: PostgreSQL and Ultrasparc T1 Juan Casero 00:32
Re: SAN/NAS options Matthew Schumacher 00:41
Re: SAN/NAS options Anjan Dave 01:24
Re: PostgreSQL and Ultrasparc T1 Luke Lonergan 01:34
Re: PostgreSQL and Ultrasparc T1 Luke Lonergan 01:37
Re: High context switches occurring Anjan Dave 02:08
Re: separate drives for WAL or pgdata files David Lang 03:20
Re: separate drives for WAL or pgdata files David Lang 03:48
Re: High context switches occurring Juan Casero 04:16
Re: PostgreSQL and Ultrasparc T1 Jignesh K. Shah 04:19
Re: High context switches occurring Oleg Bartunov 05:26
Re: High context switches occurring Jignesh K. Shah 06:44
Read only transactions - Commit or Rollback Markus Schaber 10:40
Re: Read only transactions - Commit or Rollback 10:55
unsubscribe William Lai 11:36
Re: Read only transactions - Commit or Rollback Grega Bremec 11:41
Re: Read only transactions - Commit or Rollback 11:54
Re: Read only transactions - Commit or Rollback Markus Schaber 12:03
Re: Read only transactions - Commit or Rollback Michael Riess 12:05
Re: Read only transactions - Commit or Rollback Andreas Seltenreich 12:27
Re: Read only transactions - Commit or Rollback Markus Schaber 12:31
Re: Read only transactions - Commit or Rollback Nicolas Barbier 13:06
Re: filesystem performance with lots of files David Roussel 13:26
Re: High context switches occurring Tom Lane 14:41
Re: 2 phase commit: performance implications? David Roussel 15:00
Re: PostgreSQL and Ultrasparc T1 Alan Stange 15:01
Re: PostgreSQL and Ultrasparc T1 David Lang 15:08
Re: PostgreSQL and Ultrasparc T1 Alan Stange 15:14
Re: High context switches occurring Oleg Bartunov 15:18
Re: PostgreSQL and Ultrasparc T1 David Lang 15:22
Re: High context switches occurring Tom Lane 15:28
Re: Read only transactions - Commit or Rollback Tom Lane 15:48
Re: Read only transactions - Commit or Rollback Greg Stark 16:02
Re: Read only transactions - Commit or Rollback Markus Schaber 16:07
Re: Read only transactions - Commit or Rollback Tom Lane 16:16
Re: PostgreSQL and Ultrasparc T1 Richard_D_Levine 16:50
Re: PostgreSQL and Ultrasparc T1 Jignesh K. Shah 17:20
What's the best hardver for PostgreSQL 8.1? Antal Attila 18:27
Re: Overriding the optimizer Jim C. Nasby 18:56
Re: make bulk deletes faster? Jim C. Nasby 19:16
Re: PostgreSQL and Ultrasparc T1 Jim C. Nasby 19:22
Re: PostgreSQL and Ultrasparc T1 Jim C. Nasby 19:34
Re: Any way to optimize GROUP BY queries? Jim C. Nasby 19:47
Re: High context switches occurring Anjan Dave 19:50
Re: separate drives for WAL or pgdata files Jim C. Nasby 19:52
Re: filesystem performance with lots of files Jim C. Nasby 19:59
Re: What's the best hardver for PostgreSQL 8.1? Jim C. Nasby 20:06
Re: What's the best hardver for PostgreSQL 8.1? Vivek Khera 21:08
Re: Any way to optimize GROUP BY queries? Tom Lane 21:44

Dec. 21, 2005

Thread Author Time
Re: What's the best hardver for PostgreSQL 8.1? Juan Casero 00:50
Re: What's the best hardver for PostgreSQL 8.1? David Lang 02:46
Re: SAN/NAS options Charles Sprickman 05:58
Re: Simple Join Mark Kirkwood 06:55
Windows performance again Josep Maria Pinyol Fontseca 09:05
Re: Windows performance again Richard Huxton 09:58
Re: SAN/NAS options Alex Stapleton 10:17
Re: What's the best hardver for PostgreSQL 8.1? Antal Attila 10:38
Re: SAN/NAS options Luke Lonergan 10:46
Re: Speed of different procedural language Steinar H. Gunderson 11:06
Re: [PERFORM] need help Alban Medici (NetCentrex) 11:10
Re: 2 phase commit: performance implications? Andy Ballingall 12:10
Re: Windows performance again Greg Stark 14:48
Re: Windows performance again Tom Lane 16:10
Wrong index used when ORDER BY LIMIT 1 Szűcs Gábor 18:03
ORDER BY costs Carlos Benkendorf 18:16
Re: Windows performance again Merlin Moncure 18:40
Re: Wrong index used when ORDER BY LIMIT 1 Michael Fuhr 18:51
Re: Wrong index used when ORDER BY LIMIT 1 Tom Lane 19:34
Re: ORDER BY costs Tom Lane 19:39
Re: Speed of different procedural language Merlin Moncure 20:43
Re: Speed of different procedural language Michael Fuhr 21:24
Re: Speed of different procedural language Steinar H. Gunderson 21:38
Re: Speed of different procedural language Michael Fuhr 22:10
Re: What's the best hardver for PostgreSQL 8.1? William Yu 23:57

Dec. 22, 2005

Thread Author Time
Re: ORDER BY costs Carlos Benkendorf 00:35
Re: Speed of different procedural language Steinar H. Gunderson 01:08
CPU and RAM Harry Jackson 01:20
MySQL is faster than PgSQL but a large margin in my program... any ideas why? Madison Kelly 02:03
Re: Speed of different procedural language Michael Fuhr 02:13
Re: MySQL is faster than PgSQL but a large margin in my program... any ideas why? Stephen Frost 02:14
Re: MySQL is faster than PgSQL but a large margin in my program... any ideas why? Kevin Brown 02:44
Re: What's the best hardver for PostgreSQL 8.1? Juan Casero 03:09
Re: What's the best hardver for PostgreSQL 8.1? Juan Casero 03:31
Re: MySQL is faster than PgSQL but a large margin in Luke Lonergan 03:33
Re: What's the best hardver for PostgreSQL 8.1? Tom Arthurs 03:34
Re: Speed of different procedural language Tom Lane 03:45
Re: CPU and RAM Qingqing Zhou 04:01
Re: What's the best hardver for PostgreSQL 8.1? Jignesh K. Shah 04:07
Re: MySQL is faster than PgSQL but a large margin in my Madison Kelly 06:58
Re: MySQL is faster than PgSQL but a large margin in Madison Kelly 07:02
Re: MySQL is faster than PgSQL but a large margin in Luke Lonergan 07:07
Re: MySQL is faster than PgSQL but a large margin in Luke Lonergan 07:10
Re: CPU and RAM Richard Huxton 09:19
Re: Wrong index used when ORDER BY LIMIT 1 Szűcs Gábor 12:52
Re: Speed of different procedural language Merlin Moncure 13:29
Re: MySQL is faster than PgSQL but a large margin in Markus Schaber 13:34
Re: ORDER BY costs Carlos Benkendorf 14:06
Re: effizient query with jdbc Dave Cramer 14:17
Re: effizient query with jdbc Steve Peterson 15:23
Re: ORDER BY costs Carlos Benkendorf 16:23

Dec. 23, 2005

Thread Author Time
Re: MySQL is faster than PgSQL but a large margin in Juan Casero 02:44
Re: What's the best hardver for PostgreSQL 8.1? David Lang 03:12
Re: CPU and RAM Greg Stark 03:52
Re: What's the best hardver for PostgreSQL 8.1? Juan Casero 04:10
Re: What's the best hardver for PostgreSQL 8.1? David Lang 04:14
Re: CPU and RAM Qingqing Zhou 04:29
DELETE, INSERT vs SELECT, UPDATE || INSERT Anton Maksimenkov 09:02
Order by behaviour Carlos Benkendorf 12:34
Re: Order by behaviour Mario Weilguni 12:51
Re: Order by behaviour Carlos Benkendorf 13:32
Re: Order by behaviour Guido Neitzer 13:34
Re: Order by behaviour Kresimir Tonkovic 14:31
Re: Order by behaviour Carlos Benkendorf 14:35
Re: Order by behaviour Guido Neitzer 15:03
Re: DELETE, INSERT vs SELECT, UPDATE || INSERT Tom Lane 15:30
Re: Order by behaviour Tom Lane 15:54
Re: MySQL is faster than PgSQL but a large margin in Vivek Khera 16:16
Re: What's the best hardver for PostgreSQL 8.1? Vivek Khera 16:23
Re: What's the best hardver for PostgreSQL 8.1? Mark Kirkwood 22:15

Dec. 24, 2005

Thread Author Time
Re: Order by behaviour Carlos Benkendorf 01:49
Re: What's the best hardver for PostgreSQL 8.1? Vivek Khera 04:00
Re: What's the best hardver for PostgreSQL 8.1? Frank Wiles 19:50
Re: What's the best hardver for PostgreSQL 8.1? Ron 21:31
Re: What's the best hardver for PostgreSQL 8.1? Joshua D. Drake 21:42
Re: What's the best hardver for PostgreSQL 8.1? David Lang 21:54
Re: What's the best hardver for PostgreSQL 8.1? Ron 22:24
Re: What's the best hardver for PostgreSQL 8.1? William Yu 22:36
Re: What's the best hardver for PostgreSQL 8.1? Ron 22:45
Re: What's the best hardver for PostgreSQL 8.1? Sander Steffann 22:54

Dec. 25, 2005

Thread Author Time
Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan 01:51
Re: What's the best hardver for PostgreSQL 8.1? David Lang 03:03
Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan 03:13
Re: What's the best hardver for PostgreSQL 8.1? William Yu 03:43
Re: What's the best hardver for PostgreSQL 8.1? Joshua D. Drake 04:18
Re: What's the best hardver for PostgreSQL 8.1? David Lang 12:13
Re: What's the best hardver for PostgreSQL 8.1? Steinar H. Gunderson 12:29
Re: What's the best hardver for PostgreSQL 8.1? Bruno Wolff III 15:15
Re: What's the best hardver for PostgreSQL 8.1? Michael Stone 17:37

Dec. 26, 2005

Thread Author Time
Re: What's the best hardver for PostgreSQL 8.1? Benjamin Arai 09:22
vacuuming template0 gave ERROR Gourish Singbal 11:34
Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan 12:13
Fwd: vacuuming template0 gave ERROR Gourish Singbal 12:32
Re: vacuuming template0 gave ERROR Tom Lane 16:02
Re: What's the best hardver for PostgreSQL 8.1? Alex Turner 17:32
Re: What's the best hardver for PostgreSQL 8.1? David Lang 18:11
Re: What's the best hardver for PostgreSQL 8.1? Benjamin Arai 18:21
Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan 18:50
Performance hit on large row counts 📎 David Scott 21:03
Bitmap indexes etc. Ivan Voras 21:32
Re: Performance hit on large row counts Tom Lane 21:36
Re: Bitmap indexes etc. Tom Lane 21:57
Re: What's the best hardver for PostgreSQL 8.1? Alex Turner 22:54
Re: What's the best hardver for PostgreSQL 8.1? Alex Turner 23:04
Re: Performance hit on large row counts David Scott 23:07
Re: What's the best hardver for PostgreSQL 8.1? David Lang 23:27
Re: Performance hit on large row counts Tom Lane 23:52

Dec. 27, 2005

Thread Author Time
Re: vacuuming template0 gave ERROR Gourish Singbal 07:05
Re: vacuuming template0 gave ERROR Tom Lane 07:16
Re: vacuuming template0 gave ERROR Gourish Singbal 07:20
Re: What's the best hardver for PostgreSQL 8.1? Dawid Kuroczko 07:24
Re: Bitmap indexes etc. Ivan Voras 13:19
Re: What's the best hardver for PostgreSQL 8.1? Michael Stone 13:35
Performance problems with 8.1.1 compared to 7.4.7 Albert Cervera Areny 16:09
Re: What's the best hardver for PostgreSQL 8.1? Ron 16:50
Re: Performance problems with 8.1.1 compared to 7.4.7 Michael Fuhr 17:13

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