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