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 - December 2012

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

2012-12-02

Re: Optimize update query Vitalii Tymchyshyn (11:14)
Re: Optimize update query Mark Kirkwood (23:34)

2012-12-03

Re: Optimize update query Niels Kristian Schjødt (09:37)

2012-12-04

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)

2012-12-05

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)

2012-12-06

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)

2012-12-07

How do I track stats on foreign table access through foreign data wrapper? David Crawford (22:09)

2012-12-08

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)

2012-12-10

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)

2012-12-11

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)

2012-12-12

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)

2012-12-13

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)

2012-12-14

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)

2012-12-15

Re: Do I have a hardware or a software problem? Scott Marlowe (00:22)

2012-12-17

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)

2012-12-18

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

2012-12-19

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)

2012-12-20

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)

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

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