pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Range query optimization
  2004-06-24 21:24 UTC  Mischa Sandberg <mischa_sandberg@telus.net>

after using pg_resetxlog, db lost
  2004-06-22 18:42 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: after using pg_resetxlog, db lost
  2004-06-22 19:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: after using pg_resetxlog, db lost
  2004-06-22 20:05 UTC  Richard Huxton <dev@archonet.com>
` Re: after using pg_resetxlog, db lost
  2004-06-22 20:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: after using pg_resetxlog, db lost
  2004-06-24 02:46 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: after using pg_resetxlog, db lost
  2004-06-24 03:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: after using pg_resetxlog, db lost
  2004-06-24 16:14 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: after using pg_resetxlog, db lost
  2004-06-24 16:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: after using pg_resetxlog, db lost
  2004-06-24 17:17 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
  [9+ messages in thread]

Re: Pas la samedi
  2004-06-24 12:25 UTC  Laurent Martelli <laurent@bearteam.org>

Re: Traduc Party
  2004-06-23 16:02 UTC  Laurent Martelli <laurent@bearteam.org>
` Re: Traduc Party
  2004-06-23 18:47 UTC  Laurent Martelli <laurent@aopsys.com>
` Re: Traduc Party
  2004-06-23 23:07 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
  [3+ messages in thread]

postgresql and openmosix migration
  2004-06-22 14:29 UTC  Bill <bill@math.uchicago.edu>
` Re: postgresql and openmosix migration
  2004-06-22 16:31 UTC  Josh Berkus <josh@agliodbs.com>
` Re: postgresql and openmosix migration
  2004-06-22 17:31 UTC  Bill <bill@math.uchicago.edu>
` Re: postgresql and openmosix migration
  2004-06-22 17:53 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: postgresql and openmosix migration
  2004-06-22 17:58 UTC  jason.servetar@ccgenesis.com
` Re: postgresql and openmosix migration
  2004-06-22 18:08 UTC  Richard Welty <rwelty@averillpark.net>
` Re: postgresql and openmosix migration
  2004-06-22 18:49 UTC  Matthew Nuzum <matt@followers.net>
` Re: postgresql and openmosix migration
  2004-06-23 01:25 UTC  Joe Conway <mail@joeconway.com>
` Re: postgresql and openmosix migration
  2004-06-23 14:47 UTC  Andrew Hammond <ahammond@ca.afilias.info>
` Re: postgresql and openmosix migration
  2004-06-23 16:34 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: postgresql and openmosix migration
  2004-06-23 17:31 UTC  Josh Berkus <josh@agliodbs.com>
` Re: postgresql and openmosix migration
  2004-06-23 17:52 UTC  Rod Taylor <pg@rbt.ca>
` Re: postgresql and openmosix migration
  2004-06-23 18:20 UTC  Richard Welty <rwelty@averillpark.net>
  [13+ messages in thread]

Postgres over Linux NBD or NFS
  2004-06-21 18:02 UTC  Andrew Hammond <ahammond@ca.afilias.info>
` Re: Postgres over Linux NBD or NFS
  2004-06-22 01:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres over Linux NBD or NFS
  2004-06-22 02:46 UTC  Andrew Rawnsley <ronz@ravensfield.com>
` Re: Postgres over Linux NBD or NFS
  2004-06-22 03:46 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Postgres over Linux NBD or NFS
  2004-06-22 11:25 UTC  Carlos Eduardo Smanioto <cesmanioto@planae.com.br>
` Re: Postgres over Linux NBD or NFS
  2004-06-22 11:50 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Postgres over Linux NBD or NFS
  2004-06-22 12:49 UTC  Andrew Rawnsley <ronz@ravensfield.com>
` Re: Postgres over Linux NBD or NFS
  2004-06-22 13:21 UTC  Matt Clark <matt@ymogen.net>
` Re: Postgres over Linux NBD or NFS
  2004-06-22 13:49 UTC  Andrew Hammond <ahammond@ca.afilias.info>
` Re: Postgres over Linux NBD or NFS
  2004-06-22 17:15 UTC  Matthew Nuzum <newz@bearfruit.org>
  [10+ messages in thread]

Problems with vacuum!
  2004-06-11 13:54 UTC  Domenico Sgarbossa <domenico@xtecnica.com>
` Re: Problems with vacuum!
  2004-06-11 14:39 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: [BULK] Problems with vacuum!
  2004-06-11 14:53 UTC  Domenico Sgarbossa <domenico@xtecnica.com>
` Re: [BULK] Problems with vacuum!
  2004-06-11 15:03 UTC  Doug McNaught <doug@mcnaught.org>
` Re: [BULK] Problems with vacuum!
  2004-06-14 15:24 UTC  Dawn Hollingsworth <dmh@airdefense.net>
` Re: [BULK] Problems with vacuum!
  2004-06-18 13:54 UTC  Domenico Sgarbossa <domenico@xtecnica.com>
` Re: [BULK] Problems with vacuum!
  2004-06-18 15:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [BULK] Problems with vacuum!
  2004-06-18 18:07 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: [BULK] Problems with vacuum!
  2004-06-18 18:47 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: [BULK] Problems with vacuum!
  2004-06-18 18:58 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: [BULK] Problems with vacuum!
  2004-06-22 13:33 UTC  Domenico Sgarbossa <domenico@xtecnica.com>
  [11+ messages in thread]

Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 11:31 UTC  Gary Cowell <gary_cowell@yahoo.co.uk>
` Re: Major differences between oracle and postgres performance
  2004-06-18 12:07 UTC  Richard Huxton <dev@archonet.com>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 12:09 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 12:14 UTC  Jeff <threshar@torgo.978.org>
` Re: Major differences between oracle and postgres performance
  2004-06-18 12:17 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: Major differences between oracle and postgres performance
  2004-06-18 12:36 UTC  pginfo <pginfo@t1.unisoftbg.com>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 13:25 UTC  Gary Cowell <gary_cowell@yahoo.co.uk>
` Re: Major differences between oracle and postgres performance
  2004-06-18 13:56 UTC  Richard Huxton <dev@archonet.com>
` Re: Major differences between oracle and postgres performance
  2004-06-18 13:59 UTC  pginfo <pginfo@t1.unisoftbg.com>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 14:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 15:47 UTC  Gary Cowell <gary_cowell@yahoo.co.uk>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 16:30 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 17:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 17:53 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 18:16 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 20:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-18 23:06 UTC  Gary Cowell <gary_cowell@yahoo.co.uk>
` Re: Major differences between oracle and postgres performance - what can I do ?
  2004-06-22 04:46 UTC  Mischa Sandberg <mischa_sandberg@telus.net>
  [18+ messages in thread]

Re: Pl/Pgsql Functions running simultaneously
  2004-06-02 21:08 UTC  Marcus Whitney <marcus@coldfeetcreative.com>
` Re: Pl/Pgsql Functions running simultaneously
  2004-06-03 21:38 UTC  Marcus Whitney <marcus@coldfeetcreative.com>
` Re: Pl/Pgsql Functions running simultaneously
  2004-06-04 21:39 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Pl/Pgsql Functions running simultaneously
  2004-06-07 16:43 UTC  Marcus Whitney <marcus@coldfeetcreative.com>
` Re: Pl/Pgsql Functions running simultaneously
  2004-06-21 19:46 UTC  Andrew Hammond <ahammond@ca.afilias.info>
  [5+ messages in thread]

slow vacuum performance
  2004-03-24 10:20 UTC  pginfo <pginfo@t1.unisoftbg.com>
` Re: slow vacuum performance
  2004-03-24 14:07 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: slow vacuum performance
  2004-03-24 14:21 UTC  pginfo <pginfo@t1.unisoftbg.com>
` Re: slow vacuum performance
  2004-03-24 16:26 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: slow vacuum performance
  2004-03-24 16:49 UTC  pginfo <pginfo@t1.unisoftbg.com>
` Re: slow vacuum performance
  2004-03-24 17:08 UTC  pginfo <pginfo@t1.unisoftbg.com>
` Re: slow vacuum performance
  2004-03-24 18:13 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Slow vacuum performance
  2004-06-17 20:09 UTC  Patrick Hatcher <PHatcher@macys.com>
` Re: Slow vacuum performance
  2004-06-18 04:30 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Slow vacuum performance
  2004-06-18 08:15 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: Slow vacuum performance
  2004-06-21 10:11 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: Slow vacuum performance
  2004-06-21 15:24 UTC  Patrick Hatcher <PHatcher@macys.com>
  [12+ messages in thread]

pg_fetch_array
  2004-06-14 09:12 UTC  Thanks <Thanks@verymuch.com>
` Re: pg_fetch_array
  2004-06-20 20:02 UTC  Rod Taylor <pg@rbt.ca>
` Re: pg_fetch_array
  2004-06-21 10:34 UTC  Richard Huxton <dev@archonet.com>
  [3+ messages in thread]

Indexing question
  2003-08-29 06:52 UTC  Alexander Priem <ap@cict.nl>
` Re: Indexing question
  2003-08-29 07:03 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Indexing question
  2003-08-29 07:05 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Indexing question
  2003-08-29 07:49 UTC  Alexander Priem <ap@cict.nl>
` Re: Indexing question
  2003-08-29 07:59 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Indexing question
  2003-08-29 08:14 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Indexing question
  2003-08-29 08:41 UTC  Alexander Priem <ap@cict.nl>
` Re: Indexing question
  2003-08-29 08:57 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Indexing question
  2003-08-29 09:08 UTC  Alexander Priem <ap@cict.nl>
` Re: Indexing question
  2003-08-29 14:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexing question
  2003-08-29 15:13 UTC  Alexander Priem <ap@cict.nl>
` Re: Indexing question
  2003-08-29 16:58 UTC  Richard Ellis <rellis9@yahoo.com>
` Re: Indexing question
  2003-08-30 01:07 UTC  Rudi Starcevic <rudi@oasis.net.au>
` Indexing question
  2004-06-15 21:29 UTC  Stan Bielski <bielski@ece.cmu.edu>
` Re: Indexing question
  2004-06-20 18:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [15+ messages in thread]

*very* inefficient choice made by the planner (regarding IN(...))
  2004-06-10 14:24 UTC  Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 15:00 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: *very* inefficient choice made by the planner (regarding IN(...))
  2004-06-10 15:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: *very* inefficient choice made by the planner (regarding IN(...))
  2004-06-10 15:32 UTC  Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 15:45 UTC  Jean-Luc Lachance <jllachan@sympatico.ca>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 15:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 16:56 UTC  Jean-Luc Lachance <jllachan@sympatico.ca>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 17:09 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-10 17:14 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-18 08:37 UTC  SZUCS Gábor <surrano@mailbox.hu>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-18 14:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: *very* inefficient choice made by the planner (regarding
  2004-06-18 15:32 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [12+ messages in thread]

Visual Explain
  2004-06-16 14:01 UTC  Jeff <threshar@torgo.978.org>
` Re: Visual Explain
  2004-06-17 11:10 UTC  Adam Witney <awitney@sghms.ac.uk>
` Re: [PERFORM] Visual Explain
  2004-06-17 12:16 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Visual Explain
  2004-06-17 12:52 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Visual Explain
  2004-06-17 13:37 UTC  Jeff <threshar@torgo.978.org>
` Re: Visual Explain
  2004-06-17 16:54 UTC  Vitaly Belman <vitalyb@gmail.com>
` Re: Visual Explain
  2004-06-17 17:05 UTC  Jeff <threshar@torgo.978.org>
` Re: Visual Explain
  2004-06-17 17:35 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Visual Explain
  2004-06-17 18:13 UTC  Vitaly Belman <vitalyb@gmail.com>
  [9+ messages in thread]

in-transaction insert performance in 7.5devel
  2004-06-11 18:40 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 18:55 UTC  Rod Taylor <pg@rbt.ca>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 19:04 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 19:27 UTC  Rod Taylor <pg@rbt.ca>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 19:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 21:04 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: in-transaction insert performance in 7.5devel
  2004-06-11 21:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: in-transaction insert performance in 7.5devel
  2004-06-17 16:35 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [8+ messages in thread]

50 000 000 Table entries and I have to do a keyword search HELP NEEDED
  2004-06-07 21:47 UTC  borajetta <borajetta@hotmail.com>
` Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED
  2004-06-15 00:11 UTC  Josh Berkus <josh@agliodbs.com>
` Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED
  2004-06-15 12:43 UTC  Jeremy Dunn <jdunn@autorevenue.com>
` Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED
  2004-06-15 15:16 UTC  Aaron <smokedvw@hotmail.com>
` Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED
  2004-06-17 00:33 UTC  Josh Berkus <josh@agliodbs.com>
  [5+ messages in thread]

Basic Postgresql Performance Question
  2004-06-16 19:15 UTC  Bill <bill@math.uchicago.edu>
` Re: Basic Postgresql Performance Question
  2004-06-16 19:35 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Basic Postgresql Performance Question
  2004-06-16 20:08 UTC  Kevin Barnard <kbarnard@speedfc.com>
` Re: Basic Postgresql Performance Question
  2004-06-16 20:18 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Basic Postgresql Performance Question
  2004-06-16 20:49 UTC  Stephen Frost <sfrost@snowman.net>
  [5+ messages in thread]

why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
  2004-06-15 06:49 UTC  Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
  2004-06-15 13:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
  2004-06-15 15:30 UTC  Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
  2004-06-15 18:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
  2004-06-16 08:42 UTC  Frank van Vugt <ftm.van.vugt@foxi.nl>
  [5+ messages in thread]

Re: Index oddity (still)
  2004-06-14 23:47 UTC  ken <southerland@samsixedd.com>
` Re: Index oddity (still)
  2004-06-15 13:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Interpreting OSDB Results
  2004-06-15 06:03 UTC  Neeraj  <bunku@rediffmail.com>

Re: Failed System follow up
  2004-06-15 03:41 UTC  Marcus Whitney <marcus@coldfeetcreative.com>

Re: Failed System.  Help.
  2004-06-15 03:33 UTC  Marcus Whitney <marcus@coldfeetcreative.com>

Additional select fields in a GROUP BY
  2004-06-13 03:21 UTC  Vitaly Belman <vitalib@012.net.il>
` Re: Additional select fields in a GROUP BY
  2004-06-13 03:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Additional select fields in a GROUP BY
  2004-06-13 13:52 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Additional select fields in a GROUP BY
  2004-06-13 17:35 UTC  Vitaly Belman <vitalyb@gmail.com>
` Re: Additional select fields in a GROUP BY
  2004-06-13 17:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

ORDER BY user defined function performance issues
  2004-06-11 11:14 UTC  Nick Trainor <nick.trainor@trainorthornton.co.uk>
` Re: ORDER BY user defined function performance issues
  2004-06-11 13:41 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: ORDER BY user defined function performance issues
  2004-06-11 17:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Database Server Tuning
  2004-02-26 21:28 UTC  John Allgood <john@turbocorp.com>
` Re: Database Server Tuning
  2004-02-26 22:01 UTC  Troels Arvin <troels@arvin.dk>
` Re: Database Server Tuning
  2004-02-26 22:48 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Database Server Tuning
  2004-02-27 03:07 UTC  John Allgood <john@turbocorp.com>
` Re: Database Server Tuning
  2004-03-02 20:51 UTC  Vivek Khera <khera@kcilink.com>
` Re: Database Server Tuning
  2004-03-02 21:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Database Server Tuning
  2004-03-02 21:32 UTC  Vivek Khera <khera@kcilink.com>
` Re: Database Server Tuning
  2004-03-03 18:59 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Database Server Tuning
  2004-06-10 16:02 UTC  Anjan Dave <adave@vantage.com>
` Re: Database Server Tuning
  2004-06-10 16:51 UTC  Vivek Khera <khera@kcilink.com>
  [10+ 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