pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Ensuring data integrity with fsync=off
  2006-01-14 18:13 UTC  Benjamin Arai <barai@cs.ucr.edu>
` Re: Ensuring data integrity with fsync=off
  2006-01-14 18:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Ensuring data integrity with fsync=off
  2006-01-17 20:40 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [3+ messages in thread]

big databases & hospitals
  2006-01-14 12:13 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: big databases & hospitals
  2006-01-14 14:51 UTC  Javier Carlos <nediam@nediam.com.mx>
` Re: big databases & hospitals
  2006-01-14 17:37 UTC  Chris Mair <list@1006.org>
` Re: big databases & hospitals
  2006-01-14 17:55 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: big databases & hospitals
  2006-01-14 20:31 UTC  Jaime Casanova <systemguards@gmail.com>
` Re: big databases & hospitals
  2006-01-17 20:36 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [6+ messages in thread]

new to postgres (and db management) and performance already a problem :-(
  2006-01-16 22:07 UTC  Antoine <melser.anton@gmail.com>
` Re: new to postgres (and db management) and performance already a problem :-(
  2006-01-16 22:42 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: new to postgres (and db management) and performance already a problem :-(
  2006-01-16 22:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: new to postgres (and db management) and performance already a problem :-(
  2006-01-16 22:48 UTC  me@alternize.com
` Re: new to postgres (and db management) and performance already a problem :-(
  2006-01-17 01:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: new to postgres (and db management) and performance already a problem :-(
  2006-01-17 01:29 UTC  me@alternize.com
` Re: new to postgres (and db management) and performance already a problem :-(
  2006-01-17 03:57 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: new to postgres (and db management) and performance already a problem :-(
  2006-01-17 04:13 UTC  me@alternize.com
` Re: new to postgres (and db management) and performance already a problem :-(
  2006-01-17 08:14 UTC  Antoine <melser.anton@gmail.com>
` Re: new to postgres (and db management) and performance already a problem :-(
  2006-01-17 13:28 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: new to postgres (and db management) and performance
  2006-01-17 13:33 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: new to postgres (and db management) and performance
  2006-01-17 13:52 UTC  Markus Schaber <schabi@logix-tt.com>
  [12+ messages in thread]

Use of * affect the performance
  2006-01-16 14:49 UTC  Marcos <mjs_ops@gmx.net>
` Re: Use of * affect the performance
  2006-01-16 21:55 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
  [2+ messages in thread]

Materialized Views
  2006-01-16 14:36 UTC  Michael Riess <mlriess@gmx.de>
` Re: Materialized Views
  2006-01-16 15:40 UTC  Frank Wiles <frank@wiles.org>
` Re: Materialized Views
  2006-01-16 16:17 UTC  me@alternize.com
` Re: Materialized Views
  2006-01-16 16:26 UTC  Michael Riess <mlriess@gmx.de>
  [4+ messages in thread]

>= forces row compare and not index elements compare when possible
  2006-01-09 17:10 UTC  Bernard Dhooghe <dhoogheb@yahoo.com>
` Re: >= forces row compare and not index elements compare when possible
  2006-01-14 18:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Hanging Query
  2006-01-08 17:34 UTC  vimal.gupta@gmail.com
` Re: Hanging Query
  2006-01-14 18:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Throwing unnecessary joins away
  2006-01-12 12:18 UTC  Ottó Havasvölgyi <havasvolgyi.otto@gmail.com>
` Re: Throwing unnecessary joins away
  2006-01-12 12:35 UTC  Alessandro Baretta <a.baretta@barettadeit.com>
` Re: Throwing unnecessary joins away
  2006-01-12 13:41 UTC  Ottó Havasvölgyi <havasvolgyi.otto@gmail.com>
` Re: Throwing unnecessary joins away
  2006-01-12 15:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Throwing unnecessary joins away
  2006-01-12 16:25 UTC  Szűcs Gábor <surrano@gmail.com>
` Re: Throwing unnecessary joins away
  2006-01-12 17:00 UTC  Ottó Havasvölgyi <havasvolgyi.otto@gmail.com>
` Re: Throwing unnecessary joins away
  2006-01-12 17:03 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Throwing unnecessary joins away
  2006-01-12 18:51 UTC  Ottó Havasvölgyi <havasvolgyi.otto@gmail.com>
` Re: Throwing unnecessary joins away
  2006-01-14 00:17 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Throwing unnecessary joins away
  2006-01-14 00:22 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [10+ messages in thread]

Slow query with joins
  2006-01-11 10:59 UTC  Bendik Rognlien Johansen <bendik.johansen@gmail.com>
` Re: Slow query with joins
  2006-01-11 15:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query with joins
  2006-01-11 19:55 UTC  Bendik Rognlien Johansen <bendik.johansen@gmail.com>
` Re: Slow query with joins
  2006-01-11 20:23 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Slow query with joins
  2006-01-11 21:30 UTC  Bendik Rognlien Johansen <bendik.johansen@gmail.com>
` Re: Slow query with joins
  2006-01-13 23:34 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [6+ messages in thread]

insert without oids
  2006-01-13 20:10 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: insert without oids
  2006-01-13 20:19 UTC  Michael Fuhr <mike@fuhr.org>
` Re: insert without oids
  2006-01-13 21:29 UTC  Neil Conway <neilc@samurai.com>
` Re: insert without oids
  2006-01-13 22:48 UTC  Michael Stone <mstone+postgres@mathom.us>
  [4+ messages in thread]

Please Help: PostgreSQL performance Optimization
  2006-01-12 00:32 UTC  Jamal Ghaffour <Jamal.Ghaffour@elios-informatique.fr>
` Re: Please Help: PostgreSQL performance Optimization
  2006-01-12 14:53 UTC  Jamal Ghaffour <Jamal.Ghaffour@elios-informatique.fr>
` Re: Please Help: PostgreSQL performance Optimization
  2006-01-12 18:42 UTC  Andrew Lazarus <andrew@pillette.com>
` Re: Please Help: PostgreSQL performance Optimization
  2006-01-12 20:16 UTC  Jaime Casanova <systemguards@gmail.com>
` Re: Please Help: PostgreSQL performance Optimization
  2006-01-13 09:13 UTC  Jamal Ghaffour <Jamal.Ghaffour@elios-informatique.fr>
` Re: Please Help: PostgreSQL performance Optimization
  2006-01-13 17:41 UTC  Frank Wiles <frank@wiles.org>
  [6+ messages in thread]

query slower on 8.1 than 7.3
  2006-01-12 14:48 UTC  Robert Treat <xzilla@users.sourceforge.net>

indexes on primary and foreign keys
  2006-01-11 22:38 UTC  Burak Seydioglu <buraks78@gmail.com>
` Re: indexes on primary and foreign keys
  2006-01-11 23:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: indexes on primary and foreign keys
  2006-01-11 23:21 UTC  Michael Fuhr <mike@fuhr.org>
` Re: indexes on primary and foreign keys
  2006-01-11 23:52 UTC  Burak Seydioglu <buraks78@gmail.com>
` Re: indexes on primary and foreign keys
  2006-01-12 00:36 UTC  K C Lau <kclau60@netvigator.com>
` Re: indexes on primary and foreign keys
  2006-01-12 01:26 UTC  Michael Glaesemann <grzm@myrealbox.com>
` Re: indexes on primary and foreign keys
  2006-01-12 01:40 UTC  Michael Fuhr <mike@fuhr.org>
` Re: indexes on primary and foreign keys
  2006-01-12 03:49 UTC  K C Lau <kclau60@netvigator.com>
` Re: indexes on primary and foreign keys
  2006-01-12 04:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [9+ messages in thread]

Index isn't used during a join.
  2006-01-10 04:23 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: Index isn't used during a join.
  2006-01-10 05:58 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Index isn't used during a join.
  2006-01-10 15:17 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: Index isn't used during a join.
  2006-01-11 05:10 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: Index isn't used during a join.
  2006-01-11 07:56 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Index isn't used during a join.
  2006-01-11 09:00 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Index isn't used during a join.
  2006-01-11 14:26 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: Index isn't used during a join.
  2006-01-11 15:02 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: Index isn't used during a join.
  2006-01-11 15:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index isn't used during a join.
  2006-01-11 17:06 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Index isn't used during a join.
  2006-01-12 04:20 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
  [11+ messages in thread]

NOT LIKE much faster than LIKE?
  2006-01-10 01:44 UTC  Andrea Arcangeli <andrea@cpushare.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 02:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 02:23 UTC  Andrea Arcangeli <andrea@cpushare.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 02:29 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 02:45 UTC  Andrea Arcangeli <andrea@cpushare.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 02:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 02:54 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 03:47 UTC  Andrea Arcangeli <andrea@cpushare.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 09:08 UTC  Matteo Beccati <php@beccati.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 15:11 UTC  Greg Stark <gsstark@mit.edu>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 15:27 UTC  Andrea Arcangeli <andrea@cpushare.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 15:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 17:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 22:06 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 22:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: NOT LIKE much faster than LIKE?
  2006-01-10 23:36 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-11 03:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: NOT LIKE much faster than LIKE?
  2006-01-11 07:59 UTC  Andrea Arcangeli <andrea@cpushare.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-11 09:07 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-11 09:18 UTC  Andrea Arcangeli <andrea@cpushare.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-11 18:40 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-11 20:39 UTC  Andrea Arcangeli <andrea@cpushare.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-11 20:46 UTC  Andrea Arcangeli <andrea@cpushare.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-11 21:02 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: NOT LIKE much faster than LIKE?
  2006-01-11 21:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: NOT LIKE much faster than LIKE?
  2006-01-12 00:48 UTC  Simon Riggs <simon@2ndquadrant.com>
  [26+ messages in thread]

Showing Column Statistics Number
  2006-01-11 22:05 UTC  Dave Dutcher <dave@tridecap.com>
` Re: Showing Column Statistics Number
  2006-01-11 22:21 UTC  Michael Fuhr <mike@fuhr.org>
  [2+ messages in thread]

Postgres8.0 Planner chooses WRONG plan.
  2006-01-11 15:03 UTC  Pallav Kalva <pkalva@livedatagroup.com>
` Postgres8.0 planner chooses WRONG plan
  2006-01-11 15:27 UTC  Pallav Kalva <pkalva@livedatagroup.com>
` Re: Postgres8.0 planner chooses WRONG plan
  2006-01-11 16:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres8.0 planner chooses WRONG plan
  2006-01-11 16:44 UTC  Pallav Kalva <pkalva@livedatagroup.com>
` Re: Postgres8.0 planner chooses WRONG plan
  2006-01-11 19:02 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [5+ messages in thread]

Improving Inner Join Performance
  2006-01-05 15:16 UTC  Andy <frum@ar-sd.net>
` Re: Improving Inner Join Performance
  2006-01-05 19:20 UTC  Frank Wiles <frank@wiles.org>
` Re: Improving Inner Join Performance
  2006-01-06 09:21 UTC  Andy <frum@ar-sd.net>
` Re: Improving Inner Join Performance
  2006-01-06 09:45 UTC  Michael Glaesemann <grzm@myrealbox.com>
` Re: Improving Inner Join Performance
  2006-01-06 09:54 UTC  Andy <frum@ar-sd.net>
` Re: Improving Inner Join Performance
  2006-01-06 09:56 UTC  Pandurangan R S <pandurangan.r.s@gmail.com>
` Re: Improving Inner Join Performance
  2006-01-06 10:21 UTC  Andy <frum@ar-sd.net>
` Re: Improving Inner Join Performance
  2006-01-06 15:26 UTC  Jaime Casanova <systemguards@gmail.com>
` Re: Improving Inner Join Performance
  2006-01-09 07:56 UTC  Andy <frum@ar-sd.net>
` Re: Improving Inner Join Performance
  2006-01-11 18:25 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [10+ messages in thread]

Re: 500x speed-down: Wrong statistics!
  2006-01-10 07:46 UTC  Alessandro Baretta <a.baretta@barettadeit.com>
` Re: 500x speed-down: Wrong statistics!
  2006-01-10 15:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 500x speed-down: Wrong statistics!
  2006-01-11 09:42 UTC  Alessandro Baretta <a.baretta@barettadeit.com>
  [3+ messages in thread]

help tuning queries on large database
  2006-01-06 22:59 UTC  peter royal <peter.royal@pobox.com>
` Re: help tuning queries on large database
  2006-01-06 23:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: help tuning queries on large database
  2006-01-07 01:08 UTC  Harry Jackson <harryjackson@gmail.com>
` Re: help tuning queries on large database
  2006-01-07 01:18 UTC  David Lang <dlang@invendra.net>
` Re: help tuning queries on large database
  2006-01-08 18:42 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: help tuning queries on large database
  2006-01-08 21:35 UTC  Ron <rjpeace@earthlink.net>
` Re: help tuning queries on large database
  2006-01-09 14:37 UTC  Kelly Burkhart <kelly.burkhart@gmail.com>
` Re: help tuning queries on large database
  2006-01-09 15:40 UTC  Harry Jackson <harryjackson@gmail.com>
` Re: help tuning queries on large database
  2006-01-09 17:23 UTC  peter royal <peter.royal@pobox.com>
` Re: help tuning queries on large database
  2006-01-09 19:01 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: help tuning queries on large database
  2006-01-09 20:59 UTC  peter royal <peter.royal@pobox.com>
` Re: help tuning queries on large database
  2006-01-09 21:29 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: help tuning queries on large database
  2006-01-10 14:33 UTC  Ron <rjpeace@earthlink.net>
` Re: help tuning queries on large database
  2006-01-11 00:28 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: help tuning queries on large database
  2006-01-11 06:03 UTC  Ron <rjpeace@earthlink.net>
  [15+ messages in thread]

Left Join Performance vs Inner Join Performance
  2006-01-11 02:06 UTC  Dave Dutcher <dave@tridecap.com>
` Re: Left Join Performance vs Inner Join Performance
  2006-01-11 04:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

How to handle a large DB and simultaneous accesses?
  2006-01-10 14:41 UTC  Charles A. Landemaine <landemaine@gmail.com>
` Re: How to handle a large DB and simultaneous accesses?
  2006-01-11 03:50 UTC  David Lang <dlang@invendra.net>
  [2+ messages in thread]

[PERFORMANCE] Beetwen text and varchar field
  2006-01-09 10:58 UTC  TNO <tnodev@free.fr>
` Re: [PERFORMANCE] Beetwen text and varchar field
  2006-01-09 11:49 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: [PERFORMANCE] Beetwen text and varchar field
  2006-01-09 23:50 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [3+ messages in thread]

Memory Usage Question
  2006-01-09 18:54 UTC  Chris Hoover <revoohc@gmail.com>
` Re: Memory Usage Question
  2006-01-09 20:35 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [2+ messages in thread]

500x speed-down: Wrong query plan?
  2006-01-09 13:51 UTC  Alessandro Baretta <a.baretta@barettadeit.com>
` Re: 500x speed-down: Wrong query plan?
  2006-01-09 15:02 UTC  Matteo Beccati <php@beccati.com>
` Re: 500x speed-down: Wrong query plan?
  2006-01-09 15:30 UTC  Jaime Casanova <systemguards@gmail.com>
` Re: 500x speed-down: Wrong query plan?
  2006-01-09 16:23 UTC  Alessandro Baretta <a.baretta@barettadeit.com>
` Re: 500x speed-down: Wrong query plan?
  2006-01-09 18:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 500x speed-down: Wrong query plan?
  2006-01-09 18:50 UTC  Alessandro Baretta <a.baretta@barettadeit.com>
` Re: 500x speed-down: Wrong query plan?
  2006-01-09 18:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [7+ 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