• Text Size: Normal / Large
• Donate
• Contact

Section Navigation

• Community
• Contributors
• Mailing Lists
  • Subscribe
  • User lists
    • pgsql-admin
    • pgsql-advocacy
    • pgsql-announce
    • pgsql-bugs
    • pgsql-docs
    • pgsql-general
    • pgsql-jobs
    • pgsql-novice
    • pgsql-performance
    • pgsql-php
    • pgsql-sql
    • pgsql-students
  • Developer lists
  • Regional lists
  • Associations
  • User groups
  • Project lists
  • Inactive lists
• IRC
• Featured Users
• International Sites
• Propaganda
• Resources
• Weekly News
• Community login
  • Profile
  • Lost password

pgsql-performance 2008-05 Chronological Index (1/3)

• Thread Index
• [Prev Page]
• [Next Page]

• 31 May 2008
  • Re: 2GB or not 2GB Gregory Stark (19:41)
  • Re: 2GB or not 2GB Josh Berkus (18:53)
  • Re: Statistics issue Tom Lane (15:51)
  • Re: 2GB or not 2GB Simon Riggs (07:42)
  • Statistics issue Vlad Arkhipov (04:24)
• 30 May 2008
  • Re: ProcArrayLock (The Saga continues) Gregory Stark (00:28)
• 29 May 2008
  • ProcArrayLock (The Saga continues) Jignesh K. Shah (22:10)
  • Re: 2GB or not 2GB Magnus Hagander (19:50)
  • Re: Adding "LIMIT 1" kills performance. Tom Lane (17:59)
  • Re: Adding "LIMIT 1" kills performance. Chris Shoemaker (17:49)
  • OVERLAPS is slow Chris Browne (17:23)
  • Re: Adding "LIMIT 1" kills performance. Shane Ambler (16:53)
  • Adding "LIMIT 1" kills performance. Chris Shoemaker (15:48)
  • Re: 2GB or not 2GB Joshua D. Drake (15:44)
  • Re: IN() statement values order makes 2x performance hit Alexey Kupershtokh (09:51)
  • Re: IN() statement values order makes 2x performance hit Oleg Bartunov (09:40)
  • IN() statement values order makes 2x performance hit Alexey Kupershtokh (09:37)
  • Re: 2GB or not 2GB Jignesh K. Shah (03:02)
  • Re: 2GB or not 2GB Jignesh K. Shah (02:54)
  • Re: 2GB or not 2GB Greg Smith (01:19)
  • Re: 2GB or not 2GB Gregory Stark (01:03)
  • Re: 2GB or not 2GB Steve Crawford (00:07)
• 28 May 2008
  • 2GB or not 2GB Josh Berkus (23:56)
  • Re: Creating large database of MD5 hash values Tom Lane (23:42)
  • Re: Creating large database of MD5 hash values Bruce Momjian (23:37)
  • Re: GEQO Benchmark Tarcizio Bini (17:55)
  • Re: GEQO Benchmark Simon Riggs (16:50)
  • Re: GEQO Benchmark Tarcizio Bini (16:13)
  • Re: GEQO Benchmark Tom Lane (14:03)
  • GEQO Benchmark tarcizioab (13:51)
  • Re: Outer joins and equivalence Simon Riggs (13:37)
  • Re: Outer joins and equivalence Matthew Wakeling (10:45)
• 27 May 2008
  • Re: Outer joins and equivalence Tom Lane (21:44)
  • Re: I/O on select count(*) Simon Riggs (20:52)
  • Outer joins and equivalence Simon Riggs (19:56)
  • Re: [GENERAL] select query takes 13 seconds to run with index hubert depesz lubaczewski (14:58)
  • Re: [GENERAL] select query takes 13 seconds to run with index mark (14:47)
  • Re: [GENERAL] select query takes 13 seconds to run with index hubert depesz lubaczewski (08:22)
  • Re: [GENERAL] select query takes 13 seconds to run with index PFC (08:13)
• 26 May 2008
  • Re: [GENERAL] select query takes 13 seconds to run with index mark (23:57)
  • Re: [GENERAL] select query takes 13 seconds to run with index mark (23:32)
  • Re: RAID controllers for Postgresql on large setups Marinos Yannikos (23:14)
  • Re: Symbolic Links to Tablespaces Heikki Linnakangas (20:26)
  • Re: Symbolic Links to Tablespaces Tino Wildenhain (19:19)
  • Re: Symbolic Links to Tablespaces Heikki Linnakangas (18:26)
  • Re: Symbolic Links to Tablespaces A. Kretschmer (17:32)
  • Re: Symbolic Links to Tablespaces Campbell, Lance (17:10)
  • Re: I/O on select count(*) Tom Lane (15:37)
  • Re: Symbolic Links to Tablespaces Tom Lane (15:09)
  • Re: "Big O" notation for postgres? H. Hall (15:00)
  • Symbolic Links to Tablespaces Campbell, Lance (14:12)
  • Re: I/O on select count(*) Heikki Linnakangas (13:03)
  • Re: Posible planner improvement? ITAGAKI Takahiro (11:30)
• 24 May 2008
  • Re: Quad Xeon or Quad Opteron? Jeffrey Baker (20:39)
  • Re: I/O on select count(*) Decibel! (19:15)
  • Re: I/O on select count(*) Decibel! (19:07)
  • Re: Posible planner improvement? Decibel! (18:51)
  • Re: shared_buffers performance Decibel! (18:51)
  • Re: Creating large database of MD5 hash values Decibel! (18:50)
  • Re: Quad Xeon or Quad Opteron? Andrzej Zawadzki (16:49)
  • Re: Quad Xeon or Quad Opteron? Andrzej Zawadzki (16:39)
• 23 May 2008
  • Re: index performance on large tables with update and insert Magnus Hagander (16:35)
  • IBM ServRAID-MR10M / LSI1078ROC advice Kevin Grittner (15:15)
  • index performance on large tables with update and insert Jessica Richard (13:28)
  • Re: Quad Xeon or Quad Opteron? Reid Thompson (13:00)
  • Re: Quad Xeon or Quad Opteron? Knight, Doug (12:36)
  • Re: Quad Xeon or Quad Opteron? Adam Tauno Williams (12:22)
  • Re: Quad Xeon or Quad Opteron? Craig Ringer (11:34)
  • Quad Xeon or Quad Opteron? Andrzej Zawadzki (10:49)
  • join/from_collapse_limit and geqo_threshold default values Vlad Arkhipov (09:01)
  • Re: I/O on select count(*) Luke Lonergan (03:49)
• 22 May 2008
  • Re: "Big O" notation for postgres? Gregory Stark (23:08)
  • Re: Index creation time and distribution Guillaume Smet (21:52)
  • Re: Index creation time and distribution Tom Lane (19:18)
  • Re: Index creation time and distribution Guillaume Smet (18:34)
  • Re: Index creation time and distribution Scott Marlowe (16:50)
  • Re: Index creation time and distribution Matthew Wakeling (14:10)
  • Re: Index creation time and distribution Guillaume Smet (13:38)
  • Re: Index creation time and distribution Tom Lane (13:14)
  • Index creation time and distribution Guillaume Smet (12:32)
  • Re: Varchar pkey instead of integer Robins Tharakan (00:54)
• 21 May 2008
  • Re: "Big O" notation for postgres? H. Hall (19:15)
  • Re: "append" takes a lot of time in a query Scott Marlowe (18:44)
  • Re: Posible planner improvement? Albert Cervera Areny (16:22)
  • Re: "Big O" notation for postgres? PFC (16:20)
  • Re: Posible planner improvement? PFC (16:12)
  • Re: "Big O" notation for postgres? Richard Huxton (14:40)
  • Re: "Big O" notation for postgres? Jonah H. Harris (14:29)
  • "Big O" notation for postgres? H. Hall (14:20)
  • Re: Posible planner improvement? Richard Huxton (13:09)
  • Re: Posible planner improvement? Luke Lonergan (11:50)
  • Re: Posible planner improvement? Albert Cervera Areny (11:37)
  • Re: Posible planner improvement? Albert Cervera Areny (11:30)
  • Re: Posible planner improvement? Mark Mielke (11:25)
  • Re: Posible planner improvement? Albert Cervera Areny (11:11)
  • Re: Posible planner improvement? Richard Huxton (10:48)
  • Re: "append" takes a lot of time in a query Frank Dekervel (10:38)
  • Posible planner improvement? Albert Cervera Areny (10:35)
  • Re: Varchar pkey instead of integer J. Andrew Rogers (08:57)
  • Re: Varchar pkey instead of integer Craig Ringer (08:02)
  • Re: Varchar pkey instead of integer Shane Ambler (07:33)
  • Re: Varchar pkey instead of integer Craig Ringer (06:34)
  • Re: Varchar pkey instead of integer Joshua D. Drake (06:16)
  • Varchar pkey instead of integer Robins Tharakan (05:52)
• 20 May 2008
  • Re: improving performance for a delete PFC (20:47)
  • Re: improving performance for a delete kevin kempter (20:03)
  • improving performance for a delete kevin kempter (19:58)
  • Re: slow update Scott Marlowe (17:47)
  • Re: Author Wanted Bill Moran (12:32)
  • Author Wanted Markus Feilner (11:52)
  • Re: slow update A. Kretschmer (06:24)
  • slow update kevin kempter (06:00)
• 19 May 2008
  • Re: I/O on select count(*) PFC (17:09)
  • Re: I/O on select count(*) Tom Lane (15:54)
  • Re: I/O on select count(*) Greg Smith (15:47)
  • Re: I/O on select count(*) Tom Lane (15:38)
  • Re: I/O on select count(*) Bruce Momjian (14:54)
  • Re: I/O on select count(*) Matthew Wakeling (12:32)
• 18 May 2008
  • Re: Strange behavior: pgbench and new Linux kernels Greg Smith (16:25)
  • Re: I/O on select count(*) Greg Smith (05:48)
• 17 May 2008
  • Re: I/O on select count(*) Jeremy Harris (13:14)
  • Re: I/O on select count(*) Tom Lane (02:45)
• 16 May 2008
  • Re: Regexps - never completing join. Scott Marlowe (21:44)
  • Re: Regexps - never completing join. Rusty Conover (21:37)
  • Re: Please ignore ... Alvaro Herrera (21:03)
  • Re: I/O on select count(*) Alvaro Herrera (21:01)
  • Re: Regexps - never completing join. Scott Marlowe (20:35)
  • Re: I/O on select count(*) Alvaro Herrera (20:15)
  • Re: very slow left join Craig Ringer (19:25)
  • Re: very slow left join Ben (18:43)
  • Re: very slow left join Scott Marlowe (18:27)
  • Re: I/O on select count(*) Simon Riggs (18:22)
  • Re: very slow left join Ben (18:21)
  • Re: very slow left join Scott Marlowe (18:09)
  • Re: I/O on select count(*) Greg Smith (18:06)
  • very slow left join Ben (17:56)
  • Re: which ext3 fs type should I use for postgresql Joshua D. Drake (17:14)
  • Re: which ext3 fs type should I use for postgresql Scott Marlowe (17:07)
  • Re: which ext3 fs type should I use for postgresql david (09:52)
  • Re: Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter (08:50)
  • Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Luke Lonergan (08:47)
  • Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Richard Huxton (08:33)
  • Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Richard Huxton (08:32)
  • Re: Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter (08:27)
  • Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Richard Huxton (08:19)
  • Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Simon Riggs (08:18)
  • Re: Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter (08:10)
  • Re: Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter (08:08)
  • Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Claus Guttesen (08:08)
  • Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter (06:43)
• 15 May 2008
  • Re: I/O on select count(*) Kevin Grittner (22:38)
  • Re: I/O on select count(*) Gregory Stark (22:30)
  • Re: I/O on select count(*) James Mansion (22:07)
  • Re: I/O on select count(*) Robert Lor (21:21)
  • Re: Update performance degrades over time Subbiah Stalin-XCGF84 (19:27)
  • Re: I/O on select count(*) Tom Lane (17:42)
  • Re: I/O on select count(*) Robert Lor (16:53)
  • Re: Update performance degrades over time Subbiah Stalin-XCGF84 (16:28)
  • Re: I/O on select count(*) Tom Lane (16:19)
  • Re: which ext3 fs type should I use for postgresql Guillaume Cottenceau (15:56)
  • Re: I/O on select count(*) Alvaro Herrera (15:52)
  • Re: I/O on select count(*) Alvaro Herrera (15:49)
  • Re: which ext3 fs type should I use for postgresql Joshua D. Drake (15:38)
  • Re: which ext3 fs type should I use for postgresql Guillaume Cottenceau (15:32)
  • Re: which ext3 fs type should I use for postgresql Matthew Wakeling (15:21)
  • Re: I/O on select count(*) Matthew Wakeling (15:17)
  • Re: I/O on select count(*) Heikki Linnakangas (15:16)
  • Re: I/O on select count(*) Heikki Linnakangas (15:08)
  • Re: which ext3 fs type should I use for postgresql Guillaume Cottenceau (15:08)
  • Re: which ext3 fs type should I use for postgresql Craig James (14:59)
  • Re: I/O on select count(*) Tom Lane (14:57)
  • Re: I/O on select count(*) Alvaro Herrera (14:41)
  • Re: Update performance degrades over time Jeffrey Baker (13:57)
  • Re: I/O on select count(*) Ron Mayer (13:51)
  • Re: I/O on select count(*) Matthew Wakeling (13:39)
  • Re: I/O on select count(*) Jan de Visser (13:15)
  • Re: I/O on select count(*) Matthew Wakeling (12:55)
  • Re: I/O on select count(*) Heikki Linnakangas (12:54)
  • Re: I/O on select count(*) Matthew Wakeling (12:40)
  • Re: which ext3 fs type should I use for postgresql Matthew Wakeling (12:24)

• Thread Index
• [Prev Page]
• [Next Page]