pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDoes auto-analyze work on dirty writes? (was: Re: [HACKERS] Slow count(*) again...)
2011-02-04 03:31 UTC Mark Mielke <mark@mark.mielke.cc>
` Re: Does auto-analyze work on dirty writes? (was: Re: [HACKERS] Slow count(*) again...)
2011-02-04 15:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Queries becoming slow under heavy load
2011-01-25 21:37 UTC Anne Rosset <arosset@collab.net>
` Re: Queries becoming slow under heavy load
2011-01-25 22:12 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Queries becoming slow under heavy load
2011-01-25 22:12 UTC Andy Colson <andy@squeakycode.net>
` Re: Queries becoming slow under heavy load
2011-01-25 22:27 UTC Ing. Marcos Ortiz Valmaseda <mlortiz@uci.cu>
` Re: Queries becoming slow under heavy load
2011-01-26 13:25 UTC Ivan Voras <ivoras@freebsd.org>
` FW: Queries becoming slow under heavy load
2011-01-26 16:04 UTC Anne Rosset <arosset@collab.net>
` Re: FW: Queries becoming slow under heavy load
2011-01-26 17:16 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Queries becoming slow under heavy load
2011-01-27 02:34 UTC mark <dvlhntr@gmail.com>
` Re: FW: Queries becoming slow under heavy load
2011-01-27 04:18 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: FW: Queries becoming slow under heavy load
2011-01-27 05:07 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: FW: Queries becoming slow under heavy load
2011-01-28 05:12 UTC Anne Rosset <arosset@collab.net>
` Re: FW: Queries becoming slow under heavy load
2011-01-28 15:31 UTC Shaun Thomas <sthomas@peak6.com>
` Re: FW: Queries becoming slow under heavy load
2011-01-28 18:46 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: FW: Queries becoming slow under heavy load
2011-02-03 17:40 UTC Anne Rosset <arosset@collab.net>
` Re: FW: Queries becoming slow under heavy load
2011-02-03 18:22 UTC Scott Marlowe <scott.marlowe@gmail.com>
[15+ messages in thread]
Get master-detail relationship metadata
2011-02-03 11:40 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Get master-detail relationship metadata
2011-02-03 15:26 UTC Andy Colson <andy@squeakycode.net>
[2+ messages in thread]
Server Configuration
2011-02-02 18:15 UTC Cesar Arrieta <cesar.cba@gmail.com>
` Re: Server Configuration
2011-02-02 18:32 UTC Kenneth Marshall <ktm@rice.edu>
` Re: Server Configuration
2011-02-02 19:11 UTC Richard Carnes <Richard.Carnes@cchsfs.com>
` Re: Server Configuration
2011-02-03 02:19 UTC Marcos Ortiz <mlortiz@uci.cu>
[4+ messages in thread]
Are we in the ballpark?
2011-02-02 00:23 UTC Wayne Conrad <wayne@databill.com>
` Re: Are we in the ballpark?
2011-02-02 01:30 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Are we in the ballpark?
2011-02-02 17:06 UTC Wayne Conrad <wayne@databill.com>
` Re: Are we in the ballpark?
2011-02-02 19:51 UTC John Rouillard <rouilj@renesys.com>
[4+ messages in thread]
Configuration for a new server.
2011-01-31 23:55 UTC Benjamin Krajmalnik <kraj@servoyant.com>
` Re: Configuration for a new server.
2011-02-01 11:53 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Configuration for a new server.
2011-02-01 16:46 UTC Benjamin Krajmalnik <kraj@servoyant.com>
` Re: Configuration for a new server.
2011-02-01 17:22 UTC Benjamin Krajmalnik <kraj@servoyant.com>
` Re: Configuration for a new server.
2011-02-02 01:16 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Configuration for a new server.
2011-02-02 17:46 UTC Benjamin Krajmalnik <kraj@servoyant.com>
` Re: Configuration for a new server.
2011-02-02 18:22 UTC Greg Smith <greg@2ndquadrant.com>
[7+ messages in thread]
About pg_stat_activity
2011-02-02 15:21 UTC Cesar Arrieta <cesar.cba@gmail.com>
` Re: About pg_stat_activity
2011-02-02 17:15 UTC Maciek Sakrejda <msakrejda@truviso.com>
` Re: About pg_stat_activity
2011-02-02 17:24 UTC Greg Smith <greg@2ndquadrant.com>
[3+ messages in thread]
monitoring querys Re: About pg_stat_activity
2011-02-02 16:03 UTC Jens Wilke <jens.wilke@affinitas.de>
Any experience using "shake" defragmenter?
2011-01-30 20:11 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Any experience using "shake" defragmenter?
2011-01-30 21:31 UTC Mark Felder <feld@feld.me>
` Re: Any experience using "shake" defragmenter?
2011-01-30 22:27 UTC Marcin Mirosław <marcin@mejor.pl>
` Re: Any experience using "shake" defragmenter?
2011-01-31 04:33 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Any experience using "shake" defragmenter?
2011-01-31 04:38 UTC Mladen Gogala <mladen.gogala@vmsinfo.com>
` Re: Any experience using "shake" defragmenter?
2011-01-31 12:28 UTC Lew <noone@lewscanon.com>
` Re: Any experience using "shake" defragmenter?
2011-01-31 16:44 UTC Florian Weimer <fweimer@bfk.de>
` Re: Any experience using "shake" defragmenter?
2011-01-31 16:49 UTC Florian Weimer <fweimer@bfk.de>
` Re: Any experience using "shake" defragmenter?
2011-01-31 23:41 UTC Lew <noone@lewscanon.com>
` Re: Any experience using "shake" defragmenter?
2011-02-01 19:24 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Any experience using "shake" defragmenter?
2011-02-01 19:38 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: Any experience using "shake" defragmenter?
2011-02-01 20:31 UTC Grant Johnson <grant@amadensor.com>
` Re: Any experience using "shake" defragmenter?
2011-02-01 22:33 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Any experience using "shake" defragmenter?
2011-02-01 23:50 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[14+ messages in thread]
Re: Bloat issue on 8.3; autovac ignores HOT new pages?
2011-01-31 18:27 UTC Josh Berkus <josh@agliodbs.com>
` Re: Bloat issue on 8.3; autovac ignores HOT new pages?
2011-01-31 21:23 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Bloat issue on 8.3; autovac ignores HOT new pages?
2011-01-31 21:57 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Bloat issue on 8.3; autovac ignores HOT new pages?
2011-02-01 23:37 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[4+ messages in thread]
Questions on query planner, join types, and work_mem
2010-07-27 23:08 UTC Peter Hussey <peter@labkey.com>
` Re: Questions on query planner, join types, and work_mem
2010-07-27 23:57 UTC Andres Freund <andres@anarazel.de>
` Re: Questions on query planner, join types, and work_mem
2010-07-28 00:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Questions on query planner, join types, and work_mem
2010-07-28 04:01 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Questions on query planner, join types, and work_mem
2010-07-28 04:27 UTC Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re: Questions on query planner, join types, and work_mem
2010-07-28 04:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Questions on query planner, join types, and work_mem
2010-07-30 14:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Questions on query planner, join types, and work_mem
2010-08-02 21:23 UTC Peter Hussey <peter@labkey.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-03 02:48 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-03 02:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Questions on query planner, join types, and work_mem
2010-08-03 07:03 UTC Hannu Krosing <hannu@2ndquadrant.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 13:14 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 14:01 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 17:51 UTC Hannu Krosing <hannu@2ndquadrant.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 18:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 18:41 UTC Hannu Krosing <hannu@2ndquadrant.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 19:03 UTC Hannu Krosing <hannu@2ndquadrant.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 19:16 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 19:18 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 19:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 19:38 UTC Hannu Krosing <hannu@krosing.net>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 19:51 UTC Hannu Krosing <hannu@krosing.net>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 19:58 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 20:24 UTC Hannu Krosing <hannu@2ndquadrant.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 20:38 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 20:40 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 20:42 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Questions on query planner, join types, and work_mem
2010-08-04 20:46 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Questions on query planner, join types, and work_mem
2010-08-12 01:42 UTC Bruce Momjian <bruce@momjian.us>
` Re: Questions on query planner, join types, and work_mem
2010-08-12 02:39 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Questions on query planner, join types, and work_mem
2011-02-01 03:17 UTC Bruce Momjian <bruce@momjian.us>
` Re: Questions on query planner, join types, and work_mem
2011-02-01 20:24 UTC Bruce Momjian <bruce@momjian.us>
[32+ messages in thread]
postgres 9 query performance
2011-01-28 17:30 UTC yazan suleiman <yazan.suleiman@gmail.com>
` Re: postgres 9 query performance
2011-01-28 20:33 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgres 9 query performance
2011-01-28 20:50 UTC Kenneth Marshall <ktm@rice.edu>
` Re: postgres 9 query performance
2011-01-28 21:01 UTC yazan suleiman <yazan.suleiman@gmail.com>
` Re: postgres 9 query performance
2011-01-28 21:19 UTC Andres Freund <andres@anarazel.de>
` Re: postgres 9 query performance
2011-01-28 21:34 UTC yazan suleiman <yazan.suleiman@gmail.com>
` Re: postgres 9 query performance
2011-01-30 22:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgres 9 query performance
2011-01-30 22:35 UTC Andres Freund <andres@anarazel.de>
` Re: postgres 9 query performance
2011-02-01 16:42 UTC Ross J. Reedstrom <reedstrm@rice.edu>
[9+ messages in thread]
Migrating to Postgresql and new hardware
2011-01-18 10:56 UTC Lars <la@unifaun.com>
` Re: Migrating to Postgresql and new hardware
2011-01-18 19:17 UTC Andy Colson <andy@squeakycode.net>
` Re: Migrating to Postgresql and new hardware
2011-01-18 19:19 UTC Andy Colson <andy@squeakycode.net>
` Re: Migrating to Postgresql and new hardware
2011-01-18 22:06 UTC Strange, John W <john.w.strange@jpmchase.com>
` Re: Migrating to Postgresql and new hardware
2011-01-18 22:53 UTC Mark Felder <feld@feld.me>
` Re: Migrating to Postgresql and new hardware
2011-01-19 04:09 UTC mark <dvlhntr@gmail.com>
` Re: Migrating to Postgresql and new hardware
2011-01-19 07:26 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Migrating to Postgresql and new hardware
2011-01-19 07:49 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Migrating to Postgresql and new hardware
2011-01-19 08:17 UTC Lars <la@unifaun.com>
` Re: Migrating to Postgresql and new hardware
2011-01-19 08:45 UTC Lars <la@unifaun.com>
` Re: Migrating to Postgresql and new hardware
2011-01-19 09:09 UTC Lars <la@unifaun.com>
` Re: Migrating to Postgresql and new hardware
2011-01-20 00:42 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Migrating to Postgresql and new hardware
2011-01-20 14:48 UTC Andy Colson <andy@squeakycode.net>
` Re: Migrating to Postgresql and new hardware
2011-01-20 15:43 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Migrating to Postgresql and new hardware
2011-01-29 00:27 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Migrating to Postgresql and new hardware
2011-01-31 10:12 UTC Lars <la@unifaun.com>
[16+ messages in thread]
Re: pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1
2011-01-27 19:26 UTC DM <dm.aeqa@gmail.com>
` Re: pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1
2011-01-30 19:25 UTC Robert Haas <robertmhaas@gmail.com>
[2+ messages in thread]
Postgres 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]
[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