pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedThe order of fields around the "=" in the WHERE conditions
2006-04-03 21:24 UTC Mike Quinn <mquinn@co.merced.ca.us>
` Re: The order of fields around the "=" in the WHERE conditions
2006-04-03 21:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: The order of fields around the "=" in the WHERE conditions
2006-04-03 21:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: The order of fields around the "=" in the WHERE
2006-04-04 17:18 UTC Mike Quinn <mquinn@co.merced.ca.us>
` Re: The order of fields around the "=" in the WHERE
2006-04-04 22:07 UTC Mike Quinn <mquinn@co.merced.ca.us>
[5+ messages in thread]
Query using SeqScan instead of IndexScan
2006-03-30 03:12 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: Query using SeqScan instead of IndexScan
2006-03-30 03:20 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: Query using SeqScan instead of IndexScan
2006-03-30 05:18 UTC Josh Berkus <josh@agliodbs.com>
` Re: Query using SeqScan instead of IndexScan
2006-03-31 15:59 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-01 01:09 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-01 01:23 UTC chris smith <dmagick@gmail.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-01 01:31 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-01 15:32 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-01 17:51 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-02 00:50 UTC chris smith <dmagick@gmail.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-02 01:32 UTC chris smith <dmagick@gmail.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-02 04:26 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-02 04:31 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Query using SeqScan instead of IndexScan
2006-04-02 04:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query using SeqScan instead of IndexScan
2006-04-02 22:30 UTC Josh Berkus <josh@agliodbs.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-03 04:20 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-04 20:26 UTC Jim Nasby <jnasby@pervasive.com>
` Re: Query using SeqScan instead of IndexScan
2006-04-04 20:28 UTC Jim Nasby <jnasby@pervasive.com>
[18+ messages in thread]
vacuum full seems to hang on very small table
2006-04-04 14:59 UTC Dan Harris <fbsd@drivefaster.net>
` Re: vacuum full seems to hang on very small table
2006-04-04 15:07 UTC Brad Nicholson <bnichols@ca.afilias.info>
` Re: vacuum full seems to hang on very small table
2006-04-04 15:35 UTC Simon Riggs <simon@2ndquadrant.com>
[3+ messages in thread]
optimizing db for small table with tons of updates
2006-04-03 18:24 UTC Kenji Morishige <kenjim@juniper.net>
` Re: optimizing db for small table with tons of updates
2006-04-03 18:29 UTC Josh Berkus <josh@agliodbs.com>
` Re: optimizing db for small table with tons of updates
2006-04-03 18:36 UTC Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
` Re: optimizing db for small table with tons of updates
2006-04-03 18:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing db for small table with tons of updates
2006-04-03 19:02 UTC Kenji Morishige <kenjim@juniper.net>
` Re: optimizing db for small table with tons of updates
2006-04-03 19:03 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: optimizing db for small table with tons of updates
2006-04-03 19:08 UTC Kenji Morishige <kenjim@juniper.net>
` Re: optimizing db for small table with tons of updates
2006-04-03 19:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing db for small table with tons of updates
2006-04-03 19:28 UTC Kenji Morishige <kenjim@juniper.net>
[9+ messages in thread]
Measuring the execution time of functions within functions...
2006-04-03 09:42 UTC Mario Splivalo <mario.splivalo@mobart.hr>
` Re: Measuring the execution time of functions within functions...
2006-04-03 12:50 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Measuring the execution time of functions within functions...
2006-04-03 16:32 UTC Jerry Sievers <jerry@jerrysievers.com>
[3+ messages in thread]
Trigger vs Rule
2006-04-02 08:31 UTC Ключников А.С. <alexs@analytic.mv.ru>
` Re: Trigger vs Rule
2006-04-02 21:08 UTC Niklas Johansson <spot@tele2.se>
` Re: Trigger vs Rule
2006-04-03 09:04 UTC Niklas Johansson <spot@tele2.se>
` Re: Trigger vs Rule
2006-04-03 09:17 UTC Ключников А.С. <alexs@analytic.mv.ru>
[4+ messages in thread]
index not used again
2006-03-31 09:16 UTC Jan Kesten <jan.kesten@web.de>
` Re: index not used again
2006-03-31 14:44 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: index not used again
2006-04-02 16:20 UTC Jan Kesten <jan.kesten@web.de>
` Re: index not used again
2006-04-02 19:46 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
[4+ messages in thread]
Re: Logging SQL queries to optimize them ?
2006-04-02 14:45 UTC Qingqing Zhou <zhouqq@cs.toronto.edu>
Large Binary Objects Middleware
2006-03-27 20:16 UTC Rodrigo Madera <rodrigo.madera@gmail.com>
` Re: Large Binary Objects Middleware
2006-04-02 14:36 UTC Qingqing Zhou <zhouqq@cs.toronto.edu>
[2+ messages in thread]
statistics buffer is full
2006-03-29 12:22 UTC Gábriel Ákos <akos.gabriel@i-logic.hu>
` Re: statistics buffer is full
2006-04-02 14:33 UTC Qingqing Zhou <zhouqq@cs.toronto.edu>
[2+ messages in thread]
Slow performance on Windows .NET and OleDb
2006-03-28 12:14 UTC Greg Quinn <greg@officium.co.za>
` Re: Slow performance on Windows .NET and OleDb
2006-03-28 14:10 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Slow performance on Windows .NET and OleDb
2006-03-28 17:32 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Slow performance on Windows .NET and OleDb
2006-03-28 17:52 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Slow performance on Windows .NET and OleDb
2006-03-29 06:22 UTC Greg Quinn <greg@officium.co.za>
` Re: Slow performance on Windows .NET and OleDb
2006-03-29 06:24 UTC Greg Quinn <greg@officium.co.za>
` Re: Slow performance on Windows .NET and OleDb
2006-03-29 06:58 UTC Ruben Rubio Rey <ruben@rentalia.com>
` Re: Slow performance on Windows .NET and OleDb
2006-03-29 07:16 UTC Chris <dmagick@gmail.com>
` Re: Slow performance on Windows .NET and OleDb
2006-03-29 11:00 UTC Greg Quinn <greg@officium.co.za>
` Re: Slow performance on Windows .NET and OleDb
2006-03-29 11:21 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Slow performance on Windows .NET and OleDb
2006-03-29 11:40 UTC PFC <lists@peufeu.com>
` Re: Slow performance on Windows .NET and OleDb
2006-03-29 14:05 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Slow performance on Windows .NET and OleDb
2006-03-30 01:21 UTC Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
` [Solved] Slow performance on Windows .NET and OleDb
2006-03-30 05:57 UTC Greg Quinn <greg@officium.co.za>
` Re: [Solved] Slow performance on Windows .NET and OleDb
2006-03-30 14:34 UTC Dave Dutcher <dave@tridecap.com>
` Re: [Solved] Slow performance on Windows .NET and OleDb
2006-03-31 20:49 UTC Antoine <melser.anton@gmail.com>
` Re: [Solved] Slow performance on Windows .NET and OleDb
2006-03-31 23:27 UTC Magnus Hagander <mha@sollentuna.net>
` Re: [Solved] Slow performance on Windows .NET and OleDb
2006-04-01 09:54 UTC Antoine <melser.anton@gmail.com>
` Re: [Solved] Slow performance on Windows .NET and OleDb
2006-04-01 19:23 UTC Merlin Moncure <mmoncure@gmail.com>
[19+ messages in thread]
un-'vacuum analyse'
2006-03-31 16:02 UTC Frederic Back <fredericback@gmail.com>
` Re: un-'vacuum analyse'
2006-03-31 16:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
simple join uses indexes, very slow
2006-03-27 18:47 UTC george young <gry@ll.mit.edu>
` Re: simple join uses indexes, very slow
2006-03-28 08:30 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: simple join uses indexes, very slow
2006-03-28 15:22 UTC george young <gry@ll.mit.edu>
` Re: simple join uses indexes, very slow
2006-03-28 15:26 UTC Markus Schaber <schabi@logix-tt.com>
` Re: simple join uses indexes, very slow
2006-03-28 16:18 UTC Dave Dutcher <dave@tridecap.com>
` Re: simple join uses indexes, very slow
2006-03-28 16:29 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: simple join uses indexes, very slow
2006-03-28 17:20 UTC Dave Dutcher <dave@tridecap.com>
` Re: simple join uses indexes, very slow
2006-03-28 17:30 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: simple join uses indexes, very slow
2006-03-28 17:34 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: simple join uses indexes, very slow
2006-03-28 18:17 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: simple join uses indexes, very slow
2006-03-28 20:56 UTC george young <gry@ll.mit.edu>
` Re: simple join uses indexes, very slow
2006-03-29 01:30 UTC Dave Dutcher <dave@tridecap.com>
` Re: simple join uses indexes, very slow
2006-03-29 05:15 UTC Chris <dmagick@gmail.com>
` Re: simple join uses indexes, very slow
2006-03-29 06:08 UTC stef <stef@ummon.com>
` Re: simple join uses indexes, very slow
2006-03-29 15:29 UTC george young <gry@ll.mit.edu>
` Re: simple join uses indexes, very slow
2006-03-31 15:47 UTC Jim C. Nasby <jnasby@pervasive.com>
[16+ messages in thread]
Decide between Postgresql and Mysql (help of comunity)
2006-03-28 15:31 UTC Marcos <mjs_ops@gmx.net>
` Re: Decide between Postgresql and Mysql (help of
2006-03-28 16:55 UTC Marcos <mjs_ops@gmx.net>
` Re: Decide between Postgresql and Mysql (help of comunity)
2006-03-28 18:57 UTC Madison Kelly <linux@alteeve.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-28 18:59 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-28 19:42 UTC PFC <lists@peufeu.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-28 19:50 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-28 20:50 UTC Chris Travers <chris@travelamericas.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-28 21:18 UTC PFC <lists@peufeu.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-28 21:24 UTC PFC <lists@peufeu.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-28 21:52 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-28 21:56 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-29 13:48 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Decide between Postgresql and Mysql (help of comunity)
2006-03-29 15:32 UTC Vivek Khera <vivek@khera.org>
` Re: Decide between Postgresql and Mysql (help of
2006-03-29 15:35 UTC Vivek Khera <vivek@khera.org>
` Re: Decide between Postgresql and Mysql (help of
2006-03-29 15:36 UTC Vivek Khera <vivek@khera.org>
` Re: Decide between Postgresql and Mysql (help of
2006-03-30 00:01 UTC Gorshkov <listsubscriptions@oghma.on.ca>
` Re: Decide between Postgresql and Mysql (help of
2006-03-30 02:23 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-30 03:01 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-30 04:07 UTC Gorshkov <listsubscriptions@oghma.on.ca>
` Re: Decide between Postgresql and Mysql (help of
2006-03-30 04:39 UTC Gorshkov <listsubscriptions@oghma.on.ca>
` Re: Decide between Postgresql and Mysql (help of
2006-03-30 08:29 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-30 17:22 UTC Chris Browne <cbbrowne@acm.org>
` Re: Decide between Postgresql and Mysql (help of
2006-03-30 19:21 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-30 21:31 UTC PFC <lists@peufeu.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-30 22:36 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Decide between Postgresql and Mysql (help of
2006-03-30 22:53 UTC Chris Browne <cbbrowne@acm.org>
` Re: Decide between Postgresql and Mysql (help of
2006-03-31 02:08 UTC Philippe Marzin <philippe.marzin@free.fr>
` Re: Decide between Postgresql and Mysql (help of
2006-03-31 06:56 UTC Guido Neitzer <guido.neitzer@pharmaline.de>
[28+ messages in thread]
CREATE INDEX rather sluggish
2006-03-30 08:26 UTC Gavin Hamill <gdh@laterooms.com>
` Re: CREATE INDEX rather sluggish
2006-03-30 15:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: CREATE INDEX rather sluggish
2006-03-30 17:08 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: CREATE INDEX rather sluggish
2006-03-30 20:21 UTC Gavin Hamill <gdh@laterooms.com>
` Re: CREATE INDEX rather sluggish
2006-03-30 20:45 UTC Gavin Hamill <gdh@laterooms.com>
[5+ messages in thread]
Index scan startup time
2006-03-30 11:59 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Index scan startup time
2006-03-30 12:02 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Index scan startup time
2006-03-30 12:06 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Index scan startup time
2006-03-30 12:23 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Index scan startup time
2006-03-30 12:24 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Index scan startup time
2006-03-30 12:31 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Index scan startup time
2006-03-30 12:35 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Index scan startup time
2006-03-30 12:42 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Index scan startup time
2006-03-30 12:51 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Index scan startup time
2006-03-30 12:59 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Index scan startup time
2006-03-30 13:00 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Index scan startup time
2006-03-30 13:29 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Index scan startup time
2006-03-30 14:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index scan startup time
2006-03-30 15:16 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Index scan startup time
2006-03-30 15:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index scan startup time
2006-03-30 17:19 UTC Simon Riggs <simon@2ndquadrant.com>
[16+ messages in thread]
Automatic tuning of postgresql.conf parameters?
2006-03-30 09:16 UTC Mattias Kregert <mattias@kregert.se>
Database possible corruption , unsolvable mystery
2006-03-29 17:58 UTC Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: Database possible corruption , unsolvable mystery
2006-03-29 22:09 UTC Richard Huxton <dev@archonet.com>
` Re: Database possible corruption , unsolvable mystery
2006-03-29 22:16 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Database possible corruption , unsolvable mystery
2006-03-29 22:31 UTC Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: Database possible corruption , unsolvable mystery
2006-03-29 22:52 UTC stef <stef@ummon.com>
` Re: Database possible corruption , unsolvable mystery
2006-03-29 23:33 UTC Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: Database possible corruption , unsolvable mystery
2006-03-30 05:14 UTC Josh Berkus <josh@agliodbs.com>
[7+ messages in thread]
MVCC intro and benefits docs?
2006-03-28 20:27 UTC Antoine <melser.anton@gmail.com>
` Re: MVCC intro and benefits docs?
2006-03-28 21:59 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: MVCC intro and benefits docs?
2006-03-29 04:59 UTC Qingqing Zhou <zhouqq@cs.toronto.edu>
[3+ messages in thread]
Massive Inserts Strategies
2006-03-22 15:32 UTC ashah <ashah@opuspro.com>
` Re: Massive Inserts Strategies
2006-03-22 16:07 UTC PFC <lists@peufeu.com>
` Re: Massive Inserts Strategies
2006-03-22 16:09 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Massive Inserts Strategies
2006-03-28 15:59 UTC ashah <ashah@opuspro.com>
` Re: Massive Inserts Strategies
2006-03-28 16:18 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Massive Inserts Strategies
2006-03-28 17:38 UTC Jim C. Nasby <jnasby@pervasive.com>
[6+ messages in thread]
count(*) performance
2006-03-27 13:34 UTC Gábriel Ákos <akos.gabriel@i-logic.hu>
` Re: count(*) performance
2006-03-27 13:41 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: count(*) performance
2006-03-27 16:31 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: count(*) performance
2006-03-27 18:04 UTC Gábriel Ákos <akos.gabriel@i-logic.hu>
` Re: count(*) performance
2006-03-27 18:05 UTC Gábriel Ákos <akos.gabriel@i-logic.hu>
` Re: count(*) performance
2006-03-27 18:14 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: count(*) performance
2006-03-27 18:21 UTC Gábriel Ákos <akos.gabriel@i-logic.hu>
` Re: count(*) performance
2006-03-27 19:20 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: count(*) performance
2006-03-27 19:21 UTC Matthew T. O'Connor <matthew@zeut.net>
` Re: count(*) performance
2006-03-27 19:35 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: count(*) performance
2006-03-27 19:43 UTC Guido Neitzer <guido.neitzer@pharmaline.de>
` Re: count(*) performance
2006-03-27 21:57 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
` Re: count(*) performance
2006-03-27 22:43 UTC Matthew T. O'Connor <matthew@zeut.net>
` Re: count(*) performance
2006-03-27 23:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: count(*) performance
2006-03-27 23:17 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
` Re: count(*) performance
2006-03-28 11:49 UTC Markus Schaber <schabi@logix-tt.com>
` Re: count(*) performance
2006-03-28 17:26 UTC Jim C. Nasby <jnasby@pervasive.com>
[17+ messages in thread]
Query parallelism
2006-03-27 14:25 UTC luchot <luchot@voila.fr>
` Re: Query parallelism
2006-03-27 14:31 UTC Jim C. Nasby <jnasby@pervasive.com>
[2+ messages in thread]
experiences needed - how does Itanium2/1.5GHz(4MB) compare to AMD and Intel CPUs as far as Postgresql is concerned
2006-03-25 19:11 UTC Tomaz Borstnar <tomaz.borstnar@over.net>
` Re: experiences needed - how does Itanium2/1.5GHz(4MB) compare to AMD and Intel CPUs as far as Postgresql is concerned
2006-03-27 12:14 UTC Jim C. Nasby <jnasby@pervasive.com>
[2+ messages in thread]
Array performance
2006-03-24 12:41 UTC Ruben Rubio Rey <ruben@rentalia.com>
` Re: Array performance
2006-03-24 12:52 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Array performance
2006-03-24 13:01 UTC Ruben Rubio Rey <ruben@rentalia.com>
` Re: Array performance
2006-03-24 13:06 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Array performance
2006-03-24 13:32 UTC Michael Fuhr <mike@fuhr.org>
` Re: Array performance
2006-03-24 15:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Array performance
2006-03-27 07:03 UTC Ruben Rubio Rey <ruben@rentalia.com>
[7+ messages in thread]
Query plan from hell
2006-03-24 22:54 UTC PFC <lists@peufeu.com>
` Re: Query plan from hell
2006-03-25 09:52 UTC Guido Neitzer <guido.neitzer@pharmaline.de>
[2+ 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