pgsql-performance since 2010-07-06 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)

Browse Archives

Prev | Next

July 6, 2010

Thread Author Time
Re: big data - slow select (speech search) Robert Haas 00:25
Re: Performance issues with postgresql-8.4.0: Query gets stuck sometimes Robert Haas 00:34
Re: SeqScans on boolen values / How to speed this up? Craig Ringer 02:42
Re: SeqScans on boolen values / How to speed this up? Scott Marlowe 03:19
Re: Slow query with planner row strange estimation damien hostin 12:48
Re: Extremely high CPU usage when building tables Deborah Fuentes 15:59
Re: Question about partitioned query behavior Ranga Gopalan 16:30
Re: Extremely high CPU usage when building tables Kevin Grittner 17:43
Re: Highly Efficient Custom Sorting Robert Haas 19:01
Re: Two "equivalent" WITH RECURSIVE queries, one of them slow. Robert Haas 19:21
Re: Question about partitioned query behavior Robert Haas 19:30
Re: Highly Efficient Custom Sorting Eliot Gable 19:42
Re: Highly Efficient Custom Sorting Joe Conway 20:00
Re: Highly Efficient Custom Sorting Eliot Gable 20:17
Re: Question about partitioned query behavior Stephen Frost 20:26
Re: Question about partitioned query behavior Ranga Gopalan 21:02
Re: Highly Efficient Custom Sorting Eliot Gable 21:53
Re: Highly Efficient Custom Sorting Tom Lane 22:21

July 7, 2010

Thread Author Time
Re: using dbt2 postgresql 8.4 - rampup time issue Mark Wong 00:35
WAL partition overloaded--by autovacuum? Richard Yen 01:10
Re: WAL partition overloaded--by autovacuum? Scott Marlowe 03:25
Re: WAL partition overloaded--by autovacuum? Scott Marlowe 03:27
Re: WAL partition overloaded--by autovacuum? Scott Marlowe 04:13
Invitation to connect on LinkedIn Gourish Singbal 06:33
Two different execution plan for the same request 📎 JOUANIN Nicolas (44) 07:55
Re: Two different execution plan for the same request Yeb Havinga 08:27
Re: Two different execution plan for the same request 📎 JOUANIN Nicolas (44) 08:47
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Mark Kirkwood 08:58
Re: Two different execution plan for the same request Yeb Havinga 08:59
Re: Two different execution plan for the same request Guillaume Smet 08:59
Re: Two different execution plan for the same request 📎 JOUANIN Nicolas (44) 11:27
Re: WAL partition overloaded--by autovacuum? Kevin Grittner 11:58
Re: Two different execution plan for the same request Matthew Wakeling 12:34
Re: Two "equivalent" WITH RECURSIVE queries, one of them slow. Merlin Moncure 13:14
Re: big data - slow select (speech search) Michal Fapso 13:31
Re: Slow query with planner row strange estimation damien hostin 14:39
Re: Weird XFS WAL problem 📎 Bruce Momjian 14:42
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen 16:39
Re: Highly Efficient Custom Sorting Eliot Gable 19:23
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen 19:32
Re: Highly Efficient Custom Sorting Kenneth Marshall 19:42
Re: big data - slow select (speech search) Robert Haas 20:49
Logarithmic data frequency distributions and the query planner Jerry Gamache 20:54
Re: Logarithmic data frequency distributions and the query planner Tom Lane 21:22
performance on new linux box Ryan Wexler 23:06

July 8, 2010

Thread Author Time
Re: performance on new linux box Tom Lane 00:39
Re: performance on new linux box Rob Wultsch 00:39
Re: performance on new linux box Andy Colson 02:07
Re: performance on new linux box Pierre C 08:56
Re: performance on new linux box Eliot Gable 13:45
Re: performance on new linux box Kevin Grittner 13:53
Re: performance on new linux box Eliot Gable 14:38
Re: performance on new linux box Kevin Grittner 15:02
Re: performance on new linux box Ryan Wexler 16:31
Re: performance on new linux box Joshua D. Drake 17:04
Re: performance on new linux boxeradmin(11983)i: STATEMENT: update license set expires= '2010-06-15' where lic John Rouillard 17:05
Re: performance on new linux box Craig James 17:10
Fwd: performance on new linux box Ryan Wexler 17:16
Re: Slow query with planner row strange estimation Robert Haas 18:42
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Robert Haas 18:51
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Kevin Grittner 19:04
Re: performance on new linux box Jochen Erwied 19:13
Re: performance on new linux box Ryan Wexler 19:18
Need help in performance tuning. Harpreet singh Wadhwa 19:20
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen 19:25
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Tom Lane 19:27
Re: performance on new linux box Kevin Grittner 19:28
Re: performance on new linux box Jochen Erwied 19:32
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen 19:34
Re: performance on new linux box Ryan Wexler 19:37
Re: performance on new linux box Ben Chobot 19:40
Re: performance on new linux box Kevin Grittner 19:46
Re: performance on new linux box Ryan Wexler 19:47
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Kevin Grittner 19:50
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Tom Lane 19:50
Re: performance on new linux box David Boreham 19:50
Re: performance on new linux box Kevin Grittner 19:59
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen 20:06
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Richard Yen 20:06
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Kevin Grittner 20:14
Re: Need help in performance tuning. Kevin Grittner 20:22
Re: performance on new linux box Craig James 21:01
Re: performance on new linux box Ryan Wexler 21:02
Re: performance on new linux box Timothy.Noonan 21:18
Re: performance on new linux box Jochen Erwied 21:39
Re: performance on new linux box Craig James 21:42
Re: performance on new linux box David Boreham 21:43

July 9, 2010

Thread Author Time
Re: Need help in performance tuning. Craig Ringer 03:11
Re: Need help in performance tuning. Samuel Gendler 04:19
Re: Need help in performance tuning. Tom Lane 04:42
Re: Need help in performance tuning. Hannu Krosing 05:48
Re: Need help in performance tuning. Craig Ringer 07:52
Re: Need help in performance tuning. Harpreet singh Wadhwa 08:55
Re: performance on new linux box Russell Smith 09:08
Re: Need help in performance tuning. Harpreet singh Wadhwa 09:31
Re: performance on new linux box Samuel Gendler 09:38
Queries about PostgreSQL PITR Jayadevan M 09:47
Re: Need help in performance tuning. Craig Ringer 09:53
Re: Slow query with planner row strange estimation damien hostin 10:13
Re: Need help in performance tuning. Brad Nicholson 12:56
Re: Need help in performance tuning. Kevin Grittner 15:09
Re: Need help in performance tuning. Matthew Wakeling 15:30
Re: Need help in performance tuning. Kevin Grittner 15:49
Re: Need help in performance tuning. Jorge Montero 16:44
Re: Need help in performance tuning. Matthew Wakeling 17:03
Re: Need help in performance tuning. Kevin Grittner 17:52
Re: Need help in performance tuning. Jorge Montero 19:27
Re: Need help in performance tuning. Kevin Grittner 19:31
Re: Slow query with planner row strange estimation Robert Haas 20:25
Re: Need help in performance tuning. Robert Haas 20:35
Index usage with functions in where condition Jeremy Palmer 22:36
Re: Need help in performance tuning. Greg Smith 22:59
Re: Index usage with functions in where condition Tom Lane 23:19
Re: [Slony1-general] WAL partition overloaded--by autovacuum? Greg Smith 23:23

July 10, 2010

Thread Author Time
Re: Index usage with functions in where condition Jeremy Palmer 00:25
Re: Need help in performance tuning. Kevin Grittner 00:31
Re: Need help in performance tuning. Mark Kirkwood 01:01
Re: Pooling in Core WAS: Need help in performance tuning. Josh Berkus 01:25
Re: Pooling in Core WAS: Need help in performance tuning. Samuel Gendler 03:29
Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer 03:33
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas 03:47
Re: Need help in performance tuning. Jesper Krogh 06:33
Re: Need help in performance tuning. Greg Smith 12:30
Re: Pooling in Core WAS: Need help in performance tuning. Josh Berkus 18:42
Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane 18:51

July 11, 2010

Thread Author Time
Re: performance on new linux box Ryan Wexler 20:02
Re: Need help in performance tuning. Pierre C 22:47

July 12, 2010

Thread Author Time
Re: Queries about PostgreSQL PITR Fujii Masao 06:25
Re: Slow query with planner row strange estimation Dimitri 07:17
Re: Queries about PostgreSQL PITR Jayadevan M 08:29
[Fwd: Re: Slow query with planner row strange estimation] damien hostin 09:03
Re: [Fwd: Re: Slow query with planner row strange estimation] damien hostin 09:04
Re: Pooling in Core WAS: Need help in performance tuning. Matthew Wakeling 09:45
Re: Queries about PostgreSQL PITR Fujii Masao 10:05
Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer 10:58
now() gives same time within the session Atul.Goel 11:00
Re: now() gives same time within the session A. Kretschmer 11:15
PostgreSQL PITR - more doubts Jayadevan M 11:23
Re: PostgreSQL PITR - more doubts Jesper Krogh 11:38
Re: PostgreSQL PITR - more doubts Jayadevan M 12:04
Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing 12:22
Re: now() gives same time within the session Atul.Goel 12:23
Re: PostgreSQL PITR - more doubts Kevin Grittner 12:28
Re: Pooling in Core WAS: Need help in performance tuning. Kevin Grittner 12:41
Re: now() gives same time within the session Rob Wultsch 13:11
Re: now() gives same time within the session Thom Brown 13:23
Re: now() gives same time within the session A. Kretschmer 13:24
Re: now() gives same time within the session Kenneth Marshall 13:26
Exists, limit and alternate plans Віталій Тимчишин 13:29
Re: Exists, limit and alternate plans Tom Lane 14:45
Re: performance on new linux box Greg Smith 15:23
Re: Need help in performance tuning. Bruce Momjian 16:04
Re: Slow query with planner row strange estimation phb07 20:33

July 13, 2010

Thread Author Time
Re: partition queries hitting all partitions even though check key is specified Josh Berkus 03:01
Re: partition queries hitting all partitions even though check key is specified Joshua D. Drake 04:00
Who are you voting for? 📎 kangayarkanni 05:52
Re: Slow query with planner row strange estimation damien hostin 08:51
Queries with conditions using bitand operator Elias Ghanem 11:48
Re: Pooling in Core WAS: Need help in performance tuning. Dimitri Fontaine 14:42
Re: Pooling in Core WAS: Need help in performance tuning. Magnus Hagander 14:44
Re: Queries with conditions using bitand operator Andy Colson 23:19
Re: performance on new linux box Andy Colson 23:26

July 14, 2010

Thread Author Time
Re: Queries with conditions using bitand operator Joe Conway 01:07
Re: Need help in performance tuning. Scott Marlowe 06:44
Understanding tsearch2 performance Ivan Voras 11:47
Re: Understanding tsearch2 performance Oleg Bartunov 12:31
Re: Understanding tsearch2 performance Ivan Voras 12:55
Re: Understanding tsearch2 performance Oleg Bartunov 13:25
Re: Understanding tsearch2 performance Ivan Voras 13:37
Re: Understanding tsearch2 performance Stephen Frost 13:49
Re: Understanding tsearch2 performance Ivan Voras 13:57
Re: Need help in performance tuning. Kevin Grittner 13:58
Re: Understanding tsearch2 performance Kevin Grittner 14:03
Re: Understanding tsearch2 performance Ivan Voras 14:21
Re: Understanding tsearch2 performance Oleg Bartunov 14:36
Re: Queries with conditions using bitand operator valgog 14:49
Re: Need help in performance tuning. Hannu Krosing 14:54
Re: Understanding tsearch2 performance Kevin Grittner 15:16
Re: Understanding tsearch2 performance Ivan Voras 20:25

July 15, 2010

Thread Author Time
Re: performance on new linux box Scott Carey 01:57
Re: performance on new linux box Ben Chobot 02:50
Query optimization problem Zotov 06:12
Re: performance on new linux box Ryan Wexler 06:18
Re: Query optimization problem Yeb Havinga 07:58
Identical query slower on 8.4 vs 8.3 Patrick Donlin 14:41
Re: Identical query slower on 8.4 vs 8.3 Thom Brown 14:50
Re: Identical query slower on 8.4 vs 8.3 Kevin Grittner 14:55
Re: Identical query slower on 8.4 vs 8.3 Patrick Donlin 15:12
Re: Identical query slower on 8.4 vs 8.3 Alvaro Herrera 15:21
Re: Identical query slower on 8.4 vs 8.3 Andy Colson 15:31
Re: Identical query slower on 8.4 vs 8.3 Jon Nelson 15:34
Re: Identical query slower on 8.4 vs 8.3 Kevin Grittner 15:53
Re: Identical query slower on 8.4 vs 8.3 Merlin Moncure 16:04
Re: performance on new linux box Scott Carey 16:30
Re: Identical query slower on 8.4 vs 8.3 Joshua D. Drake 17:17
Question of using COPY on a table with triggers Benjamin Krajmalnik 17:27
Re: Identical query slower on 8.4 vs 8.3 Patrick Donlin 18:48
Re: performance on new linux box Ben Chobot 19:35
Re: performance on new linux box Ben Chobot 19:49
Re: performance on new linux box Ryan Wexler 21:40

Browse Archives

Prev | Next