Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-performance - July 2011
Prev | Next
2011-07-01
- Infinite Cache Anthony Presley (14:43)
- Re: Infinite Cache Greg Smith (15:54)
- Re: Infinite Cache Jim Nasby (22:37)
- Re: near identical queries have vastly different plans Tom Lane (22:46)
2011-07-02
- Re: near identical queries have vastly different plans Samuel Gendler (00:51)
- Re: Infinite Cache Dave Page (08:20)
2011-07-03
- How can retrieve total query run-time with out using explain Radhya sahal (04:13)
- Re: How can retrieve total query run-time with out using explain Craig Ringer (06:09)
- Re: Infinite Cache Magnus Hagander (11:21)
- Re: Infinite Cache Greg Smith (18:18)
2011-07-05
- Re: bitmask index Marcus Engene (10:15)
- Re: Infinite Cache Shaun Thomas (13:35)
- Postgres bulkload without transaction logs shouvik basu (14:42)
- Re: Postgres bulkload without transaction logs Greg Smith (17:41)
- Re: bitmask index Greg Smith (17:43)
- Query in 9.0.2 not using index in 9.0.0 works fine Matthias Howell (20:50)
2011-07-06
- Slow query when using ORDER BY *and* LIMIT Jonathan (00:18)
- GROUP BY with reasonable timings in PLAN but unreasonable execution time Clem Dickey (02:26)
- Re: Query in 9.0.2 not using index in 9.0.0 works fine Samuel Gendler (07:42)
- Re: Query in 9.0.2 not using index in 9.0.0 works fine Matthias Howell (12:50)
- Re: 100% CPU Utilization when we run queries. bakkiya (13:30)
- Re: 100% CPU Utilization when we run queries. Kevin Grittner (13:47)
- Re: 100% CPU Utilization when we run queries. Tomas Vondra (19:04)
- Re: Query in 9.0.2 not using index in 9.0.0 works fine Samuel Gendler (20:01)
- Re: 100% CPU Utilization when we run queries. Scott Marlowe (21:05)
- Re: 100% CPU Utilization when we run queries. Craig Ringer (23:36)
2011-07-07
- Re: GROUP BY with reasonable timings in PLAN but unreasonable execution time Clem Dickey (00:59)
- Re: 100% CPU Utilization when we run queries. Robert Klemme (09:45)
- Re: 100% CPU Utilization when we run queries. bakkiya (12:49)
- DELETE taking too much memory vincent dephily (13:34)
- very large record sizes and ressource usage jtkells (14:33)
- INSERT query times sergio mayoral (15:35)
- Re: [PERFORM] DELETE taking too much memory French, Martin (18:54)
- "VACUUM FULL ANALYZE" vs. Autovacuum Contention D C (20:23)
- Re: DELETE taking too much memory Guillaume Lelarge (20:26)
- "VACUUM FULL ANALYZE" vs. Autovacuum Contention D C (20:30)
- Re: "VACUUM FULL ANALYZE" vs. Autovacuum Contention Scott Marlowe (21:21)
- Re: "VACUUM FULL ANALYZE" vs. Autovacuum Contention Greg Smith (21:30)
- UPDATEDs slowing SELECTs in a fully cached database lars (23:56)
2011-07-08
- Very large record sizes and resource usage jtkells (00:02)
- Re: DELETE taking too much memory Dean Rasheed (09:05)
- Re: DELETE taking too much memory Vincent de Phily (09:13)
- Re: [PERFORM] DELETE taking too much memory Vincent de Phily (09:20)
- Re: [PERFORM] DELETE taking too much memory French, Martin (09:31)
- Re: DELETE taking too much memory Vincent de Phily (09:44)
- Re: [PERFORM] DELETE taking too much memory Vincent de Phily (09:50)
- Re: DELETE taking too much memory Dean Rasheed (10:48)
- Re: [PERFORM] DELETE taking too much memory Claudio Freire (11:09)
- execution time for first INSERT Sergio Mayoral (11:23)
- Re: Infinite Cache Heikki Linnakangas (13:34)
- Re: [PERFORM] DELETE taking too much memory Jose Ildefonso Camargo Tolosa (13:37)
- Re: Infinite Cache Magnus Hagander (13:41)
- Re: "VACUUM FULL ANALYZE" vs. Autovacuum Contention D C (16:46)
- Re: "VACUUM FULL ANALYZE" vs. Autovacuum Contention Greg Smith (17:12)
- Just a note about column equivalence disarming the planner Shaun Thomas (20:20)
- issue with query optimizer when joining two partitioned tables Anish Kejariwal (21:36)
- Re: Slow query when using ORDER BY *and* LIMIT Jonathan (22:23)
2011-07-09
- Re: execution time for first INSERT Jeff Davis (00:40)
- Re: GROUP BY with reasonable timings in PLAN but unreasonable execution time Clem Dickey (01:33)
- Re: Slow query when using ORDER BY *and* LIMIT Pavel Stehule (03:39)
- Re: Slow query when using ORDER BY *and* LIMIT Pavel Stehule (03:49)
- Memory usage of auto-vacuum Gael Le Mignot (07:25)
- Re: issue with query optimizer when joining two partitioned tables Heikki Linnakangas (07:54)
- Re: Memory usage of auto-vacuum Craig Ringer (08:31)
- Re: Memory usage of auto-vacuum Guillaume Lelarge (08:33)
- Re: Memory usage of auto-vacuum Gael Le Mignot (08:39)
- Re: Memory usage of auto-vacuum Gael Le Mignot (08:43)
- Re: Memory usage of auto-vacuum Guillaume Lelarge (08:53)
- Re: Memory usage of auto-vacuum Gael Le Mignot (09:00)
- Re: Memory usage of auto-vacuum Guillaume Lelarge (09:06)
- Re: Memory usage of auto-vacuum Gael Le Mignot (09:27)
- Re: Memory usage of auto-vacuum Craig Ringer (12:15)
- Re: Memory usage of auto-vacuum Tom Lane (16:23)
- Re: issue with query optimizer when joining two partitioned tables Tom Lane (17:43)
2011-07-10
- Re: INSERT query times Pavel Stehule (08:12)
- Re: Memory usage of auto-vacuum Gael Le Mignot (10:06)
- query total time im milliseconds Radhya sahal (11:41)
- query total time im milliseconds Radhya sahal (13:07)
- query total time im milliseconds Radhya sahal (13:08)
- Re: issue with query optimizer when joining two partitioned tables Anish Kejariwal (15:33)
- Re: issue with query optimizer when joining two partitioned tables Jeremy Harris (15:46)
- Re: INSERT query times Tom Lane (16:42)
- query total time im milliseconds Radhya sahal (16:44)
- Re: query total time im milliseconds Samuel Gendler (17:51)
- Fw: query total time im milliseconds Radhya sahal (18:26)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (20:34)
- Statistics and Multi-Column indexes lars (21:16)
- Re: Statistics and Multi-Column indexes Samuel Gendler (21:31)
- Re: query total time im milliseconds Craig Ringer (22:20)
- Re: Fw: query total time im milliseconds Craig Ringer (22:54)
- Re: UPDATEDs slowing SELECTs in a fully cached database Craig Ringer (23:11)
2011-07-11
- Re: UPDATEDs slowing SELECTs in a fully cached database lars hofhansl (04:47)
- Re: UPDATEDs slowing SELECTs in a fully cached database ktm@rice.edu (13:13)
- Re: UPDATEDs slowing SELECTs in a fully cached database Robert Klemme (15:26)
- Re: UPDATEDs slowing SELECTs in a fully cached database ktm@rice.edu (16:14)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (17:33)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (18:33)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (19:16)
- Re: Statistics and Multi-Column indexes Kevin Grittner (20:32)
- Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (21:43)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (21:55)
- Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (22:11)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (23:02)
2011-07-12
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (00:09)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (04:42)
- Trigger or Function alan (07:41)
- Re: UPDATEDs slowing SELECTs in a fully cached database Ivan Voras (13:22)
- Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (14:18)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (14:36)
- Re: UPDATEDs slowing SELECTs in a fully cached database Ivan Voras (14:43)
- Re: UPDATEDs slowing SELECTs in a fully cached database Ivan Voras (15:13)
- Re: Memory usage of auto-vacuum Gael Le Mignot (15:44)
- Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (16:23)
- Planner choosing NestedLoop, although it is slower... Mario Splivalo (18:11)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (19:01)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (19:08)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (19:26)
- Re: Planner choosing NestedLoop, although it is slower... Clem Dickey (19:55)
- Re: Planner choosing NestedLoop, although it is slower... Tom Lane (20:04)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (20:04)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (20:51)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (20:58)
- Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (21:38)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (21:51)
- Re: Planner choosing NestedLoop, although it is slower... Mario Splivalo (22:06)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (22:36)
- Re: Planner choosing NestedLoop, although it is slower... Tom Lane (22:39)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (23:15)
- Re: Planner choosing NestedLoop, although it is slower... Mario Splivalo (23:57)
2011-07-13
- Re: UPDATEDs slowing SELECTs in a fully cached database Jeff Janes (00:35)
- Re: Planner choosing NestedLoop, although it is slower... Mario Splivalo (00:53)
- Re: UPDATEDs slowing SELECTs in a fully cached database Tom Lane (01:16)
- Re: Planner choosing NestedLoop, although it is slower... Mario Splivalo (02:04)
- Re: UPDATEDs slowing SELECTs in a fully cached database Lars (04:01)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (14:46)
- Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (14:52)
- Re: UPDATEDs slowing SELECTs in a fully cached database Tom Lane (15:17)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (18:10)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (18:23)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (18:42)
- Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (19:01)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (21:57)
- Re: UPDATEDs slowing SELECTs in a fully cached database Tom Lane (22:21)
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (22:41)
2011-07-14
- Re: Trigger or Function Robert Klemme (11:06)
- Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (14:05)
- Re: UPDATEDs slowing SELECTs in a fully cached database Robert Klemme (15:03)
- Re: UPDATEDs slowing SELECTs in a fully cached database Tom Lane (15:47)
- Re: UPDATEDs slowing SELECTs in a fully cached database Jeff Janes (21:45)
- Re: UPDATEDs slowing SELECTs in a fully cached database Jeff Janes (23:03)
2011-07-15
- Hardware advice for scalable warehouse db chris (06:34)
- Re: Hardware advice for scalable warehouse db Greg Smith (07:10)
- Re: Inoptimal query plan for max() and multicolumn index Gaetano Mendola (07:14)
- Re: Inoptimal query plan for max() and multicolumn index Gaetano Mendola (07:14)
- Re: Hardware advice for scalable warehouse db jesper (08:22)
- Unexpected seq scans when expected result is 1 row out of milions Svetlin Manavski (12:57)
- Re: Hardware advice for scalable warehouse db Robert Schnabel (16:39)
- Re: Unexpected seq scans when expected result is 1 row out of milions Tom Lane (17:58)
- Re: Hardware advice for scalable warehouse db Scott Marlowe (17:59)
- Re: Hardware advice for scalable warehouse db Scott Marlowe (18:01)
- Re: Hardware advice for scalable warehouse db Josh Berkus (18:46)
- Re: Hardware advice for scalable warehouse db chris r. (18:49)
- Re: Hardware advice for scalable warehouse db Rob Wultsch (19:25)
- Re: Hardware advice for scalable warehouse db Josh Berkus (19:46)
- Re: Statistics and Multi-Column indexes lars (21:40)
2011-07-16
- Re: UPDATEDs slowing SELECTs in a fully cached database lars (00:21)
- Re: UPDATEDs slowing SELECTs in a fully cached database Jeff Janes (22:33)
2011-07-17
2011-07-18
- Re: UPDATEDs slowing SELECTs in a fully cached database Greg Smith (00:44)
- BBU still needed with SSD? Andy (01:43)
- Re: BBU still needed with SSD? Craig Ringer (02:30)
- Re: BBU still needed with SSD? Yeb Havinga (07:56)
- cpu comparison M. D. (19:48)
- Re: cpu comparison ktm@rice.edu (20:11)
- Re: cpu comparison Tomas Vondra (21:56)
- Re: cpu comparison Josh Berkus (22:03)
- Re: cpu comparison ktm@rice.edu (23:19)
- Re: BBU still needed with SSD? David Rees (23:37)
2011-07-19
- Re: BBU still needed with SSD? Greg Smith (00:39)
- Re: cpu comparison Greg Smith (00:47)
- Re: BBU still needed with SSD? Andy (01:33)
- Re: cpu comparison Scott Marlowe (01:38)
- Re: BBU still needed with SSD? Bruce Momjian (01:59)
- Re: cpu comparison M. D. (03:25)
- Re: BBU still needed with SSD? Andy (03:56)
- Re: cpu comparison Samuel Gendler (05:05)
- Re: BBU still needed with SSD? Florian Weimer (07:56)
- Re: BBU still needed with SSD? Greg Smith (10:19)
- Re: BBU still needed with SSD? Yeb Havinga (10:35)
- Re: BBU still needed with SSD? Florian Weimer (10:47)
- Re: BBU still needed with SSD? Yeb Havinga (11:25)
- Re: BBU still needed with SSD? Florian Weimer (11:37)
- Re: BBU still needed with SSD? Yeb Havinga (12:16)
- Re: BBU still needed with SSD? Greg Smith (14:29)
- Re: hstore - Implementation and performance issues around its operators Robert Haas (20:08)
- Re: Large rows number, and large objects Robert Haas (20:27)
- Re: bad plan: 8.4.8, hashagg, work_mem=1MB. Robert Haas (20:32)
- Re: hstore - Implementation and performance issues around its operators Stefan Keller (21:06)
2011-07-20
- Re: Large rows number, and large objects Jose Ildefonso Camargo Tolosa (15:57)
- Re: Large rows number, and large objects Robert Haas (19:30)