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 - June 2011

Prev | Next

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

2011-06-01

Re: [PERFORM] Hash Anti Join performance degradation Cédric Villemain (00:43)
Re: [PERFORM] Hash Anti Join performance degradation Robert Haas (00:55)
Re: [PERFORM] Hash Anti Join performance degradation Cédric Villemain (01:11)
Re: Delete performance Craig Ringer (01:40)
Re: Delete performance Jarrod Chesney (01:45)
Re: [PERFORM] Hash Anti Join performance degradation Robert Haas (02:58)
Re: [PERFORM] Hash Anti Join performance degradation Tom Lane (03:47)
Re: Delete performance Greg Smith (06:14)
Re: Speeding up loops in pl/pgsql function Reuven M. Lerner (09:19)
Re: [PERFORM] Hash Anti Join performance degradation Robert Haas (11:40)
Re: [PERFORM] Hash Anti Join performance degradation panam (12:40)
Re: Speeding up loops in pl/pgsql function Merlin Moncure (13:26)
Re: Strange behavior of child table. Jeff Davis (18:53)
Problem query CS DBA (20:14)
Re: [PERFORM] Hash Anti Join performance degradation Tom Lane (20:25)
Re: [PERFORM] Hash Anti Join performance degradation Robert Haas (20:31)
Re: [PERFORM] Hash Anti Join performance degradation Cédric Villemain (20:34)
Re: [PERFORM] Hash Anti Join performance degradation Tom Lane (20:35)
Re: [PERFORM] Hash Anti Join performance degradation Robert Haas (20:43)
Re: [PERFORM] Hash Anti Join performance degradation Tom Lane (20:47)
Re: [PERFORM] Hash Anti Join performance degradation Robert Haas (20:58)
Re: [PERFORM] Hash Anti Join performance degradation Tom Lane (21:02)
Re: Problem query Merlin Moncure (21:15)
Re: Problem query Kevin Grittner (21:38)
Re: [PERFORM] Hash Anti Join performance degradation Ross J. Reedstrom (21:53)
Re: Problem query CS DBA (22:26)
Re: Problem query CS DBA (22:28)
Re: [PERFORM] Hash Anti Join performance degradation panam (22:49)
CLUSTER versus a dedicated table Robert James (23:54)

2011-06-02

Understanding Hash Join performance Robert James (00:10)
Re: CLUSTER versus a dedicated table mark (01:18)
Re: Problem query Merlin Moncure (01:31)
Re: CLUSTER versus a dedicated table Merlin Moncure (01:33)
Re: Delete performance Jarrod Chesney (01:46)
Re: Speeding up loops in pl/pgsql function Reuven M. Lerner (06:49)
Re: Strange behavior of child table. Jenish (13:39)
Re: Problem query Kevin Grittner (13:47)
Re: Understanding Hash Join performance Kevin Grittner (14:57)
Re: Problem query Shaun Thomas (15:34)
Re: Problem query Kevin Grittner (15:41)
Re: Problem query Kevin Grittner (16:15)
Re: Problem query Shaun Thomas (17:31)
Re: Understanding Hash Join performance Robert Haas (18:39)
Re: Understanding Hash Join performance Claudio Freire (18:56)
Re: Problem query CS DBA (19:17)
Re: Problem query Kevin Grittner (19:57)

2011-06-03

Re: Understanding Hash Join performance Robert Haas (03:55)

2011-06-05

Re: Why we don't want hints Was: Slow count(*) again... pasman pasmański (15:25)

2011-06-06

Re: Why we don't want hints Was: Slow count(*) again... Robert Klemme (08:14)
Re: Index use difference betweer LIKE, LIKE ANY? Heikki Linnakangas (09:43)
Re: Index use difference betweer LIKE, LIKE ANY? Heikki Linnakangas (09:47)
Re: Different execution time for same plan Kevin Grittner (15:48)
poor performance when recreating constraints on large tables Mike Broers (20:35)
Re: poor performance when recreating constraints on large tables Tom Lane (20:37)
not exits slow compared to not in. (nested loops killing me) mark (20:38)
8.4/9.0 simple query performance regression Josh Berkus (21:45)
Re: poor performance when recreating constraints on large tables Mike Broers (22:10)
Re: 8.4/9.0 simple query performance regression Tom Lane (23:02)
Re: not exits slow compared to not in. (nested loops killing me) Craig Ringer (23:07)

2011-06-07

Re: not exits slow compared to not in. (nested loops killing me) Tom Lane (00:09)
Re: not exits slow compared to not in. (nested loops killing me) mark (00:16)
i want to ask monitory peformance memory postgresql with automatically Didik Prasetyo (07:47)
strange query plan with LIMIT anthony.shipman (08:02)
Re: 8.4/9.0 simple query performance regression Vitalii Tymchyshyn (08:19)
strange query plan with LIMIT anthony.shipman (08:26)
Re: i want to ask monitory peformance memory postgresql with automatically Craig Ringer (09:58)
Re: strange query plan with LIMIT Pavel Stehule (10:43)
Re: strange query plan with LIMIT tv (16:40)
Re: i want to ask monitory peformance memory postgresql with automatically Marcos Ortiz (16:57)

2011-06-08

Set of related slow queries John Williams (02:58)
100% CPU Utilization when we run queries. bakkiya (04:19)
Re: 100% CPU Utilization when we run queries. Craig Ringer (05:07)
Re: strange query plan with LIMIT anthony.shipman (05:08)
Re: strange query plan with LIMIT Claudio Freire (07:39)
Re: strange query plan with LIMIT tv (08:33)
Re: strange query plan with LIMIT anthony.shipman (08:34)
Re: strange query plan with LIMIT Pavel Stehule (08:39)
Re: Set of related slow queries Craig Ringer (09:20)
Re: strange query plan with LIMIT anthony.shipman (09:36)
Re: strange query plan with LIMIT tv (09:47)
Re: strange query plan with LIMIT Pavel Stehule (09:58)
Re: Set of related slow queries tv (11:08)
Re: Set of related slow queries tv (11:30)
Re: Set of related slow queries Craig Ringer (13:08)
Re: Set of related slow queries Shaun Thomas (13:36)
Oracle v. Postgres 9.0 query performance Tony Capobianco (15:11)
Re: Oracle v. Postgres 9.0 query performance tv (15:31)
Re: Oracle v. Postgres 9.0 query performance Tom Lane (15:33)
Re: Oracle v. Postgres 9.0 query performance Tony Capobianco (15:40)
Re: Oracle v. Postgres 9.0 query performance Stephen Frost (15:51)
Re: Oracle v. Postgres 9.0 query performance Vitalii Tymchyshyn (15:52)
Re: Oracle v. Postgres 9.0 query performance Tony Capobianco (16:22)
Re: Oracle v. Postgres 9.0 query performance Pavel Stehule (16:27)
Re: Oracle v. Postgres 9.0 query performance Tony Capobianco (16:28)
Re: Oracle v. Postgres 9.0 query performance Tony Capobianco (16:33)
Re: Set of related slow queries John Williams (16:37)
Re: Oracle v. Postgres 9.0 query performance Tom Lane (17:03)
Re: Oracle v. Postgres 9.0 query performance Pavel Stehule (17:17)
Re: Oracle v. Postgres 9.0 query performance Tony Capobianco (19:03)
Re: poor performance when recreating constraints on large tables Robert Haas (19:28)
Re: Oracle v. Postgres 9.0 query performance Kevin Grittner (19:30)
Re: Oracle v. Postgres 9.0 query performance Samuel Gendler (19:38)
Re: poor performance when recreating constraints on large tables Samuel Gendler (19:45)
Re: poor performance when recreating constraints on large tables Kevin Grittner (19:53)
Re: Oracle v. Postgres 9.0 query performance Tony Capobianco (19:55)
Re: poor performance when recreating constraints on large tables Samuel Gendler (19:57)
Re: poor performance when recreating constraints on large tables Claudio Freire (21:57)

2011-06-09

Re: poor performance when recreating constraints on large tables Greg Smith (05:57)
Re: strange query plan with LIMIT anthony.shipman (06:04)
Re: strange query plan with LIMIT anthony.shipman (06:16)
enable database user login/logout information muthu krishnan (07:50)
Re: enable database user login/logout information Alexander Shulgin (07:54)
Postgresql on itanium server muthu krishnan (09:20)
Re: Postgresql on itanium server Jochen Erwied (09:30)
Re: Postgresql on itanium server muthu krishnan (10:03)
Re: Postgresql on itanium server Marti Raudsepp (10:45)
Re: Postgresql on itanium server Jochen Erwied (10:46)
Re: Postgresql on itanium server Jochen Erwied (10:53)
Re: [PERFORM] [PERFORMANCE] expanding to SAN: which portion best to move Willy-Bas Loos (11:43)
Re: poor performance when recreating constraints on large tables Samuel Gendler (11:55)
Triggering autovacuum Reuven M. Lerner (15:24)
Re: Postgresql on itanium server Tom Lane (16:20)
Re: Triggering autovacuum Greg Smith (16:52)
Re: [GENERAL] [PERFORMANCE] expanding to SAN: which portion best to move Greg Smith (17:44)

2011-06-10

Re: Oracle v. Postgres 9.0 query performance Tatsuo Ishii (02:21)
Re: Oracle v. Postgres 9.0 query performance Tom Lane (02:25)
Re: 100% CPU Utilization when we run queries. bakkiya (07:39)
Re: strange query plan with LIMIT anthony.shipman (08:38)
Re: 100% CPU Utilization when we run queries. Marti Raudsepp (09:00)
Re: [GENERAL] [PERFORMANCE] expanding to SAN: which portion best to move Robert Klemme (10:02)
Re: strange query plan with LIMIT tv (11:22)
how much postgres can scale up? Anibal David Acosta (11:29)
Re: how much postgres can scale up? tv (12:10)
[PERFORM] change sample size for statistics Willy-Bas Loos (12:15)
Re: 100% CPU Utilization when we run queries. Craig Ringer (12:37)
Re: how much postgres can scale up? Anibal David Acosta (12:56)
Re: how much postgres can scale up? Craig Ringer (13:01)
Re: how much postgres can scale up? Craig Ringer (13:13)
Re: how much postgres can scale up? Anibal David Acosta (13:19)
Re: how much postgres can scale up? Pierre C (13:52)
Re: how much postgres can scale up? Pierre C (13:57)
Re: strange query plan with LIMIT Claudio Freire (15:22)
Re: how much postgres can scale up? Greg Smith (16:49)
Re: how much postgres can scale up? Anibal David Acosta (18:16)
Re: change sample size for statistics Josh Berkus (19:58)
Re: change sample size for statistics Nathan Boley (20:07)

2011-06-11

Re: Triggering autovacuum Reuven M. Lerner (22:37)

2011-06-12

Re: Triggering autovacuum Scott Marlowe (03:55)
Re: how much postgres can scale up? Benjamin Krajmalnik (15:03)

2011-06-13

Re: [PERFORM] change sample size for statistics Willy-Bas Loos (22:33)

2011-06-14

need to repeat the same condition on joined tables in order to choose the proper plan Svetlin Manavski (13:55)
Re: need to repeat the same condition on joined tables in order to choose the proper plan Tom Lane (16:29)
Re: need to repeat the same condition on joined tables in order to choose the proper plan Robert Klemme (20:21)

2011-06-15

Re: need to repeat the same condition on joined tables in order to choose the proper plan Svetlin Manavski (08:55)

2011-06-16

Re: 100% CPU Utilization when we run queries. bakkiya (04:35)
seq scan in the case of max() on the primary key column Svetlin Manavski (13:55)
Performance advice for a new low(er)-power server Haestan (15:09)
Re: seq scan in the case of max() on the primary key column Jesper Krogh (17:03)
Re: seq scan in the case of max() on the primary key column Magnus Hagander (17:25)
Re: Performance advice for a new low(er)-power server Merlin Moncure (18:19)
Re: Performance advice for a new low(er)-power server Jesper Krogh (18:29)
Re: seq scan in the case of max() on the primary key column Shaun Thomas (18:36)
Re: Performance advice for a new low(er)-power server Greg Smith (18:43)
Re: Performance advice for a new low(er)-power server Scott Marlowe (18:52)
Re: Performance advice for a new low(er)-power server Merlin Moncure (19:04)
generating a large XML document Julius Tuskenis (19:33)
Re: Performance advice for a new low(er)-power server Greg Smith (22:12)
Re: Performance advice for a new low(er)-power server Merlin Moncure (22:44)

2011-06-17

Re: Performance advice for a new low(er)-power server Haestan (08:42)
Re: Performance advice for a new low(er)-power server Haestan (09:13)
Re: Performance advice for a new low(er)-power server jesper (09:30)
Re: seq scan in the case of max() on the primary key column Svetlin Manavski (11:22)
Re: seq scan in the case of max() on the primary key column Shaun Thomas (12:43)
Degrading PostgreSQL 8.4 write performance Kabu Taah (12:48)
Re: Performance advice for a new low(er)-power server Merlin Moncure (13:29)
Re: Degrading PostgreSQL 8.4 write performance Merlin Moncure (14:08)
Re: Degrading PostgreSQL 8.4 write performance Greg Smith (17:54)
Re: seq scan in the case of max() on the primary key column Greg Smith (18:00)
Re: seq scan in the case of max() on the primary key column Jim Nasby (20:31)

2011-06-19

Large rows number, and large objects Jose Ildefonso Camargo Tolosa (04:06)
Re: Large rows number, and large objects Samuel Gendler (11:37)
Re: Large rows number, and large objects Craig James (15:49)
hstore - Implementation and performance issues around its operators Stefan Keller (18:59)
Re: Degrading PostgreSQL 8.4 write performance Pierre C (23:05)

2011-06-20

Re: Large rows number, and large objects Jose Ildefonso Camargo Tolosa (02:19)
Inoptimal query plan for max() and multicolumn index Vladimir Kulev (05:35)
Re: generating a large XML document Julius Tuskenis (06:36)
Re: generating a large XML document Pavel Stehule (06:51)
Re: generating a large XML document Samuel Gendler (07:21)
Re: generating a large XML document Julius Tuskenis (07:29)
Re: generating a large XML document Julius Tuskenis (07:38)
Re: generating a large XML document Pavel Stehule (07:47)
how to know slowly query in lock postgre Didik Prasetyo (07:57)
Re: generating a large XML document Pavel Stehule (07:58)
Re: generating a large XML document Julius Tuskenis (09:03)
Re: how to know slowly query in lock postgre Claudio Freire (09:45)
sequential scan unduly favored over text search gin index Sushant Sinha (15:38)
Re: Inoptimal query plan for max() and multicolumn index Kevin Grittner (15:41)
bad plan: 8.4.8, hashagg, work_mem=1MB. Jon Nelson (15:53)
Re: sequential scan unduly favored over text search gin index Kevin Grittner (15:58)

Prev | Next

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

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