Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - April 2010

Prev | Next

Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30

2010-04-01

Re: temp table "on commit delete rows": transaction overhead Bruce Momjian (00:44)
Re: How to fast the REINDEX Craig Ringer (03:11)
Re: How to fast the REINDEX Hannu Krosing (10:54)
Re: How to fast the REINDEX Steve Clark (11:10)
Re: How to fast the REINDEX Greg Smith (11:36)
Re: experiments in query optimization Faheem Mitha (11:46)
Re: How to fast the REINDEX Pierre C (12:25)
Re: How to fast the REINDEX raghavendra t (13:47)
Re: How to fast the REINDEX Brad Nicholson (13:52)
Re: How to fast the REINDEX Kevin Grittner (14:19)
Re: experiments in query optimization Eliot Gable (16:31)
Re: experiments in query optimization Faheem Mitha (18:15)
Re: experiments in query optimization Robert Haas (18:50)
Re: experiments in query optimization Faheem Mitha (19:01)
Re: experiments in query optimization Eliot Gable (19:29)
Re: experiments in query optimization Faheem Mitha (19:32)
Re: Database size growing over time and leads to performance impact Scott Carey (20:08)
Re: Database size growing over time and leads to performance impact Tom Lane (20:42)
Re: Database size growing over time and leads to performance impact Scott Carey (21:00)

2010-04-02

LIMIT causes planner to do Index Scan using a less optimal index Joel Jacobson (18:19)
Using high speed swap to improve performance? Christiaan Willemsen (19:15)
Re: Using high speed swap to improve performance? Arjen van der Meijden (19:53)
Re: How much memory is PostgreSQL using Campbell, Lance (20:10)
Does the psql executable support a "fetch many" approach when dumping large queries to stdout? Beaver, John E (20:28)
Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout? Pierre C (20:43)
Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout? Hannu Krosing (22:18)
Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout? John Beaver (22:18)
Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout? John Beaver (22:19)

2010-04-03

David Crooke wants to stay in touch on LinkedIn David Crooke (05:05)
Re: How much memory is PostgreSQL using Guillaume Lelarge (11:58)
ERROR: cache lookup failed for relation X raghavendra t (16:38)
Re: ERROR: cache lookup failed for relation X justin@magwerks.com (17:04)
Re: ERROR: cache lookup failed for relation X Tom Lane (17:05)

2010-04-04

Re: ERROR: cache lookup failed for relation X raghavendra t (02:50)
Re: ERROR: cache lookup failed for relation X raghavendra t (02:52)
Re: Using high speed swap to improve performance? Robert Haas (20:52)
Re: Using high speed swap to improve performance? Robert Haas (20:53)
Re: Using high speed swap to improve performance? Scott Marlowe (21:07)
Re: Using high speed swap to improve performance? Lew (21:17)

2010-04-05

Re: temp table "on commit delete rows": transaction overhead Artiom Makarov (07:56)
Re: temp table "on commit delete rows": transaction overhead Bruce Momjian (12:09)
Huge table searching optimization Oliver Kindernay (14:28)
Re: Huge table searching optimization hubert depesz lubaczewski (14:32)
Re: Using high speed swap to improve performance? Greg Smith (14:55)
Re: Huge table searching optimization Andres Freund (16:10)
Re: Huge table searching optimization Tom Lane (16:22)
Re: How to fast the REINDEX Robert Haas (16:54)
Re: Huge table searching optimization Oliver Kindernay (17:11)

2010-04-06

query slow; strace output worrisome Brian Cox (01:01)
Re: query slow; strace output worrisome Craig Ringer (01:53)
Re: query slow; strace output worrisome Brian Cox (04:04)
Re: query slow; strace output worrisome Craig Ringer (05:18)
Re: Using high speed swap to improve performance? Christiaan Willemsen (07:38)
Re: query slow; strace output worrisome Brian Cox (16:24)
Re: 3ware vs. MegaRAID Ireneusz Pluta (16:49)
Re: LIMIT causes planner to do Index Scan using a less optimal index Robert Haas (18:33)
Re: Some question Scott Marlowe (18:45)
Re: Using high speed swap to improve performance? Scott Marlowe (18:48)
indexes in partitioned tables - again Samuel Gendler (21:37)
Re: Some question Kevin Grittner (22:11)
Re: LIMIT causes planner to do Index Scan using a less optimal index Joel Jacobson (22:30)

2010-04-07

Re: LIMIT causes planner to do Index Scan using a less optimal index Robert Haas (00:22)
significant slow down with various LIMIT norn (00:42)
Re: query slow; strace output worrisome Craig Ringer (02:32)
Re: Some question Yeb Havinga (07:18)
Re: LIMIT causes planner to do Index Scan using a less optimal index Sherry.CTR.Zhu (12:20)
How check execution plan of a function Sabin Coanda (12:47)
Re: LIMIT causes planner to do Index Scan using a less optimal index Grzegorz Jaśkiewicz (12:51)
Re: LIMIT causes planner to do Index Scan using a less optimal index Sherry.CTR.Zhu (13:08)
Re: LIMIT causes planner to do Index Scan using a less optimal index Grzegorz Jaśkiewicz (13:12)
Re: LIMIT causes planner to do Index Scan using a less optimal index Sherry.CTR.Zhu (13:22)
Re: LIMIT causes planner to do Index Scan using a less optimal index Matthew Wakeling (13:36)
Re: LIMIT causes planner to do Index Scan using a less optimal index Joel Jacobson (15:52)
Re: query slow; strace output worrisome Robert Haas (18:39)
Re: indexes in partitioned tables - again Robert Haas (21:13)
Occasional giant spikes in CPU load Craig James (21:37)
Re: Occasional giant spikes in CPU load Joshua D. Drake (21:40)
Re: Occasional giant spikes in CPU load Craig James (21:45)
Re: Occasional giant spikes in CPU load Greg Smith (21:54)
Re: Occasional giant spikes in CPU load Tom Lane (21:59)
Re: Using high speed swap to improve performance? Lew (22:09)
Re: Occasional giant spikes in CPU load Joshua D. Drake (22:36)
Re: Occasional giant spikes in CPU load David Rees (22:56)
Re: Occasional giant spikes in CPU load Craig James (22:57)
Re: Occasional giant spikes in CPU load Craig James (23:07)
Re: Occasional giant spikes in CPU load Steve Crawford (23:14)
Re: Occasional giant spikes in CPU load Alan Hodgson (23:38)
Re: Occasional giant spikes in CPU load David Rees (23:52)

2010-04-08

Re: Occasional giant spikes in CPU load Tom Lane (00:18)
Re: Occasional giant spikes in CPU load Robert Haas (00:47)
Re: Occasional giant spikes in CPU load Craig James (02:06)
Re: Occasional giant spikes in CPU load David Rees (02:50)
Re: Occasional giant spikes in CPU load Robert Haas (03:07)
Re: 3ware vs. MegaRAID Scott Carey (03:29)
Re: 3ware vs. MegaRAID Dave Crooke (03:44)
Re: Occasional giant spikes in CPU load Greg Smith (06:08)
Re: 3ware vs. MegaRAID Greg Smith (06:13)
Re: How check execution plan of a function Sabin Coanda (06:29)
PostgreSQL with Zabbix - problem of newbe Krzysztof Kardas (09:23)
Re: PostgreSQL with Zabbix - problem of newbe Grzegorz Jaśkiewicz (09:31)
Query Optimization Kaloyan Iliev Iliev (12:58)
Re: PostgreSQL with Zabbix - problem of newbe Merlin Moncure (13:16)
Re: Query Optimization Kaloyan Iliev Iliev (13:41)
Re: Query Optimization A. Kretschmer (14:03)
Re: How check execution plan of a function Andy Colson (15:44)
Re: significant slow down with various LIMIT Kevin Grittner (16:44)
Re: PostgreSQL with Zabbix - problem of newbe Robert Haas (19:44)
Re: PostgreSQL with Zabbix - problem of newbe Richard Yen (20:08)

2010-04-09

Re: significant slow down with various LIMIT norn (01:13)
Re: PostgreSQL with Zabbix - problem of newbe Greg Smith (02:31)
Re: 3ware vs. MegaRAID Scott Carey (03:28)
Re: PostgreSQL with Zabbix - problem of newbe Greg Smith (04:16)
Re: 3ware vs. MegaRAID Jesper Krogh (06:32)
About “context-switching issue on Xeon” te RD黄永卫 (07:23)
Re: How check execution plan of a function Sabin Coanda (13:18)
Re: How check execution plan of a function Andy Colson (13:52)
Re: PostgreSQL with Zabbix - problem of newbe Merlin Moncure (15:06)
Re: PostgreSQL with Zabbix - problem of newbe Scott Mead (15:13)
Re: 3ware vs. MegaRAID Greg Smith (15:27)
Re: PostgreSQL with Zabbix - problem of newbe Greg Smith (16:03)
Re: 3ware vs. MegaRAID Jesper Krogh (16:11)
Re: PostgreSQL with Zabbix - problem of newbe Scott Marlowe (16:28)
Re: PostgreSQL with Zabbix - problem of newbe Merlin Moncure (16:30)
Re: PostgreSQL with Zabbix - problem of newbe Scott Marlowe (16:44)
Re: 3ware vs. MegaRAID Greg Smith (18:22)
Re: 3ware vs. MegaRAID Jesper Krogh (19:02)
Re: 3ware vs. MegaRAID Scott Marlowe (19:12)
"could not open relation..." Brian Cox (19:43)
Re: significant slow down with various LIMIT Robert Haas (22:48)

2010-04-10

Re: About “context-switching issue on Xeon” test case ？ Greg Smith (04:02)
Re: "could not open relation..." Tom Lane (04:29)
Re: significant slow down with various LIMIT norn (04:41)
Re: [PERFORM] About “context-switching issue on Xe?==?GB2312?Q?on” test case ？ Scott Marlowe (05:05)
Re: [PERFORM] About “context-switching issue on Xe?==?GB2312?Q?on” test case ？ Scott Marlowe (05:07)
Re: PostgreSQL with Zabbix - problem of newbe Krzysztof Kardas (18:54)
function performs differently with different values Ben Chobot (20:47)
Re: Some question Ľubomír Varga (21:42)

2010-04-11

Re: About “context-switching issue on Xeon” test case ？ Greg Smith (02:22)
Re: "could not open relation..." Brian Cox (04:02)
Re: Some question Kevin Grittner (12:44)
Re: [PERFORM] About “context-switching issue on Xe?==?GB2312?Q?on” test case ？ Scott Marlowe (15:43)
planer chooses very bad plan Corin (21:12)
Re: planer chooses very bad plan Scott Marlowe (21:18)
Re: planer chooses very bad plan Luke Lonergan (21:22)
Re: planer chooses very bad plan Hannu Krosing (21:25)
Re: planer chooses very bad plan Corin (22:41)
Re: planer chooses very bad plan Corin (22:44)
Re: planer chooses very bad plan Scott Marlowe (22:49)

2010-04-12

答复: [PERFORM] About “context-switchin RD黄永卫 (01:10)
Re: significant slow down with various LIMIT Helio Campos Mello de Andrade (02:43)
How to diagnose a “context-switching ” RD黄永卫 (06:35)
Re: planer chooses very bad plan Pierre C (10:06)
significant slow down with various LIMIT Helio Campos Mello de Andrade (10:23)
Re: significant slow down with various LIMIT Kevin Grittner (12:09)
Re: function performs differently with different values Robert Haas (13:21)
Re: significant slow down with various LIMIT norn (13:32)
Re: How check execution plan of a function Kevin Grittner (13:50)
Re: [PERFORM] How to diagnose a “context-switching?==?windows-1252?Q? ” storm problem ? Sergey Konoplev (21:27)
Re: significant slow down with various LIMIT Kevin Grittner (21:28)
Re: How to diagnose a *context-switching * storm problem ? Kevin Grittner (21:39)

2010-04-13

Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout? Bruce Momjian (02:49)
Re: significant slow down with various LIMIT norn (06:07)
count is ten times faster Sabin Coanda (12:32)
stats collector suddenly causing lots of IO Chris (15:55)
stats collector suddenly causing lots of IO Chris (17:01)
Re: significant slow down with various LIMIT Kevin Grittner (17:24)
Re: significant slow down with various LIMIT Chris Bowlby (17:59)
Re: count is ten times faster Pierre C (18:09)
Re: stats collector suddenly causing lots of IO Cédric Villemain (18:13)
Re: "could not open relation..." Tom Lane (19:25)
Re: stats collector suddenly causing lots of IO Alvaro Herrera (21:55)

2010-04-14

Re: PostgreSQL with Zabbix - problem of newbe Krzysztof Kardas (13:21)
Re: PostgreSQL with Zabbix - problem of newbe Grzegorz Jaśkiewicz (13:30)
Re: PostgreSQL with Zabbix - problem of newbe Kevin Grittner (13:50)
Re: count is ten times faster Kevin Grittner (14:16)
Re: significant slow down with various LIMIT Kevin Grittner (14:31)
Re: PostgreSQL with Zabbix - problem of newbe Krzysztof Kardas (19:02)
JDBC question for PG 8.3.9 Dave Crooke (20:49)
Re: Occasional giant spikes in CPU load Bruce Momjian (21:58)
Re: JDBC question for PG 8.3.9 Craig Ringer (23:10)

2010-04-15

Good/Bad query plans based on text criteria JmH (01:45)
Re: Good/Bad query plans based on text criteria Tom Lane (02:42)
Re: JDBC question for PG 8.3.9 Dave Crooke (03:03)
Re: JDBC question for PG 8.3.9 Dave Cramer (10:59)
Re: significant slow down with various LIMIT norn (14:23)
8.3.9 - latency spikes with Linux (and tuning for consistently low latency) Marinos Yannikos (16:46)
Re: 8.3.9 - latency spikes with Linux (and tuning for consistently low latency) Tom Lane (17:38)
Re: 8.3.9 - latency spikes with Linux (and tuning for consistently low latency) Kevin Grittner (17:47)
HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Dave Crooke (19:42)
Autovaccum with cost_delay does not complete on one solaris 5.10 machine Josh Berkus (19:44)
Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Alvaro Herrera (20:00)
Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Dave Crooke (20:01)
Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Tom Lane (20:14)
Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Alvaro Herrera (20:24)
Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Josh Berkus (22:17)
Re: stats collector suddenly causing lots of IO Tom Lane (22:21)
Re: 8.3.9 - latency spikes with Linux (and tuning for consistently low latency) Greg Smith (22:45)
Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Tom Lane (22:48)
Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Josh Berkus (22:52)
SOLVED: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Dave Crooke (23:39)

Prev | Next

Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group