pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Implicit casting and JOIN syntax constraints
  2003-01-17 14:48 UTC  Roman Fail <rfail@posportal.com>
` Re: Implicit casting and JOIN syntax constraints
  2003-01-17 15:41 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [2+ messages in thread]

schema/db design wrt performance
  2003-01-16 13:51 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: schema/db design wrt performance
  2003-01-16 14:07 UTC  Fernando Papa <fpapa@claxson.com>
` Re: schema/db design wrt performance
  2003-01-16 14:20 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: schema/db design wrt performance
  2003-01-16 14:34 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: schema/db design wrt performance
  2003-01-16 15:39 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: schema/db design wrt performance
  2003-01-16 15:50 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: schema/db design wrt performance
  2003-01-16 16:02 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: schema/db design wrt performance
  2003-01-16 16:05 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: schema/db design wrt performance
  2003-01-16 16:25 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: schema/db design wrt performance
  2003-01-16 16:38 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: schema/db design wrt performance
  2003-01-16 16:46 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: schema/db design wrt performance
  2003-01-16 17:24 UTC  Ron Johnson <ron.l.johnson@cox.net>
  [12+ messages in thread]

Re: Sun vs. Mac  - gprof output
  2003-01-15 17:22 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac - gprof output
  2003-01-16 06:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun vs. Mac - gprof output
  2003-01-16 13:45 UTC  CaptainX0r <captainx0r@yahoo.com>
  [3+ messages in thread]

Re: complicated queries in pl/pgsql
  2003-01-13 18:44 UTC  Josh Berkus <josh@agliodbs.com>
` complicated queries in pl/pgsql
  2003-01-14 10:54 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: complicated queries in pl/pgsql
  2003-01-14 20:36 UTC  Josh Berkus <josh@agliodbs.com>
` Re: complicated queries in pl/pgsql
  2003-01-15 19:12 UTC  Tomasz Myrta <jasiek@klaster.net>
  [4+ messages in thread]

Sun vs. Mac
  2003-01-14 15:00 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 15:09 UTC  Justin Clift <justin@postgresql.org>
` Re: Sun vs. Mac
  2003-01-14 15:10 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Sun vs. Mac
  2003-01-14 15:18 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 15:41 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 16:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun vs. Mac
  2003-01-14 16:08 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Sun vs. Mac
  2003-01-14 16:18 UTC  Lee Kindness <lkindness@csl.co.uk>
` Re: Sun vs. Mac
  2003-01-14 16:29 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 16:38 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 16:54 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 17:50 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 17:58 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Sun vs. Mac
  2003-01-14 18:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun vs. Mac
  2003-01-14 18:26 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Sun vs. Mac
  2003-01-14 18:27 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 18:41 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 19:26 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Sun vs. Mac
  2003-01-14 19:38 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-15 05:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [20+ messages in thread]

Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 18:10 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 18:30 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 18:39 UTC  eric soroos <eric-psql@soroos.net>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 19:01 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 19:18 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 23:59 UTC  Justin Clift <justin@postgresql.org>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-15 00:02 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [7+ messages in thread]

Re: Multiple databases
  2003-01-13 22:32 UTC  Josh Berkus <josh@agliodbs.com>
` Multiple databases
  2003-01-14 20:51 UTC  Noah Silverman <noah@allresearch.com>
` Re: Multiple databases
  2003-01-14 20:54 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Multiple databases
  2003-01-14 20:58 UTC  Noah Silverman <noah@allresearch.com>
  [4+ messages in thread]

How good I can get
  2003-01-14 19:42 UTC  Vernon Wu <vernonw@gatewaytech.com>

Cursor rowcount
  2003-01-13 21:33 UTC  typea@l-i-e.com
` Re: Cursor rowcount
  2003-01-13 22:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cursor rowcount
  2003-01-14 01:05 UTC  typea@l-i-e.com
` Re: Cursor rowcount
  2003-01-14 04:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cursor rowcount
  2003-01-14 09:12 UTC  Ron Johnson <ron.l.johnson@cox.net>
  [5+ messages in thread]

Accessing ANALYZE stats
  2003-01-13 18:42 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Accessing ANALYZE stats
  2003-01-13 18:46 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  [2+ messages in thread]

join over 12 tables takes 3 secs to plan
  2003-01-02 19:42 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 20:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 20:41 UTC  Neil Conway <neilc@samurai.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:03 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:08 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:11 UTC  Neil Conway <neilc@samurai.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:21 UTC  Neil Conway <neilc@samurai.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:29 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:40 UTC  Joe Conway <mail@joeconway.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 22:49 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 00:01 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 00:24 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 00:36 UTC  Charles H. Woloszynski <chw@clearmetrix.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 17:01 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 17:12 UTC  Jeff <threshar@torgo.978.org>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 19:38 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 22:09 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: [PERFORM] join over 12 tables takes 3 secs to plan
  2003-01-03 22:16 UTC  Charles H. Woloszynski <chw@clearmetrix.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 22:22 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-12 01:03 UTC  Neil Conway <neilc@samurai.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-12 15:52 UTC  Charles H. Woloszynski <chw@clearmetrix.com>
` Re: [PERFORM] join over 12 tables takes 3 secs to plan
  2003-01-13 13:08 UTC  Charles H. Woloszynski <chw@clearmetrix.com>
  [22+ messages in thread]

"IN" or "=" and "OR"
  2003-01-11 18:51 UTC  Vernon Wu <vernonw@gatewaytech.com>
` Re: "IN" or "=" and "OR"
  2003-01-12 04:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

postgresql in cluster of servers
  2003-01-08 17:18 UTC  enediel <enediel@com.ith.tur.cu>
` Re: postgresql in cluster of servers
  2003-01-08 19:08 UTC  Josh Berkus <josh@agliodbs.com>
` Re: postgresql in cluster of servers
  2003-01-08 21:14 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Fw: postgresql in cluster of servers
  2003-01-08 23:38 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Fw: postgresql in cluster of servers
  2003-01-09 01:49 UTC  enediel <enediel@com.ith.tur.cu>
` Re: Fw: postgresql in cluster of servers
  2003-01-09 16:22 UTC  pginfo <pginfo@t1.unisoftbg.com>
` Re: Fw: Fw: postgresql in cluster of servers
  2003-01-09 20:18 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Fw: Fw: postgresql in cluster of servers
  2003-01-09 20:41 UTC  enediel <enediel@com.ith.tur.cu>
` Fw: Fw: Fw: postgresql in cluster of servers
  2003-01-10 00:35 UTC  enediel <enediel@com.ith.tur.cu>
  [9+ messages in thread]

Re: [SQL] 7.3.1 index use / performance
  2003-01-07 12:00 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: [PERFORM] 7.3.1 index use / performance
  2003-01-07 15:27 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` 7.3.1 index use / performance
  2003-01-07 15:39 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] 7.3.1 index use / performance
  2003-01-07 16:21 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] [PERFORM] 7.3.1 index use / performance
  2003-01-07 16:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] [PERFORM] 7.3.1 index use / performance
  2003-01-07 17:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] [PERFORM] 7.3.1 index use / performance
  2003-01-07 18:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] 7.3.1 index use / performance
  2003-01-07 18:45 UTC  Rod Taylor <rbt@rbt.ca>
` Re: [SQL] [PERFORM] 7.3.1 index use / performance
  2003-01-07 19:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] [PERFORM] 7.3.1 index use / performance
  2003-01-07 20:27 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] [PERFORM] 7.3.1 index use / performance
  2003-01-07 21:05 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] [PERFORM] 7.3.1 index use / performance
  2003-01-07 22:38 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] [PERFORM] 7.3.1 index use / performance
  2003-01-07 22:51 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: [SQL] [PERFORM] 7.3.1 index use / performance
  2003-01-08 17:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] [PERFORM] 7.3.1 index use / performance
  2003-01-08 17:53 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
  [15+ messages in thread]

Unions and where optimisation
  2003-01-08 13:25 UTC  Boris Klug <boris.klug@control.de>
` Re: Unions and where optimisation
  2003-01-08 14:32 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Unions and where optimisation
  2003-01-08 14:36 UTC  Boris Klug <boris.klug@control.de>
` Re: Unions and where optimisation
  2003-01-08 14:40 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Unions and where optimisation
  2003-01-08 15:48 UTC  Michael Paesold <mpaesold@gmx.at>
` Re: Unions and where optimisation
  2003-01-08 16:02 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Unions and where optimisation
  2003-01-08 16:13 UTC  Boris Klug <boris.klug@control.de>
` Re: Unions and where optimisation
  2003-01-08 16:49 UTC  Hannu Krosing <hannu@tm.ee>
  [8+ messages in thread]

Re: PostgreSQL and memory usage
  2003-01-07 03:32 UTC  Dann Corbit <DCorbit@connx.com>
` Re: PostgreSQL and memory usage
  2003-01-07 16:55 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: PostgreSQL and memory usage
  2003-01-07 17:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] PostgreSQL and memory usage
  2003-01-07 19:46 UTC  Fred Moyer <fred@digicamp.com>
` Re: [PERFORM] PostgreSQL and memory usage
  2003-01-07 23:16 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [5+ messages in thread]

Re: 7.3.1 function problem: ERROR: cache lookup failed for type 0
  2003-01-07 18:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 7.3.1 function problem: ERROR: cache lookup failed
  2003-01-07 18:39 UTC  Joe Conway <mail@joeconway.com>
` 7.3.1 function problem: ERROR:  cache lookup failed for type 0
  2003-01-07 21:55 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: 7.3.1 function problem: ERROR: cache lookup failed
  2003-01-07 22:32 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
  [4+ messages in thread]

path
  2003-01-07 20:29 UTC  Claiborne, Aldemaco Earl (Al) <claiborne@lucent.com>

Question on hardware & server capacity
  2003-01-02 17:42 UTC  Steve Wolfe <nw@codon.com>
` Re: Question on hardware & server capacity
  2003-01-02 19:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question on hardware & server capacity
  2003-01-02 20:59 UTC  Steve Wolfe <nw@codon.com>
` Re: Question on hardware & server capacity
  2003-01-02 22:07 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Question on hardware & server capacity
  2003-01-03 17:31 UTC  Steve Wolfe <nw@codon.com>
` Re: Question on hardware & server capacity
  2003-01-03 18:06 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Question on hardware & server capacity
  2003-01-03 20:49 UTC  Steve Wolfe <nw@codon.com>
` Re: Question on hardware & server capacity
  2003-01-06 19:14 UTC  Josh Berkus <josh@agliodbs.com>
  [8+ messages in thread]

views vs pl/pgsql
  2003-01-06 11:03 UTC  Tomasz Myrta <jasiek@klaster.net>

Re: executing pgsql on Xeon-dual machine
  2003-01-06 02:27 UTC  yutaka_inada@justsystem.co.jp

Fwd: Stock update like application
  2003-01-04 13:31 UTC  Albert Cervera Areny <albertca@jazzfree.com>

Re: preliminary testing, two very slow situations...
  2003-01-01 21:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: preliminary testing, two very slow situations...
  2003-01-02 15:57 UTC  george young <gry@ll.mit.edu>
  [2+ messages in thread]

alter table TBL add constraint TBL_FK foreign key ... very slow
  2003-01-01 03:32 UTC  Minghann Ho <Minghann.Ho@mcs.vuw.ac.nz>
` alter table TBL add constraint TBL_FK foreign key ... very slow
  2003-01-01 03:38 UTC  Minghann Ho <mho@mcs.vuw.ac.nz>
` Re: alter table TBL add constraint TBL_FK foreign key ...
  2003-01-01 03:38 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: alter table TBL add constraint TBL_FK foreign key
  2003-01-01 08:14 UTC  Ron Johnson <ron.l.johnson@cox.net>
  [4+ messages in thread]


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