Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2011-07 Chronological Index (1/2)
Last updated: Wed Jan 18 04:12:20 2012
235 messages
30 July 2011
Re: Performance penalty when using WITH Robert Klemme (13:10)
Re: insert Gavin Flower (05:24)
Re: Trigger or Function Gavin Flower (01:01)
29 July 2011
Re: heavy load-high cpu itilization Scott Marlowe (19:54)
Re: Performance penalty when using WITH Tom Lane (17:40)
Re: UPDATEDs slowing SELECTs in a fully cached database lars hofhansl (15:57)
Re: Queries related to checkpoints Kevin Grittner (15:25)
Queries related to checkpoints Rohan Malhotra (13:37)
Re: very large record sizes and ressource usage Robert Haas (00:25)
28 July 2011
27 July 2011
Re: UPDATEDs slowing SELECTs in a fully cached database Pavan Deolasee (14:16)
issue related to logging facility of postgres shailesh singh (09:11)
25 July 2011
heavy load-high cpu itilization Filippos (18:00)
Re: insert alan (14:43)
Re: [ADMIN] Restore database after drop command Florian Weimer (10:51)
Re: [ADMIN] Restore database after drop command Adarsh Sharma (07:11)
Re: [ADMIN] Restore database after drop command Vibhor Kumar (06:47)
Restore database after drop command Adarsh Sharma (06:38)
24 July 2011
Re: Bad query plan Tom Lane (16:02)
Bad query plan Дмитрий Васильев (14:06)
23 July 2011
Re: Trigger or Function alan (16:13)
22 July 2011
Re: Large rows number, and large objects Jose Ildefonso Camargo Tolosa (00:46)
21 July 2011
Re: BBU still needed with SSD? Klaus Ita (07:26)
20 July 2011
Re: Large rows number, and large objects Robert Haas (19:30)
Re: Large rows number, and large objects Jose Ildefonso Camargo Tolosa (15:57)
19 July 2011
Re: bad plan: 8.4.8, hashagg, work_mem=1MB. Robert Haas (20:32)
Re: Large rows number, and large objects Robert Haas (20:28)
Re: hstore - Implementation and performance issues around its operators Robert Haas (20:08)
Re: BBU still needed with SSD? Greg Smith (14:29)
Re: BBU still needed with SSD? Yeb Havinga (12:16)
Re: BBU still needed with SSD? Florian Weimer (11:37)
Re: BBU still needed with SSD? Yeb Havinga (11:25)
Re: BBU still needed with SSD? Florian Weimer (10:47)
Re: BBU still needed with SSD? Yeb Havinga (10:35)
Re: BBU still needed with SSD? Greg Smith (10:19)
Re: BBU still needed with SSD? Florian Weimer (07:57)
Re: cpu comparison Samuel Gendler (05:05)
Re: BBU still needed with SSD? Andy (03:56)
Re: cpu comparison M. D. (03:25)
Re: BBU still needed with SSD? Bruce Momjian (02:00)
Re: cpu comparison Scott Marlowe (01:38)
Re: BBU still needed with SSD? Andy (01:33)
Re: cpu comparison Greg Smith (00:47)
Re: BBU still needed with SSD? Greg Smith (00:40)
18 July 2011
Re: cpu comparison ktm(at)rice(dot)edu (23:19)
Re: cpu comparison Josh Berkus (22:03)
Re: cpu comparison Tomas Vondra (21:56)
Re: cpu comparison ktm(at)rice(dot)edu (20:11)
cpu comparison M. D. (19:48)
Re: BBU still needed with SSD? Yeb Havinga (07:56)
Re: BBU still needed with SSD? Craig Ringer (02:30)
BBU still needed with SSD? Andy (01:43)
Re: UPDATEDs slowing SELECTs in a fully cached database Greg Smith (00:44)
17 July 2011
16 July 2011
Re: UPDATEDs slowing SELECTs in a fully cached database lars (00:22)
15 July 2011
Re: Hardware advice for scalable warehouse db Josh Berkus (19:46)
Re: Hardware advice for scalable warehouse db Rob Wultsch (19:26)
Re: Hardware advice for scalable warehouse db chris r. (18:56)
Re: Hardware advice for scalable warehouse db Josh Berkus (18:46)
Re: Hardware advice for scalable warehouse db Scott Marlowe (18:01)
Re: Hardware advice for scalable warehouse db Scott Marlowe (18:00)
Re: Unexpected seq scans when expected result is 1 row out of milions Tom Lane (17:59)
Re: Hardware advice for scalable warehouse db Robert Schnabel (16:49)
Unexpected seq scans when expected result is 1 row out of milions Svetlin Manavski (12:57)
Re: Hardware advice for scalable warehouse db jesper (08:23)
Re: Inoptimal query plan for max() and multicolumn index Gaetano Mendola (07:43)
Re: Inoptimal query plan for max() and multicolumn index Gaetano Mendola (07:43)
Re: Hardware advice for scalable warehouse db Greg Smith (07:10)
Hardware advice for scalable warehouse db chris (06:40)
14 July 2011
Re: UPDATEDs slowing SELECTs in a fully cached database Jeff Janes (21:45)
Re: UPDATEDs slowing SELECTs in a fully cached database Tom Lane (16:01)
Re: UPDATEDs slowing SELECTs in a fully cached database Robert Klemme (15:06)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (14:31)
Re: Trigger or Function Robert Klemme (11:09)
13 July 2011
Re: UPDATEDs slowing SELECTs in a fully cached database Tom Lane (22:21)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (21:57)
Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (19:01)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (18:42)
Re: UPDATEDs slowing SELECTs in a fully cached database lars (18:23)
Re: UPDATEDs slowing SELECTs in a fully cached database lars (18:12)
Re: UPDATEDs slowing SELECTs in a fully cached database Tom Lane (15:17)
Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (14:53)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (14:46)
Re: UPDATEDs slowing SELECTs in a fully cached database Lars (04:01)
Re: Planner choosing NestedLoop, although it is slower... Mario Splivalo (02:04)
Re: UPDATEDs slowing SELECTs in a fully cached database Tom Lane (01:16)
Re: Planner choosing NestedLoop, although it is slower... Mario Splivalo (00:53)
Re: UPDATEDs slowing SELECTs in a fully cached database Jeff Janes (00:40)
12 July 2011
Re: UPDATEDs slowing SELECTs in a fully cached database lars (23:15)
Re: Planner choosing NestedLoop, although it is slower... Tom Lane (22:39)
Re: UPDATEDs slowing SELECTs in a fully cached database lars (22:36)
Re: Planner choosing NestedLoop, although it is slower... Mario Splivalo (22:06)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (21:51)
Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (21:38)
Re: UPDATEDs slowing SELECTs in a fully cached database lars (20:58)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (20:51)
Re: Planner choosing NestedLoop, although it is slower... Clem Dickey (20:13)
Re: UPDATEDs slowing SELECTs in a fully cached database lars (20:05)
Re: Planner choosing NestedLoop, although it is slower... Tom Lane (20:04)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (19:26)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (19:08)
Re: UPDATEDs slowing SELECTs in a fully cached database lars (19:02)
Planner choosing NestedLoop, although it is slower... Mario Splivalo (18:18)
Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (16:23)
Re: Memory usage of auto-vacuum Gael Le Mignot (15:44)
Re: UPDATEDs slowing SELECTs in a fully cached database Ivan Voras (15:13)
Re: UPDATEDs slowing SELECTs in a fully cached database Ivan Voras (14:43)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (14:36)
Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (14:18)
Re: UPDATEDs slowing SELECTs in a fully cached database Ivan Voras (13:23)
Trigger or Function alan (07:43)
Re: UPDATEDs slowing SELECTs in a fully cached database lars (04:43)
Re: UPDATEDs slowing SELECTs in a fully cached database lars (00:09)
11 July 2011
Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (22:11)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (21:55)
Re: UPDATEDs slowing SELECTs in a fully cached database Merlin Moncure (21:43)
Re: Statistics and Multi-Column indexes Kevin Grittner (20:32)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (19:16)
Re: UPDATEDs slowing SELECTs in a fully cached database lars (18:33)
Re: UPDATEDs slowing SELECTs in a fully cached database Kevin Grittner (17:34)
Re: UPDATEDs slowing SELECTs in a fully cached database ktm(at)rice(dot)edu (16:15)
Re: UPDATEDs slowing SELECTs in a fully cached database Robert Klemme (15:27)
Re: UPDATEDs slowing SELECTs in a fully cached database ktm(at)rice(dot)edu (13:13)
Re: UPDATEDs slowing SELECTs in a fully cached database lars hofhansl (04:47)
10 July 2011
Re: Fw: query total time im milliseconds Craig Ringer (22:54)
Re: query total time im milliseconds Craig Ringer (22:21)
Re: Statistics and Multi-Column indexes Samuel Gendler (21:31)
Statistics and Multi-Column indexes lars (21:16)
Re: UPDATEDs slowing SELECTs in a fully cached database lars (20:34)
Fw: query total time im milliseconds Radhya sahal (18:26)
query total time im milliseconds Radhya sahal (18:13)
query total time im milliseconds Radhya sahal (18:13)
Re: query total time im milliseconds Samuel Gendler (17:51)
query total time im milliseconds Radhya sahal (16:44)
Re: INSERT query times Tom Lane (16:43)
query total time im milliseconds Radhya sahal (16:41)
Re: issue with query optimizer when joining two partitioned tables Jeremy Harris (16:06)
Re: Memory usage of auto-vacuum Gael Le Mignot (15:49)
Re: issue with query optimizer when joining two partitioned tables Anish Kejariwal (15:34)
Re: INSERT query times Pavel Stehule (08:12)
09 July 2011
Re: Memory usage of auto-vacuum Tom Lane (16:23)
Re: Memory usage of auto-vacuum Craig Ringer (12:15)
Re: Memory usage of auto-vacuum Gael Le Mignot (09:27)
Re: Memory usage of auto-vacuum Guillaume Lelarge (09:06)
Re: Memory usage of auto-vacuum Gael Le Mignot (09:00)
Re: Memory usage of auto-vacuum Guillaume Lelarge (08:53)
Re: Memory usage of auto-vacuum Gael Le Mignot (08:43)
Re: Memory usage of auto-vacuum Gael Le Mignot (08:39)
Re: Memory usage of auto-vacuum Guillaume Lelarge (08:33)
Re: Memory usage of auto-vacuum Craig Ringer (08:32)
Re: issue with query optimizer when joining two partitioned tables Heikki Linnakangas (07:54)
Memory usage of auto-vacuum Gael Le Mignot (07:49)
Re: Slow query when using ORDER BY *and* LIMIT Pavel Stehule (03:50)
Re: Slow query when using ORDER BY *and* LIMIT Pavel Stehule (03:40)
Re: GROUP BY with reasonable timings in PLAN but unreasonable execution time Clem Dickey (01:38)
Re: execution time for first INSERT Jeff Davis (00:40)
08 July 2011
issue with query optimizer when joining two partitioned tables Anish Kejariwal (21:36)
Just a note about column equivalence disarming the planner Shaun Thomas (20:20)