pgsql-performance - December 2012

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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 2 3 4 5 6 7 8 10 11 12 13 14 15 17 18 19 20 21 22 23 24 27 28 29 30 31

Dec. 2, 2012

Thread Author Time
Re: Optimize update query Vitalii Tymchyshyn 11:14
Re: Optimize update query Mark Kirkwood 23:34

Dec. 3, 2012

Thread Author Time
Re: Optimize update query Niels Kristian Schjødt 09:37

Dec. 4, 2012

Thread Author Time
Slow query: bitmap scan troubles postgresql 15:06
Re: Slow query: bitmap scan troubles postgresql 15:21
Re: Slow query: bitmap scan troubles Claudio Freire 15:27
Re: Comparative tps question John Lister 16:30
Re: Slow query: bitmap scan troubles Jeff Janes 17:22
Re: Slow query: bitmap scan troubles Claudio Freire 17:25
Re: Slow query: bitmap scan troubles Philip Scott 17:35
Re: Slow query: bitmap scan troubles postgresql 17:47
Re: Slow query: bitmap scan troubles postgresql 18:03
Re: Slow query: bitmap scan troubles Philip Scott 18:31
Re: Slow query: bitmap scan troubles Claudio Freire 18:31
Re: Slow query: bitmap scan troubles Claudio Freire 18:32
Re: Slow query: bitmap scan troubles Vitalii Tymchyshyn 18:50
Re: Slow query: bitmap scan troubles postgresql 18:54
Re: Slow query: bitmap scan troubles Philip Scott 18:55
Re: Slow query: bitmap scan troubles postgresql 18:56
Re: Slow query: bitmap scan troubles Kevin Grittner 19:09
Re: Slow query: bitmap scan troubles Sergey Konoplev 20:11
Re: Slow query: bitmap scan troubles Jeff Janes 22:34
Re: Slow query: bitmap scan troubles Jeff Janes 23:42

Dec. 5, 2012

Thread Author Time
CREATING INDEX on column having null values suhas.basavaraj12 08:10
Re: CREATING INDEX on column having null values Willem Leenen 08:47
Why is PostgreSQL 9.2 slower than 9.1 in my tests? Patryk Sidzina 12:09
xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Andrea Suisani 15:34
Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Jean-David Beyer 16:51
Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Claudio Freire 16:56
Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Andrew Dunstan 17:00
Re: Slow query: bitmap scan troubles Jeff Janes 17:39
Re: Slow query: bitmap scan troubles Claudio Freire 17:43
Re: Slow query: bitmap scan troubles Tom Lane 18:05
Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Shaun Thomas 18:28
Any idea on how to improve the statistics estimates for this plan? Guillaume Smet 19:39
Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Niels Kristian Schjødt 21:45
Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Daniel Farina 22:19
Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Shaun Thomas 22:25
Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Bruce Momjian 22:41
Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Shaun Thomas 23:04

Dec. 6, 2012

Thread Author Time
Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Scott Marlowe 00:54
Perform scan on Toast table classical_89 03:08
Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance Stuart Bishop 07:51
Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] John Lister 08:29
Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance John Lister 08:29
Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Andrea Suisani 08:44
Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Andrea Suisani 09:33
Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] John Lister 11:37
Re: Slow query: bitmap scan troubles postgresql 12:52
Re: Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance] Andrea Suisani 12:53
Re: Slow query: bitmap scan troubles postgresql 12:56
Re: Slow query: bitmap scan troubles postgresql 14:10
Re: Slow query: bitmap scan troubles Jeff Janes 17:27
Re: Slow query: bitmap scan troubles Claudio Freire 20:05
Re: Slow query: bitmap scan troubles Jeff Janes 21:09

Dec. 7, 2012

Thread Author Time
How do I track stats on foreign table access through foreign data wrapper? David Crawford 22:09

Dec. 8, 2012

Thread Author Time
Re: Any idea on how to improve the statistics estimates for this plan? Jeff Janes 02:32
Re: Any idea on how to improve the statistics estimates for this plan? Tom Lane 04:16
Re: Any idea on how to improve the statistics estimates for this plan? Guillaume Smet 14:51
Re: Slow query: bitmap scan troubles Guillaume Lelarge 15:15
Re: Any idea on how to improve the statistics estimates for this plan? Jeff Janes 19:03

Dec. 10, 2012

Thread Author Time
Re: Why is PostgreSQL 9.2 slower than 9.1 in my tests? Jeff Janes 03:53
Re: Perform scan on Toast table Albe Laurenz 08:57
Re: Slow query: bitmap scan troubles postgresql 09:52
Do I have a hardware or a software problem? Niels Kristian Schjødt 22:51
Re: Do I have a hardware or a software problem? Evgeny Shishkin 23:00
Re: Do I have a hardware or a software problem? Jeff Janes 23:58

Dec. 11, 2012

Thread Author Time
Re: Do I have a hardware or a software problem? Niels Kristian Schjødt 10:04
Re: Why is PostgreSQL 9.2 slower than 9.1 in my tests? Patryk Sidzina 10:50
Re: Do I have a hardware or a software problem? Craig Ringer 13:29
Re: Do I have a hardware or a software problem? Niels Kristian Schjødt 13:35
Re: Do I have a hardware or a software problem? Evgeny Shishkin 17:15
Re: Do I have a hardware or a software problem? Jeff Janes 17:25
Re: Do I have a hardware or a software problem? Niels Kristian Schjødt 18:54
Re: Do I have a hardware or a software problem? Evgeny Shishkin 19:11
Occasional timeouts on TRUNCATE and simple INSERTs Osborn, Jeff 21:19
Re: Occasional timeouts on TRUNCATE and simple INSERTs Sergey Konoplev 21:38
Re: Occasional timeouts on TRUNCATE and simple INSERTs Merlin Moncure 22:16
Re: Occasional timeouts on TRUNCATE and simple INSERTs Osborn, Jeff 22:34
Re: Do I have a hardware or a software problem? Niels Kristian Schjødt 22:41
Re: Do I have a hardware or a software problem? Evgeny Shishkin 22:44
Re: Why is PostgreSQL 9.2 slower than 9.1 in my tests? Jeff Janes 23:53

Dec. 12, 2012

Thread Author Time
Re: Why is PostgreSQL 9.2 slower than 9.1 in my tests? Tom Lane 00:38
Re: Do I have a hardware or a software problem? Craig Ringer 01:03
Re: Do I have a hardware or a software problem? Evgeny Shishkin 01:17
Re: Do I have a hardware or a software problem? Craig Ringer 01:29
Re: Do I have a hardware or a software problem? Evgeny Shishkin 01:44
Re: Do I have a hardware or a software problem? Rosser Schwarz 01:47
Re: Do I have a hardware or a software problem? Craig Ringer 02:02
Re: Do I have a hardware or a software problem? Evgeny Shishkin 02:13
Re: Do I have a hardware or a software problem? David Boreham 02:15
Re: Do I have a hardware or a software problem? Evgeny Shishkin 02:20
Re: Do I have a hardware or a software problem? David Boreham 02:26
Re: Do I have a hardware or a software problem? Evgeny Shishkin 02:38
Re: Do I have a hardware or a software problem? David Boreham 02:41
Re: Do I have a hardware or a software problem? Craig Ringer 02:47
Re: Do I have a hardware or a software problem? Evgeny Shishkin 02:49
Re: Do I have a hardware or a software problem? David Boreham 03:05
Re: Do I have a hardware or a software problem? Mark Kirkwood 03:07
Re: Do I have a hardware or a software problem? Evgeny Shishkin 03:11
Re: Do I have a hardware or a software problem? David Boreham 03:19
hash join vs nested loop join Huan Ruan 04:25
Re: hash join vs nested loop join Evgeny Shishkin 04:33
Re: hash join vs nested loop join Evgeny Shishkin 04:59
Re: Do I have a hardware or a software problem? Niels Kristian Schjødt 16:22
Read rows deleted Alejandro Carrillo 16:26
Re: hash join vs nested loop join Jeff Janes 16:28
Re: Do I have a hardware or a software problem? Niels Kristian Schjødt 16:46
Re: Savepoints in transactions for speed? Jeff Janes 17:01
track_activity_query_size Andrew Dunstan 20:02
Re: Read rows deleted Sergey Konoplev 20:13
Re: Read rows deleted Alejandro Carrillo 20:24
Re: Read rows deleted Andrew Dunstan 20:30
encouraging index-only scans Andrew Dunstan 21:06
Re: encouraging index-only scans Tom Lane 21:32
Re: encouraging index-only scans Andrew Dunstan 22:12
Re: encouraging index-only scans Andrew Dunstan 22:27
Re: Do I have a hardware or a software problem? Craig Ringer 23:26
Re: hash join vs nested loop join Kevin Grittner 23:47

Dec. 13, 2012

Thread Author Time
Re: hash join vs nested loop join Huan Ruan 00:56
Re: hash join vs nested loop join Huan Ruan 01:10
Re: [PERFORM] encouraging index-only scans Bruce Momjian 02:48
Re: [PERFORM] encouraging index-only scans Tom Lane 03:51
Limit & offset effect on query plans Amitabh Kant 04:08
Re: Limit & offset effect on query plans Pavan Deolasee 04:43
Re: [PERFORM] encouraging index-only scans Pavan Deolasee 04:48
Memory issue for inheritance tables. Hari Babu 04:52
Re: [PERFORM] encouraging index-only scans Simon Riggs 09:40
Re: [PERFORM] encouraging index-only scans Bruce Momjian 13:46
Re: Do I have a hardware or a software problem? Jeff Janes 15:10
Re: hash join vs nested loop join Kevin Grittner 15:26
Re: [PERFORM] encouraging index-only scans Peter Geoghegan 15:31
problem with large inserts Lutz Fischer 15:37
Re: Limit & offset effect on query plans Kevin Grittner 15:47
Re: problem with large inserts Willem Leenen 15:49
Re: problem with large inserts Filip Rembiałkowski 16:09
Re: problem with large inserts Tom Lane 16:10
Re: Limit & offset effect on query plans Tom Lane 16:20
Re: problem with large inserts Lutz Fischer 16:33
Re: problem with large inserts Filip Rembiałkowski 16:44
Re: Limit & offset effect on query plans Kevin Grittner 17:07
Slow queries after vacuum analyze Ghislain ROUVIGNAC 17:10
Re: Limit & offset effect on query plans Tom Lane 17:12
Re: Limit & offset effect on query plans Kevin Grittner 18:14
Re: Slow queries after vacuum analyze Kevin Grittner 20:42
Re: Occasional timeouts on TRUNCATE and simple INSERTs Osborn, Jeff 20:57
Why does the number of rows are different in actual and estimated. AI Rumman 22:12
Re: Why does the number of rows are different in actual and estimated. Andrew Dunstan 22:36
Re: Why does the number of rows are different in actual and estimated. Evgeny Shishkin 22:40
Re: Why does the number of rows are different in actual and estimated. Claudio Freire 22:42
Re: Why does the number of rows are different in actual and estimated. Andrew Dunstan 23:09
Re: Why does the number of rows are different in actual and estimated. Evgeny Shishkin 23:13
Re: Why does the number of rows are different in actual and estimated. Tom Lane 23:36
Re: Why does the number of rows are different in actual and estimated. Evgeny Shishkin 23:50
Re: hash join vs nested loop join Huan Ruan 23:51

Dec. 14, 2012

Thread Author Time
Re: Why does the number of rows are different in actual and estimated. Claudio Freire 00:38
Re: hash join vs nested loop join Kevin Grittner 00:54
Re: hash join vs nested loop join Huan Ruan 04:46
Re: hash join vs nested loop join Kevin Grittner 13:48
backend suddenly becomes slow, then remains slow Andrew Dunstan 18:40
Re: Why does the number of rows are different in actual and estimated. AI Rumman 19:01
Re: Why does the number of rows are different in actual and estimated. Claudio Freire 19:12
Re: Why does the number of rows are different in actual and estimated. Kevin Grittner 19:14
Re: Why does the number of rows are different in actual and estimated. Tom Lane 19:22
Re: Why does the number of rows are different in actual and estimated. AI Rumman 19:28
Re: backend suddenly becomes slow, then remains slow Tom Lane 19:56
Re: Why does the number of rows are different in actual and estimated. Claudio Freire 20:10
Re: backend suddenly becomes slow, then remains slow Andrew Dunstan 20:16
Re: Why does the number of rows are different in actual and estimated. AI Rumman 20:25
Re: Why does the number of rows are different in actual and estimated. Claudio Freire 20:32
Re: Why does the number of rows are different in actual and estimated. Kevin Grittner 20:34
Re: Why does the number of rows are different in actual and estimated. AI Rumman 22:12
Re: Why does the number of rows are different in actual and estimated. Kevin Grittner 22:47

Dec. 15, 2012

Thread Author Time
Re: Do I have a hardware or a software problem? Scott Marlowe 00:22

Dec. 17, 2012

Thread Author Time
Re: How can i find out top high load sql queries in PostgreSQL. suhas.basavaraj12 09:21
Re: How can i find out top high load sql queries in PostgreSQL. Vibhor Kumar 16:33

Dec. 18, 2012

Thread Author Time
Re: [PERFORM] Slow query: bitmap scan troubles Jeff Janes 06:00
Re: Slow queries after vacuum analyze Kevin Grittner 20:09

Dec. 19, 2012

Thread Author Time
Re: [PERFORM] Slow query: bitmap scan troubles Jeff Janes 01:05
Re: hash join vs nested loop join Huan Ruan 01:55
Re: hash join vs nested loop join Kevin Grittner 13:16
Re: [PERFORM] Slow query: bitmap scan troubles Jeff Janes 14:40
Re: How can i find out top high load sql queries in PostgreSQL. Igor Neyman 19:13
PG 9.1 performance loss due to query plan being changed depending on db data (4s vs 200ms) Rodrigo Rosenfeld Rosas 19:35
Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill 21:13
Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Sergey Konoplev 22:59
Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill 23:49

Dec. 20, 2012

Thread Author Time
Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Sergey Konoplev 00:08
Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill 00:22
Re: hash join vs nested loop join Huan Ruan 01:02
Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Tom Lane 03:06
Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Jeff Janes 05:12
Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill 05:51
Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Richard Neill 05:57
Re: hash join vs nested loop join Kevin Grittner 14:06
Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Tom Lane 15:43
Re: Why does the query planner use two full indexes, when a dedicated partial index exists? Tom Lane 15:49
Performance on Bulk Insert to Partitioned Table Charles Gomes 17:29
Re: Performance on Bulk Insert to Partitioned Table Scott Marlowe 17:39
Re: Performance on Bulk Insert to Partitioned Table Charles Gomes 18:55

Browse Archives

Prev | Next
Jump to day: 2 3 4 5 6 7 8 10 11 12 13 14 15 17 18 19 20 21 22 23 24 27 28 29 30 31