pgsql-performance since 2010-07-02 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 2, 2010

Thread Author Time
Highly Efficient Custom Sorting Eliot Gable 00:46
Re: No hash join across partitioned tables? Bruce Momjian 03:00
Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer Craig Ringer 03:00
Re: Highly Efficient Custom Sorting Craig Ringer 03:04
Re: No hash join across partitioned tables? Tom Lane 04:05
Re: Highly Efficient Custom Sorting Tom Lane 04:08
Re: big data - slow select (speech search) Michal Fapso 05:23
Performance issues with postgresql-8.4.0: Query gets stuck sometimes Sachin Kumar 05:40
Re: Performance issues with postgresql-8.4.0: Query gets stuck sometimes Scott Marlowe 05:50
Slow query with planner row strange estimation damien hostin 08:48
Re: Highly Efficient Custom Sorting Merlin Moncure 13:59
Re: Highly Efficient Custom Sorting Eliot Gable 13:59
using dbt2 postgresql 8.4 - rampup time issue MUHAMMAD ASIF 14:38
Re: Highly Efficient Custom Sorting Matthew Wakeling 14:50
Re: Highly Efficient Custom Sorting Merlin Moncure 14:56
Question about partitioned query behavior Ranga Gopalan 15:28
Re: Highly Efficient Custom Sorting Craig James 16:36
Re: Question about partitioned query behavior Benjamin Krajmalnik 16:40
Re: Low perfomance SUM and Group by large databse Robert Haas 17:21
Re: Extremely high CPU usage when building tables Deborah Fuentes 19:07
Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer Rajesh Kumar Mallah 19:22
Re: Extremely high CPU usage when building tables Rajesh Kumar Mallah 19:53
Re: No hash join across partitioned tables? Bruce Momjian 20:53
Re: No hash join across partitioned tables? Tom Lane 20:58
Re: No hash join across partitioned tables? Robert Haas 21:10
Re: No hash join across partitioned tables? Bruce Momjian 21:12
Re: using dbt2 postgresql 8.4 - rampup time issue Mark Wong 23:56

July 3, 2010

Thread Author Time
Re: Highly Efficient Custom Sorting Craig Ringer 01:44
Re: Highly Efficient Custom Sorting Eliot Gable 03:17
Re: Highly Efficient Custom Sorting Merlin Moncure 18:08
Re: Highly Efficient Custom Sorting Eliot Gable 20:17
Re: Highly Efficient Custom Sorting Merlin Moncure 22:53

July 4, 2010

Thread Author Time
Re: Highly Efficient Custom Sorting Alvaro Herrera 02:47
Re: Performance issues with postgresql-8.4.0 Craig Ringer 12:38

July 5, 2010

Thread Author Time
Two "equivalent" WITH RECURSIVE queries, one of them slow. Octavio Alvarez 06:07
Re: Slow query with planner row strange estimation damien hostin 07:28
Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer Matthew Wakeling 09:55
SeqScans on boolen values / How to speed this up? Jens Hoffrichter 11:36
Re: SeqScans on boolen values / How to speed this up? Stephen Frost 13:47
Re: using dbt2 postgresql 8.4 - rampup time issue MUHAMMAD ASIF 17:24

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

Browse Archives

Prev | Next