Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2010-10 Chronological Index (1/4)
Last updated: Wed Jan 18 04:13:11 2012
606 messages
31 October 2010
Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Greg Smith (19:59)
Defaulting wal_sync_method to fdatasync on Linux for 9.1? Marti Raudsepp (12:14)
29 October 2010
Re: Slow Query- Bad Row Estimate Tom Lane (22:03)
Re: Slow Query- Bad Row Estimate Ozer, Pam (21:56)
Re: Slow Query- Bad Row Estimate Josh Berkus (21:55)
Re: Slow Query- Bad Row Estimate Tom Lane (21:50)
Re: Slow Query- Bad Row Estimate Ozer, Pam (21:48)
Re: Slow Query- Bad Row Estimate Ozer, Pam (21:46)
Re: Slow Query- Bad Row Estimate Kevin Grittner (21:40)
Re: Slow Query- Bad Row Estimate Tom Lane (21:17)
Re: BBU Cache vs. spindles david (21:14)
Re: Slow Query- Bad Row Estimate Josh Berkus (21:09)
Slow Query- Bad Row Estimate Ozer, Pam (20:54)
Re: BBU Cache vs. spindles James Mansion (20:52)
Re: MVCC and Implications for (Near) Real-Time Application Pierre C (20:34)
Re: BBU Cache vs. spindles david (19:09)
Re: typoed column name, but postgres didn't grump Tom Lane (19:07)
Re: BBU Cache vs. spindles Alvaro Herrera (18:49)
Re: typoed column name, but postgres didn't grump Kevin Grittner (18:39)
Re: temporary tables, indexes, and query plans Robert Haas (18:16)
Re: typoed column name, but postgres didn't grump Tom Lane (17:48)
Re: MVCC and Implications for (Near) Real-Time Application Kevin Grittner (17:18)
Re: MVCC and Implications for (Near) Real-Time Application A.M. (17:05)
typoed column name, but postgres didn't grump Jon Nelson (16:45)
Re: BBU Cache vs. spindles Robert Haas (16:44)
Re: partitioning question 1 Igor Neyman (16:28)
Re: partitioning question 1 Ben (16:16)
Re: BBU Cache vs. spindles Tom Lane (15:57)
Re: BBU Cache vs. spindles Aidan Van Dyk (15:56)
Re: BBU Cache vs. spindles Robert Haas (15:44)
Re: partitioning question 1 Igor Neyman (14:38)
28 October 2010
Re: Massive update, memory usage Trenta sis (21:48)
Re: BBU Cache vs. spindles Tom Lane (21:26)
Re: partitioning question 1 Ben (21:07)
Re: partitioning question 1 Joshua D. Drake (20:48)
Re: BBU Cache vs. spindles James Mansion (20:33)
Re: partitioning question 1 Reid Thompson (20:08)
Re: partitioning question 1 Ben (20:00)
Re: partitioning question 1 Joshua D. Drake (19:44)
Re: partitioning question 1 Ben (19:25)
Re: partitioning question 1 Joshua D. Drake (18:50)
Re: partitioning question 1 Ben (18:44)
Re: how to get the total number of records in report Merlin Moncure (18:18)
Re: how to get the total number of records in report AI Rumman (17:49)
Re: how to get the total number of records in report Merlin Moncure (17:40)
Re: partitioning question 1 Joshua D. Drake (17:31)
Re: how to get the total number of records in report Robert Haas (17:05)
partitioning question 1 Ben (16:37)
Re: Query much faster with enable_seqscan=0 Robert Haas (16:21)
Re: Slow Query- Simple taking Robert Haas (16:18)
Re: Massive update, memory usage Cédric Villemain (15:38)
Re: How does PG know if data is in memory? Cédric Villemain (15:31)
Re: Postgres insert performance and storage requirement compared to Oracle Jesper Krogh (15:29)
Re: Slow Query- Simple taking Mladen Gogala (15:23)
Re: Slow Query- Simple taking Richard Broersma (14:53)
Re: Slow Query- Simple taking Mladen Gogala (14:51)
Re: Slow Query- Simple taking Robert Haas (14:42)
Re: Slow Query- Simple taking Robert Haas (14:40)
Re: Slow Query- Simple taking Robert Haas (14:39)
Re: temporary tables, indexes, and query plans Tom Lane (14:23)
Re: temporary tables, indexes, and query plans Jon Nelson (14:08)
Re: Select count(*), the sequel Kenneth Marshall (13:34)
Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure (13:13)
Re: AIX slow buffer reads André Volpato (12:33)
Re: Select count(*), the sequel Pierre C (09:33)
Massive update, memory usage Trenta sis (08:16)
Re: Postgres insert performance and storage requirement compared to Oracle Pavel Stehule (04:26)
Re: Postgres insert performance and storage requirement compared to Oracle Alex Hunsaker (04:24)
Re: BBU Cache vs. spindles Rob Wultsch (03:44)
Re: Re: Postgres insert performance and storage requirement compared to Oracle Tom Lane (03:32)
Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh (03:09)
Re: How does PG know if data is in memory? Francisco Reyes (02:30)
Re: Re: Postgres insert performance and storage requirement compared to Oracle Robert Haas (02:01)
Re: BBU Cache vs. spindles Robert Haas (01:55)
27 October 2010
Re: AIX slow buffer reads Tom Lane (22:45)
Re: AIX slow buffer reads Brad Nicholson (22:37)
Re: temporary tables, indexes, and query plans Tom Lane (22:36)
Re: temporary tables, indexes, and query plans Jon Nelson (22:03)
Re: Select count(*), the sequel Tom Lane (21:49)
Re: temporary tables, indexes, and query plans Tom Lane (21:46)
Re: AIX slow buffer reads André Volpato (20:57)
Re: Select count(*), the sequel Thomas Kellerer (20:54)
Re: Select count(*), the sequel Kenneth Marshall (20:41)
Re: temporary tables, indexes, and query plans Jon Nelson (20:36)
Re: Select count(*), the sequel Kevin Grittner (20:11)
Re: AIX slow buffer reads Tom Lane (20:10)
Re: CPUs for new databases Greg Smith (19:59)
Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Tom Lane (19:56)
Re: Select count(*), the sequel Pierre C (19:53)
Re: temporary tables, indexes, and query plans Justin Pitts (19:51)
Re: Postgres insert performance and storage requirement compared to Oracle Jesper Krogh (19:47)
Re: Postgres insert performance and storage requirement compared to Oracle Alex Hunsaker (19:45)
Re: temporary tables, indexes, and query plans Tom Lane (19:43)
Re: temporary tables, indexes, and query plans Jon Nelson (19:29)
Re: AIX slow buffer reads Greg Smith (19:24)
Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Scott Carey (19:24)
Re: temporary tables, indexes, and query plans Justin Pitts (19:23)
Re: CPUs for new databases Scott Marlowe (19:17)
Re: temporary tables, indexes, and query plans Jon Nelson (19:00)
Re: Massive update, memory usage Andreas Kretschmer (18:58)
Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure (18:51)
Re: Postgres insert performance and storage requirement compared to Oracle Steve Singer (18:51)
Re: Postgres insert performance and storage requirement compared to Oracle Jesper Krogh (18:42)
Massive update, memory usage Trenta sis (18:38)
Re: temporary tables, indexes, and query plans Reid Thompson (18:33)
Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure (18:28)
Re: CPUs for new databases Scott Marlowe (18:28)
Re: temporary tables, indexes, and query plans Jon Nelson (18:23)
Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh (18:14)
Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure (18:13)
Re: temporary tables, indexes, and query plans Jon Nelson (18:07)
Re: Postgres insert performance and storage requirement compared to Oracle Mladen Gogala (18:07)
Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure (18:06)
Re: CPUs for new databases Josh Berkus (18:03)
Re: Postgres insert performance and storage requirement compared to Oracle Scott Carey (17:47)
Re: temporary tables, indexes, and query plans Mladen Gogala (17:44)
temporary tables, indexes, and query plans Jon Nelson (17:30)
Re: AIX slow buffer reads André Volpato (17:05)
Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Francisco Reyes (17:02)
Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh (16:12)
Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Tom Lane (16:09)
Re: Postgres insert performance and storage requirement compared to Oracle David Wilson (15:50)
Re: Postgres insert performance and storage requirement compared to Oracle Reid Thompson (15:49)
Re: Postgres insert performance and storage requirement compared to Oracle Steve Singer (15:42)
Re: Running 9 in production? Sticking with 8.4.4 for a while? Francisco Reyes (15:19)
Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Francisco Reyes (15:14)
Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Marcin Mirosław (14:56)
Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Francisco Reyes (14:53)
Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh (14:00)
Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Pavel Stehule (13:17)
Regression: 8.3 2 seconds -> 8.4 100+ seconds Francisco Reyes (12:48)
Re: AIX slow buffer reads Brad Nicholson (12:42)
Re: Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure (11:05)
Re: Postgres insert performance and storage requirement compared to Oracle Ivan Voras (10:13)
Re: CPUs for new databases Scott Marlowe (08:07)
Re: CPUs for new databases Scott Marlowe (07:52)
Re: CPUs for new databases Yeb Havinga (07:32)
Re: BBU Cache vs. spindles Rob Wultsch (04:42)
Re: odd postgresql performance (excessive lseek) Tom Lane (03:57)
Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Tom Lane (03:48)
Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh (03:11)
Re: odd postgresql performance (excessive lseek) Robert Haas (03:05)
Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Robert Haas (02:56)
Re: Select count(*), the sequel Robert Haas (01:48)
Re: CPUs for new databases Scott Marlowe (01:14)
Re: CPUs for new databases Ivan Voras (00:21)
26 October 2010
Slow Query- Bad Row Estimate Ozer, Pam (23:27)
Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure (23:17)
Re: Select count(*), the sequel Tom Lane (22:51)
Re: Postgres insert performance and storage requirement compared to Oracle Robert Haas (22:50)
Re: Select count(*), the sequel Robert Haas (22:45)
Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure (22:14)
Re: Postgres insert performance and storage requirement compared to Oracle Mladen Gogala (21:55)
Re: Postgres insert performance and storage requirement compared to Oracle Jon Nelson (21:27)
Re: AIX slow buffer reads André Volpato (21:04)
Re: Postgres insert performance and storage requirement compared to Oracle Mladen Gogala (21:03)
Re: CPUs for new databases Josh Berkus (20:54)
Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure (15:42)
Re: CPUs for new databases Christian Elmerot (15:23)
Re: Postgres insert performance and storage requirement compared to Oracle Leonardo Francalanci (15:08)
Re: CPUs for new databases Scott Marlowe (14:51)
Re: CPUs for new databases Kevin Grittner (14:27)
Re: BBU Cache vs. spindles Robert Haas (14:25)
Re: BBU Cache vs. spindles Rob Wultsch (14:14)
Re: AIX slow buffer reads Brad Nicholson (14:07)
Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure (13:20)
CPUs for new databases Christian Elmerot (12:55)
Re: BBU Cache vs. spindles Robert Haas (12:41)
Re: which one is faster Mladen Gogala (12:33)
Re: Auto ANALYZE criteria Robert Haas (12:24)
Re: No hash join across partitioned tables? Robert Haas (12:23)
Re: which one is faster Szymon Guz (12:23)
Re: which one is faster Grzegorz Jaśkiewicz (12:20)
Re: which one is faster Szymon Guz (12:16)