pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
tricky query
  2005-06-28 14:21 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: tricky query
  2005-06-28 15:07 UTC  John A Meinel <john@arbash-meinel.com>
` Re: tricky query
  2005-06-28 15:12 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: tricky query
  2005-06-28 15:20 UTC  Cosimo Streppone <cosimo@streppone.it>
` Re: tricky query
  2005-06-28 15:30 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: tricky query
  2005-06-28 15:39 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: tricky query
  2005-06-28 15:42 UTC  John A Meinel <john@arbash-meinel.com>
` Re: tricky query
  2005-06-28 15:42 UTC  Sam Mason <sam@samason.me.uk>
` Re: tricky query
  2005-06-28 15:43 UTC  John A Meinel <john@arbash-meinel.com>
` Re: tricky query
  2005-06-28 16:02 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: tricky query
  2005-06-28 16:25 UTC  John A Meinel <john@arbash-meinel.com>
` Re: tricky query
  2005-06-28 17:42 UTC  Sam Mason <sam@samason.me.uk>
` Re: tricky query
  2005-06-28 19:31 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: tricky query
  2005-06-28 19:33 UTC  Cosimo Streppone <cosimo@streppone.it>
` Re: tricky query
  2005-06-28 19:36 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: tricky query
  2005-06-28 19:42 UTC  John A Meinel <john@arbash-meinel.com>
` Re: tricky query
  2005-06-28 19:45 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: tricky query
  2005-06-28 20:38 UTC  Sebastian Hennebrueder <usenet@laliluna.de>
` Re: tricky query
  2005-06-29 06:36 UTC  Dawid Kuroczko <qnex42@gmail.com>
  [19+ messages in thread]

Performance analysis of plpgsql code
  2005-06-27 23:30 UTC  Karl O. Pinc <kop@meme.com>
` Re: Performance analysis of plpgsql code
  2005-06-27 23:33 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Performance analysis of plpgsql code
  2005-06-28 01:15 UTC  Michael Glaesemann <grzm@myrealbox.com>
` Re: Performance analysis of plpgsql code
  2005-06-28 01:34 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Performance analysis of plpgsql code
  2005-06-28 01:54 UTC  Karl O. Pinc <kop@meme.com>
` Re: Performance analysis of plpgsql code
  2005-06-28 02:49 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Performance analysis of plpgsql code
  2005-06-28 03:03 UTC  Karl O. Pinc <kop@meme.com>
` Re: Fwd: Re: [PERFORM] Performance analysis of plpgsql code
  2005-06-29 01:53 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [8+ messages in thread]

perl garbage collector
  2005-06-27 20:46 UTC  Jean-Max Reymond <jmreymond@gmail.com>
` Re: perl garbage collector
  2005-06-27 21:11 UTC  Vivek Khera <vivek@khera.org>
` Re: perl garbage collector
  2005-06-28 05:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: perl garbage collector
  2005-06-28 18:47 UTC  Jean-Max Reymond <jmreymond@gmail.com>
` Re: perl garbage collector
  2005-06-28 22:10 UTC  Jean-Max Reymond <jmreymond@gmail.com>
  [5+ messages in thread]

Too slow querying a table of 15 million records
  2005-06-21 18:33 UTC  kjelle@bingon.no
` Re: Too slow querying a table of 15 million records
  2005-06-28 06:03 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Too slow querying a table of 15 million records
  2005-06-28 06:35 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Too slow querying a table of 15 million records
  2005-06-28 08:50 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Too slow querying a table of 15 million records
  2005-06-28 17:10 UTC  PFC <lists@boutiquenumerique.com>
` Re: Too slow querying a table of 15 million records
  2005-06-28 18:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

read block size
  2005-06-28 15:27 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: read block size
  2005-06-28 17:02 UTC  John A Meinel <john@arbash-meinel.com>
` Re: read block size
  2005-06-28 17:27 UTC  Michael Stone <mstone+postgres@mathom.us>
  [3+ messages in thread]

Re: Poor index choice -- multiple indexes of the same columns
  2005-06-27 22:37 UTC  Josh Berkus <josh@agliodbs.com>
` Poor index choice -- multiple indexes of the same columns
  2005-06-27 23:09 UTC  Karl O. Pinc <kop@meme.com>
` Re: Poor index choice -- multiple indexes of the same
  2005-06-28 02:36 UTC  Karl O. Pinc <kop@meme.com>
` Re: Poor index choice -- multiple indexes of the same
  2005-06-28 03:11 UTC  Karl O. Pinc <kop@meme.com>
` Re: Poor index choice -- multiple indexes of the same columns
  2005-06-28 06:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor index choice -- multiple indexes of the same
  2005-06-28 17:16 UTC  Karl O. Pinc <kop@meme.com>
  [6+ messages in thread]

Fwd: Re: [PERFORM] Performance analysis of plpgsql code [kop@meme.com]
  2005-06-28 15:42 UTC  Karl O. Pinc <kop@meme.com>

Réf. :  tricky query
  2005-06-28 14:50 UTC  bsimon@loxane.com

Insert performance vs Table size
  2005-06-27 11:24 UTC  Praveen Raja <praveen.raja@netlight.se>
` Re: Insert performance vs Table size
  2005-06-27 11:30 UTC  李江华 <ljh1469@alibaba-inc.com>
` Re: Insert performance vs Table size
  2005-06-27 11:40 UTC  Jacques Caron <jc@directinfos.com>
` Re: Insert performance vs Table size
  2005-06-27 11:50 UTC  Praveen Raja <praveen.raja@netlight.se>
` Re: Insert performance vs Table size
  2005-06-27 12:05 UTC  Jacques Caron <jc@directinfos.com>
` Re: Insert performance vs Table size
  2005-06-28 09:50 UTC  Praveen Raja <praveen.raja@netlight.se>
` Re: Insert performance vs Table size
  2005-06-28 10:43 UTC  Jacques Caron <jc@directinfos.com>
` Re: Insert performance vs Table size
  2005-06-28 14:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [8+ messages in thread]

(no subject)
  2005-06-28 14:18 UTC  Erik Westland <erikwestland@yahoo.com>

How can I speed up this function?
  2005-06-28 02:37 UTC  David Mitchell <david.mitchell@telogis.com>
` Re: How can I speed up this function?
  2005-06-28 03:04 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: How can I speed up this function?
  2005-06-28 03:11 UTC  David Mitchell <david.mitchell@telogis.com>
` Re: How can I speed up this function?
  2005-06-28 03:20 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: How can I speed up this function?
  2005-06-28 03:21 UTC  Keith Worthington <KeithW@NarrowPathInc.com>
` Re: How can I speed up this function?
  2005-06-28 03:31 UTC  David Mitchell <david.mitchell@telogis.com>
` Re: How can I speed up this function?
  2005-06-28 03:33 UTC  David Mitchell <david.mitchell@telogis.com>
` Re: How can I speed up this function?
  2005-06-28 04:06 UTC  Gnanavel Shanmugam <s.gnanavel@inbox.com>
` Re: How can I speed up this function?
  2005-06-28 04:29 UTC  David Mitchell <david.mitchell@telogis.com>
` Re: How can I speed up this function?
  2005-06-28 04:42 UTC  Gnanavel Shanmugam <s.gnanavel@inbox.com>
` Re: How can I speed up this function?
  2005-06-28 04:55 UTC  David Mitchell <david.mitchell@telogis.com>
` Re: How can I speed up this function?
  2005-06-28 05:27 UTC  Gnanavel Shanmugam <s.gnanavel@inbox.com>
` Re: How can I speed up this function?
  2005-06-28 08:36 UTC  Klint Gore <kg@kgb.une.edu.au>
  [13+ messages in thread]

How are text columns stored?
  2005-06-23 10:40 UTC  Meetesh Karia <meetesh.karia@gmail.com>
` Re: How are text columns stored?
  2005-06-28 06:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

LIKE search with ending % not optimized in v8
  2005-06-22 09:03 UTC  Aditya Damle <aditya@skillnetinc.com>
` Re: LIKE search with ending % not optimized in v8
  2005-06-28 05:16 UTC  Michael Fuhr <mike@fuhr.org>
  [2+ messages in thread]

Faster drives for WAL than for data?
  2005-06-28 01:24 UTC  Leigh Dyer <leigh@eclinic.com.au>

Re: Forcing use of a particular index
  2005-06-27 22:40 UTC  Jacques Caron <jc@directinfos.com>
` Forcing use of a particular index
  2005-06-27 23:16 UTC  Karl O. Pinc <kop@meme.com>
  [2+ messages in thread]

ETL optimization
  2005-06-23 19:38 UTC  Bricklen Anderson <BAnderson@PresiNET.com>
` Re: ETL optimization
  2005-06-23 19:54 UTC  Meetesh Karia <meetesh.karia@gmail.com>
` Re: ETL optimization
  2005-06-23 20:16 UTC  Bricklen Anderson <BAnderson@PresiNET.com>
` Re: ETL optimization
  2005-06-23 21:56 UTC  Jacques Caron <jc@directinfos.com>
` Re: ETL optimization
  2005-06-23 22:04 UTC  Bricklen Anderson <BAnderson@PresiNET.com>
` Re: ETL optimization
  2005-06-24 04:27 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: ETL optimization
  2005-06-27 18:15 UTC  Bricklen Anderson <BAnderson@PresiNET.com>
  [7+ messages in thread]

Re: [HACKERS] How two perform TPC-H test on postgresql-8.0.2
  2005-06-27 18:14 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>

PERFORMANCE ISSUE ODBC x LIBPQ C++ Application
  2005-06-27 13:32 UTC  grupos <grupos@carvalhaes.net>
` Re: PERFORMANCE ISSUE ODBC x LIBPQ C++ Application
  2005-06-27 14:29 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: PERFORMANCE ISSUE ODBC x LIBPQ C++ Application
  2005-06-27 14:46 UTC  Eric Lauzon <eric.lauzon@abovesecurity.com>
  [3+ messages in thread]

Performance - moving from oracle to postgresql
  2005-06-24 19:49 UTC  Greg Maples <gregm@nimblefish.com>
` Re: Performance - moving from oracle to postgresql
  2005-06-24 22:00 UTC  Rod Taylor <pg@rbt.ca>
` Re: Performance - moving from oracle to postgresql
  2005-06-25 10:45 UTC  Radu-Adrian Popescu <radu.popescu@aldratech.com>
` Re: Performance - moving from oracle to postgresql
  2005-06-27 12:40 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [4+ messages in thread]

Speed with offset clause
  2005-06-24 18:18 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Speed with offset clause
  2005-06-24 18:54 UTC  hubert depesz lubaczewski <depesz@gmail.com>
` Re: Speed with offset clause
  2005-06-24 19:22 UTC  John A Meinel <john@arbash-meinel.com>
` Fwd: Speed with offset clause
  2005-06-24 20:19 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Speed with offset clause
  2005-06-24 20:23 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Speed with offset clause
  2005-06-24 20:34 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Speed with offset clause
  2005-06-25 11:42 UTC  Radu-Adrian Popescu <radu.popescu@aldratech.com>
  [7+ messages in thread]

Configurator project launched
  2005-06-21 18:24 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Configurator project launched
  2005-06-21 23:14 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Configurator project launched
  2005-06-21 23:30 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Configurator project launched
  2005-06-22 00:50 UTC  Greg Sabino Mullane <greg@turnstep.com>
` Re: Configurator project launched
  2005-06-22 08:30 UTC  Andreas Pflug <pgadmin@pse-consulting.de>
` Re: Configurator project launched
  2005-06-25 01:09 UTC  Greg Sabino Mullane <greg@turnstep.com>
` Re: Configurator project launched
  2005-06-25 07:46 UTC  Andreas Pflug <pgadmin@pse-consulting.de>
  [7+ messages in thread]

parameterized LIKE does not use index
  2005-06-22 18:50 UTC  Kurt De Grave <kurt.degrave@pharmadm.com>
` parameterized LIKE does not use index
  2005-06-22 19:25 UTC  Kurt De Grave <Kurt.DeGrave@student.kuleuven.ac.be>
` Re: parameterized LIKE does not use index
  2005-06-22 21:08 UTC  Josh Berkus <josh@agliodbs.com>
` Re: parameterized LIKE does not use index
  2005-06-23 08:33 UTC  Kurt De Grave <Kurt.DeGrave@student.kuleuven.ac.be>
` Re: parameterized LIKE does not use index
  2005-06-23 14:18 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: parameterized LIKE does not use index
  2005-06-23 18:55 UTC  Josh Berkus <josh@agliodbs.com>
` Re: parameterized LIKE does not use index
  2005-06-24 23:41 UTC  Jim C. Nasby <decibel@decibel.org>
  [7+ messages in thread]

Performance Tuning Article
  2005-06-22 14:52 UTC  Frank Wiles <frank@wiles.org>
` Re: Performance Tuning Article
  2005-06-22 17:16 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Performance Tuning Article
  2005-06-22 17:42 UTC  Frank Wiles <frank@wiles.org>
` Re: Performance Tuning Article
  2005-06-22 18:05 UTC  Karim Nassar <karim.nassar@acm.org>
` Re: Performance Tuning Article
  2005-06-23 01:06 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Performance Tuning Article
  2005-06-23 02:31 UTC  Keith Worthington <KeithW@NarrowPathInc.com>
` Re: Performance Tuning Article
  2005-06-23 09:22 UTC  Radu-Adrian Popescu <radu.popescu@aldratech.com>
` Re: Performance Tuning Article
  2005-06-23 12:16 UTC  Keith Worthington <KeithW@NarrowPathInc.com>
` Re: Performance Tuning Article
  2005-06-23 13:36 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Performance Tuning Article
  2005-06-23 13:46 UTC  Radu-Adrian Popescu <radu.popescu@aldratech.com>
` Re: Performance Tuning Article
  2005-06-23 13:48 UTC  Frank Wiles <frank@wiles.org>
` Re: Performance Tuning Article
  2005-06-23 14:44 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Performance Tuning Article
  2005-06-23 16:16 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Performance Tuning Article
  2005-06-23 17:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance Tuning Article
  2005-06-24 22:02 UTC  Dmitri Bichko <dbichko@aveopharma.com>
  [15+ messages in thread]

Needed: Simplified guide to optimal memory configuration
  2005-06-15 09:06 UTC  Todd Landfried <tlandfried@viatornetworks.com>
` Re: Needed: Simplified guide to optimal memory configuration
  2005-06-15 09:25 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Needed: Simplified guide to optimal memory configuration
  2005-06-15 14:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Needed: Simplified guide to optimal memory configuration
  2005-06-15 14:19 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Needed: Simplified guide to optimal memory configuration
  2005-06-15 18:34 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Needed: Simplified guide to optimal memory configuration
  2005-06-16 14:46 UTC  Todd Landfried <tlandfried@viatornetworks.com>
` Re: Needed: Simplified guide to optimal memory
  2005-06-16 17:01 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: Needed: Simplified guide to optimal memory configuration
  2005-06-16 17:03 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Needed: Simplified guide to optimal memory
  2005-06-17 02:15 UTC  Todd Landfried <tlandfried@viatornetworks.com>
` Re: Needed: Simplified guide to optimal memory
  2005-06-17 04:46 UTC  Alvaro Herrera <alvherre@surnet.cl>
` Re: Needed: Simplified guide to optimal memory
  2005-06-17 16:42 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Needed: Simplified guide to optimal memory configuration
  2005-06-24 21:18 UTC  Todd Landfried <tlandfried@viatornetworks.com>
  [12+ messages in thread]

max_connections / shared_buffers / effective_cache_size questions
  2005-06-24 18:54 UTC  Puddle <rotaecho@yahoo.com>
` Re: max_connections / shared_buffers / effective_cache_size
  2005-06-24 19:16 UTC  John A Meinel <john@arbash-meinel.com>
` Re: max_connections / shared_buffers / effective_cache_size questions
  2005-06-24 19:56 UTC  Puddle <rotaecho@yahoo.com>
  [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