pgsql-performance since 2010-12-07 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 26 28 29 30

Dec. 7, 2010

Thread Author Time
Re: Performance under contention Jignesh Shah 02:59
Re: Performance under contention Jignesh Shah 03:03
Re: Group commit and commit delay/siblings Jignesh Shah 03:07
Re: Group commit and commit delay/siblings 📎 Greg Smith 04:52
Slow BLOBs restoring Vlad Arkhipov 08:36
Compared MS SQL 2000 to Postgresql 9.0 on Windows Tom Polak 17:34
Re: Performance under contention Robert Haas 17:37
Re: Performance under contention Tom Lane 17:50
Re: Performance under contention Dave Crooke 18:00
Re: Performance under contention Ivan Voras 18:08
Re: Performance under contention Robert Haas 18:09
Re: Performance under contention Robert Haas 18:10
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Kevin Grittner 18:11
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson 18:13
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andres Freund 18:20
Re: Performance under contention Ivan Voras 18:21
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Craig James 19:23
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson 19:43
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Richard Broersma 19:56
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Gary Doades 19:58
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Kenneth Marshall 20:10
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Mladen Gogala 20:22
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson 20:23
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Tom Polak 21:29
Re: Performance under contention Віталій Тимчишин 21:36
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Craig James 21:53
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Gary Doades 22:11
Re: Update problem on large table Josh Kupershmidt 22:25
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Kevin Grittner 22:39
Re: Performance under contention Ivan Voras 22:43

Dec. 8, 2010

Thread Author Time
Re: Performance under contention Robert Haas 04:23
Re: Performance under contention Robert Haas 04:24
Re: Slow BLOBs restoring Vlad Arkhipov 08:50
Re: Performance under contention Tom Lane 14:34
Re: Slow BLOBs restoring Tom Lane 14:46
Tunning Postgres salima 16:53
hashed subplan 5000x slower than two sequential operations Bryce Nesbitt 18:53
Re: Group commit and commit delay/siblings Simon Riggs 19:00
Re: hashed subplan 5000x slower than two sequential operations Shrirang Chitnis 19:05
Re: hashed subplan 5000x slower than two sequential operations Bryce Nesbitt 20:05
Re: hashed subplan 5000x slower than two sequential operations Marc Mamin 20:06
Re: hashed subplan 5000x slower than two sequential operations Marc Mamin 20:12
Re: hashed subplan 5000x slower than two sequential operations Tom Lane 20:12
Re: hashed subplan 5000x slower than two sequential operations Pavel Stehule 20:25
Re: hashed subplan 5000x slower than two sequential operations 📎 Bryce Nesbitt 20:31
Re: hashed subplan 5000x slower than two sequential operations Bryce Nesbitt 20:33
Re: Performance under contention Robert Haas 21:09
Re: Performance under contention Tom Lane 22:02
Hardware recommendations Benjamin Krajmalnik 23:03
Re: Hardware recommendations Andy 23:26
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations John W Strange 23:31
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Pierre C 23:35

Dec. 9, 2010

Thread Author Time
Re: Hardware recommendations Marti Raudsepp 00:02
Re: Hardware recommendations Benjamin Krajmalnik 00:03
Re: Hardware recommendations Andy 00:23
Re: Performance under contention Robert Haas 01:41
Re: Hardware recommendations Scott Marlowe 02:28
Re: Slow BLOBs restoring Vlad Arkhipov 03:58
Re: Slow BLOBs restoring Vlad Arkhipov 04:05
libpq vs ODBC Divakar Singh 04:31
Re: libpq vs ODBC Alex Goncharov 05:01
Re: Hardware recommendations mark 05:17
Re: libpq vs ODBC Divakar Singh 05:17
Re: Slow BLOBs restoring Tom Lane 05:28
Re: libpq vs ODBC Alex Goncharov 05:51
Re: libpq vs ODBC Divakar Singh 06:39
Re: libpq vs ODBC Pavel Stehule 06:57
UNION and bad performance Olivier Pala 10:52
Re: Hardware recommendations Marti Raudsepp 12:09
Re: [PERFORM] Slow BLOBs restoring Robert Haas 13:05
Re: [PERFORM] Slow BLOBs restoring Tom Lane 14:50
Re: [PERFORM] Slow BLOBs restoring Tom Lane 15:05
Re: [PERFORM] Slow BLOBs restoring Robert Haas 15:56
Re: [PERFORM] Slow BLOBs restoring Andrew Dunstan 16:01

Dec. 10, 2010

Thread Author Time
Re: Hardware recommendations John W Strange 01:57
Re: libpq vs ODBC Pierre C 02:32
Re: Hardware recommendations alan bryan 06:38
Re: Hardware recommendations Andy 13:58
Re: Hardware recommendations Arjen van der Meijden 17:57
Re: Hardware recommendations Arjen van der Meijden 18:05
Re: Hardware recommendations Scott Marlowe 18:08
Re: Hardware recommendations Andy 19:27

Dec. 11, 2010

Thread Author Time
Re: Hardware recommendations Greg Smith 09:10
Re: Hardware recommendations Greg Smith 09:18
Re: UNION and bad performance Marc Mamin 10:27
Re: UNION and bad performance Andreas Kretschmer 13:45

Dec. 12, 2010

Thread Author Time
Re: UNION and bad performance pasman pasmański 13:12

Dec. 13, 2010

Thread Author Time
CPU bound Royce Ausburn 02:43
Re: SELECT INTO large FKyed table is slow Robert Haas 03:30
Re: CPU bound Craig Ringer 11:10
Re: CPU bound Josh Berkus 18:59
Re: Hardware recommendations Benjamin Krajmalnik 20:45
Re: CPU bound Royce Ausburn 21:03
Re: Tunning Postgres Robert Haas 23:06

Dec. 14, 2010

Thread Author Time
Re: Hardware recommendations mark 03:29
Re: Tunning Postgres Grzegorz Jaśkiewicz 07:30
Re: Help with bulk read performance Jim Nasby 07:54
Index Bloat - how to tell? John W Strange 14:47
Re: Index Bloat - how to tell? Plugge, Joe R. 14:54
Re: Help with bulk read performance Andy Colson 15:27
Re: Help with bulk read performance Jim Nasby 15:41
Re: Help with bulk read performance Andy Colson 15:51
Re: Help with bulk read performance Nick Matheson 16:07
Re: Index Bloat - how to tell? Mladen Gogala 16:21
Re: Help with bulk read performance Jim Nasby 16:39
Re: Index Bloat - how to tell? Dave Crooke 20:12
Re: Index Bloat - how to tell? Mark Kirkwood 22:20

Dec. 15, 2010

Thread Author Time
only one index is using, why? AI Rumman 06:56
Re: only one index is using, why? Marti Raudsepp 08:52
Problems with FTS Rauan Maemirov 13:56
performance libpq vs JDBC Werner Scholtes 14:51
Re: Help with bulk read performance 📎 Dan Schaffer 20:15

Dec. 16, 2010

Thread Author Time
Re: performance libpq vs JDBC Divakar Singh 08:10
Re: performance libpq vs JDBC Werner Scholtes 09:21
Re: performance libpq vs JDBC Divakar Singh 09:37
Re: performance libpq vs JDBC Werner Scholtes 09:41
Re: performance libpq vs JDBC Divakar Singh 09:48
How to get FK to use new index without restarting the database Eric Comeau 12:12
Re: performance libpq vs JDBC Richard Huxton 12:14
Re: performance libpq vs JDBC Werner Scholtes 12:28
postgres performance tunning selvi88 12:33
Re: How to get FK to use new index without restarting the database Jayadevan M 12:34
Re: performance libpq vs JDBC Richard Huxton 12:37
Re: How to get FK to use new index without restarting the database Richard Huxton 12:39
Re: How to get FK to use new index without restarting the database Eric Comeau 12:55
Re: Help with bulk read performance Krzysztof Nienartowicz 13:39
Re: performance libpq vs JDBC Merlin Moncure 15:09
Re: Help with bulk read performance Pierre C 15:22
Re: How to get FK to use new index without restarting the database Tom Lane 16:27
Re: How to get FK to use new index without restarting the database Eric Comeau 16:46
Re: Index Bloat - how to tell? Mladen Gogala 19:27
Auto-clustering? Royce Ausburn 23:49

Dec. 17, 2010

Thread Author Time
Re: How to get FK to use new index without restarting the database Eric Comeau 06:53
Re: Auto-clustering? Filip Rembiałkowski 09:27
Re: Auto-clustering? Marti Raudsepp 09:41
Re: postgres performance tunning Pierre C 10:07
Re: Auto-clustering? Filip Rembiałkowski 10:19
Re: Auto-clustering? Pierre C 10:20
Re: postgres performance tunning selvi88 10:48
Re: postgres performance tunning Greg Smith 13:20
Re: Help with bulk read performance Nick Matheson 13:51
Re: postgres performance tunning Marti Raudsepp 14:01
Re: Auto-clustering? phb07 16:19
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Tom Polak 17:08
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Craig James 17:32
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Richard Broersma 17:33
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Rob Wultsch 17:36
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Robert Haas 17:37
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson 17:44
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Tom Polak 17:49
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson 17:50
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Justin Pitts 19:53
Re: postgres performance tunning Merlin Moncure 22:13
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Robert Haas 23:49

Dec. 18, 2010

Thread Author Time
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Scott Marlowe 02:06
Re: Index Bloat - how to tell? Robert Haas 02:32
Re: Strange optimization - xmin,xmax compression :) Robert Haas 02:46
Re: Index Bloat - how to tell? Mladen Gogala 03:56
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Gael Le Mignot 08:38
Re: postgres performance tunning selvi88 09:34
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Scott Marlowe 11:31
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Pierre C 13:55
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Kevin Grittner 15:53
Re: Problems with FTS Kevin Grittner 17:56
PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh 18:15
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Kevin Grittner 18:35
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Jeff Janes 18:51
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh 18:57
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh 19:13
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh 19:42
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Jeff Janes 19:48
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Ivan Voras 22:27
Re: Auto-clustering? Royce Ausburn 22:39

Dec. 19, 2010

Thread Author Time
Re: Auto-clustering? Royce Ausburn 03:07
Re: Strange optimization - xmin,xmax compression :) Jim Nasby 18:22

Dec. 20, 2010

Thread Author Time
Re: CPU bound James Cloos 00:57
Re: CPU bound Mladen Gogala 06:47
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh 14:10
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Scott Marlowe 14:21
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Scott Marlowe 14:24
Re: CPU bound James Cloos 15:33
Re: CPU bound Kenneth Marshall 15:48
Re: postgres performance tunning Fernando Hevia 15:50
Re: postgres performance tunning Scott Marlowe 17:26
Re: postgres performance tunning Greg Smith 17:49
Re: CPU bound Jeremy Harris 17:59
Re: postgres performance tunning Scott Marlowe 18:19
Re: UNION and bad performance Robert Haas 18:57

Dec. 21, 2010

Thread Author Time
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh 03:31
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Scott Marlowe 03:35
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Magnus Hagander 08:43
MySQL HandlerSocket - Is this possible in PG? Michael Ben-Nes 09:09
Re: MySQL HandlerSocket - Is this possible in PG? Pavel Stehule 11:31
Re: CPU bound Mladen Gogala 11:34

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