Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2008-07 Chronological Index (1/2)
Last updated: Wed Jan 18 04:15:50 2012
281 messages
31 July 2008
SSD Performance Article Matthew T. O'Connor (17:45)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Steve Crawford (15:31)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Craig Ringer (10:24)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Theo Kramer (09:53)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Richard Huxton (09:45)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Miernik (09:39)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Richard Huxton (09:24)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Theo Kramer (09:05)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Miernik (08:39)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Richard Huxton (07:36)
Re: what is less resource-intensive, WHERE id IN or INNER JOIN? Scott Carey (06:47)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Miernik (06:39)
Re: why "WHERE uid NOT IN" is so slow, and EXCEPT in the same situtation is fast? Tom Lane (03:55)
Re: why "WHERE uid NOT IN" is so slow, and EXCEPT in the same situtation is fast? Miernik (03:26)
Re: why "WHERE uid NOT IN" is so slow, and EXCEPT in the same situtation is fast? Tom Lane (03:13)
why "WHERE uid NOT IN" is so slow, and EXCEPT in the same situtation is fast? Miernik (02:45)
Re: Difference between "Explain analyze" and "\timing" Tom Lane (01:08)
Re: Difference between "Explain analyze" and "\timing" Bill Moran (01:00)
Difference between "Explain analyze" and "\timing" tarcizioab (00:53)
30 July 2008
what is less resource-intensive, WHERE id IN or INNER JOIN? Miernik (22:12)
Re: Database size Vs performance degradation Miernik (21:59)
Re: how does pg handle concurrent queries and same queries Dennis Brakhane (18:59)
Re: Database size Vs performance degradation Mark Roberts (18:04)
Re: Database size Vs performance degradation Guillaume Lelarge (17:52)
Re: Database size Vs performance degradation Tom Lane (17:52)
Re: Database size Vs performance degradation Dave North (17:39)
Re: Database size Vs performance degradation Richard Huxton (17:19)
Re: Database size Vs performance degradation Mark Roberts (16:49)
Re: Database size Vs performance degradation Greg Smith (16:48)
Re: Database size Vs performance degradation Matthew Wakeling (16:16)
Re: Database size Vs performance degradation Mark Roberts (15:46)
Re: Database size Vs performance degradation Craig James (15:32)
Re: Database size Vs performance degradation Tom Lane (15:05)
Re: Database size Vs performance degradation Dave North (15:02)
Re: Database size Vs performance degradation Valentin Bogdanov (14:59)
Re: Database size Vs performance degradation Dave North (12:44)
Re: Database size Vs performance degradation Dave North (12:42)
Re: Database size Vs performance degradation Matthew Wakeling (12:36)
Re: Database size Vs performance degradation Richard Huxton (12:28)
Database size Vs performance degradation Dave North (12:14)
28 July 2008
Re: how does pg handle concurrent queries and same queries Alvaro Herrera (13:47)
Re: how does pg handle concurrent queries and same queries Matthew Wakeling (11:27)
Re: how does pg handle concurrent queries and same queries Craig Ringer (08:46)
Re: how does pg handle concurrent queries and same queries Faludi Gábor (07:53)
Re: how does pg handle concurrent queries and same queries Claus Guttesen (06:56)
how does pg handle concurrent queries and same queries Faludi Gábor (06:50)
27 July 2008
Re: Using ENUM with huge NAMEDATALEN David Andersen (00:15)
26 July 2008
Re: Using ENUM with huge NAMEDATALEN Tom Lane (21:44)
Using ENUM with huge NAMEDATALEN David Andersen (21:22)
25 July 2008
24 July 2008
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Richard Huxton (08:44)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Albert Cervera Areny (07:41)
23 July 2008
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Scott Marlowe (20:43)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Miernik (20:34)
Re: Samsung 32GB SATA SSD tested Scott Marlowe (20:11)
Re: Samsung 32GB SATA SSD tested Jeffrey Baker (19:59)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Alvaro Herrera (19:32)
Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Scott Marlowe (17:39)
how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence Miernik (16:22)
Re: Perl/DBI vs Native Valentin Bogdanov (10:47)
Re: Performance of jobs Craig Ringer (01:15)
Re: Samsung 32GB SATA SSD tested Scott Marlowe (00:52)
Samsung 32GB SATA SSD tested Jeffrey W. Baker (00:12)
22 July 2008
Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Greg Smith (20:36)
Re: Perl/DBI vs Native Greg Sabino Mullane (20:28)
Re: Performance of jobs samantha mahindrakar (19:49)
Re: Difference between 8.1 & 8.3 Patrick Vachon (16:34)
Re: Performance of jobs Craig Ringer (16:23)
Performance of jobs samantha mahindrakar (16:00)
Re: Perl/DBI vs Native Valentin Bogdanov (11:32)
Re: Less rows -> better performance? Łukasz Filut (08:22)
Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Stephane Bailliez (06:46)
Re: A guide/tutorial to performance monitoring and tuning Greg Smith (05:24)
Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Tom Lane (00:08)
21 July 2008
Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Emil Pedersen (23:21)
Re: A guide/tutorial to performance monitoring and tuning Francisco Reyes (21:27)
Re: Perl/DBI vs Native Greg Sabino Mullane (20:37)
Re: [BACKUPS]Little backups Levi (19:03)
Re: [BACKUPS]Little backups Berge Schwebs Bjørlo (18:59)
Re: Perl/DBI vs Native Tom Lane (18:46)
Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Greg Smith (18:44)
Re: [BACKUPS]Little backups A. Kretschmer (18:38)
Re: [BACKUPS]Little backups Albert Cervera Areny (18:37)
Re: [BACKUPS]Little backups Kevin Grittner (18:31)
[BACKUPS]Little backups Leví Teodoro da Silva (18:23)
Re: Perl/DBI vs Native Craig James (17:24)
Re: Less rows -> better performance? Mario Weilguni (15:29)
Re: Less rows -> better performance? Andreas Hartmann (15:14)
Re: Less rows -> better performance? Harald Armin Massa (14:56)
Re: Less rows -> better performance? Andreas Hartmann (14:45)
Re: Less rows -> better performance? Christian GRANDIN (14:01)
Re: Perl/DBI vs Native Rusty Conover (13:57)
Re: Less rows -> better performance? Craig Ringer (13:54)
Re: Perl/DBI vs Native Craig Ringer (13:49)
Re: Less rows -> better performance? Richard Huxton (12:11)
Re: Less rows -> better performance? Guillaume Smet (11:32)
Re: Less rows -> better performance? Andreas Hartmann (11:25)
Perl/DBI vs Native Valentin Bogdanov (11:19)
Re: Less rows -> better performance? Richard Huxton (11:06)
Less rows -> better performance? Andreas Hartmann (10:50)
Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Stephane Bailliez (10:12)
Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Luke Lonergan (08:58)
Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Stephane Bailliez (08:53)
Re: log_statement at postgres.conf Pomarede Nicolas (08:27)
Re: log_statement at postgres.conf System/IJS - Joko (06:35)
20 July 2008
Re: 3ware vs Areca Greg Smith (23:10)
Re: An "obvious" index not being used Daniele Varrazzo (23:07)
Re: An "obvious" index not being used Tom Lane (04:51)
19 July 2008
Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Luke Lonergan (13:59)
Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Stephane Bailliez (13:20)
Re: An "obvious" index not being used Francisco Reyes (01:45)
Re: 3ware vs Areca Francisco Reyes (01:40)
18 July 2008
Re: Mailing list hacked by spammer? Andrew Sullivan (18:07)
Re: Mailing list hacked by spammer? Craig James (17:40)
Re: long transaction Lennin Caro (17:23)
Re: Mailing list hacked by spammer? Glyn Astill (16:42)
Re: Mailing list hacked by spammer? Alvaro Herrera (16:28)
long transaction Sabin Coanda (15:41)
Re: Mailing list hacked by spammer? Steve Atkins (15:41)
Mailing list hacked by spammer? Craig James (15:13)
query plan, index scan cost Stefan Zweig (10:29)
Hi,Thank you! Krishna Kumar (09:31)
Re: log_statement at postgres.conf Pomarede Nicolas (08:16)
Re: log_statement at postgres.conf System/IJS - Joko (06:15)
Re: index scan cost Tom Lane (04:43)
17 July 2008
Re: index scan cost Jeff Frost (23:13)
index scan cost Jeff Frost (21:21)
Re: log_statement at postgres.conf Pomarede Nicolas (09:40)
Re: log_statement at postgres.conf Claus Guttesen (09:29)
log_statement at postgres.conf System/IJS - Joko (09:15)
16 July 2008
Difference between 8.1 & 8.3 Patrick Vachon (21:38)
15 July 2008
Re: 3ware vs Areca Jeffrey Baker (16:58)
Re: 3ware vs Areca Jeffrey Baker (15:45)
Re: 3ware vs Areca Greg Smith (15:19)
Re: requested shared memory size overflows size_t Tom Lane (14:25)
requested shared memory size overflows size_t Uwe Bartels (10:26)
Re: 3ware vs Areca Greg Smith (04:25)
14 July 2008
Re: [QUESTION]Concurrent Access Leví Teodoro da Silva (14:23)
Re: Trigger is not firing immediately Praveen (09:48)
Re: Trigger is not firing immediately Pavel Stehule (09:33)
Re: Trigger is not firing immediately Praveen (07:13)
Re: Trigger is not firing immediately Chris (06:52)
Re: Trigger is not firing immediately A. Kretschmer (06:48)
Trigger is not firing immediately Praveen (06:37)
Trigger is taking time to fire Ramasubramanian (05:53)
[SOLVED] Re: Altering a column type - Most efficient way Ow Mun Heng (01:46)
12 July 2008
Re: how to estimate shared_buffers... Scott Marlowe (13:06)
best starting point... Jessica Richard (12:03)
how to estimate shared_buffers... Jessica Richard (11:30)
Re: 3ware vs Areca Greg Smith (00:39)
11 July 2008
How many inserts am I doing Campbell, Lance (21:39)
How many updates and inserts Campbell, Lance (21:39)
Re: REINDEX/SELECT deadlock? Karl Wright (21:39)
Re: 3ware vs Areca Jeff (19:59)
Re: 3ware vs Areca Jeff (19:52)
Re: 3ware vs Areca Jeffrey Baker (19:39)
Re: REINDEX/SELECT deadlock? Tom Lane (19:38)
Re: 3ware vs Areca Greg Smith (19:32)
Re: 3ware vs Areca Scott Marlowe (17:46)
REINDEX/SELECT deadlock? Karl Wright (17:23)
Re: 3ware vs Areca Luke Lonergan (15:06)