Peripheral Links

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

pgsql-performance - March 2008

2008-03-01

• Re: t1.col like '%t2.col%' Gregory Williamson (00:30)
• Re: 12 disks raid setup Shane Ambler (00:44)
• Re: t1.col like '%t2.col%' Joshua D. Drake (01:39)
• Re: t1.col like '%t2.col%' Tom Lane (02:10)
• Re: 12 disks raid setup Greg Smith (04:56)
• Re: 12 disks raid setup Franck Routier (10:27)
• Re: 12 disks raid setup Scott Marlowe (12:44)
• How to allocate 8 disks Craig James (18:06)
• Re: 12 disks raid setup Tom Lane (18:11)
• Re: multi-threaded pgloader needs your tests Simon Riggs (18:17)
• Re: How to allocate 8 disks Scott Marlowe (18:47)
• Re: How to allocate 8 disks Joshua D. Drake (21:03)
• Re: How to allocate 8 disks Craig James (21:53)
• Re: How to allocate 8 disks Scott Marlowe (22:30)

2008-03-02

• Re: 12 disks raid setup Greg Smith (04:17)
• Re: How to allocate 8 disks Greg Smith (04:51)
• How to choose a disc array for Postgresql? Steve Poe (07:37)
• Re: How to choose a disc array for Postgresql? Joshua D. Drake (08:05)
• Re: How to choose a disc array for Postgresql? Luke Lonergan (14:29)

2008-03-03

• Re: How to choose a disc array for Postgresql? Vivek Khera (03:11)
• Re: How to choose a disc array for Postgresql? Steve Poe (04:02)
• Re: How to choose a disc array for Postgresql? Joshua D. Drake (04:13)
• Re: How to choose a disc array for Postgresql? Scott Marlowe (04:23)
• Re: How to choose a disc array for Postgresql? Greg Smith (05:16)
• Re: How to allocate 8 disks Matthew (12:11)
• which is more important? freq of checkpoints or the duration of them? Douglas J Hunley (14:25)
• Re: How to choose a disc array for Postgresql? Vivek Khera (14:32)
• Re: How to choose a disc array for Postgresql? Vivek Khera (14:34)
• Re: How to allocate 8 disks Mark Mielke (14:48)
• Re: How to allocate 8 disks Craig James (14:53)
• Performance problems deleting data Rafael Martinez (14:54)
• Re: How to allocate 8 disks Matthew (14:57)
• Re: How to choose a disc array for Postgresql? Vivek Khera (15:02)
• Re: How to allocate 8 disks Mark Mielke (15:06)
• Re: which is more important? freq of checkpoints or the duration of them? Scott Marlowe (15:16)
• Re: How to allocate 8 disks Scott Marlowe (15:22)
• Re: which is more important? freq of checkpoints or the duration of them? Chris Browne (15:55)
• Re: which is more important? freq of checkpoints or the duration of them? Greg Smith (16:40)
• Re: which is more important? freq of checkpoints or the duration of them? Greg Smith (17:06)
• Re: Performance problems deleting data Tom Lane (17:25)
• Re: How to choose a disc array for Postgresql? Ron Mayer (19:38)
• Performance tuning on FreeBSD alan bryan (23:39)

2008-03-04

• Re: Performance tuning on FreeBSD Bill Moran (00:26)
• Re: Performance tuning on FreeBSD alan bryan (00:34)
• Re: Performance tuning on FreeBSD Greg Smith (01:11)
• Re: Performance problems deleting data Rafael Martinez (08:28)
• Re: Performance tuning on FreeBSD alan bryan (09:15)
• Re: Performance tuning on FreeBSD Greg Smith (10:22)
• Re: How to allocate 8 disks Ivan Voras (10:45)
• Re: Performance tuning on FreeBSD Ivan Voras (10:54)
• Re: Performance problems deleting data Alvaro Herrera (11:57)
• Re: Performance tuning on FreeBSD Ivan Voras (14:07)
• Re: Performance tuning on FreeBSD Matthew (14:14)
• Ramifications of turning off Nested Loops for slow queries Chris Kratz (14:42)
• Re: How to allocate 8 disks Shane Ambler (15:04)
• PostgreSQL performance on a virtual host Theo Kramer (15:43)
• Re: Ramifications of turning off Nested Loops forslow queries Kevin Grittner (16:18)
• Re: Performance tuning on FreeBSD Greg Smith (16:25)
• Re: Ramifications of turning off Nested Loops for slow queries Tom Lane (17:19)
• Re: Ramifications of turning off Nested Loops for slow queries Chris Kratz (18:13)
• Re: Ramifications of turning off Nested Loops for slow queries Chris Kratz (18:16)
• Re: Optimisation help Alan Hodgson (21:03)
• Optimisation help dforums (22:21)
• Re: Optimisation help Steinar H. Gunderson (22:54)
• Re: Optimisation help Greg Smith (22:59)

2008-03-05

• Re: Optimisation help dforums (00:10)
• Re: Optimisation help dforums (00:15)
• Re: Optimisation help Erik Jones (00:19)
• Re: Optimisation help dforums (00:37)
• Re: Optimisation help dforums (00:54)
• Re: Optimisation help dforums (08:18)
• Re: PostgreSQL performance on a virtual host Moritz Onken (08:54)
• postgresql performance SPMLINGAM (10:27)
• Confirmação de envio / Sending confirmation (captchaid:13266b111e1d) petchimuthu lingam (10:38)
• Re: postgresql performance Steinar H. Gunderson (10:39)
• Re: postgresql performance Franck Routier (10:52)
• Re: postgresql performance Claus Guttesen (11:03)
• Re: PostgreSQL performance on a virtual host Dave Cramer (12:42)
• Re: postgresql performance Dave Dutcher (14:09)
• Re: PostgreSQL performance on a virtual host Ivan Zolotukhin (14:26)
• Re: PostgreSQL performance on a virtual host Bill Moran (14:40)
• Re: PostgreSQL performance on a virtual host Ivan Zolotukhin (14:56)
• Re: postgresql performance Kevin Grittner (15:46)
• Re: postgresql performance Bill Moran (16:00)

2008-03-06

• Why the difference in plans ? Dave Cramer (00:27)
• Confirmação de envio / Sending confirmation (captchaid:13266b1124bc) petchimuthu lingam (04:48)
• Confirmação de envio / Sending confirmation (captchaid:13266b203c28) petchimuthu lingam (04:54)
• Confirmação de envio / Sending confirmation (captchaid:13266b203e23) petchimuthu lingam (05:08)
• Confirmação de envio / Sending confirmation (captchaid:13266b20536d) petchimuthu lingam (05:17)
• count * performance issue sathiya psql (05:43)
• Re: Confirmação de envio / Sending confirmation (captchaid:13266b20536d) Chris (05:46)
• Re: count * performance issue Chris (05:48)
• Confirmação de envio / Sending confirmation (captchaid:13266b2056e4) petchimuthu lingam (05:57)
• Re: count * performance issue A. Kretschmer (06:08)
• postgresql Explain command output RaviRam Kolipaka (06:10)
• Re: count * performance issue Shoaib Mir (06:15)
• Re: count * performance issue sathiya psql (06:19)
• Re: count * performance issue Shoaib Mir (06:26)
• Re: count * performance issue Mark Mielke (06:26)
• Re: count * performance issue sathiya psql (06:31)
• Re: count * performance issue Shoaib Mir (06:32)
• Re: count * performance issue A. Kretschmer (06:36)
• Re: count * performance issue sathiya psql (06:43)
• Fwd: count * performance issue sathiya psql (06:48)
• Re: count * performance issue A. Kretschmer (06:54)
• Re: count * performance issue A. Kretschmer (06:57)
• oid...any optimizations sathiya psql (07:02)
• Re: count * performance issue sathiya psql (07:06)
• Re: oid...any optimizations Joshua D. Drake (07:06)
• Re: oid...any optimizations sathiya psql (07:13)
• Re: count * performance issue A. Kretschmer (07:18)
• Re: oid...any optimizations Theo Kramer (07:21)
• index usage makes problem sathiya psql (08:16)
• Re: count * performance issue Dave Cramer (11:50)
• Re: count * performance issue Dave Cramer (12:13)
• Re: count * performance issue sathiya psql (12:43)
• Re: count * performance issue Harald Armin Massa (12:48)
• Re: count * performance issue A. Kretschmer (12:49)
• Re: count * performance issue Alvaro Herrera (12:49)
• Re: postgresql Explain command output Greg Smith (13:10)
• Re: count * performance issue Mark Mielke (13:10)
• Re: count * performance issue Greg Smith (13:18)
• Re: count * performance issue Greg Smith (13:27)
• Re: postgresql Explain command output Tom Lane (13:31)
• Re: postgresql Explain command output Greg Smith (13:43)
• Re: count * performance issue Craig James (15:28)
• Re: count * performance issue Bruce Momjian (15:33)
• Re: count * performance issue Steinar H. Gunderson (15:36)
• Re: count * performance issue Bill Moran (15:41)
• Re: count * performance issue Greg Smith (15:49)
• Re: count * performance issue Dave Page (16:05)
• Re: count * performance issue Mark Lewis (16:16)
• Re: oid...any optimizations Joshua D. Drake (16:28)
• Re: count * performance issue D'Arcy J.M. Cain (16:31)
• Re: Performance of aggregates over set-returning functions Bruce Momjian (17:23)
• Re: Why the difference in plans ? Josh Berkus (17:26)
• Re: count * performance issue Tom Lane (17:29)
• Re: Performance of aggregates over set-returning functions Tom Lane (17:53)
• Re: Performance of aggregates over set-returning functions Bruce Momjian (18:01)
• Re: Why the difference in plans ? Dave Cramer (18:56)
• Re: More shared buffers causes lower performances Bruce Momjian (21:37)
• Re: Why the difference in plans ? Stephen Denne (22:10)

2008-03-07

• Re: Why the difference in plans ? Dave Cramer (02:16)
• Re: Why the difference in plans ? Stephen Denne (02:30)
• Re: count * performance issue Mark Kirkwood (02:40)
• Re: count * performance issue Craig James (03:00)
• Improve Full text rank in a query b wragg (03:58)
• database design for large data. shilpa.raghavendra (04:59)
• Re: count * performance issue paul rivers (05:38)
• Re: Improve Full text rank in a query Tom Lane (05:40)
• Nested loop vs merge join: inconsistencies between estimated and actual time Vlad Arkhipov (05:50)
• Re: Nested loop vs merge join: inconsistencies between estimated and actual time Tom Lane (06:35)
• Toast space grows Pavel Rotek (08:35)
• Re: Improve Full text rank in a query Oleg Bartunov (08:44)
• Re: Toast space grows Richard Huxton (09:13)
• Re: Toast space grows Pavel Rotek (09:29)
• Re: Why the difference in plans ? Dave Cramer (11:21)
• Re: Why the difference in plans ? Dave Cramer (11:21)
• Re: Toast space grows Bill Moran (11:53)
• Re: postgresql Explain command output RaviRam Kolipaka (12:59)
• Re: Toast space grows Pavel Rotek (12:59)
• Re: Toast space grows Alvaro Herrera (13:19)
• Re: Toast space grows Tom Lane (13:33)
• Re: Toast space grows Matthew (13:56)
• Re: Toast space grows Pavel Rotek (14:11)
• Re: Toast space grows Matthew (14:19)
• Re: Toast space grows Pavel Rotek (14:22)
• Re: Toast space grows Pavel Rotek (14:27)
• Re: Toast space grows Tom Lane (14:31)
• Re: Toast space grows Bill Moran (14:34)
• Re: Toast space grows Pavel Rotek (15:03)
• Re: Effects of cascading references in foreign keys Bruce Momjian (19:19)
• Re: count * performance issue Mark Kirkwood (23:51)

2008-03-08

• Re: Why the difference in plans ? Josh Berkus (01:23)
• Re: count * performance issue Josh Berkus (01:27)
• Re: count * performance issue Tom Lane (01:38)
• join query performance petchimuthu lingam (04:07)
• Confirmação de envio / Sending confirmation (captchaid:13266b402bd3) petchimuthu lingam (04:16)
• Re: Confirmação de envio / Sending confirmation (captchaid:13266b402f09) petchimuthu lingam (04:33)
• join query performance petchimuthu lingam (05:01)
• Re: count * performance issue Greg Smith (05:08)
• Re: count * performance issue Mark Mielke (05:31)
• Re: count * performance issue Tom Lane (06:13)
• Re: count * performance issue paul rivers (07:11)
• Re: count * performance issue Arjen van der Meijden (08:04)
• Re: Re: Confirma?==?iso-8859-1?B?5+M=?==?iso-8859-1?Q?o de envio / Sending confirmation(captchaid:13266b402f09) Alvaro Herrera (14:17)
• Joins and DELETE FROM Kynn Jones (17:31)
• Re: Joins and DELETE FROM Heikki Linnakangas (18:01)
• Re: Joins and DELETE FROM Kynn Jones (19:02)
• Re: Joins and DELETE FROM Tom Lane (20:08)
• Re: Joins and DELETE FROM Heikki Linnakangas (20:25)

2008-03-09

• Re: join query performance Chris (23:42)

2008-03-10

• UPDATE 66k rows too slow Miguel Arroz (02:21)
• Re: UPDATE 66k rows too slow andrew (04:10)
• Re: UPDATE 66k rows too slow Tom Lane (04:48)
• Re: UPDATE 66k rows too slow Greg Smith (05:10)
• Utility functions for enabling/disabling fkey triggers Craig Ringer (09:12)
• Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Craig Ringer (09:55)
• Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Heikki Linnakangas (11:01)
• Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Craig Ringer (11:29)