pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline)
  2008-05-05 23:33 UTC  Craig James <craig_james@emolecules.com>
` Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline)
  2008-05-06 03:15 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline)
  2008-05-06 03:59 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline)
  2008-05-06 12:26 UTC  Jeff <threshar@torgo.978.org>
` Re: RAID 10 Benchmark with different I/O schedulers
  2008-05-06 18:30 UTC  Craig James <craig_james@emolecules.com>
` Re: RAID 10 Benchmark with different I/O schedulers
  2008-05-06 20:21 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: RAID 10 Benchmark with different I/O schedulers
  2008-05-06 20:43 UTC  Craig James <craig_james@emolecules.com>
` Re: RAID 10 Benchmark with different I/O schedulers
  2008-05-07 07:29 UTC  Albe Laurenz *EXTERN* <laurenz.albe@wien.gv.at>
` Re: RAID 10 Benchmark with different I/O schedulers
  2008-05-07 10:46 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: RAID 10 Benchmark with different I/O schedulers
  2008-06-26 01:52 UTC  Craig James <craig_james@emolecules.com>
  [10+ messages in thread]

Query Planner not choosing hash_aggregate appropriately.
  2008-06-25 20:42 UTC  Scott Carey <scott@richrelevance.com>

PostgreSQL and Ruby on Rails - better accessibility
  2008-06-25 07:46 UTC  Amol Pujari <amol_pujari@persistent.co.in>
` Re: PostgreSQL and Ruby on Rails - better accessibility
  2008-06-25 08:33 UTC  Nikhils <nikkhils@gmail.com>
  [2+ messages in thread]

Postgresql is very slow
  2008-06-23 11:06 UTC  bijayant kumar <bijayant4u@yahoo.com>
` Re: Postgresql is very slow
  2008-06-23 12:35 UTC  Jan de Visser <jdevisser@digitalfairway.com>
` Re: Postgresql is very slow
  2008-06-23 13:36 UTC  Jeremy Harris <jgh@wizmail.org>
` Re: Postgresql is very slow
  2008-06-23 13:50 UTC  tv@fuzzy.cz
` Re: Postgresql is very slow
  2008-06-23 16:06 UTC  Gregory S. Youngblood <greg@tcscs.com>
` Re: Postgresql is very slow
  2008-06-24 05:48 UTC  bijayant kumar <bijayant4u@yahoo.com>
` Re: Postgresql is very slow
  2008-06-24 07:51 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgresql is very slow
  2008-06-24 07:52 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgresql is very slow
  2008-06-24 08:17 UTC  tv@fuzzy.cz
` Re: Postgresql is very slow
  2008-06-24 09:17 UTC  bijayant kumar <bijayant4u@yahoo.com>
` Re: Postgresql is very slow
  2008-06-24 09:33 UTC  Ian Barwick <barwick@gmail.com>
` Re: Postgresql is very slow
  2008-06-24 10:02 UTC  tv@fuzzy.cz
` Re: Postgresql is very slow
  2008-06-24 11:25 UTC  PFC <lists@peufeu.com>
` Re: Postgresql is very slow
  2008-06-24 12:12 UTC  bijayant kumar <bijayant4u@yahoo.com>
` Re: [SOLVED] Postgresql is very slow
  2008-06-25 05:41 UTC  bijayant kumar <bijayant4u@yahoo.com>
  [15+ messages in thread]

Checkpoint tuning on 8.2.4
  2008-06-06 06:30 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Checkpoint tuning on 8.2.4
  2008-06-06 17:22 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Checkpoint tuning on 8.2.4
  2008-06-23 22:42 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [3+ messages in thread]

Tsearch2 Initial Search Speed
  2008-06-16 17:55 UTC  Howard Cole <howardnews@selestial.com>
` Re: Tsearch2 Initial Search Speed
  2008-06-16 18:24 UTC  Alan Hodgson <ahodgson@simkin.ca>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 09:54 UTC  Howard Cole <howardnews@selestial.com>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 10:54 UTC  Howard Cole <howardnews@selestial.com>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 11:00 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 11:04 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 11:23 UTC  Howard Cole <howardnews@selestial.com>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 11:30 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 11:59 UTC  Howard Cole <howardnews@selestial.com>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 13:13 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 13:28 UTC  Howard Cole <howardnews@selestial.com>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 15:55 UTC  Alan Hodgson <ahodgson@simkin.ca>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 15:56 UTC  Alan Hodgson <ahodgson@simkin.ca>
` Re: Tsearch2 Initial Search Speed
  2008-06-17 16:04 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Tsearch2 Initial Search Speed
  2008-06-18 10:40 UTC  Howard Cole <howardnews@selestial.com>
` Re: Tsearch2 Initial Search Speed
  2008-06-18 12:38 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Tsearch2 Initial Search Speed
  2008-06-19 09:03 UTC  Howard Cole <howardnews@selestial.com>
` Re: Tsearch2 Initial Search Speed
  2008-06-20 13:10 UTC  Howard Cole <howardnews@selestial.com>
  [18+ messages in thread]

Which hardware ?
  2008-06-17 13:38 UTC  Lionel <lionel@art-informatique.com>
` Re: Which hardware ?
  2008-06-17 14:23 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Which hardware ?
  2008-06-17 14:25 UTC  Andrew Sullivan <ajs@commandprompt.com>
` Re: Which hardware ?
  2008-06-17 14:31 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Which hardware ?
  2008-06-17 14:33 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Which hardware ?
  2008-06-17 14:49 UTC  Lionel <lionel@art-informatique.com>
` Re: Which hardware ?
  2008-06-17 15:32 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Which hardware ?
  2008-06-17 15:42 UTC  Andrew Sullivan <ajs@commandprompt.com>
` Re: Which hardware ?
  2008-06-17 15:42 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Which hardware ?
  2008-06-17 16:22 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Which hardware ?
  2008-06-17 16:32 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Which hardware ?
  2008-06-17 16:56 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Which hardware ?
  2008-06-17 17:07 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Which hardware ?
  2008-06-17 17:59 UTC  Lionel <lionel@art-informatique.com>
` Re: Which hardware ?
  2008-06-17 18:28 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Which hardware ?
  2008-06-17 21:15 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Which hardware ?
  2008-06-18 01:14 UTC  Jon D <slackmaster22@hotmail.com>
` Re: Which hardware ?
  2008-06-20 10:53 UTC  Lionel <lionel@art-informatique.com>
  [18+ messages in thread]

WAL DUDAS
  2008-06-18 19:43 UTC  Antonio Perez <renjin25@yahoo.com>
` Re: [PERFORM] WAL DUDAS
  2008-06-18 23:19 UTC  Jaime Casanova <systemguards@gmail.com>
` Re: WAL DUDAS
  2008-06-19 07:13 UTC  Albe Laurenz <laurenz.albe@wien.gv.at>
  [3+ messages in thread]

Partial backup of linked tables
  2008-06-18 16:18 UTC  Cisko <78cisko78@gmail.com>

Migration Articles.. ???
  2008-06-17 13:13 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: [PERFORM] Migration Articles.. ???
  2008-06-17 13:23 UTC  Matthew Wakeling <matthew@flymine.org>
  [2+ messages in thread]

function difference(geometry,geometry) is SLOW!
  2008-06-16 09:06 UTC  luke.78@libero.it <luke.78@libero.it>
` Re: [pgsql-performance] function difference(geometry, geometry) is SLOW!
  2008-06-16 19:26 UTC  Chris Mair <chris@1006.org>
  [2+ messages in thread]

how to find the sql using most of the i/o in an oltp system
  2008-06-15 13:48 UTC  Uwe Bartels <uwe.bartels@gmail.com>
` Re: how to find the sql using most of the i/o in an oltp system
  2008-06-15 14:41 UTC  Uwe Bartels <uwe.bartels@gmail.com>
` Re: how to find the sql using most of the i/o in an oltp system
  2008-06-15 14:53 UTC  Gavin M. Roy <gmr@myyearbook.com>
  [3+ messages in thread]

8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
  2008-06-12 01:40 UTC  Josh Rovero <rovero@sonalysts.com>
` Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
  2008-06-12 12:28 UTC  Kenneth Marshall <ktm@rice.edu>
` Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
  2008-06-12 12:54 UTC  Josh Rovero <rovero@sonalysts.com>
  [3+ messages in thread]

Scalability question
  2008-06-11 09:56 UTC  Zoltan Boszormenyi <zb@cybertec.at>
` Re: Scalability question
  2008-06-11 10:15 UTC  tv@fuzzy.cz
` Re: Scalability question
  2008-06-11 10:35 UTC  Zoltan Boszormenyi <zb@cybertec.at>
` Re: Scalability question
  2008-06-11 13:34 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Scalability question
  2008-06-11 14:13 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [5+ messages in thread]

Performance of aggregates over set-returning functions
  2008-01-09 02:21 UTC  John Smith <sodgodofall@gmail.com>
` Re: Performance of aggregates over set-returning functions
  2008-01-09 03:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance of aggregates over set-returning functions
  2008-01-09 03:33 UTC  John Smith <sodgodofall@gmail.com>
` Re: Performance of aggregates over set-returning functions
  2008-01-09 03:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance of aggregates over set-returning functions
  2008-03-06 17:23 UTC  Bruce Momjian <bruce@momjian.us>
` Re: Performance of aggregates over set-returning functions
  2008-03-06 17:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance of aggregates over set-returning functions
  2008-03-06 18:01 UTC  Bruce Momjian <bruce@momjian.us>
` Re: Performance of aggregates over set-returning functions
  2008-06-09 22:57 UTC  John Smith <sodgodofall@gmail.com>
` Re: Performance of aggregates over set-returning functions
  2008-06-10 00:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [9+ messages in thread]

Optimizing AGE()
  2008-06-06 13:20 UTC  Volkan YAZICI <yazicivo@ttmail.com>
` Re: Optimizing AGE()
  2008-06-08 06:09 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [2+ messages in thread]

PgPool parallel query performance rules of thumb
  2008-06-04 15:58 UTC  John Beaver <john.e.beaver@gmail.com>
` Re: PgPool parallel query performance rules of thumb
  2008-06-06 15:01 UTC  Mason Sharp <mason.sharp@enterprisedb.com>
  [2+ messages in thread]

insert/update tps slow with indices on table > 1M rows
  2008-06-03 22:36 UTC  andrew klassen <aptklassen@yahoo.com>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 00:15 UTC  PFC <lists@peufeu.com>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 02:44 UTC  andrew klassen <aptklassen@yahoo.com>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 06:02 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 10:31 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 15:05 UTC  andrew klassen <aptklassen@yahoo.com>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 15:10 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 17:24 UTC  andrew klassen <aptklassen@yahoo.com>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 20:15 UTC  James Mansion <james@mansionfamily.plus.com>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 20:20 UTC  James Mansion <james@mansionfamily.plus.com>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 21:30 UTC  andrew klassen <aptklassen@yahoo.com>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 21:50 UTC  PFC <lists@peufeu.com>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-04 22:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert/update tps slow with indices on table > 1M rows
  2008-06-05 06:18 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
  [14+ messages in thread]

Outer joins and equivalence
  2008-05-27 19:59 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Outer joins and equivalence
  2008-05-27 21:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Outer joins and equivalence
  2008-05-28 10:45 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: Outer joins and equivalence
  2008-05-28 13:39 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Outer joins and equivalence
  2008-06-02 17:10 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Outer joins and equivalence
  2008-06-02 19:47 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: [PERFORM] Outer joins and equivalence
  2008-06-05 02:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Outer joins and equivalence
  2008-06-05 05:17 UTC  Simon Riggs <simon@2ndquadrant.com>
  [8+ messages in thread]

RAM / Disk ratio, any rule?
  2008-06-04 14:02 UTC  Mathieu Gilardet <mgilardet@alaloop.com>
` Re: RAM / Disk ratio, any rule?
  2008-06-05 00:32 UTC  Greg Smith <gsmith@gregsmith.com>
  [2+ messages in thread]

backend pid changing
  2008-06-04 14:44 UTC  Lewis Kapell <lkapell@setonhome.org>
` Re: backend pid changing
  2008-06-04 15:06 UTC  Matthew Wakeling <matthew@flymine.org>
` Re: backend pid changing
  2008-06-04 15:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: backend pid changing
  2008-06-04 15:18 UTC  Lewis Kapell <lkapell@setonhome.org>
  [4+ messages in thread]

getting estimated cost to agree with actual
  2008-06-02 21:43 UTC  Justin <justin@emproshunts.com>
` Re: getting estimated cost to agree with actual
  2008-06-02 23:38 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: getting estimated cost to agree with actual
  2008-06-03 01:20 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: getting estimated cost to agree with actual
  2008-06-03 03:06 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [4+ messages in thread]

2GB or not 2GB
  2008-05-28 23:59 UTC  Josh Berkus <josh@agliodbs.com>
` Re: 2GB or not 2GB
  2008-05-29 00:04 UTC  Steve Crawford <scrawford@pinpointresearch.com>
` Re: 2GB or not 2GB
  2008-05-29 00:25 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: 2GB or not 2GB
  2008-05-29 01:06 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: 2GB or not 2GB
  2008-05-29 02:54 UTC  Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: 2GB or not 2GB
  2008-05-29 03:01 UTC  Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: 2GB or not 2GB
  2008-05-29 15:45 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: 2GB or not 2GB
  2008-05-29 19:50 UTC  Magnus Hagander <magnus@hagander.net>
` Re: 2GB or not 2GB
  2008-05-31 07:44 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: 2GB or not 2GB
  2008-05-31 18:53 UTC  Josh Berkus <josh@agliodbs.com>
` Re: 2GB or not 2GB
  2008-05-31 19:41 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: 2GB or not 2GB
  2008-06-01 09:10 UTC  Simon Riggs <simon@2ndquadrant.com>
  [12+ messages in thread]

Statistics issue
  2008-05-30 11:02 UTC  Vlad Arkhipov <arhipov@dc.baikal.ru>
` Re: Statistics issue
  2008-05-31 15:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

ProcArrayLock (The Saga continues)
  2008-05-29 22:08 UTC  Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: ProcArrayLock (The Saga continues)
  2008-05-30 00:19 UTC  Gregory Stark <stark@enterprisedb.com>
  [2+ 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