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