pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTrouble 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