pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql geqo optimization
2006-02-11 01:46 UTC uwcssa <uwcssa@gmail.com>
` Re: postgresql geqo optimization
2006-02-11 01:52 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
[2+ messages in thread]
Basic Database Performance
2006-02-10 08:22 UTC James Dey <james@mygus.com>
` Re: Basic Database Performance
2006-02-10 09:36 UTC Richard Huxton <dev@archonet.com>
` Re: Basic Database Performance
2006-02-10 09:50 UTC Richard Huxton <dev@archonet.com>
` Re: Basic Database Performance
2006-02-10 09:55 UTC James Dey <james@mygus.com>
` Re: Basic Database Performance
2006-02-10 10:37 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Basic Database Performance
2006-02-10 20:14 UTC PFC <lists@peufeu.com>
[6+ messages in thread]
pgbench output
2006-02-02 07:09 UTC Pradeep Parmar <pradeep.dba@gmail.com>
` Re: pgbench output
2006-02-07 05:06 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: pgbench output
2006-02-10 15:41 UTC Gourish Singbal <gourish@gmail.com>
[3+ messages in thread]
Help with optimizing a sql statement
2006-02-09 15:10 UTC Rafael Martinez Guerrero <r.m.guerrero@usit.uio.no>
` Re: Help with optimizing a sql statement
2006-02-09 19:33 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Help with optimizing a sql statement
2006-02-09 19:44 UTC Dave Dutcher <dave@tridecap.com>
` Re: Help with optimizing a sql statement
2006-02-09 19:46 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Help with optimizing a sql statement
2006-02-09 22:44 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Help with optimizing a sql statement
2006-02-09 23:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help with optimizing a sql statement
2006-02-09 23:36 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Help with optimizing a sql statement
2006-02-10 02:28 UTC Vivek Khera <vivek@khera.org>
` Re: Help with optimizing a sql statement
2006-02-10 06:05 UTC Greg Stark <gsstark@mit.edu>
[9+ messages in thread]
Sane configuration options for a WinXP laptop 8.1 install?
2006-02-08 22:05 UTC Ron <rjpeace@earthlink.net>
` Re: Sane configuration options for a WinXP laptop 8.1 install?
2006-02-09 06:32 UTC Jim C. Nasby <jnasby@pervasive.com>
[2+ messages in thread]
Default autovacuum settings too conservative
2006-02-01 21:16 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: [PERFORM] Default autovacuum settings too conservative
2006-02-01 21:37 UTC Matthew T. O'Connor <matthew@zeut.net>
` Re: Default autovacuum settings too conservative
2006-02-06 20:00 UTC Vivek Khera <vivek@khera.org>
` Re: Default autovacuum settings too conservative
2006-02-06 22:15 UTC Chris Browne <cbbrowne@acm.org>
` Re: [PERFORM] Default autovacuum settings too conservative
2006-02-07 05:05 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Default autovacuum settings too conservative
2006-02-07 06:14 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Default autovacuum settings too conservative
2006-02-07 07:26 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Default autovacuum settings too conservative
2006-02-07 12:39 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Default autovacuum settings too conservative
2006-02-07 14:20 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Default autovacuum settings too conservative
2006-02-08 01:03 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Default autovacuum settings too conservative
2006-02-08 01:49 UTC Russell Smith <mr-russ@pws.com.au>
` Re: Default autovacuum settings too conservative
2006-02-08 04:12 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Default autovacuum settings too conservative
2006-02-08 11:05 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Default autovacuum settings too conservative
2006-02-08 13:38 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Default autovacuum settings too conservative
2006-02-08 23:31 UTC Tim Allen <tim@proximity.com.au>
` Re: Default autovacuum settings too conservative
2006-02-09 00:21 UTC Markus Schaber <schabi@logix-tt.com>
[16+ messages in thread]
Size and performance hit from using UTF8 vs. ASCII?
2006-02-08 14:11 UTC Ron <rjpeace@earthlink.net>
` Re: Size and performance hit from using UTF8 vs. ASCII?
2006-02-08 15:54 UTC Jeffrey W. Baker <jwbaker@acm.org>
[2+ messages in thread]
optimizing away join when querying view
2006-02-08 13:54 UTC Jacob Costello <jake@suntradingllc.com>
` Re: optimizing away join when querying view
2006-02-08 15:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing away join when querying view
2006-02-08 15:46 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
[3+ messages in thread]
partitioning and locking problems
2006-01-31 23:25 UTC Marc Morin <marc@sandvine.com>
` Re: partitioning and locking problems
2006-02-01 05:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: partitioning and locking problems
2006-02-01 09:39 UTC Richard Huxton <dev@archonet.com>
` Re: partitioning and locking problems
2006-02-01 14:25 UTC Marc Morin <marc@sandvine.com>
` Re: partitioning and locking problems
2006-02-01 15:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: partitioning and locking problems
2006-02-02 12:44 UTC Markus Schaber <schabi@logix-tt.com>
` Re: partitioning and locking problems
2006-02-02 16:27 UTC Marc Morin <marc@sandvine.com>
` Re: partitioning and locking problems
2006-02-07 04:11 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: partitioning and locking problems
2006-02-07 22:09 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: partitioning and locking problems
2006-02-07 22:22 UTC Ron <rjpeace@earthlink.net>
` Re: partitioning and locking problems
2006-02-07 22:57 UTC Marc Morin <marc@sandvine.com>
` Re: partitioning and locking problems
2006-02-08 00:59 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: partitioning and locking problems
2006-02-08 08:30 UTC Simon Riggs <simon@2ndquadrant.com>
[13+ messages in thread]
execution plan : Oracle vs PostgreSQL
2006-02-01 10:11 UTC FERREIRA, William (VALTECH) <william.ferreira@airbus.com>
` Re: execution plan : Oracle vs PostgreSQL
2006-02-01 16:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: execution plan : Oracle vs PostgreSQL
2006-02-01 16:33 UTC FERREIRA, William (VALTECH) <william.ferreira@airbus.com>
` Re: execution plan : Oracle vs PostgreSQL
2006-02-06 20:36 UTC Andrew Lazarus <andrew@pillette.com>
[4+ messages in thread]
Index occupancy
2006-02-02 14:03 UTC tschak <jochen.schlosser@gmail.com>
` Re: Index occupancy
2006-02-05 00:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Huge Data sets, simple queries
2006-01-28 01:23 UTC Mike Biamonte <mike@dbeat.com>
` Re: Huge Data sets, simple queries
2006-01-28 03:05 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-01-28 06:50 UTC Jeffrey W. Baker <jwbaker@acm.org>
` Re: Huge Data sets, simple queries
2006-01-28 15:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Huge Data sets, simple queries
2006-01-28 17:08 UTC Jeffrey W. Baker <jwbaker@acm.org>
` Re: Huge Data sets, simple queries
2006-01-28 17:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Huge Data sets, simple queries
2006-01-28 18:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Huge Data sets, simple queries
2006-01-29 11:25 UTC hubert depesz lubaczewski <depesz@gmail.com>
` Re: Huge Data sets, simple queries
2006-01-29 15:43 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Huge Data sets, simple queries
2006-01-29 18:44 UTC Luke Lonergan <LLonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-01-29 21:04 UTC Jeffrey W. Baker <jwbaker@acm.org>
` Re: Huge Data sets, simple queries
2006-01-30 00:32 UTC Michael Adler <adler@pobox.com>
` Re: Huge Data sets, simple queries
2006-01-30 03:19 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Huge Data sets, simple queries
2006-01-30 05:35 UTC Charles Sprickman <spork@bway.net>
` Re: Huge Data sets, simple queries
2006-01-30 07:25 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-01-30 17:53 UTC hubert depesz lubaczewski <depesz@gmail.com>
` Re: Huge Data sets, simple queries
2006-01-30 19:48 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-01-30 20:25 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Huge Data sets, simple queries
2006-01-31 17:00 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-01-31 17:25 UTC Kevin <kev@drule.org>
` Re: Huge Data sets, simple queries
2006-01-31 19:21 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Huge Data sets, simple queries
2006-01-31 20:03 UTC Jeffrey W. Baker <jwbaker@acm.org>
` Re: Huge Data sets, simple queries
2006-01-31 20:47 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-01-31 22:52 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-01-31 23:11 UTC PFC <lists@peufeu.com>
` Re: Huge Data sets, simple queries
2006-01-31 23:12 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Huge Data sets, simple queries
2006-01-31 23:13 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-01-31 23:19 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-02-01 01:26 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Huge Data sets, simple queries
2006-02-01 01:35 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-02-01 02:47 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Huge Data sets, simple queries
2006-02-01 04:09 UTC Jeffrey W. Baker <jwbaker@acm.org>
` Re: Huge Data sets, simple queries
2006-02-01 05:53 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-02-01 08:25 UTC Jeffrey W. Baker <jwbaker@acm.org>
` Re: Huge Data sets, simple queries
2006-02-01 09:01 UTC PFC <lists@peufeu.com>
` Re: Huge Data sets, simple queries
2006-02-01 12:15 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Huge Data sets, simple queries
2006-02-01 17:42 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-02-01 17:55 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Huge Data sets, simple queries
2006-02-01 17:57 UTC Mike Rylander <mrylander@gmail.com>
` Re: Huge Data sets, simple queries
2006-02-02 04:47 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Huge Data sets, simple queries
2006-02-02 19:41 UTC Alan Stange <stange@rentec.com>
[41+ messages in thread]
Planner reluctant to start from subquery
2006-02-01 18:33 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Planner reluctant to start from subquery
2006-02-01 19:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner reluctant to start from subquery
2006-02-01 19:59 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Planner reluctant to start from subquery
2006-02-01 20:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner reluctant to start from subquery
2006-02-01 20:24 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Planner reluctant to start from subquery
2006-02-01 20:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner reluctant to start from subquery
2006-02-01 20:43 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Planner reluctant to start from subquery
2006-02-01 20:50 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Planner reluctant to start from subquery
2006-02-01 20:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner reluctant to start from subquery
2006-02-02 16:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[10+ messages in thread]
Where is my bottleneck?
2006-01-24 18:40 UTC Arnau Rebassa Villalonga <arebassa@androme.es>
` Re: Where is my bottleneck?
2006-01-30 09:25 UTC Richard Huxton <dev@archonet.com>
` Re: Where is my bottleneck?
2006-01-30 11:00 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Where is my bottleneck?
2006-01-30 16:49 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Where is my bottleneck?
2006-01-30 20:10 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Where is my bottleneck?
2006-02-02 12:14 UTC Markus Schaber <schabi@logix-tt.com>
[6+ messages in thread]
Index Usage using IN
2006-02-01 20:12 UTC Ralph Mason <ralph.mason@telogis.com>
` Re: Index Usage using IN
2006-02-01 20:22 UTC Jeffrey W. Baker <jwbaker@acm.org>
` Re: Index Usage using IN
2006-02-01 20:28 UTC Jeffrey W. Baker <jwbaker@acm.org>
` Re: Index Usage using IN
2006-02-01 20:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index Usage using IN
2006-02-01 21:23 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Index Usage using IN
2006-02-01 22:12 UTC Hari Warrier <hbhaskaran@gmail.com>
[6+ messages in thread]
Sequential scan being used despite indexes
2006-02-01 03:14 UTC James Russell <internationalhobo@gmail.com>
` Re: Sequential scan being used despite indexes
2006-02-01 03:29 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Sequential scan being used despite indexes
2006-02-01 03:58 UTC Michael Fuhr <mike@fuhr.org>
` Re: Sequential scan being used despite indexes
2006-02-01 04:33 UTC James Russell <internationalhobo@gmail.com>
` Re: Sequential scan being used despite indexes
2006-02-01 04:43 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Sequential scan being used despite indexes
2006-02-01 05:08 UTC Michael Fuhr <mike@fuhr.org>
[6+ messages in thread]
Delete me
2006-01-31 16:24 UTC 2386429@studenti.unige.it
` Re: Delete me
2006-01-31 18:33 UTC Richard Huxton <dev@archonet.com>
` Re: Delete me
2006-01-31 19:23 UTC Jim C. Nasby <jnasby@pervasive.com>
[3+ messages in thread]
Query planner issue
2006-01-30 22:57 UTC Emmanuel Lacour <elacour@easter-eggs.com>
` Re: Query planner issue
2006-01-30 23:26 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Query planner issue
2006-01-30 23:37 UTC Jim Buttafuoco <jim@contactbda.com>
` Re: Query planner issue
2006-01-31 00:27 UTC Emmanuel Lacour <elacour@easter-eggs.com>
` Re: Query planner issue
2006-01-31 01:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Desperate: View not using indexes (very slow)
2006-01-25 16:09 UTC Jen Sale <js@slipt.net>
` Re: Desperate: View not using indexes (very slow)
2006-01-30 03:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Re: [GENERAL] Creation of tsearch2 index is very
2006-01-21 12:22 UTC Ron <rjpeace@earthlink.net>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-21 13:34 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-21 16:11 UTC Ron <rjpeace@earthlink.net>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-21 16:33 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-21 18:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-21 20:19 UTC David Lang <dlang@invendra.net>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-21 20:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-27 00:18 UTC Ron <rjpeace@earthlink.net>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-27 01:00 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-27 01:55 UTC Ron <rjpeace@earthlink.net>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-27 02:29 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-27 03:33 UTC Ron <rjpeace@earthlink.net>
` Re: [GENERAL] Creation of tsearch2 index is very
2006-01-27 07:52 UTC Ron <rjpeace@earthlink.net>
[13+ messages in thread]
Incorrect Total runtime Reported by Explain Analyze!?
2006-01-26 15:50 UTC Jozsef Szalay <jszalay@storediq.com>
` Re: Incorrect Total runtime Reported by Explain Analyze!?
2006-01-26 16:35 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Incorrect Total runtime Reported by Explain Analyze!?
2006-01-26 16:49 UTC Richard Huxton <dev@archonet.com>
` Re: Incorrect Total runtime Reported by Explain Analyze!?
2006-01-26 17:35 UTC Jozsef Szalay <jszalay@storediq.com>
` Re: Incorrect Total runtime Reported by Explain Analyze!?
2006-01-26 17:57 UTC Michael Fuhr <mike@fuhr.org>
` Re: Incorrect Total runtime Reported by Explain Analyze!?
2006-01-26 17:59 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Incorrect Total runtime Reported by Explain Analyze!?
2006-01-26 18:03 UTC Jozsef Szalay <jszalay@storediq.com>
[7+ messages in thread]
Query optimization with X Y JOIN
2006-01-26 15:43 UTC J@Planeti.Biz
` Re: Query optimization with X Y JOIN
2006-01-26 16:12 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Query optimization with X Y JOIN
2006-01-26 16:25 UTC J@Planeti.Biz
` Re: [PERFORM] Query optimization with X Y JOIN
2006-01-26 16:33 UTC Jaime Casanova <systemguards@gmail.com>
` Re: Query optimization with X Y JOIN
2006-01-26 16:34 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Query optimization with X Y JOIN
2006-01-26 16:47 UTC Richard Huxton <dev@archonet.com>
` Re: Query optimization with X Y JOIN
2006-01-26 17:13 UTC J@Planeti.Biz
[7+ messages in thread]
PostgreSQL Solaris packages now in beta
2006-01-26 01:46 UTC Robert Lor <Robert.Lor@Sun.COM>
` Re: PostgreSQL Solaris packages now in beta
2006-01-26 14:56 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
[2+ messages in thread]
DB responce during DB dump
2006-01-25 12:01 UTC Evgeny Gridasov <eugrid@fpm.kubsu.ru>
` Re: DB responce during DB dump
2006-01-25 12:44 UTC Richard Huxton <dev@archonet.com>
` Re: DB responce during DB dump
2006-01-25 16:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: DB responce during DB dump
2006-01-25 16:43 UTC Evgeny Gridasov <eugrid@fpm.kubsu.ru>
` Re: DB responce during DB dump
2006-01-25 16:47 UTC Evgeny Gridasov <eugrid@fpm.kubsu.ru>
[5+ messages in thread]
Inconsistant query plan
2006-01-24 23:15 UTC Daniel Gish <dan@centrifugesolutions.com>
` Re: Inconsistant query plan
2006-01-24 23:30 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Inconsistant query plan
2006-01-24 23:58 UTC Michael Fuhr <mike@fuhr.org>
` Re: Inconsistant query plan
2006-01-25 01:04 UTC Daniel Gish <dan@centrifugesolutions.com>
` Re: Inconsistant query plan
2006-01-25 09:05 UTC Alessandro Baretta <a.baretta@barettadeit.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