pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [GENERAL] more execution time
  2005-03-11 13:05 UTC  Richard Huxton <dev@archonet.com>

Statistics not working??
  2005-03-11 11:53 UTC  Hugo Ferreira <bytter@gmail.com>
` Re: Statistics not working??
  2005-03-11 12:03 UTC  Oleg Bartunov <oleg@sai.msu.su>
  [2+ messages in thread]

What's better: Raid 0 or disk for seperate pg_xlog
  2005-03-10 07:44 UTC  Karim Nassar <Karim.Nassar@acm.org>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
  2005-03-10 14:14 UTC  David Brown <time@bigpond.net.au>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
  2005-03-10 15:26 UTC  John A Meinel <john@arbash-meinel.com>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
  2005-03-10 16:41 UTC  Mario Weilguni <mweilguni@sime.com>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
  2005-03-10 19:50 UTC  Karim Nassar <Karim.Nassar@acm.org>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
  2005-03-10 19:56 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
  2005-03-11 08:05 UTC  Richard Huxton <dev@archonet.com>
  [7+ messages in thread]

Multi-line requests in COPY ... FROM STDIN
  2005-03-10 05:29 UTC  Mischa <mischa.Sandberg@telus.net>

Help trying to tune query that executes 40x slower than in SqlServer
  2005-03-07 17:01 UTC  Hugo Ferreira <bytter@gmail.com>
` Re: Help trying to tune query that executes 40x slower than in SqlServer
  2005-03-07 17:28 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Help trying to tune query that executes 40x slower than in SqlServer
  2005-03-07 17:45 UTC  Hugo Ferreira <bytter@gmail.com>
` Re: Help trying to tune query that executes 40x slower than in SqlServer
  2005-03-07 18:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help trying to tune query that executes 40x slower than in SqlServer
  2005-03-09 12:08 UTC  Hugo Ferreira <bytter@gmail.com>
` Re: Help trying to tune query that executes 40x slower than in SqlServer
  2005-03-09 22:08 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: Help trying to tune query that executes 40x slower
  2005-03-10 02:09 UTC  Jim Johannsen <jjsa@gvtc.com>
  [7+ messages in thread]

How to speed up tsearch2 indexing
  2005-03-09 17:25 UTC  Werner Bohl <WernerBohl@infutor.com>
` Re: How to speed up tsearch2 indexing
  2005-03-09 17:41 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: How to speed up tsearch2 indexing
  2005-03-09 20:21 UTC  Werner Bohl <WernerBohl@infutor.com>
` Re: How to speed up tsearch2 indexing
  2005-03-09 20:27 UTC  Oleg Bartunov <oleg@sai.msu.su>
  [4+ messages in thread]

vacuum full, why multiple times ?
  2005-03-09 01:02 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: vacuum full, why multiple times ?
  2005-03-09 02:15 UTC  Michael Fuhr <mike@fuhr.org>
` Re: vacuum full, why multiple times ?
  2005-03-09 11:27 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: vacuum full, why multiple times ?
  2005-03-09 12:30 UTC  Richard Huxton <dev@archonet.com>
` Re: vacuum full, why multiple times ?
  2005-03-09 14:30 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: vacuum full, why multiple times ?
  2005-03-09 15:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: vacuum full, why multiple times ?
  2005-03-09 16:17 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [7+ messages in thread]

pl/pgsql faster than raw SQL?
  2005-03-08 12:20 UTC  Markus Bertheau ☭ <twanger@bluetwanger.de>
` Re: pl/pgsql faster than raw SQL?
  2005-03-08 12:48 UTC  Richard Huxton <dev@archonet.com>
` Re: pl/pgsql faster than raw SQL?
  2005-03-08 15:10 UTC  John A Meinel <john@arbash-meinel.com>
` Re: pl/pgsql faster than raw SQL?
  2005-03-09 00:54 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: pl/pgsql faster than raw SQL?
  2005-03-09 01:27 UTC  John A Meinel <john@arbash-meinel.com>
` Re: pl/pgsql faster than raw SQL?
  2005-03-09 11:20 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [6+ messages in thread]

Why would writes to pgsql_tmp bottleneck at 1mb/s?
  2005-03-08 20:18 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
  2005-03-09 00:17 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
  2005-03-09 00:44 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
  2005-03-09 01:13 UTC  Aaron Birkland <birkie@gmail.com>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
  2005-03-09 04:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
  2005-03-09 04:37 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
  2005-03-09 04:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
  2005-03-09 07:00 UTC  Josh Berkus <josh@agliodbs.com>
  [8+ messages in thread]

64bit Opteron multi drive raid. Help with best config settings
  2005-03-09 03:07 UTC  David B <davidb999@gmail.com>
` Re: 64bit Opteron multi drive raid. Help with best	config
  2005-03-09 03:53 UTC  Karim Nassar <Karim.Nassar@acm.org>
  [2+ messages in thread]

Tuning, configuration for 7.3.5 on a Sun E4500
  2005-03-07 14:46 UTC  tsarevich@gmail.com
` Re: Tuning, configuration for 7.3.5 on a Sun E4500
  2005-03-07 17:31 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Tuning, configuration for 7.3.5 on a Sun E4500
  2005-03-08 07:47 UTC  tsarevich@gmail.com
` Re: Tuning, configuration for 7.3.5 on a Sun E4500
  2005-03-08 17:10 UTC  Josh Berkus <josh@agliodbs.com>
  [4+ messages in thread]

Re: [PERFORM] Help with tuning this query (with
  2005-03-07 16:29 UTC  John A Meinel <john@arbash-meinel.com>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-07 17:24 UTC  John A Meinel <john@arbash-meinel.com>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-07 18:05 UTC  Greg Stark <gsstark@mit.edu>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-07 22:30 UTC  Dave Held <dave.held@arrayservicesgrp.com>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-07 22:48 UTC  John A Meinel <john@arbash-meinel.com>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-07 22:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-07 23:08 UTC  Dave Page <dpage@vale-housing.co.uk>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-07 23:15 UTC  Greg Stark <gsstark@mit.edu>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-08 00:11 UTC  Dave Held <dave.held@arrayservicesgrp.com>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-08 00:29 UTC  Dave Held <dave.held@arrayservicesgrp.com>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-08 01:37 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-08 02:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-08 02:06 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-08 03:51 UTC  PFC <lists@boutiquenumerique.com>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-08 04:35 UTC  John A Meinel <john@arbash-meinel.com>
` Re: [PERFORM] Help with tuning this query (with
  2005-03-08 09:05 UTC  Magnus Hagander <mha@sollentuna.net>
  [16+ messages in thread]

Help with slow running query
  2005-03-07 23:54 UTC  jesse d <jesse_dv2001@yahoo.com>

Re: Help with tuning this query (with explain analyze finally)
  2005-03-02 20:06 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-02 20:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-02 20:38 UTC  Ken Egervari <ken@upfactor.com>
` Re: [PERFORM] Help with tuning this query (with explain analyze finally)
  2005-03-02 22:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Help with tuning this query (with explain analyze finally)
  2005-03-02 23:01 UTC  Dave Held <dave.held@arrayservicesgrp.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-02 23:25 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-03 01:20 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-03 05:52 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-03 06:59 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-03 09:21 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-03 17:35 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-03 23:42 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-04 00:22 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-04 05:22 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-04 15:56 UTC  Richard Huxton <dev@archonet.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-04 16:36 UTC  Ken <ken@upfactor.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-04 16:56 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-04 17:07 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-04 18:29 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Help with tuning this query (with explain analyze finally)
  2005-03-04 19:56 UTC  John A Meinel <john@arbash-meinel.com>
` Re: [PERFORM] Help with tuning this query (with explain analyze finally)
  2005-03-07 08:55 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: [PERFORM] Help with tuning this query (with explain analyze finally)
  2005-03-07 14:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Help with tuning this query (with explain analyze finally)
  2005-03-07 14:36 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: [PERFORM] Help with tuning this query (with explain analyze finally)
  2005-03-07 14:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Help with tuning this query (with explain analyze finally)
  2005-03-07 16:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Help with tuning this query (with explain analyze finally)
  2005-03-07 22:34 UTC  Dave Held <dave.held@arrayservicesgrp.com>
  [26+ messages in thread]

How to Partition?
  2005-03-07 06:26 UTC  xsk <xsk@mails.tsinghua.edu.cn>

Query Optimization - Hash Join estimate off?
  2005-03-05 18:38 UTC  mark.lubratt@indeq.com

MAIN vs. PLAIN
  2005-03-04 20:59 UTC  Dave Held <dave.held@arrayservicesgrp.com>
` Re: MAIN vs. PLAIN
  2005-03-05 04:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

multi billion row tables: possible or insane?
  2005-03-01 09:34 UTC  Ramon Bastiaans <bastiaans@sara.nl>
` Re: multi billion row tables: possible or insane?
  2005-03-01 12:40 UTC  Thomas Ganss <tganss_at_t_dash_online_dot_de-remove-all-after-first-real-dash@yahoo.com>
` Re: multi billion row tables: possible or insane?
  2005-03-01 13:37 UTC  Jeff <threshar@torgo.978.org>
` Re: multi billion row tables: possible or insane?
  2005-03-01 14:01 UTC  Markus Schaber <schabios@logi-track.com>
` Re: multi billion row tables: possible or insane?
  2005-03-01 15:19 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: multi billion row tables: possible or insane?
  2005-03-01 15:40 UTC  Vig, Sandor (G/FI-2) <Sandor.Vig@audi.hu>
` Re: multi billion row tables: possible or insane?
  2005-03-01 15:52 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: multi billion row tables: possible or insane?
  2005-03-01 15:54 UTC  Andras Kadinger <bandit@surfnonstop.com>
` Re: multi billion row tables: possible or insane?
  2005-03-01 15:57 UTC  Alan Stange <stange@rentec.com>
` Re: multi billion row tables: possible or insane?
  2005-03-01 16:26 UTC  Markus Schaber <schabios@logi-track.com>
` Re: multi billion row tables: possible or insane?
  2005-03-01 16:44 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: multi billion row tables: possible or insane?
  2005-03-02 01:11 UTC  Josh Berkus <josh@agliodbs.com>
` Re: multi billion row tables: possible or insane?
  2005-03-02 02:28 UTC  Alan Stange <stange@rentec.com>
` Re: multi billion row tables: possible or insane?
  2005-03-04 22:05 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: multi billion row tables: possible or insane?
  2005-03-05 00:15 UTC  Alex Turner <armtuk@gmail.com>
  [15+ messages in thread]

Select in FOR LOOP Performance
  2005-03-04 17:53 UTC  Charles Joseph <khocuihu@yahoo.com>
` Re: Select in FOR LOOP Performance
  2005-03-04 18:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

name search query speed
  2005-03-03 16:38 UTC  Jeremiah Jahn <jeremiah@cs.earlham.edu>
` Re: name search query speed
  2005-03-03 17:00 UTC  Ken Egervari <ken@upfactor.com>
` Re: name search query speed
  2005-03-03 17:23 UTC  Jeremiah Jahn <jeremiah@cs.earlham.edu>
` Re: name search query speed
  2005-03-03 17:44 UTC  Josh Berkus <josh@agliodbs.com>
` Re: name search query speed
  2005-03-03 17:46 UTC  John A Meinel <john@arbash-meinel.com>
` Re: name search query speed
  2005-03-03 18:36 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: name search query speed
  2005-03-03 20:14 UTC  Jeremiah Jahn <jeremiah@cs.earlham.edu>
` Re: name search query speed
  2005-03-03 20:19 UTC  Jeremiah Jahn <jeremiah@cs.earlham.edu>
` Re: name search query speed
  2005-03-03 20:26 UTC  Dave Held <dave.held@arrayservicesgrp.com>
` Re: name search query speed
  2005-03-03 20:47 UTC  Jeremiah Jahn <jeremiah@cs.earlham.edu>
` Re: name search query speed
  2005-03-03 21:37 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: name search query speed
  2005-03-03 22:03 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: name search query speed
  2005-03-04 02:55 UTC  William Yu <wyu@talisys.com>
` Re: name search query speed
  2005-03-04 15:46 UTC  stig erikson <stigerikson_nospam_@yahoo.se>
  [14+ messages in thread]

Query's fast standalone - slow as a subquery.
  2005-03-04 11:27 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Query's fast standalone - slow as a subquery.
  2005-03-04 15:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Re: Help with tuning this query (more musings)
  2005-03-03 02:51 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query (more musings)
  2005-03-03 05:04 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Help with tuning this query (more musings)
  2005-03-03 06:35 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query (more musings)
  2005-03-03 07:06 UTC  Richard Huxton <dev@archonet.com>
  [4+ messages in thread]

Help with tuning this query
  2005-03-02 06:51 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query
  2005-03-02 08:58 UTC  Richard Huxton <dev@archonet.com>
` Re: Help with tuning this query
  2005-03-02 16:13 UTC  Bricklen Anderson <BAnderson@PresiNET.com>
` Re: Help with tuning this query
  2005-03-02 16:18 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Help with tuning this query
  2005-03-02 16:56 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: Help with tuning this query
  2005-03-02 17:23 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query
  2005-03-02 17:38 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: Help with tuning this query
  2005-03-02 18:13 UTC  Ragnar Hafstað <gnari@simnet.is>
` Re: Help with tuning this query
  2005-03-02 18:28 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query
  2005-03-02 18:49 UTC  Ragnar Hafstað <gnari@simnet.is>
` Re: Help with tuning this query
  2005-03-02 18:56 UTC  Ken Egervari <ken@upfactor.com>
` Re: Help with tuning this query
  2005-03-03 04:30 UTC  Mark Kirkwood <markir@coretech.co.nz>
` Re: Help with tuning this query
  2005-03-03 05:36 UTC  Josh Berkus <josh@agliodbs.com>
  [13+ messages in thread]

Performance tradeoff
  2005-03-02 17:52 UTC  Shawn Chisholm <schisholm@sandvine.com>
` Re: Performance tradeoff
  2005-03-03 05:31 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

Re: Help with tuning this query (Some musings)
  2005-03-03 02:52 UTC  Ken Egervari <ken@upfactor.com>


[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