pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 9.0 has a bias against indexes
2011-01-27 15:41 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 15:45 UTC Kenneth Marshall <ktm@rice.edu>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 15:49 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 15:51 UTC J Sisson <sisson.j@gmail.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 15:56 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 15:57 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 16:09 UTC David Wilson <david.t.wilson@gmail.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 16:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 17:00 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 20:10 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 20:31 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 20:37 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 20:44 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 20:59 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 21:12 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 21:16 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 21:18 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 21:20 UTC Kenneth Marshall <ktm@rice.edu>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 21:25 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 21:31 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 21:32 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 21:33 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 21:33 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Postgres 9.0 has a bias against indexes
2011-01-27 21:43 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[24+ messages in thread]
Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 10:59 UTC A B <gentosaker@gmail.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 11:11 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 11:14 UTC Thom Brown <thom@linux.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 11:15 UTC Thom Brown <thom@linux.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 11:23 UTC Szymon Guz <mabewlun@gmail.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 11:24 UTC A B <gentosaker@gmail.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 11:27 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 11:30 UTC Marti Raudsepp <marti@juffo.org>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 11:32 UTC A B <gentosaker@gmail.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 11:36 UTC A B <gentosaker@gmail.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 11:36 UTC Marti Raudsepp <marti@juffo.org>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 11:41 UTC Thom Brown <thom@linux.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 12:06 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 12:08 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 12:12 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 12:26 UTC Lello, Nick <nick.lello@rentrakmail.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 15:13 UTC Chris Browne <cbbrowne@acm.org>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 15:23 UTC Devrim GÜNDÜZ <devrim@gunduz.org>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-05 16:25 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-07 00:21 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-08 15:57 UTC Dimitri Fontaine <dimitri@2ndQuadrant.fr>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-08 15:58 UTC Klaus Ita <klaus@worstofall.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-15 15:06 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-15 19:27 UTC Andy Colson <andy@squeakycode.net>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2010-11-15 19:36 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2011-01-19 17:07 UTC Bruce Momjian <bruce@momjian.us>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2011-01-19 17:27 UTC Fabrízio de Royes Mello <fabriziomello@gmail.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2011-01-20 15:25 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2011-01-26 01:32 UTC Bruce Momjian <bruce@momjian.us>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2011-01-27 16:51 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Running PostgreSQL as fast as possible no matter the consequences
2011-01-27 17:07 UTC Bruce Momjian <bruce@momjian.us>
[31+ messages in thread]
Real vs Int performance
2011-01-26 19:31 UTC David Greco <David_Greco@harte-hanks.com>
` Re: Real vs Int performance
2011-01-26 21:52 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Real vs Int performance
2011-01-26 22:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Real vs Int performance
2011-01-27 13:48 UTC David Greco <David_Greco@harte-hanks.com>
` Re: Real vs Int performance
2011-01-27 14:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Real vs Int performance
2011-01-27 14:30 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Real vs Int performance
2011-01-27 15:11 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Real vs Int performance
2011-01-27 16:17 UTC Igor Neyman <ineyman@perceptron.com>
[8+ messages in thread]
Why I lost the last pg_xlog file?
2011-01-27 12:10 UTC Waldomiro <waldomiro@shx.com.br>
` Re: Why I lost the last pg_xlog file?
2011-01-27 14:17 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Why I lost the last pg_xlog file?
2011-01-27 14:51 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[3+ messages in thread]
anti-join chosen even when slower than old plan
2010-11-09 21:18 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: anti-join chosen even when slower than old plan
2010-11-09 23:07 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: anti-join chosen even when slower than old plan
2010-11-09 23:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join chosen even when slower than old plan
2010-11-09 23:24 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: anti-join chosen even when slower than old plan
2010-11-10 00:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join chosen even when slower than old plan
2010-11-10 05:36 UTC Grzegorz Jaśkiewicz <gryzman@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-10 12:38 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: anti-join chosen even when slower than old plan
2010-11-10 15:15 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: anti-join chosen even when slower than old plan
2010-11-10 15:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join chosen even when slower than old plan
2010-11-10 22:07 UTC Robert Haas <robertmhaas@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-10 22:43 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: anti-join chosen even when slower than old plan
2010-11-10 23:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join chosen even when slower than old plan
2010-11-11 03:47 UTC Robert Haas <robertmhaas@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 05:14 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 08:01 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 13:51 UTC Kenneth Marshall <ktm@rice.edu>
` Re: anti-join chosen even when slower than old plan
2010-11-11 14:15 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 14:28 UTC Kenneth Marshall <ktm@rice.edu>
` Re: anti-join chosen even when slower than old plan
2010-11-11 15:00 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: anti-join chosen even when slower than old plan
2010-11-11 17:05 UTC Bob Lunney <bob_lunney@yahoo.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 17:13 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 17:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join chosen even when slower than old plan
2010-11-11 17:55 UTC Craig James <craig_james@emolecules.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 17:57 UTC Robert Haas <robertmhaas@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 18:11 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 18:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join chosen even when slower than old plan
2010-11-11 18:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join chosen even when slower than old plan
2010-11-11 19:02 UTC Robert Haas <robertmhaas@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 19:05 UTC Robert Haas <robertmhaas@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 19:15 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: anti-join chosen even when slower than old plan
2010-11-11 19:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join chosen even when slower than old plan
2010-11-11 19:22 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: anti-join chosen even when slower than old plan
2010-11-11 19:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join chosen even when slower than old plan
2010-11-11 19:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join chosen even when slower than old plan
2010-11-11 19:47 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: anti-join chosen even when slower than old plan
2010-11-11 19:50 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: anti-join chosen even when slower than old plan
2010-11-11 19:52 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: anti-join chosen even when slower than old plan
2010-11-11 20:11 UTC Andres Freund <andres@anarazel.de>
` Re: anti-join chosen even when slower than old plan
2010-11-11 20:29 UTC Robert Haas <robertmhaas@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-11 20:56 UTC gnuoytr@rcn.com
` Re: anti-join chosen even when slower than old plan
2010-11-11 21:28 UTC Kenneth Marshall <ktm@rice.edu>
` Re: anti-join chosen even when slower than old plan
2010-11-12 09:07 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-12 09:15 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-12 10:10 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-12 10:56 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-12 12:06 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-12 12:40 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-12 16:30 UTC Robert Haas <robertmhaas@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-12 16:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join chosen even when slower than old plan
2010-11-12 18:57 UTC Robert Haas <robertmhaas@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-13 05:44 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-13 09:32 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: anti-join chosen even when slower than old plan
2010-11-13 16:15 UTC bricklen <bricklen@gmail.com>
` Re: anti-join chosen even when slower than old plan
2010-11-14 00:20 UTC Robert Haas <robertmhaas@gmail.com>
` Re: anti-join chosen even when slower than old plan
2011-01-19 19:47 UTC Bruce Momjian <bruce@momjian.us>
` Re: anti-join chosen even when slower than old plan
2011-01-19 20:03 UTC Bruce Momjian <bruce@momjian.us>
` Re: anti-join chosen even when slower than old plan
2011-01-19 20:04 UTC Bruce Momjian <bruce@momjian.us>
` Re: anti-join chosen even when slower than old plan
2011-01-20 09:17 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: anti-join chosen even when slower than old plan
2011-01-20 14:19 UTC Robert Haas <robertmhaas@gmail.com>
` Re: anti-join chosen even when slower than old plan
2011-01-20 16:16 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: anti-join chosen even when slower than old plan
2011-01-20 16:36 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: anti-join chosen even when slower than old plan
2011-01-27 01:40 UTC Bruce Momjian <bruce@momjian.us>
[62+ messages in thread]
Bloat issue on 8.3; autovac ignores HOT page splits?
2011-01-25 02:26 UTC Josh Berkus <josh@agliodbs.com>
` Re: Bloat issue on 8.3; autovac ignores HOT page splits?
2011-01-25 16:41 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Bloat issue on 8.3; autovac ignores HOT page splits?
2011-01-25 18:28 UTC Josh Berkus <josh@agliodbs.com>
` Re: Bloat issue on 8.3; autovac ignores HOT page splits?
2011-01-25 21:29 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[4+ messages in thread]
Fun little performance IMPROVEMENT...
2011-01-21 18:12 UTC grant@amadensor.com
` Re: Fun little performance IMPROVEMENT...
2011-01-21 18:29 UTC Andy Colson <andy@squeakycode.net>
` Re: Fun little performance IMPROVEMENT...
2011-01-21 19:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Fun little performance IMPROVEMENT...
2011-01-21 20:18 UTC grant@amadensor.com
` Re: Fun little performance IMPROVEMENT...
2011-01-21 20:19 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Fun little performance IMPROVEMENT...
2011-01-21 20:23 UTC grant@amadensor.com
` Re: Fun little performance IMPROVEMENT...
2011-01-21 21:10 UTC Scott Carey <scott@richrelevance.com>
` Re: Fun little performance IMPROVEMENT...
2011-01-21 21:24 UTC grant@amadensor.com
` Re: Fun little performance IMPROVEMENT...
2011-01-21 21:26 UTC grant@amadensor.com
` Re: Fun little performance IMPROVEMENT...
2011-01-25 15:27 UTC Ivan Voras <ivoras@freebsd.org>
[10+ messages in thread]
Possible to improve query plan?
2011-01-17 03:21 UTC Jeremy Palmer <JPalmer@linz.govt.nz>
` Re: Possible to improve query plan?
2011-01-17 04:22 UTC Andy Colson <andy@squeakycode.net>
` Possible to improve query plan?
2011-01-17 04:43 UTC Jeremy Palmer <JPalmer@linz.govt.nz>
` Re: Possible to improve query plan?
2011-01-17 04:57 UTC Andy Colson <andy@squeakycode.net>
` Re: Possible to improve query plan?
2011-01-17 05:13 UTC Jeremy Palmer <JPalmer@linz.govt.nz>
` Re: Possible to improve query plan?
2011-01-17 08:44 UTC Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re: Possible to improve query plan?
2011-01-17 13:37 UTC Ing. Marcos Ortiz Valmaseda <mlortiz@uci.cu>
` Re: Possible to improve query plan?
2011-01-17 16:48 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Possible to improve query plan?
2011-01-17 20:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Possible to improve query plan?
2011-01-17 20:52 UTC Jeremy Palmer <JPalmer@linz.govt.nz>
` Re: Possible to improve query plan?
2011-01-17 21:01 UTC Jeremy Palmer <JPalmer@linz.govt.nz>
` Re: Possible to improve query plan?
2011-01-17 22:11 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Possible to improve query plan?
2011-01-24 16:33 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Possible to improve query plan?
2011-01-24 16:50 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Possible to improve query plan?
2011-01-24 17:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Possible to improve query plan?
2011-01-24 17:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Possible to improve query plan?
2011-01-24 17:38 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Possible to improve query plan?
2011-01-24 21:55 UTC Jeremy Palmer <JPalmer@linz.govt.nz>
` Re: Possible to improve query plan?
2011-01-24 23:54 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Possible to improve query plan?
2011-01-25 00:01 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Possible to improve query plan?
2011-01-25 00:24 UTC Jeremy Palmer <JPalmer@linz.govt.nz>
` Re: Possible to improve query plan?
2011-01-25 13:44 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
[22+ messages in thread]
How to use indexes for GROUP BY
2011-01-24 18:29 UTC Dimi Paun <dimi@lattica.com>
` Re: How to use indexes for GROUP BY
2011-01-24 19:27 UTC Shaun Thomas <sthomas@peak6.com>
` Re: How to use indexes for GROUP BY
2011-01-24 19:33 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: How to use indexes for GROUP BY
2011-01-24 20:07 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: How to use indexes for GROUP BY
2011-01-25 05:03 UTC Dimi Paun <dimi@lattica.com>
[5+ messages in thread]
"NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-17 15:35 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-17 16:47 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-17 16:52 UTC Ing. Marcos Ortiz Valmaseda <mlortiz@uci.cu>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-18 08:06 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-18 14:26 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-19 09:10 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-19 17:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-20 07:05 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-21 17:09 UTC Robert Haas <robertmhaas@gmail.com>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-21 17:42 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-21 17:51 UTC Robert Haas <robertmhaas@gmail.com>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-21 18:12 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-21 19:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-21 20:00 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-21 20:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
2011-01-24 15:40 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
[16+ messages in thread]
Best way to get the latest revision from a table
2011-01-14 21:17 UTC Nikolas Everett <nik9000@gmail.com>
` Re: Best way to get the latest revision from a table
2011-01-14 22:30 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Best way to get the latest revision from a table
2011-01-14 22:40 UTC Nikolas Everett <nik9000@gmail.com>
` Re: Best way to get the latest revision from a table
2011-01-14 22:57 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Best way to get the latest revision from a table
2011-01-14 23:06 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Best way to get the latest revision from a table
2011-01-14 23:33 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Best way to get the latest revision from a table
2011-01-14 23:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Best way to get the latest revision from a table
2011-01-15 00:59 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Best way to get the latest revision from a table
2011-01-15 01:50 UTC Nikolas Everett <nik9000@gmail.com>
` Re: Best way to get the latest revision from a table
2011-01-15 19:54 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Best way to get the latest revision from a table
2011-01-15 19:58 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Best way to get the latest revision from a table
2011-01-21 17:13 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Best way to get the latest revision from a table
2011-01-21 18:55 UTC Nikolas Everett <nik9000@gmail.com>
[13+ messages in thread]
the XID question
2011-01-19 09:19 UTC Charles.Hou <givemeegn@gmail.com>
` Re: the XID question
2011-01-19 10:21 UTC Charles.Hou <givemeegn@gmail.com>
` Re: the XID question
2011-01-19 12:00 UTC Filip Rembiałkowski <plk.zuber@gmail.com>
` Re: the XID question
2011-01-19 14:39 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: the XID question
2011-01-19 14:54 UTC Charles.Hou <givemeegn@gmail.com>
` Re: the XID question
2011-01-19 18:06 UTC Chris Browne <cbbrowne@acm.org>
` Re: the XID question
2011-01-19 18:31 UTC Andres Freund <andres@anarazel.de>
` Re: the XID question
2011-01-19 18:41 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: the XID question
2011-01-19 22:46 UTC Greg Smith <greg@2ndquadrant.com>
` Re: the XID question
2011-01-20 07:26 UTC Charles.Hou <givemeegn@gmail.com>
` Re: the XID question
2011-01-20 17:04 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: the XID question
2011-01-21 17:49 UTC Robert Haas <robertmhaas@gmail.com>
[12+ messages in thread]
hashed subplan 5000x slower than two sequential operations
2010-12-08 18:53 UTC Bryce Nesbitt <bryce2@obviously.com>
` Re: hashed subplan 5000x slower than two sequential operations
2010-12-08 19:05 UTC Shrirang Chitnis <Shrirang.Chitnis@hovservices.com>
` Re: hashed subplan 5000x slower than two sequential operations
2010-12-08 20:05 UTC Bryce Nesbitt <bryce2@obviously.com>
` Re: hashed subplan 5000x slower than two sequential operations
2010-12-08 20:06 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: hashed subplan 5000x slower than two sequential operations
2010-12-08 20:12 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: hashed subplan 5000x slower than two sequential operations
2010-12-08 20:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: hashed subplan 5000x slower than two sequential operations
2010-12-08 20:25 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: hashed subplan 5000x slower than two sequential operations
2010-12-08 20:31 UTC Bryce Nesbitt <bryce2@obviously.com>
` Re: hashed subplan 5000x slower than two sequential operations
2010-12-08 20:33 UTC Bryce Nesbitt <bryce2@obviously.com>
` Re: hashed subplan 5000x slower than two sequential operations
2011-01-18 18:56 UTC masterchief <esimon@theiqgroup.com>
` Re: hashed subplan 5000x slower than two sequential operations
2011-01-18 21:29 UTC Віталій Тимчишин <tivv00@gmail.com>
[11+ messages in thread]
Bad plan when join on function
2011-01-17 08:03 UTC Zotov <zotov@oe-it.ru>
` Re: Bad plan when join on function
2011-01-17 20:12 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Bad plan when join on function
2011-01-17 20:51 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Bad plan when join on function
2011-01-17 21:24 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Bad plan when join on function
2011-01-17 21:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad plan when join on function
2011-01-17 21:37 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Bad plan when join on function
2011-01-18 14:15 UTC Shaun Thomas <sthomas@peak6.com>
[7+ messages in thread]
The good, old times
2011-01-12 13:49 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: The good, old times
2011-01-12 14:16 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: The good, old times
2011-01-14 06:02 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: The good, old times
2011-01-14 16:54 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: The good, old times
2011-01-15 13:36 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: The good, old times
2011-01-16 06:50 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: The good, old times
2011-01-18 08:43 UTC Devrim GÜNDÜZ <devrim@gunduz.org>
` Re: The good, old times
2011-01-18 08:57 UTC Dave Page <dpage@pgadmin.org>
[8+ messages in thread]
Problem with query
2011-01-15 17:56 UTC Barbara Woolums <barb.woolums@ymail.com>
` Re: Problem with query
2011-01-17 23:42 UTC Fernando Hevia <fhevia@gmail.com>
[2+ messages in thread]
queries with lots of UNIONed relations
2011-01-13 15:51 UTC Jon Nelson <jnelson@jamponi.net>
` queries with lots of UNIONed relations
2011-01-13 15:55 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: queries with lots of UNIONed relations
2011-01-13 17:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: queries with lots of UNIONed relations
2011-01-13 19:54 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: queries with lots of UNIONed relations
2011-01-13 20:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: queries with lots of UNIONed relations
2011-01-13 20:12 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: queries with lots of UNIONed relations
2011-01-13 21:44 UTC Robert Haas <robertmhaas@gmail.com>
` Re: queries with lots of UNIONed relations
2011-01-13 22:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: queries with lots of UNIONed relations
2011-01-13 22:41 UTC Robert Haas <robertmhaas@gmail.com>
` Re: queries with lots of UNIONed relations
2011-01-13 22:42 UTC Robert Haas <robertmhaas@gmail.com>
` Re: queries with lots of UNIONed relations
2011-01-13 22:47 UTC Andy Colson <andy@squeakycode.net>
` Re: queries with lots of UNIONed relations
2011-01-13 22:49 UTC Robert Haas <robertmhaas@gmail.com>
` Re: queries with lots of UNIONed relations
2011-01-13 22:52 UTC Andy Colson <andy@squeakycode.net>
` Re: queries with lots of UNIONed relations
2011-01-13 22:53 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: queries with lots of UNIONed relations
2011-01-13 23:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: queries with lots of UNIONed relations
2011-01-13 23:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: queries with lots of UNIONed relations
2011-01-13 23:14 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: queries with lots of UNIONed relations
2011-01-14 00:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: queries with lots of UNIONed relations
2011-01-14 03:19 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: queries with lots of UNIONed relations
2011-01-14 11:39 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: queries with lots of UNIONed relations
2011-01-14 20:11 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: queries with lots of UNIONed relations
2011-01-15 18:15 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
[22+ messages in thread]
"COPY TO stdout" statements occurrence in log files
2011-01-14 19:42 UTC Fernando Mertins <fernando.mertins@gmail.com>
` Re: "COPY TO stdout" statements occurrence in log files
2011-01-14 20:27 UTC Maciek Sakrejda <msakrejda@truviso.com>
` Re: "COPY TO stdout" statements occurrence in log files
2011-01-14 21:19 UTC Chris Browne <cbbrowne@acm.org>
` Re: "COPY TO stdout" statements occurrence in log files
2011-01-14 22:42 UTC Marti Raudsepp <marti@juffo.org>
[4+ messages in thread]
"SELECT .. WHERE NOT IN" query running for hours
2011-01-07 02:36 UTC Ãéùñãïò Âáëêáíáò <lebiathan@gmail.com>
` Re: "SELECT .. WHERE NOT IN" query running for hours
2011-01-07 04:25 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: "SELECT .. WHERE NOT IN" query running for hours
2011-01-07 09:29 UTC Ãéùñãïò Âáëêáíáò <lebiathan@gmail.com>
` Re: "SELECT .. WHERE NOT IN" query running for hours
2011-01-10 17:28 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: "SELECT .. WHERE NOT IN" query running for hours
2011-01-10 20:24 UTC Scott Carey <scott@richrelevance.com>
` Re: "SELECT .. WHERE NOT IN" query running for hours
2011-01-10 20:37 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: "SELECT .. WHERE NOT IN" query running for hours
2011-01-10 21:05 UTC Scott Carey <scott@richrelevance.com>
` Re: "SELECT .. WHERE NOT IN" query running for hours
2011-01-14 19:01 UTC Robert Haas <robertmhaas@gmail.com>
[8+ messages in thread]
plan question - query with order by and limit not choosing index depends on size of limit, table
2011-01-05 22:57 UTC Mike Broers <mbroers@gmail.com>
` Re: plan question - query with order by and limit not choosing index depends on size of limit, table
2011-01-05 23:10 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: plan question - query with order by and limit not choosing index depends on size of limit, table
2011-01-06 21:36 UTC Mike Broers <mbroers@gmail.com>
` Re: plan question - query with order by and limit not choosing index depends on size of limit, table
2011-01-07 14:00 UTC pasman pasmański <pasman.p@gmail.com>
` Re: plan question - query with order by and limit not choosing index depends on size of limit, table
2011-01-10 16:21 UTC Mike Broers <mbroers@gmail.com>
` Re: plan question - query with order by and limit not choosing index depends on size of limit, table
2011-01-14 16:36 UTC Mike Broers <mbroers@gmail.com>
` Re: plan question - query with order by and limit not choosing index depends on size of limit, table
2011-01-14 18:03 UTC Robert Haas <robertmhaas@gmail.com>
[7+ messages in thread]
adding foreign key constraint locks up table
2010-12-28 07:08 UTC kakarukeys <kakarukeys@gmail.com>
` Re: adding foreign key constraint locks up table
2010-12-28 13:34 UTC Lew <noone@lewscanon.com>
` Re: adding foreign key constraint locks up table
2010-12-28 13:37 UTC Gurjeet Singh <singh.gurjeet@gmail.com>
` Re: adding foreign key constraint locks up table
2010-12-28 13:55 UTC kakarukeys <kakarukeys@gmail.com>
` Re: adding foreign key constraint locks up table
2010-12-28 14:43 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: adding foreign key constraint locks up table
2010-12-28 14:56 UTC Gurjeet Singh <singh.gurjeet@gmail.com>
` Re: adding foreign key constraint locks up table
2010-12-28 14:57 UTC Florian Weimer <fweimer@bfk.de>
` Re: adding foreign key constraint locks up table
2010-12-28 15:01 UTC Gurjeet Singh <singh.gurjeet@gmail.com>
` Re: adding foreign key constraint locks up table
2010-12-28 15:07 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: adding foreign key constraint locks up table
2010-12-28 15:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: adding foreign key constraint locks up table
2011-01-04 13:52 UTC Florian Weimer <fweimer@bfk.de>
` Re: adding foreign key constraint locks up table
2011-01-04 15:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: adding foreign key constraint locks up table
2011-01-05 07:09 UTC kakarukeys <kakarukeys@gmail.com>
` Re: adding foreign key constraint locks up table
2011-01-09 03:34 UTC Robert Haas <robertmhaas@gmail.com>
` Re: adding foreign key constraint locks up table
2011-01-13 15:33 UTC kakarukeys <kakarukeys@gmail.com>
[15+ messages in thread]
Slow query + why bitmap index scan??
2011-01-12 12:14 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Slow query + why bitmap index scan??
2011-01-12 13:42 UTC Florian Weimer <fweimer@bfk.de>
` Re: Slow query + why bitmap index scan??
2011-01-12 14:21 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Slow query + why bitmap index scan??
2011-01-12 14:26 UTC Kenneth Marshall <ktm@rice.edu>
` Re: Slow query + why bitmap index scan??
2011-01-12 14:36 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Slow query + why bitmap index scan??
2011-01-12 15:20 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Slow query + why bitmap index scan??
2011-01-12 16:31 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Slow query + why bitmap index scan??
2011-01-12 20:09 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
[8+ messages in thread]
Performance test of Oracle and PostgreSQL using same binary
2011-01-12 06:54 UTC Divakar Singh <dpsmails@yahoo.com>
` Re: Performance test of Oracle and PostgreSQL using same binary
2011-01-12 17:11 UTC Jeff Janes <jeff.janes@gmail.com>
[2+ messages in thread]
How to turn autovacuum prevent wrap around run faster?
2010-12-28 05:53 UTC marc.hsiao <marc.hsiao@cobrasonic.com>
` Re: How to turn autovacuum prevent wrap around run faster?
2010-12-28 06:11 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: How to turn autovacuum prevent wrap around run faster?
2011-01-03 02:01 UTC marc.hsiao <marc.hsiao@cobrasonic.com>
` Re: How to turn autovacuum prevent wrap around run faster?
2011-01-07 03:57 UTC marc47marc47 <marc47marc47@gmail.com>
` Re: How to turn autovacuum prevent wrap around run faster?
2011-01-07 08:14 UTC marc.hsiao <marc.hsiao@cobrasonic.com>
` Re: How to turn autovacuum prevent wrap around run faster?
2011-01-12 08:21 UTC marc.hsiao <marc.hsiao@cobrasonic.com>
[6+ messages in thread]
Performance of PostgreSQL over NFS
2010-12-21 19:28 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Performance of PostgreSQL over NFS
2010-12-21 20:31 UTC Rich <rhdyes@gmail.com>
` Re: Performance of PostgreSQL over NFS
2010-12-21 22:46 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Performance of PostgreSQL over NFS
2011-01-04 02:28 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Performance of PostgreSQL over NFS
2011-01-12 01:43 UTC Jignesh Shah <jkshah@gmail.com>
[5+ 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