pgsql-performance since 2012-12-04 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)
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. 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
Re: Performance on Bulk Insert to Partitioned Table Stephen Frost 20:02
Re: Performance on Bulk Insert to Partitioned Table Charles Gomes 20:08
Re: hash join vs nested loop join Huan Ruan 21:16

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