pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPlanner 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