pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
JDBC/Stored procedure performance issue
  2008-01-28 17:59 UTC  Claire McLister <mclister@zeesource.net>
` Re: JDBC/Stored procedure performance issue
  2008-01-28 20:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: JDBC/Stored procedure performance issue
  2008-01-29 10:12 UTC  Matthew Lunnon <mlunnon@rwa-net.co.uk>
` Re: JDBC/Stored procedure performance issue
  2008-01-29 18:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: JDBC/Stored procedure performance issue
  2008-01-31 19:29 UTC  Claire McLister <mclister@zeesource.net>
  [5+ messages in thread]

planner chooses unoptimal plan on joins with complex key
  2008-01-23 13:48 UTC  Dmitry Potapov <fortune.fish@gmail.com>
` Re: planner chooses unoptimal plan on joins with complex key
  2008-01-23 13:58 UTC  Guillaume Smet <guillaume.smet@gmail.com>
` Re: planner chooses unoptimal plan on joins with complex key
  2008-01-23 17:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: planner chooses unoptimal plan on joins with complex key
  2008-01-25 02:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: planner chooses unoptimal plan on joins with complex key
  2008-01-29 15:25 UTC  Dmitry Potapov <fortune.fish@gmail.com>
` Re: planner chooses unoptimal plan on joins with complex key
  2008-01-29 21:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: planner chooses unoptimal plan on joins with complex key
  2008-01-31 11:40 UTC  Dmitry Potapov <fortune.fish@gmail.com>
  [7+ messages in thread]

8x2.5" or 6x3.5" disks
  2008-01-28 19:25 UTC  Christian Nicolaisen <blackbrrd@gmail.com>
` Re: 8x2.5" or 6x3.5" disks
  2008-01-28 20:28 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: 8x2.5" or 6x3.5" disks
  2008-01-29 08:06 UTC  Claus Guttesen <kometen@gmail.com>
` Re: 8x2.5" or 6x3.5" disks
  2008-01-29 08:32 UTC  david@lang.hm
` Re: 8x2.5" or 6x3.5" disks
  2008-01-29 10:29 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: 8x2.5" or 6x3.5" disks
  2008-01-29 11:43 UTC  Mike Smith <mike.smith@enterprisedb.com>
` Re: 8x2.5" or 6x3.5" disks
  2008-01-29 15:00 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: 8x2.5" or 6x3.5" disks
  2008-01-29 15:06 UTC  Craig James <craig_james@emolecules.com>
` Re: 8x2.5" or 6x3.5" disks
  2008-01-29 18:40 UTC  Mike Smith <mike.smith@enterprisedb.com>
  [9+ messages in thread]

analyze
  2008-01-29 14:28 UTC  Adrian Moisey <adrian@careerjunction.co.za>
` Re: analyze
  2008-01-29 18:09 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: analyze
  2008-01-29 18:36 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [3+ messages in thread]

Hard Drive Usage for Speeding up Big Queries
  2008-01-28 13:54 UTC  Alex Hochberger <alex@dsgi.us>
` Re: Hard Drive Usage for Speeding up Big Queries
  2008-01-28 15:19 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Hard Drive Usage for Speeding up Big Queries
  2008-01-29 02:56 UTC  Merlin Moncure <mmoncure@gmail.com>
  [3+ messages in thread]

Performance issues migrating from 743 to 826
  2008-01-28 11:41 UTC  Matthew Lunnon <mlunnon@rwa-net.co.uk>
` Re: Performance issues migrating from 743 to 826
  2008-01-28 12:41 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: Performance issues migrating from 743 to 826
  2008-01-28 15:14 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Performance issues migrating from 743 to 826
  2008-01-28 15:27 UTC  Matthew Lunnon <mlunnon@rwa-net.co.uk>
` Re: Performance issues migrating from 743 to 826
  2008-01-28 15:39 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Performance issues migrating from 743 to 826
  2008-01-28 15:49 UTC  Matthew Lunnon <mlunnon@rwa-net.co.uk>
` Re: Performance issues migrating from 743 to 826
  2008-01-28 15:54 UTC  Matthew Lunnon <mlunnon@rwa-net.co.uk>
  [7+ messages in thread]

Slow set-returning functions
  2008-01-20 11:40 UTC  Dean Rasheed <dean_rasheed@hotmail.com>
` Re: Slow set-returning functions
  2008-01-20 14:34 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Slow set-returning functions
  2008-01-20 15:25 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Slow set-returning functions
  2008-01-20 17:32 UTC  Dean Rasheed <dean_rasheed@hotmail.com>
` Re: Slow set-returning functions
  2008-01-20 18:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow set-returning functions
  2008-01-27 17:29 UTC  Dean Rasheed <dean_rasheed@hotmail.com>
` Re: Slow set-returning functions
  2008-01-27 19:16 UTC  Marcin Stępnicki <mstepnicki@gmail.com>
` Re: Slow set-returning functions
  2008-01-27 23:01 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Slow set-returning functions
  2008-01-28 12:38 UTC  Dean Rasheed <dean_rasheed@hotmail.com>
  [9+ messages in thread]

8.3rc1 Out of memory when performing update
  2008-01-24 23:46 UTC  Stephen Denne <Stephen.Denne@datamail.co.nz>
` Re: 8.3rc1 Out of memory when performing update
  2008-01-25 01:14 UTC  Fernando Ike <fike@midstorm.org>
` Re: 8.3rc1 Out of memory when performing update
  2008-01-25 02:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.3rc1 Out of memory when performing update
  2008-01-25 03:20 UTC  Stephen Denne <Stephen.Denne@datamail.co.nz>
` Re: 8.3rc1 Out of memory when performing update
  2008-01-25 04:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.3rc1 Out of memory when performing update
  2008-01-25 10:14 UTC  Stephen Denne <Stephen.Denne@datamail.co.nz>
` Re: 8.3rc1 Out of memory when performing update
  2008-01-25 18:32 UTC  cgallant@gmail.com
` Re: 8.3rc1 Out of memory when performing update
  2008-01-25 18:36 UTC  Roberts, Jon <Jon.Roberts@asurion.com>
` Re: 8.3rc1 Out of memory when performing update
  2008-01-25 18:45 UTC  Magnus Hagander <magnus@hagander.net>
` Re: 8.3rc1 Out of memory when performing update
  2008-01-27 21:55 UTC  Stephen Denne <Stephen.Denne@datamail.co.nz>
` Re: 8.3rc1 Out of memory when performing update
  2008-01-28 04:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.3rc1 Out of memory when performing update
  2008-01-28 05:04 UTC  Stephen Denne <Stephen.Denne@datamail.co.nz>
` Re: 8.3rc1 Out of memory when performing update
  2008-01-28 08:18 UTC  Guillaume Smet <guillaume.smet@gmail.com>
  [13+ messages in thread]

Postgres 8.2 memory weirdness
  2008-01-23 18:23 UTC  Tory M Blue <tmblue@gmail.com>
` Re: Postgres 8.2 memory weirdness
  2008-01-24 00:31 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Postgres 8.2 memory weirdness
  2008-01-24 17:46 UTC  Tory M Blue <tmblue@gmail.com>
` Re: Postgres 8.2 memory weirdness
  2008-01-24 18:49 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Postgres 8.2 memory weirdness
  2008-01-25 17:36 UTC  Tory M Blue <tmblue@gmail.com>
` Re: Postgres 8.2 memory weirdness
  2008-01-28 00:08 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Postgres 8.2 memory weirdness
  2008-01-28 06:09 UTC  Tory M Blue <tmblue@gmail.com>
  [7+ messages in thread]

1 or 2 servers for large DB scenario.
  2008-01-25 16:36 UTC  David Brain <dbrain@bandwidth.com>
` Re: 1 or 2 servers for large DB scenario.
  2008-01-25 16:55 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: 1 or 2 servers for large DB scenario.
  2008-01-25 16:56 UTC  Matthew <matthew@flymine.org>
` Re: 1 or 2 servers for large DB scenario.
  2008-01-25 17:00 UTC  Matthew <matthew@flymine.org>
` Re: 1 or 2 servers for large DB scenario.
  2008-01-27 10:47 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: 1 or 2 servers for large DB scenario.
  2008-01-28 00:53 UTC  Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: 1 or 2 servers for large DB scenario.
  2008-01-28 04:25 UTC  Merlin Moncure <mmoncure@gmail.com>
  [7+ messages in thread]

Vacuum and FSM page size
  2008-01-23 18:29 UTC  Thomas Lozza <thomas.lozza@nexustelecom.com>
` Re: Vacuum and FSM page size
  2008-01-23 19:02 UTC  Decibel! <decibel@decibel.org>
` Re: Vacuum and FSM page size
  2008-01-23 19:22 UTC  Vivek Khera <khera@kcilink.com>
` Re: Vacuum and FSM page size
  2008-01-23 20:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Vacuum and FSM page size
  2008-01-24 15:48 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Vacuum and FSM page size
  2008-01-27 23:01 UTC  Thomas Lozza <thomas.lozza@nexustelecom.com>
` Re: Vacuum and FSM page size
  2008-01-27 23:54 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [7+ messages in thread]

Making the most of memory?
  2008-01-23 04:11 UTC  Joshua Fielek <jfielek@centriccrm.com>
` Re: Making the most of memory?
  2008-01-23 05:20 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Making the most of memory?
  2008-01-23 14:59 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Making the most of memory?
  2008-01-23 18:44 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Making the most of memory?
  2008-01-23 19:06 UTC  Rich <rhdyes@gmail.com>
` Re: Making the most of memory?
  2008-01-23 19:57 UTC  Guy Rouillier <guyr-ml1@burntmail.com>
` Re: Making the most of memory?
  2008-01-23 20:40 UTC  A.M. <agentm@themactionfaction.com>
` Re: Making the most of memory?
  2008-01-23 20:50 UTC  Brian Hurt <bhurt@janestcapital.com>
` Re: Making the most of memory?
  2008-01-23 21:06 UTC  Craig James <craig_james@emolecules.com>
` Re: Making the most of memory?
  2008-01-24 00:54 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Making the most of memory?
  2008-01-24 01:45 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Making the most of memory?
  2008-01-24 08:05 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Making the most of memory?
  2008-01-24 09:19 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Making the most of memory?
  2008-01-24 14:01 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Making the most of memory?
  2008-01-24 14:15 UTC  Matthew <matthew@flymine.org>
` Re: Making the most of memory?
  2008-01-24 14:26 UTC  Florian Weimer <fweimer@bfk.de>
` Re: Making the most of memory?
  2008-01-24 16:09 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Making the most of memory?
  2008-01-24 16:23 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Making the most of memory?
  2008-01-24 18:01 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Making the most of memory?
  2008-01-24 18:21 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Making the most of memory?
  2008-01-25 08:18 UTC  Florian Weimer <fweimer@bfk.de>
  [21+ messages in thread]

Configuration settings (shared_buffers, etc) in Linux: puzzled
  2008-01-24 18:00 UTC  Rick Schumeyer <rschumeyer@ieee.org>
` Re: Configuration settings (shared_buffers, etc) in Linux: puzzled
  2008-01-24 18:52 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Configuration settings (shared_buffers, etc) in Linux: puzzled
  2008-01-25 01:53 UTC  Fernando Ike <fike@midstorm.org>
  [3+ messages in thread]

*_cost recommendation with 8.3 and a fully cached db
  2008-01-23 12:36 UTC  Guillaume Smet <guillaume.smet@gmail.com>

Workaround for cross column stats dependency
  2008-01-23 00:57 UTC  Guillaume Smet <guillaume.smet@gmail.com>
` Re: Workaround for cross column stats dependency
  2008-01-23 01:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Workaround for cross column stats dependency
  2008-01-23 02:02 UTC  Guillaume Smet <guillaume.smet@gmail.com>
` Re: Workaround for cross column stats dependency
  2008-01-23 09:05 UTC  Guillaume Smet <guillaume.smet@gmail.com>
  [4+ messages in thread]

SELECT * FROM table is too slow
  2007-12-16 18:34 UTC  Adam PAPAI <wooh@wooh.hu>
` Re: SELECT * FROM table is too slow
  2007-12-16 18:37 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: SELECT * FROM table is too slow
  2007-12-16 19:03 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: SELECT * FROM table is too slow
  2007-12-16 22:49 UTC  andrew@pillette.com
` Re: SELECT * FROM table is too slow
  2008-01-22 19:44 UTC  Luiz K. Matsumura <luiz@planit.com.br>
` Re: SELECT * FROM table is too slow
  2008-01-22 20:19 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: SELECT * FROM table is too slow
  2008-01-23 08:47 UTC  Guillaume Cottenceau <gc@mnc.ch>
  [7+ messages in thread]

Optimizing queries that use temporary tables
  2008-01-22 19:32 UTC  Luiz K. Matsumura <luiz@planit.com.br>
` Re: Optimizing queries that use temporary tables
  2008-01-22 20:34 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [2+ messages in thread]

8.3 synchronous_commit
  2008-01-21 21:55 UTC  Hannes Dorbath <light@theendofthetunnel.de>
` Re: 8.3 synchronous_commit
  2008-01-21 22:11 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: 8.3 synchronous_commit
  2008-01-21 22:25 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: 8.3 synchronous_commit
  2008-01-21 23:31 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: 8.3 synchronous_commit
  2008-01-21 23:45 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: 8.3 synchronous_commit
  2008-01-22 00:26 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: 8.3 synchronous_commit
  2008-01-22 00:48 UTC  Fernando Ike <fike@midstorm.org>
` Re: 8.3 synchronous_commit
  2008-01-22 08:32 UTC  Florian Weimer <fweimer@bfk.de>
` Re: 8.3 synchronous_commit
  2008-01-22 08:49 UTC  Guillaume Smet <guillaume.smet@gmail.com>
` Re: 8.3 synchronous_commit
  2008-01-22 08:56 UTC  Florian Weimer <fweimer@bfk.de>
` Re: 8.3 synchronous_commit
  2008-01-22 11:56 UTC  Hannes Dorbath <light@theendofthetunnel.de>
` Re: 8.3 synchronous_commit
  2008-01-22 12:13 UTC  Hannes Dorbath <light@theendofthetunnel.de>
  [12+ messages in thread]

scheduler
  2008-01-22 07:00 UTC  Adrian Moisey <adrian@careerjunction.co.za>
` Re: scheduler
  2008-01-22 08:10 UTC  Claus Guttesen <kometen@gmail.com>
` Re: scheduler
  2008-01-22 08:27 UTC  Adrian Moisey <adrian@careerjunction.co.za>
` Re: scheduler
  2008-01-22 08:37 UTC  david@lang.hm
` Re: scheduler
  2008-01-22 08:45 UTC  Luke Lonergan <LLonergan@greenplum.com>
  [5+ messages in thread]

strange pauses
  2008-01-16 10:42 UTC  Adrian Moisey <adrian@careerjunction.co.za>
` Re: strange pauses
  2008-01-16 10:50 UTC  Richard Huxton <dev@archonet.com>
` Re: strange pauses
  2008-01-16 15:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: strange pauses
  2008-01-16 15:30 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: strange pauses
  2008-01-16 15:37 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: strange pauses
  2008-01-17 06:50 UTC  Adrian Moisey <adrian@careerjunction.co.za>
` Re: strange pauses
  2008-01-17 09:16 UTC  Brian Herlihy <btherl@yahoo.com.au>
` Re: strange pauses
  2008-01-17 13:44 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: strange pauses
  2008-01-18 10:58 UTC  Adrian Moisey <adrian@careerjunction.co.za>
` Re: strange pauses
  2008-01-18 12:03 UTC  Adrian Moisey <adrian@careerjunction.co.za>
` Re: strange pauses
  2008-01-18 12:41 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: strange pauses
  2008-01-18 15:36 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: strange pauses
  2008-01-21 07:58 UTC  Adrian Moisey <adrian@careerjunction.co.za>
` Re: strange pauses
  2008-01-21 19:29 UTC  Decibel! <decibel@decibel.org>
  [14+ messages in thread]

Slow performance with left outer join
  2008-01-21 15:00 UTC  Marten Verhoeven <m.verhoeven@van-beek.nl>
` Re: Slow performance with left outer join
  2008-01-21 15:17 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Slow performance with left outer join
  2008-01-21 16:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow performance with left outer join
  2008-01-21 18:04 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [4+ messages in thread]

[OT] RAID controllers blocking one another?
  2008-01-17 20:17 UTC  Sean Davis <sdavis2@mail.nih.gov>
` Re: [OT] RAID controllers blocking one another?
  2008-01-17 21:07 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: [OT] RAID controllers blocking one another?
  2008-01-17 23:23 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: [OT] RAID controllers blocking one another?
  2008-01-17 23:30 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: [OT] RAID controllers blocking one another?
  2008-01-18 13:03 UTC  Sean Davis <sdavis2@mail.nih.gov>
` Re: [OT] RAID controllers blocking one another?
  2008-01-18 19:14 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: [OT] RAID controllers blocking one another?
  2008-01-18 19:35 UTC  Sean Davis <sdavis2@mail.nih.gov>
` Re: [OT] RAID controllers blocking one another?
  2008-01-19 17:31 UTC  david@lang.hm
  [8+ messages in thread]

Tuning Postgresql on Windows XP Pro 32 bit [was on HACKERS list]
  2008-01-15 17:05 UTC  Doug Knight <dknight@wsi.com>
` Re: Tuning Postgresql on Windows XP Pro 32 bit [was on HACKERS list]
  2008-01-18 22:50 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [2+ messages in thread]

Saving result set of SELECT to table column
  2008-01-14 18:19 UTC  Patric <lists@p-dw.com>
` Re: Saving result set of SELECT to table column
  2008-01-14 18:38 UTC  Ansgar -59cobalt- Wiechers <lists@planetcobalt.net>
` Re: Saving result set of SELECT to table column
  2008-01-15 03:30 UTC  Robins Tharakan <tharakan@gmail.com>
  [3+ messages in thread]

Seq scans on indexed columns.
  2008-01-14 14:18 UTC  Yannick Le Guédart <yannick@over-blog.com>
` Re: Seq scans on indexed columns.
  2008-01-14 14:34 UTC  Guillaume Cottenceau <gc@mnc.ch>
` Re: Seq scans on indexed columns.
  2008-01-14 19:06 UTC  Shane Ambler <pgsql@Sheeky.Biz>
  [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