pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Planner mis-estimation using nested loops followup
  2008-03-18 15:35 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Planner mis-estimation using nested loops followup
  2008-03-18 15:50 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Planner mis-estimation using nested loops followup
  2008-03-18 15:58 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Planner mis-estimation using nested loops followup
  2008-03-18 16:24 UTC  Matthew <matthew@flymine.org>
` Re: Planner mis-estimation using nested loops followup
  2008-03-18 19:46 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Planner mis-estimation using nested loops followup
  2008-03-18 21:26 UTC  Stephen Denne <Stephen.Denne@datamail.co.nz>
` Re: Planner mis-estimation using nested loops followup
  2008-03-19 00:00 UTC  KC ESL <kclesl@gmail.com>
  [7+ messages in thread]

Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 04:55 UTC  Craig James <craig_james@emolecules.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 05:31 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 05:55 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 08:11 UTC  Justin Graf <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 12:11 UTC  Doug Knight <dknight@wsi.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 13:11 UTC  Will Weaver <will@myemma.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 13:55 UTC  Justin Graf <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 14:29 UTC  Craig James <craig_james@emolecules.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 14:36 UTC  Craig James <craig_james@emolecules.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 14:54 UTC  Craig James <craig_james@emolecules.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 16:01 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 21:06 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 21:09 UTC  justin <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 21:27 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-13 22:53 UTC  justin <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-14 06:09 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-14 06:12 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-14 06:17 UTC  Jesper Krogh <jesper@krogh.cc>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-14 06:19 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-14 06:23 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-14 06:29 UTC  Jesper Krogh <jesper@krogh.cc>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-14 08:19 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-14 08:31 UTC  Justin <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-14 10:49 UTC  Justin <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-14 15:16 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-16 06:19 UTC  Justin <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-16 11:25 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-16 19:04 UTC  Craig James <craig_james@emolecules.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-16 19:08 UTC  Craig James <craig_james@emolecules.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-16 19:36 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-16 20:56 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 07:14 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 07:36 UTC  Justin <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 08:02 UTC  Andrej Ricnik-Bay <andrej.groups@gmail.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 09:11 UTC  Tino Wildenhain <tino@wildenhain.de>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 16:31 UTC  Justin <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 18:12 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 18:33 UTC  Craig James <craig_james@emolecules.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 18:50 UTC  Justin <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 19:12 UTC  Justin <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 19:38 UTC  Justin <justin@emproshunts.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 20:58 UTC  Enrico Sirola <enrico.sirola@gmail.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-17 21:57 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-18 07:08 UTC  James Mansion <james@mansionfamily.plus.com>
` Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  2008-03-18 11:04 UTC  Michael Stone <mstone+postgres@mathom.us>
  [45+ messages in thread]

performance tools
  2008-03-17 07:57 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: performance tools
  2008-03-17 15:26 UTC  Mark Steben <msteben@autorevenue.com>
` Re: performance tools
  2008-03-17 15:46 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: performance tools
  2008-03-17 16:07 UTC  Ben Chobot <bench@silentmedia.com>
` Re: performance tools
  2008-03-17 16:37 UTC  Franck Routier <franck.routier@axege.com>
` Re: performance tools
  2008-03-17 22:06 UTC  Andrej Ricnik-Bay <andrej.groups@gmail.com>
  [6+ messages in thread]

Lots of "semop" calls under load
  2008-03-14 13:50 UTC  Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Lots of "semop" calls under load
  2008-03-14 16:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Lots of "semop" calls under load
  2008-03-17 09:11 UTC  Albe Laurenz <laurenz.albe@wien.gv.at>
  [3+ messages in thread]

Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 09:55 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 11:01 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 11:29 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 12:16 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 14:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 14:48 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 14:53 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 15:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 15:03 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 15:10 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 15:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 16:55 UTC  Rainer Pruy <Rainer.Pruy@Acrys.COM>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-10 22:00 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-11 06:24 UTC  Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Very slow (2 tuples/second) sequential scan afterbulk insert; speed returns to ~500 tuples/second after commit
  2008-03-11 09:58 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-11 12:34 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-11 13:06 UTC  Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-11 13:29 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-11 21:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-12 13:43 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-12 15:47 UTC  Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-12 15:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-12 17:02 UTC  Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-12 17:14 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-12 17:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-12 17:26 UTC  Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-12 17:33 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-12 17:48 UTC  Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-17 02:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
  2008-03-17 02:21 UTC  Bruce Momjian <bruce@momjian.us>
  [30+ messages in thread]

Re: best way to run maintenance script
  2008-03-15 00:32 UTC  Joshua D. Drake <jd@commandprompt.com>
` best way to run maintenance script
  2008-03-15 01:00 UTC  Vinubalaji Gopal <vgopal@abaca.com>
` Re: best way to run maintenance script
  2008-03-15 01:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: best way to run maintenance script
  2008-03-15 01:51 UTC  Vinubalaji Gopal <vgopal@abaca.com>
` Re: best way to run maintenance script
  2008-03-15 02:17 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: best way to run maintenance script
  2008-03-15 04:28 UTC  Vinubalaji Gopal <vgopal@abaca.com>
` Re: best way to run maintenance script
  2008-03-15 05:07 UTC  Vinubalaji Gopal <vgopal@abaca.com>
` Re: best way to run maintenance script
  2008-03-15 12:46 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: best way to run maintenance script
  2008-03-16 18:11 UTC  Peter Eisentraut <peter_e@gmx.net>
  [9+ messages in thread]

Adaptec 5805 SAS Raid
  2008-03-14 17:20 UTC  Glyn Astill <glynastill@yahoo.co.uk>
` Re: Adaptec 5805 SAS Raid
  2008-03-14 22:34 UTC  Leigh Dyer <leigh@eclinic.com.au>
  [2+ messages in thread]

The "many nulls" problem
  2008-03-14 18:05 UTC  Kynn Jones <kynnjo@gmail.com>
` Re: The "many nulls" problem
  2008-03-14 18:59 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: The "many nulls" problem
  2008-03-14 19:46 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: The "many nulls" problem
  2008-03-14 20:05 UTC  Kynn Jones <kynnjo@gmail.com>
` Re: The "many nulls" problem
  2008-03-14 20:06 UTC  Kynn Jones <kynnjo@gmail.com>
` Re: The "many nulls" problem
  2008-03-14 20:30 UTC  Oleg Bartunov <oleg@sai.msu.su>
  [6+ messages in thread]

Hardware question for a DB server
  2008-03-12 18:58 UTC  Pascal Cohen <pcohen@wimba.com>
` Re: Hardware question for a DB server
  2008-03-12 19:23 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: Hardware question for a DB server
  2008-03-12 19:42 UTC  Pascal Cohen <pcohen@wimba.com>
` Re: Hardware question for a DB server
  2008-03-12 20:08 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Hardware question for a DB server
  2008-03-14 19:24 UTC  Pascal Cohen <pcohen@wimba.com>
` Re: Hardware question for a DB server
  2008-03-14 19:43 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [6+ messages in thread]

ER diagram tool
  2008-03-13 13:24 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: ER diagram tool
  2008-03-13 13:32 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: ER diagram tool
  2008-03-13 19:43 UTC  Andrej Ricnik-Bay <andrej.groups@gmail.com>
` Re: ER diagram tool
  2008-03-14 10:20 UTC  Jurgen Haan <jurgen@easyflex.nl>
` Re: ER diagram tool
  2008-03-14 11:35 UTC  sathiya psql <sathiya.psql@gmail.com>
  [5+ messages in thread]

8.3 write performance
  2008-03-12 15:25 UTC  Enrico Sirola <enrico.sirola@gmail.com>
` Re: 8.3 write performance
  2008-03-14 10:17 UTC  Enrico Sirola <enrico.sirola@gmail.com>
  [2+ messages in thread]

Recomendations on raid controllers raid 1+0
  2008-03-13 12:33 UTC  Glyn Astill <glynastill@yahoo.co.uk>
` Re: Recomendations on raid controllers raid 1+0
  2008-03-13 15:58 UTC  Guillaume Smet <guillaume.smet@gmail.com>
` Re: Recomendations on raid controllers raid 1+0
  2008-03-13 16:10 UTC  Glyn Astill <glynastill@yahoo.co.uk>
` Re: Recomendations on raid controllers raid 1+0
  2008-03-13 23:14 UTC  Leigh Dyer <leigh@eclinic.com.au>
` Re: Recomendations on raid controllers raid 1+0
  2008-03-14 05:53 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [5+ messages in thread]

temp tables
  2008-03-13 22:08 UTC  James Mansion <james@mansionfamily.plus.com>
` Re: temp tables
  2008-03-14 00:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Repeated execution of identical subqueries
  2008-03-13 03:37 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: Repeated execution of identical subqueries
  2008-03-13 05:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Repeated execution of identical subqueries
  2008-03-13 06:35 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: Repeated execution of identical subqueries
  2008-03-13 14:06 UTC  Craig James <craig_james@emolecules.com>
  [4+ messages in thread]

partial index + select query performance
  2008-03-13 07:21 UTC  petchimuthu lingam <spmlingam@gmail.com>
` Re: partial index + select query performance
  2008-03-13 07:33 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
  [2+ messages in thread]

Are piped columns indexable
  2008-03-12 20:38 UTC  Mark Steben <msteben@autorevenue.com>
` Re: Are piped columns indexable
  2008-03-12 20:55 UTC  Merlin Moncure <mmoncure@gmail.com>
  [2+ messages in thread]

partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-08-24 08:53 UTC  Anton <anton200@gmail.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-08-24 10:24 UTC  Mikko Partio <mpartio@gmail.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-08-24 10:32 UTC  Anton <anton200@gmail.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-08-24 10:38 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-08-24 16:20 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-08-24 16:25 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-08-27 12:57 UTC  Tomas Tamosaitis <tomas.tamosaitis@connecty.lt>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-08-28 10:20 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-27 04:26 UTC  Anton <anton200@gmail.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-27 05:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-27 08:53 UTC  Anton <anton200@gmail.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-27 09:11 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-27 19:12 UTC  Luke Lonergan <LLonergan@greenplum.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-27 19:28 UTC  Luke Lonergan <LLonergan@greenplum.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-27 21:31 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1
  2007-10-27 21:48 UTC  Luke Lonergan <LLonergan@greenplum.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-28 00:20 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1
  2007-10-28 09:13 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1
  2007-10-28 16:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1
  2007-10-28 17:27 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-29 13:40 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-30 05:06 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-30 05:46 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-30 05:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-30 09:06 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-10-31 14:16 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-11-05 05:49 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-11-05 12:12 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-11-08 02:46 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-11-08 06:21 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-11-08 06:40 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2007-11-08 07:18 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
  2008-03-12 19:16 UTC  Bruce Momjian <bruce@momjian.us>
  [33+ messages in thread]

migration of 7.4 to 8.1
  2008-03-12 05:27 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: migration of 7.4 to 8.1
  2008-03-12 05:32 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: migration of 7.4 to 8.1
  2008-03-12 06:24 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: migration of 7.4 to 8.1
  2008-03-12 06:28 UTC  Chris <dmagick@gmail.com>
` Re: migration of 7.4 to 8.1
  2008-03-12 06:29 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: migration of 7.4 to 8.1
  2008-03-12 06:33 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: migration of 7.4 to 8.1
  2008-03-12 06:36 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: migration of 7.4 to 8.1
  2008-03-12 06:36 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: migration of 7.4 to 8.1
  2008-03-12 06:39 UTC  david@lang.hm
` Re: migration of 7.4 to 8.1
  2008-03-12 06:43 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: migration of 7.4 to 8.1
  2008-03-12 06:49 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: migration of 7.4 to 8.1
  2008-03-12 06:50 UTC  david@lang.hm
` Re: migration of 7.4 to 8.1
  2008-03-12 06:59 UTC  david@lang.hm
` Re: migration of 7.4 to 8.1
  2008-03-12 07:05 UTC  Chris <dmagick@gmail.com>
` Re: migration of 7.4 to 8.1
  2008-03-12 07:22 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: migration of 7.4 to 8.1
  2008-03-12 09:18 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: migration of 7.4 to 8.1
  2008-03-12 14:46 UTC  Vivek Khera <vivek@khera.org>
  [17+ messages in thread]

list user created triggers
  2008-03-11 13:38 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: list user created triggers
  2008-03-12 04:07 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: list user created triggers
  2008-03-12 05:17 UTC  sathiya psql <sathiya.psql@gmail.com>
  [3+ messages in thread]

how many index can have????
  2008-03-11 12:28 UTC  petchimuthu lingam <spmlingam@gmail.com>
` Re: how many index can have????
  2008-03-11 13:46 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: how many index can have????
  2008-03-11 16:04 UTC  Craig Ringer <craig@postnewspapers.com.au>
  [3+ messages in thread]

Joins and DELETE FROM
  2008-03-08 17:31 UTC  Kynn Jones <kynnjo@gmail.com>
` Re: Joins and DELETE FROM
  2008-03-08 18:01 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Joins and DELETE FROM
  2008-03-08 19:02 UTC  Kynn Jones <kynnjo@gmail.com>
` Re: Joins and DELETE FROM
  2008-03-08 20:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Joins and DELETE FROM
  2008-03-08 20:25 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Joins and DELETE FROM
  2008-03-11 15:56 UTC  Kynn Jones <kynnjo@gmail.com>
  [6+ messages in thread]

count * performance issue
  2008-03-06 05:43 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: count * performance issue
  2008-03-06 05:48 UTC  Chris <dmagick@gmail.com>
` Re: count * performance issue
  2008-03-06 06:08 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: count * performance issue
  2008-03-06 06:15 UTC  Shoaib Mir <shoaibmir@gmail.com>
` Re: count * performance issue
  2008-03-06 06:19 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: count * performance issue
  2008-03-06 06:26 UTC  Shoaib Mir <shoaibmir@gmail.com>
` Re: count * performance issue
  2008-03-06 06:26 UTC  Mark Mielke <mark@mark.mielke.cc>
` Re: count * performance issue
  2008-03-06 06:31 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: count * performance issue
  2008-03-06 06:32 UTC  Shoaib Mir <shoaibmir@gmail.com>
` Re: count * performance issue
  2008-03-06 06:36 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: count * performance issue
  2008-03-06 06:43 UTC  sathiya psql <sathiya.psql@gmail.com>
` Fwd: count * performance issue
  2008-03-06 06:48 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: count * performance issue
  2008-03-06 06:54 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: count * performance issue
  2008-03-06 06:57 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: count * performance issue
  2008-03-06 07:06 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: count * performance issue
  2008-03-06 07:18 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: count * performance issue
  2008-03-06 11:50 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: count * performance issue
  2008-03-06 12:13 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: count * performance issue
  2008-03-06 12:43 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: count * performance issue
  2008-03-06 12:48 UTC  Harald Armin Massa <haraldarminmassa@gmail.com>
` Re: count * performance issue
  2008-03-06 12:49 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: count * performance issue
  2008-03-06 12:49 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: count * performance issue
  2008-03-06 13:10 UTC  Mark Mielke <mark@mark.mielke.cc>
` Re: count * performance issue
  2008-03-06 13:18 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: count * performance issue
  2008-03-06 13:27 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: count * performance issue
  2008-03-06 15:28 UTC  Craig James <craig_james@emolecules.com>
` Re: count * performance issue
  2008-03-06 15:33 UTC  Bruce Momjian <bruce@momjian.us>
` Re: count * performance issue
  2008-03-06 15:36 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: count * performance issue
  2008-03-06 15:41 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: count * performance issue
  2008-03-06 15:49 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: count * performance issue
  2008-03-06 16:05 UTC  Dave Page <dpage@pgadmin.org>
` Re: count * performance issue
  2008-03-06 16:16 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: count * performance issue
  2008-03-06 16:31 UTC  D'Arcy J.M. Cain <darcy@druid.net>
` Re: count * performance issue
  2008-03-06 17:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: count * performance issue
  2008-03-07 02:40 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: count * performance issue
  2008-03-07 03:00 UTC  Craig James <craig_james@emolecules.com>
` Re: count * performance issue
  2008-03-07 05:38 UTC  paul rivers <rivers.paul@gmail.com>
` Re: count * performance issue
  2008-03-07 23:51 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: count * performance issue
  2008-03-08 01:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: count * performance issue
  2008-03-08 01:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: count * performance issue
  2008-03-08 05:08 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: count * performance issue
  2008-03-08 05:31 UTC  Mark Mielke <mark@mark.mielke.cc>
` Re: count * performance issue
  2008-03-08 06:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: count * performance issue
  2008-03-08 07:11 UTC  paul rivers <rivers.paul@gmail.com>
` Re: count * performance issue
  2008-03-08 08:04 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: count * performance issue
  2008-03-10 15:16 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: count * performance issue
  2008-03-10 20:54 UTC  Joe Mirabal <jmmirabal@gmail.com>
` Re: count * performance issue
  2008-03-10 21:28 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: count * performance issue
  2008-03-10 21:52 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: count * performance issue
  2008-03-10 22:21 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: count * performance issue
  2008-03-10 23:01 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: count * performance issue
  2008-03-11 02:57 UTC  Robins Tharakan <tharakan@gmail.com>
` Re: count * performance issue
  2008-03-11 03:01 UTC  Mark Mielke <mark@mark.mielke.cc>
` Re: count * performance issue
  2008-03-11 03:08 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: count * performance issue
  2008-03-11 03:11 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: count * performance issue
  2008-03-11 08:34 UTC  Albert Cervera Areny <albert@sedifa.com>
` Re: count * performance issue
  2008-03-11 13:35 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: count * performance issue
  2008-03-11 13:57 UTC  Matthew <matthew@flymine.org>
` Re: count * performance issue
  2008-03-11 14:01 UTC  Tino Wildenhain <tino@wildenhain.de>
` Re: count * performance issue
  2008-03-11 14:19 UTC  Matthew <matthew@flymine.org>
` Re: count * performance issue
  2008-03-11 14:31 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: count * performance issue
  2008-03-11 14:34 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
  [62+ messages in thread]

Re: [PERFORM] Very slow (2 tuples/second) sequentialscan after bulk insert; speed returns to ~500 tuples/second aftercommit
  2008-03-11 14:03 UTC  Heikki Linnakangas <heikki@enterprisedb.com>

UPDATE 66k rows too slow
  2008-03-10 02:21 UTC  Miguel Arroz <arroz@guiamac.com>
` Re: UPDATE 66k rows too slow
  2008-03-10 04:10 UTC  andrew@pillette.com
` Re: UPDATE 66k rows too slow
  2008-03-10 04:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: UPDATE 66k rows too slow
  2008-03-10 05:10 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: UPDATE 66k rows too slow
  2008-03-10 23:17 UTC  Miguel Arroz <arroz@guiamac.com>
` Re: UPDATE 66k rows too slow
  2008-03-10 23:22 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: UPDATE 66k rows too slow
  2008-03-10 23:46 UTC  Miguel Arroz <arroz@guiamac.com>
` Re: UPDATE 66k rows too slow
  2008-03-10 23:56 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: UPDATE 66k rows too slow
  2008-03-11 00:33 UTC  Miguel Arroz <arroz@guiamac.com>
` Re: UPDATE 66k rows too slow
  2008-03-11 04:14 UTC  Greg Smith <gsmith@gregsmith.com>
  [10+ messages in thread]

Nested loop vs merge join: inconsistencies between estimated and actual time
  2008-03-07 05:50 UTC  Vlad Arkhipov <arhipov@dc.baikal.ru>
` Re: Nested loop vs merge join: inconsistencies between estimated and actual time
  2008-03-07 06:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Nested loop vs merge join: inconsistencies between estimated and actual time
  2008-03-11 01:52 UTC  Vlad Arkhipov <arhipov@dc.baikal.ru>
  [3+ messages in thread]


[next (older)]

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox