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