pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Lengthy pg_restore and high iowait?
  2004-02-13 21:03 UTC  Leon Out <leon-lists@comvision.com>

select count(*) from anIntColumn where int_value = 0; is very slow
  2004-02-11 13:03 UTC  David Teran <david.teran@cluster9.com>
` Re: select count(*) from anIntColumn where int_value = 0;
  2004-02-11 13:11 UTC  Pavel Stehule <stehule@kix.fsv.cvut.cz>
` Re: select count(*) from anIntColumn where int_value = 0; is very slow
  2004-02-11 13:12 UTC  Rigmor Ukuhe <rigmor.ukuhe@finestmedia.com>
` Re: select count(*) from anIntColumn where int_value = 0; is very slow
  2004-02-11 13:32 UTC  David Teran <david.teran@cluster9.com>
` Re: select count(*) from anIntColumn where int_value = 0; is very slow
  2004-02-11 13:42 UTC  PC Drew <drewpc@ibsncentral.com>
` Re: select count(*) from anIntColumn where int_value = 0;
  2004-02-11 14:14 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: select count(*) from anIntColumn where int_value = 0;
  2004-02-11 16:02 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: select count(*) from anIntColumn where int_value =
  2004-02-12 02:01 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [8+ messages in thread]

slow database
  2004-02-11 14:23 UTC  alemon@tiago.hazor.com.br
` Re: slow database
  2004-02-11 14:27 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: slow database
  2004-02-11 14:28 UTC  PC Drew <drewpc@ibsncentral.com>
` Re: slow database
  2004-02-11 14:44 UTC  PC Drew <drewpc@ibsncentral.com>
` Re: slow database
  2004-02-11 14:49 UTC  Rod Taylor <pg@rbt.ca>
` Re: slow database
  2004-02-11 15:36 UTC  Chris Trawick <ctrawick@cultured.net>
` Re: slow database
  2004-02-11 15:39 UTC  Chris Browne <cbbrowne@acm.org>
` Re: slow database
  2004-02-11 16:16 UTC  alemon@tiago.hazor.com.br
` Re: slow database
  2004-02-11 16:19 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: slow database
  2004-02-11 17:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow database
  2004-02-11 17:15 UTC  alemon@tiago.hazor.com.br
` Re: slow database
  2004-02-11 17:48 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: slow database
  2004-02-11 17:55 UTC  Rod Taylor <pg@rbt.ca>
` Re: slow database
  2004-02-11 18:18 UTC  alemon@tiago.hazor.com.br
` Re: slow database
  2004-02-11 18:41 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: slow database
  2004-02-12 01:27 UTC  Mark Kirkwood <markir@paradise.net.nz>
  [16+ messages in thread]

coercing int to bigint for indexing purposes
  2004-02-11 22:38 UTC  Mark Harrison <mh@pixar.com>
` Re: coercing int to bigint for indexing purposes
  2004-02-11 23:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

update performance
  2004-02-11 14:08 UTC  stefan bogdan <sbogdan@rsb.ro>
` Re: update performance
  2004-02-11 15:53 UTC  Richard Huxton <dev@archonet.com>
` Re: update performance
  2004-02-11 16:10 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: update performance
  2004-02-11 16:36 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [4+ messages in thread]

Why is query selecting sequential?
  2004-02-06 21:36 UTC  Karl Denninger <karl@Denninger.Net>
` Re: Why is query selecting sequential?
  2004-02-06 21:51 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why is query selecting sequential?
  2004-02-06 22:22 UTC  Karl Denninger <karl@denninger.net>
` Re: Why is query selecting sequential?
  2004-02-06 22:36 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why is query selecting sequential?
  2004-02-07 01:53 UTC  Karl Denninger <karl@denninger.net>
` Re: Why is query selecting sequential?
  2004-02-07 06:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why is query selecting sequential?
  2004-02-07 16:10 UTC  Karl Denninger <karl@denninger.net>
` Re: Why is query selecting sequential?
  2004-02-09 05:34 UTC  Josh Berkus <josh@agliodbs.com>
  [8+ messages in thread]

RE : RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ?
  2004-02-08 00:26 UTC  Bruno BAGUETTE <pgsql-ml@baguette.net>
` Re: RE : RE : Increase performance of a UNION query that
  2004-02-08 05:36 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [2+ messages in thread]

7.3 vs 7.4 performance
  2004-02-05 05:16 UTC  Orion Henry <orion@trustcommerce.com>
` Re: 7.3 vs 7.4 performance
  2004-02-05 05:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: 7.3 vs 7.4 performance
  2004-02-05 05:32 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: 7.3 vs 7.4 performance
  2004-02-05 06:50 UTC  Chris Trawick <ctrawick@cultured.net>
` Re: 7.3 vs 7.4 performance
  2004-02-05 11:14 UTC  Carlos Eduardo Smanioto <csmanioto@uol.com.br>
` Re: 7.3 vs 7.4 performance
  2004-02-05 13:30 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: 7.3 vs 7.4 performance
  2004-02-05 15:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 7.3 vs 7.4 performance
  2004-02-05 18:04 UTC  Orion Henry <orion@trustcommerce.com>
` Re: 7.3 vs 7.4 performance
  2004-02-06 10:43 UTC  Hannu Krosing <hannu@tm.ee>
` Re: 7.3 vs 7.4 performance
  2004-02-06 10:44 UTC  Hannu Krosing <hannu@tm.ee>
` Re: 7.3 vs 7.4 performance
  2004-02-06 17:05 UTC  markw@osdl.org
` Re: 7.3 vs 7.4 performance
  2004-02-07 01:02 UTC  Orion Henry <orion@trustcommerce.com>
` Re: 7.3 vs 7.4 performance
  2004-02-07 01:03 UTC  Orion Henry <orion@trustcommerce.com>
` Re: 7.3 vs 7.4 performance
  2004-02-07 01:49 UTC  Orion Henry <orion@trustcommerce.com>
` Re: 7.3 vs 7.4 performance
  2004-02-07 02:32 UTC  Josh Berkus <josh@agliodbs.com>
` Re: 7.3 vs 7.4 performance
  2004-02-07 07:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [16+ messages in thread]

Seq scan on zero-parameters function
  2004-02-06 07:19 UTC  Octavio Alvarez <alvarezp@alvarezp.ods.org>
` Re: Seq scan on zero-parameters function
  2004-02-06 08:43 UTC  Octavio Alvarez <alvarezp@alvarezp.ods.org>
` Re: Seq scan on zero-parameters function
  2004-02-06 08:50 UTC  Richard Huxton <dev@archonet.com>
` Re: [PERFORM] Seq scan on zero-parameters function
  2004-02-06 08:55 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Seq scan on zero-parameters function
  2004-02-06 14:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Seq scan on zero-parameters function
  2004-02-06 17:24 UTC  Octavio Alvarez <alvarezp@alvarezp.ods.org>
  [6+ messages in thread]

RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ?
  2004-02-06 16:34 UTC  Bruno BAGUETTE <pgsql-ml@baguette.net>
` RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ?
  2004-02-06 16:41 UTC  Bruno BAGUETTE <pgsql-ml@baguette.net>
` Re: RE : Increase performance of a UNION query that thakes
  2004-02-06 17:13 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [3+ messages in thread]

Increase performance of a UNION query that thakes 655.07 msec to be runned ?
  2004-02-06 08:58 UTC  Bruno BAGUETTE <pgsql-ml@baguette.net>
` Re: Increase performance of a UNION query that thakes 655.07 msec to be runned ?
  2004-02-06 15:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Increase performance of a UNION query that thakes
  2004-02-06 15:52 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [3+ messages in thread]

COPY with INDEXES  question
  2004-02-06 00:46 UTC  Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>
` Re: COPY with INDEXES  question
  2004-02-06 02:52 UTC  Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>
` Re: COPY with INDEXES  question
  2004-02-06 02:54 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: COPY with INDEXES  question
  2004-02-06 02:55 UTC  Rod Taylor <rbt@rbt.ca>
  [4+ messages in thread]

MySQL+InnoDB vs. PostgreSQL test?
  2004-02-02 17:21 UTC  Josh Berkus <josh@agliodbs.com>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-02 18:06 UTC  Adam Ruth <aruth@intercation.com>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-02 20:14 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 00:44 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 01:18 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 01:47 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 02:20 UTC  Adam Ruth <adamruth@mac.com>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 03:04 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 03:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 04:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 04:30 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 04:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 04:54 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 04:55 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 05:17 UTC  Josh Berkus <josh@agliodbs.com>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 05:52 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 13:52 UTC  Jeff <threshar@torgo.978.org>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 14:02 UTC  Rigmor Ukuhe <rigmor.ukuhe@finestmedia.com>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 15:53 UTC  Jeff <threshar@torgo.978.org>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 16:19 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 16:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 16:55 UTC  Jeff <threshar@torgo.978.org>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 17:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: MySQL+InnoDB vs. PostgreSQL test?
  2004-02-03 17:16 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-04 13:36 UTC  Mike Nolan <nolan@gw.tssi.com>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-04 21:54 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  2004-02-05 23:09 UTC  Mark Harrison <mh@pixar.com>
  [27+ messages in thread]

select is not using index?
  2004-02-04 22:55 UTC  Mark Harrison <mh@pixar.com>
` Re: select is not using index?
  2004-02-04 23:22 UTC  Corey Edwards <coreyed@linxtechnologies.com>
` Re: select is not using index?
  2004-02-05 17:31 UTC  Mark Harrison <mh@pixar.com>
  [3+ messages in thread]

COPY from question
  2004-02-03 00:55 UTC  Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>
` Re: COPY from question
  2004-02-03 04:01 UTC  Kris Jurka <books@ejurka.com>
` Re: COPY from question
  2004-02-03 04:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: COPY from question
  2004-02-03 10:57 UTC  Kevin Brown <kevin@sysexperts.com>
` Re: COPY from question
  2004-02-03 15:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: COPY from question
  2004-02-05 00:42 UTC  Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>
  [6+ messages in thread]

cache whole data in RAM
  2004-02-03 12:54 UTC  David Teran <david.teran@cluster9.com>
` Re: cache whole data in RAM
  2004-02-03 13:26 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: cache whole data in RAM
  2004-02-03 13:27 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: cache whole data in RAM
  2004-02-03 13:32 UTC  Chris Trawick <ctrawick@cultured.net>
` Re: cache whole data in RAM
  2004-02-04 22:44 UTC  William Yu <wyu@talisys.com>
  [5+ messages in thread]

Compile Vs RPMs
  2004-02-03 20:58 UTC  Anjan Dave <adave@vantage.com>
` Re: Compile Vs RPMs
  2004-02-03 22:43 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Compile Vs RPMs
  2004-02-03 23:01 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Compile Vs RPMs
  2004-02-03 23:43 UTC  Christopher Browne <cbbrowne@libertyrms.info>
` Re: Compile Vs RPMs
  2004-02-04 16:24 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [5+ messages in thread]

Database conversion woes...
  2004-02-03 16:42 UTC  Kevin Carpenter <kevin@valenfor.com>
` Re: Database conversion woes...
  2004-02-03 17:00 UTC  Jeff <threshar@torgo.978.org>
` Re: Database conversion woes...
  2004-02-03 17:30 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Database conversion woes...
  2004-02-03 19:01 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Database conversion woes...
  2004-02-03 19:29 UTC  Richard Huxton <dev@archonet.com>
` Re: Database conversion woes...
  2004-02-03 19:59 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Database conversion woes...
  2004-02-03 22:27 UTC  Kevin Carpenter <kevin.carpenter@icrossing.com>
` Database conversion woes...
  2004-02-03 22:29 UTC  Kevin <kevin@valenfor.com>
` Re: Database conversion woes...
  2004-02-03 23:34 UTC  Richard Huxton <dev@archonet.com>
  [9+ messages in thread]

Increasing number of PG connections.
  2004-02-02 19:14 UTC  Kevin Barnard <kbarnard@speedfc.com>
` Re: Increasing number of PG connections.
  2004-02-02 19:39 UTC  Qing Zhao <qzhao@quotefx.net>
` Re: Increasing number of PG connections.
  2004-02-02 20:58 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Increasing number of PG connections.
  2004-02-02 23:10 UTC  Kevin Barnard <kbarnard@speedfc.com>
` Re: Increasing number of PG connections.
  2004-02-02 23:45 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Increasing number of PG connections.
  2004-02-03 15:34 UTC  Kevin Barnard <kbarnard@speedfc.com>
  [6+ messages in thread]

PQexecParams and types
  2004-02-03 07:25 UTC  Czuczy Gergely <phoemix@harmless.hu>
` Re: PQexecParams and types
  2004-02-03 14:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: PQexecParams and types
  2004-02-03 14:56 UTC  Czuczy Gergely <phoemix@harmless.hu>
` Re: PQexecParams and types
  2004-02-03 15:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

inserting large number of rows was: Re: Increasing number of PG connections.
  2004-02-02 20:49 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: inserting large number of rows was: Re: Increasing
  2004-02-02 21:37 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: inserting large number of rows was: Re: Increasing
  2004-02-03 07:03 UTC  Erki Kaldjärv <erki@webware.ee>
  [3+ messages in thread]

views?
  2004-01-28 18:56 UTC  Loeke <LoekeDoeLoekeDoe@dontlikespam.hotmail.com>
` Re: views?
  2004-01-31 04:35 UTC  Neil Conway <neilc@samurai.com>
` Re: views?
  2004-02-02 09:48 UTC  Richard Huxton <dev@archonet.com>
` Re: views?
  2004-02-02 21:26 UTC  Loeke <LoekeDoeLoekeDoe@dontlikespam.hotmail.com>
  [4+ messages in thread]

Bulk Record upload (was Re: Increasing number of PG connections)
  2004-02-02 20:52 UTC  Richard Huxton <dev@archonet.com>

pg_stat_activity
  2004-02-02 19:27 UTC  Orion Henry <orion@trustcommerce.com>

"Overlaping" indexes
  2004-02-02 14:46 UTC  Rigmor Ukuhe <rigmor.ukuhe@finestmedia.com>
` Re: "Overlaping" indexes
  2004-02-02 15:05 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: "Overlaping" indexes
  2004-02-02 18:30 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: "Overlaping" indexes
  2004-02-02 18:43 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: "Overlaping" indexes
  2004-02-02 18:58 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: "Overlaping" indexes
  2004-02-02 19:17 UTC  Rod Taylor <pg@rbt.ca>
  [6+ 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