pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Practical upper limits of pgbench read/write tps with 8.3
  2008-07-07 21:05 UTC  Jeffrey Baker <jwbaker@gmail.com>
` Re: Practical upper limits of pgbench read/write tps with 8.3
  2008-07-07 22:22 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Practical upper limits of pgbench read/write tps with 8.3
  2008-07-08 03:39 UTC  Jeffrey Baker <jwbaker@gmail.com>
  [3+ messages in thread]

How much work_mem to configure...
  2008-07-05 11:24 UTC  Jessica Richard <rjessil@yahoo.com>
` Re: How much work_mem to configure...
  2008-07-06 06:04 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: How much work_mem to configure...
  2008-07-07 11:15 UTC  Bill Moran <wmoran@collaborativefusion.com>
  [3+ messages in thread]

filesystem options for WAL
  2008-07-06 05:04 UTC  Jaime Casanova <jcasanov@systemguards.com.ec>
` Re: filesystem options for WAL
  2008-07-06 15:18 UTC  Greg Smith <gsmith@gregsmith.com>
  [2+ messages in thread]

Subquery WHERE IN or WHERE EXISTS faster?
  2008-06-28 15:22 UTC  Ulrich <ulrich.mierendorff@gmx.net>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-06-28 15:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-06-28 22:07 UTC  Ulrich <ulrich.mierendorff@gmx.net>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-06-28 23:01 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-06-29 10:15 UTC  Ulrich <ulrich.mierendorff@gmx.net>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-06-29 12:08 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-06-30 04:33 UTC  Jaime Casanova <jcasanov@systemguards.com.ec>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-06-30 04:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-06-30 06:50 UTC  Rusty Conover <rconover@infogears.com>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-06-30 07:29 UTC  Ulrich <ulrich.mierendorff@gmx.net>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-06-30 07:44 UTC  Rusty Conover <rconover@infogears.com>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-07-05 12:02 UTC  Sergio Gabriel Rodriguez <sgrodriguez@gmail.com>
` Re: Subquery WHERE IN or WHERE EXISTS faster?
  2008-07-05 12:14 UTC  Sergio Gabriel Rodriguez <sgrodriguez@gmail.com>
  [13+ messages in thread]

Define all IP's in the world in pg_hba.conf
  2008-07-04 04:52 UTC  idc danny <idcdanny@yahoo.com>
` Re: Define all IP's in the world in pg_hba.conf
  2008-07-04 05:30 UTC  Russell Smith <mr-russ@pws.com.au>
  [2+ messages in thread]

switchover between index and sequential scans
  2008-07-03 07:59 UTC  Abhijit Menon-Sen <ams@oryx.com>
` Re: switchover between index and sequential scans
  2008-07-03 10:05 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: switchover between index and sequential scans
  2008-07-03 11:45 UTC  Abhijit Menon-Sen <ams@oryx.com>
  [3+ messages in thread]

cursor/Fetch mechanisms under postgreSQL
  2008-07-03 10:17 UTC  Mokhtari Amine <amine.mokhtari@gmail.com>

Select running slow on Postgres
  2008-07-01 19:29 UTC  samantha mahindrakar <sam.mahindrakar@gmail.com>
` Re: Select running slow on Postgres
  2008-07-01 19:47 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Select running slow on Postgres
  2008-07-02 19:01 UTC  samantha mahindrakar <sam.mahindrakar@gmail.com>
` Re: Select running slow on Postgres
  2008-07-02 19:07 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [4+ messages in thread]

Hot Issue
  2008-07-02 12:31 UTC  Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Hot Issue
  2008-07-02 12:40 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Hot Issue
  2008-07-02 12:41 UTC  Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Hot Issue
  2008-07-02 13:08 UTC  Devrim GÜNDÜZ <devrim@gunduz.org>
` Re: Hot Issue
  2008-07-02 13:11 UTC  Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Hot Issue
  2008-07-02 13:29 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Hot Issue
  2008-07-02 13:40 UTC  Devrim GÜNDÜZ <devrim@gunduz.org>
` Re: Hot Issue
  2008-07-02 13:44 UTC  Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Hot Issue
  2008-07-02 14:21 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Hot Issue
  2008-07-02 14:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Hot Issue
  2008-07-02 14:48 UTC  Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Hot Issue
  2008-07-02 16:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [12+ messages in thread]

Does max size of varchar influence index size
  2008-06-30 16:57 UTC  Franck Routier <franck.routier@axege.com>
` Re: Does max size of varchar influence index size
  2008-06-30 20:24 UTC  Mark Roberts <mailing_lists@pandapocket.com>
` Re: Does max size of varchar influence index size
  2008-07-01 15:05 UTC  Franck Routier <franck.routier@axege.com>
` Re: Does max size of varchar influence index size
  2008-07-01 15:33 UTC  Richard Huxton <dev@archonet.com>
  [4+ messages in thread]

VACUUM ANALYZE blocking both reads and writes to a table
  2008-06-30 14:59 UTC  Peter Schuller <peter.schuller@infidyne.com>
` Re: VACUUM ANALYZE blocking both reads and writes to a table
  2008-06-30 15:25 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: VACUUM ANALYZE blocking both reads and writes to a table
  2008-06-30 15:34 UTC  Peter Schuller <peter.schuller@infidyne.com>
` Re: VACUUM ANALYZE blocking both reads and writes to a table
  2008-06-30 15:43 UTC  Peter Schuller <peter.schuller@infidyne.com>
` Re: VACUUM ANALYZE blocking both reads and writes to a table
  2008-06-30 16:23 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: VACUUM ANALYZE blocking both reads and writes to a table
  2008-06-30 18:58 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: VACUUM ANALYZE blocking both reads and writes to a table
  2008-06-30 19:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: VACUUM ANALYZE blocking both reads and writes to a table
  2008-06-30 19:04 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: VACUUM ANALYZE blocking both reads and writes to a table
  2008-07-01 15:26 UTC  Peter Schuller <peter.schuller@infidyne.com>
  [9+ messages in thread]

Inact_dirty is increasing continuously and causing the system to hang.
  2008-07-01 11:59 UTC  Kathirvel, Jeevanandam <Jeevanandam.Kathirvel@honeywell.com>
` Re: Inact_dirty is increasing continuously and causing the system to hang.
  2008-07-01 15:03 UTC  Greg Smith <gsmith@gregsmith.com>
  [2+ messages in thread]

un-understood index performance behaviour
  2008-07-01 10:49 UTC  Emiliano Leporati <emiliano.leporati@gmail.com>
` Re: un-understood index performance behaviour
  2008-07-01 14:17 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: un-understood index performance behaviour
  2008-07-01 14:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

sequence scan problem
  2008-06-29 21:52 UTC  John Beaver <john.e.beaver@gmail.com>
` Re: sequence scan problem
  2008-06-29 22:10 UTC  Jeremy Harris <jgh@wizmail.org>
` Re: sequence scan problem
  2008-06-29 22:20 UTC  John Beaver <john.e.beaver@gmail.com>
` Re: sequence scan problem
  2008-06-29 22:32 UTC  John Beaver <john.e.beaver@gmail.com>
` Re: sequence scan problem
  2008-06-30 03:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: sequence scan problem
  2008-06-30 10:59 UTC  John Beaver <john.e.beaver@gmail.com>
` Re: sequence scan problem
  2008-06-30 15:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: sequence scan problem
  2008-07-01 00:37 UTC  John Beaver <john.e.beaver@gmail.com>
  [8+ messages in thread]

Planner should use index on a LIKE 'foo%' query
  2008-06-28 16:24 UTC  Moritz Onken <onken@houseofdesign.de>
` Re: Planner should use index on a LIKE 'foo%' query
  2008-06-28 19:19 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Planner should use index on a LIKE 'foo%' query
  2008-06-30 07:16 UTC  Moritz Onken <onken@houseofdesign.de>
` Re: Planner should use index on a LIKE 'foo%' query
  2008-06-30 07:22 UTC  Moritz Onken <onken@houseofdesign.de>
` Re: Planner should use index on a LIKE 'foo%' query
  2008-06-30 10:19 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Planner should use index on a LIKE 'foo%' query
  2008-06-30 10:20 UTC  Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Planner should use index on a LIKE 'foo%' query
  2008-06-30 12:46 UTC  Moritz Onken <onken@houseofdesign.de>
` Re: Planner should use index on a LIKE 'foo%' query
  2008-06-30 12:52 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Planner should use index on a LIKE 'foo%' query
  2008-06-30 12:56 UTC  Moritz Onken <onken@houseofdesign.de>
` Re: Planner should use index on a LIKE 'foo%' query
  2008-06-30 16:11 UTC  Moritz Onken <onken@houseofdesign.de>
` Re: Planner should use index on a LIKE 'foo%' query
  2008-06-30 16:21 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Planner should use index on a LIKE 'foo%' query
  2008-06-30 16:42 UTC  Moritz Onken <onken@houseofdesign.de>
  [12+ messages in thread]

Federated Postgresql architecture ?
  2008-06-26 20:33 UTC  kevin kempter <kevin@kevinkempterllc.com>
` Re: Federated Postgresql architecture ?
  2008-06-26 20:57 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Federated Postgresql architecture ?
  2008-06-26 21:40 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Federated Postgresql architecture ?
  2008-06-26 21:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Federated Postgresql architecture ?
  2008-06-26 22:31 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Federated Postgresql architecture ?
  2008-06-27 02:05 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Federated Postgresql architecture ?
  2008-06-27 18:16 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Federated Postgresql architecture ?
  2008-06-30 13:16 UTC  Marko Kreen <markokr@gmail.com>
` Re: Federated Postgresql architecture ?
  2008-06-30 13:34 UTC  Jonah H. Harris <jonah.harris@gmail.com>
  [9+ messages in thread]

Out of memory for Select query.
  2008-06-30 04:20 UTC  Nimesh Satam <nimesh.zedo@gmail.com>
` Re: Out of memory for Select query.
  2008-06-30 06:59 UTC  Rusty Conover <rconover@infogears.com>
  [2+ messages in thread]

Sources of information about sizing of hardwares to run PostgreSQL
  2008-06-27 17:56 UTC  Sérgio R F Oliveira <sergio.r.f.oliveira@gmail.com>
` Re: Sources of information about sizing of hardwares to run PostgreSQL
  2008-06-29 19:04 UTC  Greg Smith <gsmith@gregsmith.com>
  [2+ messages in thread]

Hardware vs Software RAID
  2008-06-25 11:05 UTC  Adrian Moisey <adrian@careerjunction.co.za>
` Re: Hardware vs Software RAID
  2008-06-25 12:52 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Hardware vs Software RAID
  2008-06-25 13:03 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Hardware vs Software RAID
  2008-06-25 13:11 UTC  Peter T. Breuer <ptb@inv.it.uc3m.es>
` Re: Hardware vs Software RAID
  2008-06-25 15:24 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Hardware vs Software RAID
  2008-06-25 15:30 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Hardware vs Software RAID
  2008-06-25 15:35 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Hardware vs Software RAID
  2008-06-25 15:35 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Hardware vs Software RAID
  2008-06-25 15:53 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Hardware vs Software RAID
  2008-06-25 15:55 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Hardware vs Software RAID
  2008-06-25 16:05 UTC  Peter T. Breuer <ptb@inv.it.uc3m.es>
` Re: Hardware vs Software RAID
  2008-06-25 17:35 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Hardware vs Software RAID
  2008-06-25 17:46 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Hardware vs Software RAID
  2008-06-25 18:00 UTC  Andrew Sullivan <ajs@commandprompt.com>
` Re: Hardware vs Software RAID
  2008-06-25 18:07 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Hardware vs Software RAID
  2008-06-25 18:27 UTC  Andrew Sullivan <ajs@commandprompt.com>
` Re: Hardware vs Software RAID
  2008-06-25 19:59 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Hardware vs Software RAID
  2008-06-25 20:05 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Hardware vs Software Raid
  2008-06-26 05:03 UTC  Peter T. Breuer <ptb@inv.it.uc3m.es>
` Re: Hardware vs Software RAID
  2008-06-26 13:43 UTC  Vivek Khera <vivek@khera.org>
` Re: Hardware vs Software RAID
  2008-06-26 13:45 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Hardware vs Software RAID
  2008-06-26 13:49 UTC  Peter T. Breuer <ptb@inv.it.uc3m.es>
` Re: Hardware vs Software RAID
  2008-06-26 16:14 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Hardware vs Software RAID
  2008-06-26 16:31 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Hardware vs Software RAID
  2008-06-26 17:26 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Hardware vs Software RAID
  2008-06-26 17:35 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Hardware vs Software Raid
  2008-06-26 20:01 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Hardware vs Software Raid
  2008-06-26 20:17 UTC  david@lang.hm
` Re: Hardware vs Software Raid
  2008-06-26 23:15 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Hardware vs Software RAID
  2008-06-27 02:17 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Hardware vs Software RAID
  2008-06-27 11:00 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Hardware vs Software RAID
  2008-06-27 13:16 UTC  Merlin Moncure <mmoncure@gmail.com>
  [32+ messages in thread]

Hardware suggestions for high performance 8.3
  2008-06-25 10:16 UTC  Henrik <henke@mac.se>
` Re: Hardware suggestions for high performance 8.3
  2008-06-25 10:56 UTC  Claus Guttesen <kometen@gmail.com>
` Re: Hardware suggestions for high performance 8.3
  2008-06-25 11:15 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Hardware suggestions for high performance 8.3
  2008-06-25 12:12 UTC  Henrik <henke@mac.se>
` Re: Hardware suggestions for high performance 8.3
  2008-06-25 12:15 UTC  Henrik <henke@mac.se>
` Re: Hardware suggestions for high performance 8.3
  2008-06-25 12:40 UTC  Claus Guttesen <kometen@gmail.com>
` Re: Hardware suggestions for high performance 8.3
  2008-06-25 12:47 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Hardware suggestions for high performance 8.3
  2008-06-25 13:56 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Hardware suggestions for high performance 8.3
  2008-06-25 15:45 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Hardware suggestions for high performance 8.3
  2008-06-25 22:32 UTC  Henrik <henke@mac.se>
` Re: Hardware suggestions for high performance 8.3
  2008-06-26 13:35 UTC  Henrik <henke@mac.se>
` Re: Hardware suggestions for high performance 8.3
  2008-06-27 04:47 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Hardware suggestions for high performance 8.3
  2008-06-27 05:40 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Hardware suggestions for high performance 8.3
  2008-06-27 06:21 UTC  Joshua D. Drake <jd@commandprompt.com>
  [14+ messages in thread]

Postgresql update op is very very slow
  2008-06-25 03:12 UTC  jay <jackem.mojx@alibaba-inc.com>
` Re: Postgresql update op is very very slow
  2008-06-25 05:02 UTC  Rusty Conover <rconover@infogears.com>
` Re: Postgresql update op is very very slow
  2008-06-25 10:11 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Postgresql update op is very very slow
  2008-06-25 13:50 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: ??: Postgresql update op is very very slow
  2008-06-26 12:19 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: ??: Postgresql update op is very very slow
  2008-06-26 12:40 UTC  Holger Hoffstaette <holger@wizards.de>
` Re: ??: Postgresql update op is very very slow
  2008-06-26 13:16 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: ??: Postgresql update op is very very slow
  2008-06-26 13:53 UTC  Andrew Sullivan <ajs@commandprompt.com>
` Re: ??: Postgresql update op is very very slow
  2008-06-26 13:55 UTC  Andrew Sullivan <ajs@commandprompt.com>
` Re: ??: Postgresql update op is very very slow
  2008-06-26 14:53 UTC  Mark Mielke <mark@mark.mielke.cc>
` Re: ??: Postgresql update op is very very slow
  2008-06-26 22:15 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: ??: Postgresql update op is very very slow
  2008-06-26 22:20 UTC  Greg Smith <gsmith@gregsmith.com>
  [12+ messages in thread]

Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow
  2008-06-26 10:31 UTC  Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow
  2008-06-26 16:02 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [2+ messages in thread]

Re: [PERFORM] Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow
  2008-06-26 15:59 UTC  Scott Marlowe <scott.marlowe@gmail.com>

答复: [PERFORM] Postgresql update op is very very slow
  2008-06-25 07:39 UTC  jay <jackem.mojx@alibaba-inc.com>
` 答复: [PERFORM] Postgresql update op is very very slow
  2008-06-26 10:04 UTC  jay <jackem.mojx@alibaba-inc.com>
` Re: 答复: [PERFORM] Postgresql update op is very very slow
  2008-06-26 15:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Typecast bug?
  2008-06-26 04:17 UTC  Craig James <craig_james@emolecules.com>
` Re: Typecast bug?
  2008-06-26 05:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Typecast bug?
  2008-06-26 06:22 UTC  Craig James <craig_james@emolecules.com>
` Re: Typecast bug?
  2008-06-26 07:02 UTC  Frank Joerdens <frank@joerdens.de>
` Re: Typecast bug?
  2008-06-26 07:12 UTC  Guillaume Smet <guillaume.smet@gmail.com>
  [5+ 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