pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Trouble managing planner for timestamptz columns
  2006-03-10 17:30 UTC  Marc Morin <marc@sandvine.com>
` Re: Trouble managing planner for timestamptz columns
  2006-03-10 18:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Trouble managing planner for timestamptz columns
  2006-03-10 21:47 UTC  Marc Morin <marc@sandvine.com>
` Re: Trouble managing planner for timestamptz columns
  2006-03-10 23:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Re: Hanging queries on dual CPU windows
  2006-03-09 20:07 UTC  Jan de Visser <jdevisser@digitalfairway.com>
` Re: Hanging queries on dual CPU windows
  2006-03-09 20:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Hanging queries on dual CPU windows
  2006-03-09 21:15 UTC  Jan de Visser <jdevisser@digitalfairway.com>
` Re: Hanging queries on dual CPU windows
  2006-03-09 21:22 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: Hanging queries on dual CPU windows
  2006-03-10 02:00 UTC  Jan de Visser <jdevisser@digitalfairway.com>
` Re: Hanging queries on dual CPU windows
  2006-03-10 09:20 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: Hanging queries on dual CPU windows
  2006-03-10 14:03 UTC  Jan de Visser <jdevisser@digitalfairway.com>
` Re: Hanging queries on dual CPU windows
  2006-03-10 14:32 UTC  Hakan Kocaman <Hakan.Kocaman@digame.de>
` Re: Hanging queries on dual CPU windows
  2006-03-10 14:32 UTC  Jan de Visser <jdevisser@digitalfairway.com>
` Re: Hanging queries on dual CPU windows
  2006-03-10 14:47 UTC  Jan de Visser <jdevisser@digitalfairway.com>
` Re: Hanging queries on dual CPU windows
  2006-03-10 15:11 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: Hanging queries on dual CPU windows
  2006-03-10 16:13 UTC  Jan de Visser <jdevisser@digitalfairway.com>
` Re: Hanging queries on dual CPU windows
  2006-03-10 18:25 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: Hanging queries on dual CPU windows
  2006-03-10 19:27 UTC  Jan de Visser <jdevisser@digitalfairway.com>
` Re: Hanging queries on dual CPU windows
  2006-03-10 19:37 UTC  Jan de Visser <jdevisser@digitalfairway.com>
  [15+ messages in thread]

one-field index vs. multi-field index planner estimates
  2006-03-10 16:45 UTC  Evgeny Gridasov <eugrid@fpm.kubsu.ru>
` Re: one-field index vs. multi-field index planner estimates
  2006-03-10 17:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: one-field index vs. multi-field index planner
  2006-03-10 17:28 UTC  Evgeny Gridasov <eugrid@fpm.kubsu.ru>
` Re: one-field index vs. multi-field index planner
  2006-03-10 18:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Using materialized views for commonly-queried subsets
  2006-03-10 02:25 UTC  Casey Allen Shobe <lists@seattleserver.com>
` Re: Using materialized views for commonly-queried subsets
  2006-03-10 15:17 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [2+ messages in thread]

pg_reset_stats + cache I/O %
  2006-03-07 19:07 UTC  mcelroy, tim <tim.mcelroy@bostonstock.com>
` Re: pg_reset_stats + cache I/O %
  2006-03-07 19:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_reset_stats + cache I/O %
  2006-03-08 13:59 UTC  mcelroy, tim <tim.mcelroy@bostonstock.com>
` Re: pg_reset_stats + cache I/O %
  2006-03-08 18:27 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: pg_reset_stats + cache I/O %
  2006-03-08 18:35 UTC  mcelroy, tim <tim.mcelroy@bostonstock.com>
` Re: pg_reset_stats + cache I/O %
  2006-03-09 03:23 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: pg_reset_stats + cache I/O %
  2006-03-09 13:13 UTC  mcelroy, tim <tim.mcelroy@bostonstock.com>
` Re: pg_reset_stats + cache I/O %
  2006-03-10 15:15 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [8+ messages in thread]

FW: x206-x226
  2006-03-10 09:59 UTC  H.J. Sanders <hjs@rmax.nl>

pgCluster and postgres 8.1
  2006-03-09 10:24 UTC  Javier Somoza <jsomoza@pandasoftware.es>
` Re: pgCluster and postgres 8.1
  2006-03-10 01:48 UTC  Chris <dmagick@gmail.com>
  [2+ messages in thread]

embedded postgres and threading
  2006-03-09 00:32 UTC  Gorshkov <listsubscriptions@oghma.on.ca>

Is good idea an array of 365 elements in a cell of a table, in order to perform searchs?
  2006-03-08 14:28 UTC  Ruben Rubio Rey <ruben@rentalia.com>
` Re: Is good idea an array of 365 elements in a cell of a table, in order to perform searchs?
  2006-03-08 18:53 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [2+ messages in thread]

Bad row estimates
  2006-03-04 01:10 UTC  Alex Adriaanse <alex@innovacomputing.com>
` Re: Bad row estimates
  2006-03-04 07:01 UTC  Greg Stark <gsstark@mit.edu>
` Re: Bad row estimates
  2006-03-04 08:15 UTC  Greg Stark <gsstark@mit.edu>
` Re: Bad row estimates
  2006-03-04 15:46 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Bad row estimates
  2006-03-04 16:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad row estimates
  2006-03-04 18:11 UTC  Greg Stark <gsstark@mit.edu>
` Re: Bad row estimates
  2006-03-08 17:15 UTC  Alex Adriaanse <alex@innovacomputing.com>
` Re: Bad row estimates
  2006-03-08 17:37 UTC  Greg Stark <gsstark@mit.edu>
  [8+ messages in thread]

Postgres on VPS - how much is enough?
  2006-03-06 13:28 UTC  Nagita Karunaratne <nagita.k@gmail.com>
` Re: Postgres on VPS - how much is enough?
  2006-03-06 14:56 UTC  Matthew Nuzum <mattnuzum@gmail.com>
` Re: Postgres on VPS - how much is enough?
  2006-03-06 15:20 UTC  Kevin <kev@drule.org>
` Re: Postgres on VPS - how much is enough?
  2006-03-06 16:52 UTC  Nagita Karunaratne <nagita.k@gmail.com>
` Re: Postgres on VPS - how much is enough?
  2006-03-06 17:14 UTC  Marc G. Fournier <scrappy@postgresql.org>
` Re: Postgres on VPS - how much is enough?
  2006-03-06 19:45 UTC  Matthew Nuzum <mattnuzum@gmail.com>
` Re: Postgres on VPS - how much is enough?
  2006-03-07 18:45 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Postgres on VPS - how much is enough?
  2006-03-07 20:08 UTC  Dave Page <dpage@vale-housing.co.uk>
` Re: Postgres on VPS - how much is enough?
  2006-03-08 02:16 UTC  Matthew Nuzum <mattnuzum@gmail.com>
  [9+ messages in thread]

Can anyone explain this pgbench results?
  2006-03-06 15:29 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Can anyone explain this pgbench results?
  2006-03-06 17:47 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Can anyone explain this pgbench results?
  2006-03-06 18:46 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Can anyone explain this pgbench results?
  2006-03-06 20:17 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Can anyone explain this pgbench results?
  2006-03-07 03:22 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Can anyone explain this pgbench results?
  2006-03-07 10:34 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Can anyone explain this pgbench results?
  2006-03-07 13:08 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Can anyone explain this pgbench results?
  2006-03-07 19:09 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Can anyone explain this pgbench results?
  2006-03-07 19:49 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Can anyone explain this pgbench results?
  2006-03-07 19:59 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Can anyone explain this pgbench results?
  2006-03-07 20:15 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Can anyone explain this pgbench results?
  2006-03-07 20:21 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [12+ messages in thread]

t1000/t2000 sun-servers
  2006-03-06 09:05 UTC  Claus Guttesen <kometen@gmail.com>
` Re: t1000/t2000 sun-servers
  2006-03-06 14:30 UTC  Neil Saunders <n.j.saunders@gmail.com>
` Re: t1000/t2000 sun-servers
  2006-03-06 20:10 UTC  Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: t1000/t2000 sun-servers
  2006-03-06 21:24 UTC  Guido Neitzer <guido.neitzer@pharmaline.de>
` Re: t1000/t2000 sun-servers
  2006-03-06 22:11 UTC  Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: t1000/t2000 sun-servers
  2006-03-07 18:43 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [6+ messages in thread]

Planner enhancement suggestion.
  2006-03-05 21:00 UTC  PFC <lists@peufeu.com>
` Re: Planner enhancement suggestion.
  2006-03-07 00:19 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Planner enhancement suggestion.
  2006-03-07 18:09 UTC  PFC <lists@peufeu.com>
` Re: Planner enhancement suggestion.
  2006-03-07 18:37 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [4+ messages in thread]

Help understanding indexes, explain, and optimizing a query
  2006-03-07 00:15 UTC  i.v.r. <ivanvega@gmail.com>
` Re: Help understanding indexes, explain, and optimizing
  2006-03-07 00:40 UTC  Chris <dmagick@gmail.com>
` Re: Help understanding indexes, explain, and optimizing
  2006-03-07 02:11 UTC  i.v.r. <ivanvega@gmail.com>
` Re: Help understanding indexes, explain, and optimizing
  2006-03-07 15:02 UTC  Dave Dutcher <dave@tridecap.com>
` Re: Help understanding indexes, explain, and optimizing
  2006-03-07 15:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Hanging queries and I/O exceptions
  2006-03-06 14:38 UTC  Jan de Visser <jdevisser@digitalfairway.com>

How to query and index for customer with lastname and city
  2006-03-04 09:58 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: How to query and index for customer with lastname and city
  2006-03-04 13:49 UTC  hubert depesz lubaczewski <depesz@gmail.com>
` Re: How to query and index for customer with lastname
  2006-03-04 14:18 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: How to query and index for customer with lastname and city
  2006-03-04 14:23 UTC  hubert depesz lubaczewski <depesz@gmail.com>
` Re: How to query and index for customer with lastname and city
  2006-03-04 21:35 UTC  Kevin Brown <blargity@gmail.com>
  [5+ messages in thread]

Physical column size
  2006-01-26 10:06 UTC  Paul Mackay <mackaypaul@gmail.com>
` Re: Physical column size
  2006-01-26 11:22 UTC  Mario Weilguni <mweilguni@sime.com>
` Physical column size
  2006-03-03 10:03 UTC  Paul Mackay <mackaypaul@gmail.com>
` Re: Physical column size
  2006-03-03 10:23 UTC  Peter Eisentraut <peter_e@gmx.net>
` Re: Physical column size
  2006-03-03 10:23 UTC  Martijn van Oosterhout <kleptog@svana.org>
` Re: Physical column size
  2006-03-03 10:27 UTC  Ragnar <gnari@hive.is>
` Re: Physical column size
  2006-03-03 14:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [7+ messages in thread]

Like 'name%' is not using index
  2006-03-03 00:15 UTC  Jozsef Szalay <jszalay@storediq.com>
` Re: Like 'name%' is not using index
  2006-03-03 01:28 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Like 'name%' is not using index
  2006-03-03 02:48 UTC  Jozsef Szalay <jszalay@storediq.com>
` Re: Like 'name%' is not using index
  2006-03-03 04:01 UTC  Greg Stark <gsstark@mit.edu>
  [4+ messages in thread]

Bad plan on a view
  2006-03-01 14:56 UTC  PFC <lists@peufeu.com>
` Re: Bad plan on a view
  2006-03-01 15:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad plan on a view
  2006-03-01 15:43 UTC  PFC <lists@peufeu.com>
` Re: Bad plan on a view
  2006-03-01 16:04 UTC  Greg Stark <gsstark@mit.edu>
` Re: Bad plan on a view
  2006-03-01 16:49 UTC  PFC <lists@peufeu.com>
` Re: Bad plan on a view
  2006-03-01 18:51 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [6+ messages in thread]

Re: triggers, performance  Was: Re: [GENERAL] rotate records
  2006-02-28 05:54 UTC  Jeevanandam, Kathirvel (IE10) <Jeevanandam.Kathirvel@honeywell.com>
` Re: triggers, performance  Was: Re: [GENERAL] rotate records
  2006-03-01 18:48 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [2+ messages in thread]

Looking for a tool to "*" pg tables as ERDs
  2006-02-23 16:38 UTC  Ron Peacetree <rjpeace@earthlink.net>
` Re: [PERFORM] Looking for a tool to "*" pg tables as ERDs
  2006-02-23 16:48 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: [PERFORM] Looking for a tool to "*" pg tables as ERDs
  2006-02-23 16:59 UTC  Andrew Dunstan <andrew@dunslane.net>
` Re: Looking for a tool to "*" pg tables as ERDs
  2006-02-23 17:06 UTC  Vivek Khera <vivek@khera.org>
` Re: [PERFORM] Looking for a tool to "*" pg tables as ERDs
  2006-02-23 17:20 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: Looking for a tool to "*" pg tables as ERDs
  2006-03-01 18:31 UTC  Robert Treat <xzilla@users.sourceforge.net>
  [6+ messages in thread]

temporary indexes
  2006-02-28 15:44 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: temporary indexes
  2006-02-28 16:45 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: [PERFORM] temporary indexes
  2006-02-28 16:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] temporary indexes
  2006-02-28 17:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] temporary indexes
  2006-02-28 17:36 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: [PERFORM] temporary indexes
  2006-02-28 17:55 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: [PERFORM] temporary indexes
  2006-02-28 18:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] temporary indexes
  2006-02-28 18:08 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: [PERFORM] temporary indexes
  2006-02-28 18:16 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: [PERFORM] temporary indexes
  2006-02-28 21:02 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: [PERFORM] temporary indexes
  2006-02-28 21:15 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: [PERFORM] temporary indexes
  2006-02-28 23:02 UTC  Lukas Smith <smith@pooteeweet.org>
` Re: [PERFORM] temporary indexes
  2006-03-01 15:35 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [13+ messages in thread]

wal sync method
  2006-02-27 12:08 UTC  Evgeny Gridasov <eugrid@fpm.kubsu.ru>
` Re: wal sync method
  2006-02-27 12:29 UTC  Javier Somoza <jsomoza@pandasoftware.es>
` Re: wal sync method
  2006-02-28 01:14 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: wal sync method
  2006-02-28 23:31 UTC  PFC <lists@peufeu.com>
` Re: wal sync method
  2006-02-28 23:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: wal sync method
  2006-03-01 11:58 UTC  PFC <lists@peufeu.com>
  [6+ messages in thread]

Large Table With Only a Few Rows
  2006-02-27 14:48 UTC  Nik <XLPizza@gmail.com>
` Re: Large Table With Only a Few Rows
  2006-02-27 17:25 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Large Table With Only a Few Rows
  2006-02-27 18:34 UTC  Peter Childs <peterachilds@gmail.com>
` Re: Large Table With Only a Few Rows
  2006-03-01 06:55 UTC  Bruno Wolff III <bruno@wolff.to>
  [4+ 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