pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Best way to check for new data.
  2005-10-28 21:39 UTC  Rodrigo Madera <rodrigo.madera@gmail.com>
` Re: Best way to check for new data.
  2005-10-28 22:13 UTC  Havasvölgyi Ottó <h.otto@freemail.hu>
` Re: Best way to check for new data.
  2005-10-31 13:43 UTC  David Roussel <pgsql-performance@diroussel.xsmail.com>
` Re: Best way to check for new data.
  2005-10-31 13:47 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [4+ messages in thread]

multi-layered view join performance oddities
  2005-10-30 17:16 UTC  Svenne Krap <svenne@krap.dk>
` Re: multi-layered view join performance oddities
  2005-10-30 17:44 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: multi-layered view join performance oddities
  2005-10-30 18:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: multi-layered view join performance oddities
  2005-10-30 18:33 UTC  Svenne Krap <svenne@krap.dk>
` Re: multi-layered view join performance oddities
  2005-10-30 18:49 UTC  Svenne Krap <svenne@krap.dk>
  [5+ messages in thread]

Simple query: how to optimize
  2005-10-28 21:53 UTC  Collin Peters <cadiolis@gmail.com>
` Re: Simple query: how to optimize
  2005-10-28 22:40 UTC  Roger Hand <RHand@kailea.com>
` Re: Simple query: how to optimize
  2005-10-28 23:56 UTC  Collin Peters <cadiolis@gmail.com>
` Re: Simple query: how to optimize
  2005-10-29 00:04 UTC  Collin Peters <cadiolis@gmail.com>
` Re: Simple query: how to optimize
  2005-10-29 00:12 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Simple query: how to optimize
  2005-10-29 00:37 UTC  PostgreSQL <martin@portant.com>
  [6+ messages in thread]

How long it takes to vacuum a big table
  2005-10-28 15:14 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: How long it takes to vacuum a big table
  2005-10-28 16:48 UTC  Jan Peterson <jan.l.peterson@gmail.com>
  [2+ messages in thread]

How much memory?
  2005-10-27 19:31 UTC  PostgreSQL <martin@portant.com>
` Re: How much memory?
  2005-10-27 22:39 UTC  Ron Peacetree <rjpeace@earthlink.net>
` Re: How much memory?
  2005-10-27 22:55 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: How much memory?
  2005-10-28 14:02 UTC  Alex Turner <armtuk@gmail.com>
  [4+ messages in thread]

how postgresql request the computer resources
  2005-10-27 14:25 UTC  Sidar López Cruz <sidarlopez@hotmail.com>
` Re: how postgresql request the computer resources
  2005-10-27 15:56 UTC  Richard Huxton <dev@archonet.com>
` Re: how postgresql request the computer resources
  2005-10-27 21:58 UTC  Michael Best <mbest@pendragon.org>
` Re: how postgresql request the computer resources
  2005-10-27 22:52 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [4+ messages in thread]

What gets cached?
  2005-10-21 12:34 UTC  Martin Nickel <martin@portant.com>
` Re: What gets cached?
  2005-10-21 12:40 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: What gets cached?
  2005-10-21 15:19 UTC  Alex Turner <armtuk@gmail.com>
` Re: What gets cached?
  2005-10-21 15:59 UTC  Michael Fuhr <mike@fuhr.org>
` Re: What gets cached?
  2005-10-21 21:44 UTC  Neil Conway <neilc@samurai.com>
` Re: What gets cached?
  2005-10-24 15:09 UTC  Alex Turner <armtuk@gmail.com>
` Re: What gets cached?
  2005-10-24 15:32 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: What gets cached?
  2005-10-27 20:41 UTC  PostgreSQL <martin@portant.com>
` Re: What gets cached?
  2005-10-27 22:48 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [9+ messages in thread]

Re: Reasons and drawbacks for unused item pointers (was: Update using primary key slow)
  2005-10-27 21:01 UTC  Martin Lesser <ml-pgsql@bettercom.de>
` Re: Reasons and drawbacks for unused item pointers (was: Update using primary key slow)
  2005-10-27 21:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Reasons and drawbacks for unused item pointers
  2005-10-27 22:09 UTC  Martin Lesser <ml-pgsql@bettercom.de>
  [3+ messages in thread]

Update using primary key slow
  2005-10-27 15:41 UTC  Denis <denis.sailer@yellowbook.com>
` Re: Update using primary key slow
  2005-10-27 16:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Update using primary key slow
  2005-10-27 18:09 UTC  Denis <denis.sailer@yellowbook.com>
` Re: Update using primary key slow
  2005-10-27 19:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Perfomance of views
  2005-10-26 15:25 UTC  Svenne Krap <svenne@krap.dk>
` Re: Perfomance of views
  2005-10-27 09:33 UTC  Richard Huxton <dev@archonet.com>
` Re: Perfomance of views
  2005-10-27 11:01 UTC  Svenne Krap <svenne@krap.dk>
` Re: Perfomance of views
  2005-10-27 11:29 UTC  Richard Huxton <dev@archonet.com>
` Re: Perfomance of views
  2005-10-27 13:41 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: Perfomance of views
  2005-10-27 14:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Perfomance of views
  2005-10-27 15:10 UTC  Svenne Krap <svenne@krap.dk>
` Re: Perfomance of views
  2005-10-27 15:40 UTC  Richard Huxton <dev@archonet.com>
  [8+ messages in thread]

Performance issues with custom functions
  2005-10-26 20:33 UTC  Edward Di Geronimo Jr. <edigeronimo@xtracards.com>
` Re: Performance issues with custom functions
  2005-10-26 23:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance issues with custom functions
  2005-10-27 14:35 UTC  Edward Di Geronimo Jr. <edigeronimo@xtracards.com>
  [3+ messages in thread]

browsing table with 2 million records
  2005-10-26 20:41 UTC  aurora <aurora00@gmail.com>
` Re: browsing table with 2 million records
  2005-10-26 20:59 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: browsing table with 2 million records
  2005-10-26 21:06 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: browsing table with 2 million records
  2005-10-26 21:09 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: browsing table with 2 million records
  2005-10-26 21:22 UTC  aurora <aurora00@gmail.com>
` Re: browsing table with 2 million records
  2005-10-26 21:28 UTC  Alex Turner <armtuk@gmail.com>
` Re: browsing table with 2 million records
  2005-10-26 21:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: browsing table with 2 million records
  2005-10-26 21:49 UTC  PFC <lists@boutiquenumerique.com>
` Re: browsing table with 2 million records
  2005-10-27 01:43 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: browsing table with 2 million records
  2005-10-27 01:46 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: browsing table with 2 million records
  2005-10-27 12:59 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: browsing table with 2 million records
  2005-10-27 14:33 UTC  PFC <lists@boutiquenumerique.com>
  [12+ messages in thread]

insertion of bytea
  2005-10-25 13:44 UTC  Chris Mair <list@1006.org>
` Re: insertion of bytea
  2005-10-25 14:05 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: insertion of bytea
  2005-10-25 14:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insertion of bytea
  2005-10-25 21:36 UTC  Chris Mair <list@1006.org>
` Re: insertion of bytea
  2005-10-25 21:41 UTC  Chris Mair <list@1006.org>
` Re: insertion of bytea
  2005-10-27 13:40 UTC  Chris Mair <list@1006.org>
  [6+ messages in thread]

performance on query
  2005-10-26 23:47 UTC  Sidar López Cruz <sidarlopez@hotmail.com>
` Re: performance on query
  2005-10-27 03:00 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [2+ messages in thread]

Materializing a sequential scan
  2005-10-19 17:45 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
  2005-10-20 04:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Materializing a sequential scan
  2005-10-20 04:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Materializing a sequential scan
  2005-10-20 10:16 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
  2005-10-20 10:18 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
  2005-10-23 10:23 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
  2005-10-26 21:37 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
  2005-10-26 23:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Materializing a sequential scan
  2005-10-26 23:22 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
  2005-10-26 23:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Materializing a sequential scan
  2005-10-27 00:13 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
  2005-10-27 00:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Materializing a sequential scan
  2005-10-27 00:57 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
  [13+ messages in thread]

tuning seqscan costs
  2005-10-19 14:51 UTC  Katherine Stoovs <ambrosiac@nedsenta.nl>
` Re: [HACKERS] tuning seqscan costs
  2005-10-20 14:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: tuning seqscan costs
  2005-10-26 22:48 UTC  Thomas F. O'Connell <tfo@sitening.com>
  [3+ messages in thread]

blue prints please
  2005-10-26 04:24 UTC  Sidar López Cruz <sidarlopez@hotmail.com>
` Re: blue prints please
  2005-10-26 06:59 UTC  Jean-Max Reymond <jmreymond@gmail.com>
` Re: blue prints please
  2005-10-26 18:08 UTC  Bruno Wolff III <bruno@wolff.to>
  [3+ messages in thread]

zero performance on query
  2005-10-26 04:26 UTC  Sidar López Cruz <sidarlopez@hotmail.com>
` Re: zero performance on query
  2005-10-26 05:25 UTC  Dmitri Bichko <dbichko@aveopharma.com>
` Re: zero performance on query
  2005-10-26 10:30 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: zero performance on query
  2005-10-26 12:05 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: zero performance on query
  2005-10-26 15:20 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
  [5+ messages in thread]

Outer join query plans and performance
  2005-10-25 11:35 UTC  Rich Doughty <rich@opusvl.com>
` Re: Outer join query plans and performance
  2005-10-25 14:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Outer join query plans and performance
  2005-10-25 18:28 UTC  Rich Doughty <rich@opusvl.com>
` Re: Outer join query plans and performance
  2005-10-25 22:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Outer join query plans and performance
  2005-10-25 22:24 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Outer join query plans and performance
  2005-10-26 08:33 UTC  Rich Doughty <rich@opusvl.com>
  [6+ messages in thread]

Configuration Suggestion
  2005-10-26 06:05 UTC  Christian Paul B. Cosinas <cpc@cybees.com>

Why different execution times for different instances for the same query?
  2005-10-25 19:46 UTC  Kishore B <kishorebh@gmail.com>
` Re: Why different execution times for different
  2005-10-25 20:24 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
  [2+ messages in thread]

Why Index is not working on date columns.
  2005-10-25 08:47 UTC  Kishore B <kishorebh@gmail.com>
` Re: Why Index is not working on date columns.
  2005-10-25 13:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why Index is not working on date columns.
  2005-10-25 15:04 UTC  Kishore B <kishorebh@gmail.com>
` Re: Why Index is not working on date columns.
  2005-10-25 18:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

impact of stats_command_string
  2005-10-20 20:33 UTC  jnevans@gmail.com
` Re: impact of stats_command_string
  2005-10-25 16:04 UTC  Michael Fuhr <mike@fuhr.org>
` Re: impact of stats_command_string
  2005-10-25 17:02 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [3+ messages in thread]

Inefficient escape codes.
  2005-10-18 18:07 UTC  Rodrigo Madera <rodrigo.madera@gmail.com>
` Re: Inefficient escape codes.
  2005-10-18 19:03 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Inefficient escape codes.
  2005-10-18 20:47 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Inefficient escape codes.
  2005-10-19 07:19 UTC  Peter Childs <peterachilds@gmail.com>
` Re: Inefficient escape codes.
  2005-10-19 14:54 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Inefficient escape codes.
  2005-10-20 07:15 UTC  Nörder-Tuitje, Marcus <noerder-tuitje@technology.de>
` Re: Inefficient escape codes.
  2005-10-21 16:59 UTC  Rodrigo Madera <rodrigo.madera@gmail.com>
` Re: Inefficient escape codes.
  2005-10-24 19:11 UTC  Rodrigo Madera <rodrigo.madera@gmail.com>
` Re: Inefficient escape codes.
  2005-10-25 16:03 UTC  Rodrigo Madera <rodrigo.madera@gmail.com>
  [9+ messages in thread]

Reindex - Is this necessary after a vacuum?
  2005-10-25 13:56 UTC  Markus Benne <thing@m-bass.com>
` Re: Reindex - Is this necessary after a vacuum?
  2005-10-25 14:16 UTC  Richard Huxton <dev@archonet.com>
` Re: Reindex - Is this necessary after a vacuum?
  2005-10-25 14:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ 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