Search

Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-performance - July 2008

Search archives
	(enter a message-id to go directly to that message)	Advanced Search

Prev | Next

2008-07-01

• Re: sequence scan problem John Beaver (00:37)
• un-understood index performance behaviour Emiliano Leporati (10:49)
• Inact_dirty is increasing continuously and causing the system to hang. Kathirvel, Jeevanandam (11:59)
• Re: un-understood index performance behaviour Scott Marlowe (14:17)
• Re: un-understood index performance behaviour Tom Lane (14:18)
• Re: Inact_dirty is increasing continuously and causing the system to hang. Greg Smith (15:03)
• Re: Does max size of varchar influence index size Franck Routier (15:05)
• Re: VACUUM ANALYZE blocking both reads and writes to atable Peter Schuller (15:26)
• Re: Does max size of varchar influence index size Richard Huxton (15:33)
• Select running slow on Postgres samantha mahindrakar (19:29)
• Re: Select running slow on Postgres Scott Marlowe (19:47)

2008-07-02

• Fusion-io ioDrive Jeffrey Baker (00:18)
• Re: Fusion-io ioDrive Andrej Ricnik-Bay (01:17)
• Re: Fusion-io ioDrive Jeffrey Baker (01:36)
• Re: Fusion-io ioDrive Greg Smith (01:38)
• Re: Fusion-io ioDrive Andrej Ricnik-Bay (01:46)
• Re: Fusion-io ioDrive Merlin Moncure (10:57)
• Re: Fusion-io ioDrive Jonah H. Harris (11:41)
• Hot Issue Gauri Kanekar (12:31)
• Re: Hot Issue Jonah H. Harris (12:40)
• Re: Hot Issue Gauri Kanekar (12:41)
• Re: Hot Issue Devrim GÜNDÜZ (13:08)
• Re: Hot Issue Gauri Kanekar (13:11)
• Re: Hot Issue Jonah H. Harris (13:29)
• Re: Fusion-io ioDrive Cédric Villemain (13:36)
• Re: Hot Issue Devrim GÜNDÜZ (13:40)
• Re: Hot Issue Gauri Kanekar (13:44)
• Re: Hot Issue Jonah H. Harris (14:21)
• Re: Hot Issue Tom Lane (14:40)
• Re: Hot Issue Gauri Kanekar (14:48)
• Re: Hot Issue Tom Lane (16:35)
• [QUESTION]Concurrent Access Leví Teodoro da Silva (18:31)
• Re: [QUESTION]Concurrent Access Devrim GÜNDÜZ (18:42)
• Re: [QUESTION]Concurrent Access Scott Marlowe (18:47)
• Re: Select running slow on Postgres samantha mahindrakar (19:01)
• Re: Select running slow on Postgres Scott Marlowe (19:07)

2008-07-03

• switchover between index and sequential scans Abhijit Menon-Sen (07:59)
• Re: switchover between index and sequential scans Gregory Stark (10:05)
• cursor/Fetch mechanisms under postgreSQL Mokhtari Amine (10:17)
• Re: switchover between index and sequential scans Abhijit Menon-Sen (11:45)
• Re: [QUESTION]Concurrent Access PFC (12:56)

2008-07-04

• slow delete Jessica Richard (00:44)
• Define all IP's in the world in pg_hba.conf idc danny (04:52)
• Re: slow delete Craig Ringer (05:16)
• Re: Define all IP's in the world in pg_hba.conf Russell Smith (05:30)
• Re: slow delete PFC (10:11)
• Re: slow delete Jessica Richard (12:30)
• Re: slow delete tv (13:00)
• Re: slow delete Alan Hodgson (15:48)
• Re: [QUESTION]Concurrent Access Chris Browne (16:58)

2008-07-05

• Re: Fusion-io ioDrive Jeffrey Baker (06:41)
• How much work_mem to configure... Jessica Richard (11:24)
• Re: Subquery WHERE IN or WHERE EXISTS faster? Sergio Gabriel Rodriguez (12:02)
• Re: Subquery WHERE IN or WHERE EXISTS faster? Sergio Gabriel Rodriguez (12:14)

2008-07-06

• filesystem options for WAL Jaime Casanova (05:04)
• Re: How much work_mem to configure... Scott Marlowe (06:04)
• Re: filesystem options for WAL Greg Smith (15:18)

2008-07-07

• Re: How much work_mem to configure... Bill Moran (11:15)
• Re: Fusion-io ioDrive Merlin Moncure (13:08)
• Re: Fusion-io ioDrive Merlin Moncure (13:23)
• Re: Fusion-io ioDrive PFC (14:58)
• Re: Fusion-io ioDrive Jonah H. Harris (15:09)
• Re: Fusion-io ioDrive Jeffrey Baker (16:10)
• Re: Fusion-io ioDrive PFC (17:50)
• Practical upper limits of pgbench read/write tps with 8.3 Jeffrey Baker (21:05)
• Re: Practical upper limits of pgbench read/write tps with 8.3 Greg Smith (22:22)

2008-07-08

• Re: Practical upper limits of pgbench read/write tps with 8.3 Jeffrey Baker (03:39)
• Re: Fusion-io ioDrive Markus Wanner (09:49)
• syslog performance when logging big statements Achilleas Mantzios (12:24)
• Re: syslog performance when logging big statements Tom Lane (14:35)
• Re: syslog performance when logging big statements Achilleas Mantzios (15:21)
• Re: Fusion-io ioDrive Scott Carey (16:38)
• Re: syslog performance when logging big statements Tom Lane (18:34)
• Re: syslog performance when logging big statements Jeff (19:00)
• max fsm pages question Radhika S (19:13)
• Re: Fusion-io ioDrive Jeremy Harris (19:24)
• Re: max fsm pages question Bill Moran (19:24)
• Re: syslog performance when logging big statements Tom Lane (21:39)

2008-07-09

• Re: syslog performance when logging big statements david (00:47)
• Re: syslog performance when logging big statements Tatsuo Ishii (01:31)
• Re: syslog performance when logging big statements Tom Lane (02:08)
• Re: syslog performance when logging big statements achill@matrix (12:31)
• Re: syslog performance when logging big statements achill@matrix (12:37)
• Re: syslog performance when logging big statements achill@matrix (12:51)
• Re: max fsm pages question Vivek Khera (15:59)

2008-07-10

• Altering a column type - Most efficient way Ow Mun Heng (07:53)
• Re: Altering a column type - Most efficient way Mario Weilguni (08:36)
• Re: Altering a column type - Most efficient way Ow Mun Heng (09:34)
• how big shmmax is good for Postgres... Jessica Richard (10:53)
• Re: how big shmmax is good for Postgres... Bill Moran (11:19)
• Re: how big shmmax is good for Postgres... Scott Marlowe (11:23)
• Re: how big shmmax is good for Postgres... Scott Marlowe (12:11)
• Re: Altering a column type - Most efficient way Alvaro Herrera (13:57)
• Re: how big shmmax is good for Postgres... Scott Marlowe (15:37)

2008-07-11

• Re: Altering a column type - Most efficient way Ow Mun Heng (02:17)
• Trigger is taking time to fire Ramasubramanian (07:35)
• Re: Altering a column type - Most efficient way Mario Weilguni (08:01)
• 3ware vs Areca Jeff (13:26)
• Re: Altering a column type - Most efficient way Alvaro Herrera (13:44)
• Re: 3ware vs Areca Scott Marlowe (14:19)
• Re: Altering a column type - Most efficient way Tom Lane (14:27)
• Re: Altering a column type - Most efficient way Kevin Grittner (14:55)
• Re: 3ware vs Areca Luke Lonergan (14:59)
• REINDEX/SELECT deadlock? Karl Wright (16:59)
• Re: 3ware vs Areca Scott Marlowe (17:46)
• Re: 3ware vs Areca Greg Smith (19:21)
• Re: REINDEX/SELECT deadlock? Tom Lane (19:38)
• Re: 3ware vs Areca Jeffrey Baker (19:39)
• Re: 3ware vs Areca Jeff (19:52)
• Re: 3ware vs Areca Jeff (19:58)
• How many inserts am I doing Campbell, Lance (21:25)
• How many updates and inserts Campbell, Lance (21:27)
• Re: REINDEX/SELECT deadlock? Karl Wright (21:40)
• Re: How many updates and inserts Ben (21:47)

2008-07-12

• Re: 3ware vs Areca Greg Smith (00:39)
• how to estimate shared_buffers... Jessica Richard (11:30)
• best starting point... Jessica Richard (12:03)
• Re: how to estimate shared_buffers... Scott Marlowe (13:05)
• Re: how to estimate shared_buffers... Oleg Bartunov (14:30)

2008-07-14

• [SOLVED] Re: Altering a column type - Most efficient way Ow Mun Heng (01:46)
• Trigger is taking time to fire Ramasubramanian (05:59)
• Trigger is not firing immediately Praveen (06:34)
• Re: Trigger is not firing immediately A. Kretschmer (06:48)
• Re: Trigger is not firing immediately Chris (06:52)
• Re: Trigger is not firing immediately Praveen (07:17)
• Re: Trigger is not firing immediately Pavel Stehule (09:33)
• Re: Trigger is not firing immediately Praveen (09:51)
• Re: [QUESTION]Concurrent Access Leví Teodoro da Silva (14:23)
• Re: Trigger is taking time to fire Scott Marlowe (18:08)

2008-07-15

• Re: 3ware vs Areca Greg Smith (04:13)
• requested shared memory size overflows size_t Uwe Bartels (10:26)
• Re: requested shared memory size overflows size_t Tom Lane (14:25)
• Re: 3ware vs Areca Jeffrey Baker (14:46)
• Re: 3ware vs Areca Greg Smith (15:17)
• Re: 3ware vs Areca Jeffrey Baker (15:54)
• Re: requested shared memory size overflows size_t Stephen Conley (21:26)

2008-07-16

• Difference between 8.1 & 8.3 Patrick Vachon (21:37)
• Re: Difference between 8.1 & 8.3 Gregory Williamson (21:59)

2008-07-17

• log_statement at postgres.conf System/IJS - Joko (08:43)
• Re: log_statement at postgres.conf Claus Guttesen (09:29)
• Re: log_statement at postgres.conf Pomarede Nicolas (09:40)
• index scan cost Jeff Frost (21:21)
• Re: index scan cost Dennis Brakhane (22:58)
• Re: index scan cost Jeff Frost (23:12)

2008-07-18

• Re: index scan cost Tom Lane (04:37)
• Re: log_statement at postgres.conf System/IJS - Joko (05:48)
• Re: log_statement at postgres.conf Pomarede Nicolas (08:16)
• Hi,Thank you! Krishna Kumar (09:30)
• query plan, index scan cost Stefan Zweig (10:28)
• Mailing list hacked by spammer? Craig James (15:02)
• long transaction Sabin Coanda (15:34)
• Re: Mailing list hacked by spammer? Steve Atkins (15:41)
• Re: Mailing list hacked by spammer? Alvaro Herrera (16:21)
• Re: Mailing list hacked by spammer? Glyn Astill (16:37)
• Re: long transaction Lennin Caro (17:22)
• Re: Mailing list hacked by spammer? Craig James (17:40)
• Re: Mailing list hacked by spammer? Andrew Sullivan (18:07)
• Re: Mailing list hacked by spammer? Glyn Astill (18:41)

2008-07-19

• Re: Backup/Restore of single table in multi TB database Francisco Reyes (00:25)
• Re: 3ware vs Areca Francisco Reyes (01:39)
• Re: An "obvious" index not being used Francisco Reyes (01:45)
• Re: Backup/Restore of single table in multi TB database Simon Riggs (09:02)
• Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Stephane Bailliez (13:19)
• Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Luke Lonergan (13:59)
• Re: An "obvious" index not being used Daniele Varrazzo (17:21)

2008-07-20

• Re: An "obvious" index not being used Tom Lane (04:44)
• Re: An "obvious" index not being used Daniele Varrazzo (23:07)
• Re: 3ware vs Areca Greg Smith (23:10)
• Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Greg Smith (23:12)

2008-07-21

• Re: log_statement at postgres.conf System/IJS - Joko (06:35)
• Re: log_statement at postgres.conf Pomarede Nicolas (08:27)
• Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Stephane Bailliez (08:53)
• Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Luke Lonergan (08:57)
• Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Stephane Bailliez (10:11)
• Less rows -> better performance? Andreas Hartmann (10:50)
• Re: Less rows -> better performance? Richard Huxton (11:06)
• Perl/DBI vs Native Valentin Bogdanov (11:19)
• Re: Less rows -> better performance? Andreas Hartmann (11:25)
• Re: Less rows -> better performance? Guillaume Smet (11:32)
• Re: Less rows -> better performance? Richard Huxton (12:11)
• Re: Perl/DBI vs Native Craig Ringer (13:49)
• Re: Less rows -> better performance? Craig Ringer (13:53)
• Re: Perl/DBI vs Native Rusty Conover (13:57)
• Re: Less rows -> better performance? Christian GRANDIN (14:00)
• Re: Less rows -> better performance? Andreas Hartmann (14:45)
• Re: Less rows -> better performance? Harald Armin Massa (14:56)
• Re: Less rows -> better performance? Andreas Hartmann (15:14)
• Re: Less rows -> better performance? Mario Weilguni (15:29)
• Re: Perl/DBI vs Native Craig James (17:24)
• [BACKUPS]Little backups Leví Teodoro da Silva (18:20)
• Re: [BACKUPS]Little backups Berge Schwebs Bjørlo (18:28)
• Re: [BACKUPS]Little backups Kevin Grittner (18:30)
• Re: [BACKUPS]Little backups Albert Cervera Areny (18:30)
• Re: [BACKUPS]Little backups A. Kretschmer (18:38)
• Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Greg Smith (18:43)
• Re: Perl/DBI vs Native Tom Lane (18:44)
• Re: [BACKUPS]Little backups Levi (19:01)
• Re: Perl/DBI vs Native Greg Sabino Mullane (20:37)
• Re: A guide/tutorial to performance monitoring and tuning Francisco Reyes (21:27)
• Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) Emil Pedersen (23:20)

Prev | Next