pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: max_connections / shared_buffers /
  2005-06-24 19:24 UTC  Rod Taylor <pg@rbt.ca>

Postgres 8 vs Postgres 7.4/cygwin
  2005-06-24 04:32 UTC  Scott Goldstein <sgoldstein@apache.org>
` Re: Postgres 8 vs Postgres 7.4/cygwin
  2005-06-24 05:07 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Postgres 8 vs Postgres 7.4/cygwin
  2005-06-24 13:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

select distinct on varchar -- wild performance differences!
  2005-06-23 03:19 UTC  Elliott Bennett <pgmail@dhtns.com>
` select distinct on varchar - wild performance differences!
  2005-06-23 15:09 UTC  Elliott Bennett <pgmail@dhtns.com>
` Re: select distinct on varchar - wild performance differences!
  2005-06-23 15:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: select distinct on varchar - wild performance differences!
  2005-06-23 17:09 UTC  Elliott Bennett <pgmail@dhtns.com>
  [4+ messages in thread]

Querying 19million records very slowly
  2005-06-21 19:09 UTC  Kjell Tore Fossbakk <kjelltore@gmail.com>
` Re: Querying 19million records very slowly
  2005-06-21 19:59 UTC  Paul Ramsey <pramsey@refractions.net>
` Re: Querying 19million records very slowly
  2005-06-21 21:33 UTC  PFC <lists@boutiquenumerique.com>
` Re: Querying 19million records very slowly
  2005-06-22 07:45 UTC  Kjell Tore Fossbakk <kjelltore@gmail.com>
` Re: Querying 19million records very slowly
  2005-06-22 08:03 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Querying 19million records very slowly
  2005-06-22 08:18 UTC  Kjell Tore Fossbakk <kjelltore@gmail.com>
` Re: Querying 19million records very slowly
  2005-06-22 08:39 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Querying 19million records very slowly
  2005-06-22 08:55 UTC  Michael Glaesemann <grzm@myrealbox.com>
` Re: Querying 19million records very slowly
  2005-06-22 09:10 UTC  Kjell Tore Fossbakk <kjelltore@gmail.com>
` Re: Querying 19million records very slowly
  2005-06-22 09:36 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Querying 19million records very slowly
  2005-06-22 13:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Querying 19million records very slowly
  2005-06-22 14:20 UTC  Paul Ramsey <pramsey@refractions.net>
` Re: Querying 19million records very slowly
  2005-06-22 14:41 UTC  Kjell Tore Fossbakk <kjelltore@gmail.com>
` Re: Querying 19million records very slowly
  2005-06-22 15:23 UTC  Stefan Weiss <spaceman@foo.at>
` Re: Querying 19million records very slowly
  2005-06-22 16:28 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Querying 19million records very slowly
  2005-06-23 13:31 UTC  Kjell Tore Fossbakk <kjelltore@gmail.com>
` Re: Querying 19million records very slowly
  2005-06-23 15:31 UTC  Tobias Brox <tobias@nordicbet.com>
  [17+ messages in thread]

Forums & tsearch2 - best practices reg. concurrency
  2005-06-22 09:14 UTC  Markus Wollny <Markus.Wollny@computec.de>
` Re: Forums & tsearch2 - best practices reg. concurrency
  2005-06-22 10:53 UTC  Oleg Bartunov <oleg@sai.msu.su>
  [2+ messages in thread]

Prepared statements vs. Stored Procedures
  2005-06-21 19:46 UTC  Oliver Crosby <ryusei@gmail.com>
` Re: Prepared statements vs. Stored Procedures
  2005-06-21 20:40 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Prepared statements vs. Stored Procedures
  2005-06-22 07:24 UTC  Radu-Adrian Popescu <radu.popescu@aldratech.com>
  [3+ messages in thread]

Limit clause not using index
  2005-06-21 14:33 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Limit clause not using index
  2005-06-21 14:40 UTC  Bricklen Anderson <BAnderson@PresiNET.com>
` Re: Limit clause not using index
  2005-06-21 14:42 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Limit clause not using index
  2005-06-21 14:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Limit clause not using index
  2005-06-21 14:57 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Limit clause not using index
  2005-06-21 15:07 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Limit clause not using index
  2005-06-21 15:10 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Limit clause not using index
  2005-06-21 15:14 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Limit clause not using index
  2005-06-21 15:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Limit clause not using index
  2005-06-21 19:46 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Limit clause not using index
  2005-06-21 21:08 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Limit clause not using index
  2005-06-21 21:11 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Limit clause not using index
  2005-06-21 21:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Limit clause not using index
  2005-06-22 03:54 UTC  Tobias Brox <tobias@nordicbet.com>
  [14+ messages in thread]

autovacuum suggestions for 500,000,000+ row tables?
  2005-06-20 14:44 UTC  Alex Stapleton <alexs@advfn.com>
` Re: autovacuum suggestions for 500,000,000+ row
  2005-06-20 14:59 UTC  Jacques Caron <jc@directinfos.com>
` Re: autovacuum suggestions for 500,000,000+ row tables?
  2005-06-20 15:05 UTC  Alex Stapleton <alexs@advfn.com>
` Re: autovacuum suggestions for 500,000,000+ row tables?
  2005-06-20 15:20 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: autovacuum suggestions for 500,000,000+ row tables?
  2005-06-20 17:46 UTC  Josh Berkus <josh@agliodbs.com>
` Re: autovacuum suggestions for 500,000,000+ row tables?
  2005-06-21 10:04 UTC  Alex Stapleton <alexs@advfn.com>
` Re: autovacuum suggestions for 500,000,000+ row tables?
  2005-06-21 17:13 UTC  Josh Berkus <josh@agliodbs.com>
` Re: autovacuum suggestions for 500,000,000+ row tables?
  2005-06-21 22:08 UTC  Alex Stapleton <alexs@advfn.com>
` Re: autovacuum suggestions for 500,000,000+ row tables?
  2005-06-21 22:23 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
  [9+ messages in thread]

Trying to figure out pgbench
  2005-06-21 16:04 UTC  William Yu <wyu@talisys.com>
` Re: Trying to figure out pgbench
  2005-06-21 16:11 UTC  Mohan, Ross <RMohan@arbinet.com>
` Re: Trying to figure out pgbench
  2005-06-21 21:53 UTC  William Yu <wyu@talisys.com>
  [3+ messages in thread]

Another question on indexes (drop and recreate)
  2005-06-21 15:17 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Another question on indexes (drop and recreate)
  2005-06-21 15:22 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Another question on indexes (drop and recreate)
  2005-06-21 15:28 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Another question on indexes (drop and recreate)
  2005-06-21 15:49 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Another question on indexes (drop and recreate)
  2005-06-21 16:43 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Another question on indexes (drop and recreate)
  2005-06-21 16:54 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Another question on indexes (drop and recreate)
  2005-06-21 19:30 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
  [7+ messages in thread]

Do Views execute underlying query everytime ??
  2005-06-21 14:01 UTC  Amit V Shah <ashah@tagaudit.com>
` Re: Do Views execute underlying query everytime ??
  2005-06-21 14:45 UTC  Matthew Nuzum <mattnuzum@gmail.com>
` Re: Do Views execute underlying query everytime ??
  2005-06-21 14:48 UTC  Richard Huxton <dev@archonet.com>
` Re: Do Views execute underlying query everytime ??
  2005-06-21 14:49 UTC  Amit V Shah <ashah@tagaudit.com>
` Re: Do Views execute underlying query everytime ??
  2005-06-21 15:00 UTC  PFC <lists@boutiquenumerique.com>
` Re: Do Views execute underlying query everytime ??
  2005-06-21 15:01 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Do Views execute underlying query everytime ??
  2005-06-21 15:46 UTC  Amit V Shah <ashah@tagaudit.com>
` Re: Do Views execute underlying query everytime ??
  2005-06-21 16:59 UTC  PFC <lists@boutiquenumerique.com>
` Re: Do Views execute underlying query everytime ??
  2005-06-21 17:57 UTC  Matthew Nuzum <mattnuzum@gmail.com>
  [9+ messages in thread]

slow growing table
  2005-06-06 16:48 UTC  Jone C <jonecster@gmail.com>
` Re: slow growing table
  2005-06-06 17:00 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: slow growing table
  2005-06-06 17:12 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: slow growing table
  2005-06-07 22:21 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: slow growing table
  2005-06-21 15:05 UTC  Jone C <jonecster@gmail.com>
` Re: slow growing table
  2005-06-21 15:19 UTC  John A Meinel <john@arbash-meinel.com>
  [6+ messages in thread]

index selection by query planner
  2005-06-21 07:42 UTC  Rohit Gaddi <rohitgaddi@yahoo.co.in>
` index selection by query planner
  2005-06-21 07:48 UTC  Rohit Gaddi <rohitgaddi@yahoo.co.in>
  [2+ messages in thread]

Re: investigating slow queries through
  2005-06-20 18:45 UTC  Jacques Caron <jc@directinfos.com>

How to determine whether to VACUUM or CLUSTER
  2005-06-15 15:34 UTC  Ken Shaw <kshaw@belarc.com>
` How to determine whether to VACUUM or CLUSTER
  2005-06-16 18:04 UTC  ken shaw <kshaw987@yahoo.com>
` Re: How to determine whether to VACUUM or CLUSTER
  2005-06-17 03:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to determine whether to VACUUM or CLUSTER
  2005-06-20 06:53 UTC  Jim C. Nasby <decibel@decibel.org>
  [4+ messages in thread]

Multiple disks: RAID 5 or PG Cluster
  2005-06-17 19:34 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Multiple disks: RAID 5 or PG Cluster
  2005-06-17 20:21 UTC  Vivek Khera <vivek@khera.org>
` Re: Multiple disks: RAID 5 or PG Cluster
  2005-06-17 20:38 UTC  mudfoot@rawbw.com
` Fwd: Multiple disks: RAID 5 or PG Cluster
  2005-06-17 21:30 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Fwd: Multiple disks: RAID 5 or PG Cluster
  2005-06-17 21:31 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Multiple disks: RAID 5 or PG Cluster
  2005-06-18 16:00 UTC  PFC <lists@boutiquenumerique.com>
` Re: Multiple disks: RAID 5 or PG Cluster
  2005-06-18 16:24 UTC  Jacques Caron <jc@directinfos.com>
` Fwd: Multiple disks: RAID 5 or PG Cluster
  2005-06-18 16:42 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Fwd: Multiple disks: RAID 5 or PG Cluster
  2005-06-18 22:57 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Multiple disks: RAID 5 or PG Cluster
  2005-06-19 04:58 UTC  Alex Turner <armtuk@gmail.com>
` Re: Fwd: Multiple disks: RAID 5 or PG Cluster
  2005-06-19 05:53 UTC  Greg Stark <gsstark@mit.edu>
  [11+ messages in thread]

could not send data to client:
  2005-06-16 20:53 UTC  Justin Davis <justin.davis@rapidsys.net>
` Re: could not send data to client:
  2005-06-17 12:49 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [2+ messages in thread]

How does the transaction buffer work?
  2005-06-16 19:28 UTC  Veikko Mäkinen <veikko.makinen@ecom.fi>
` Re: How does the transaction buffer work?
  2005-06-16 19:36 UTC  John A Meinel <john@arbash-meinel.com>
` Re: How does the transaction buffer work?
  2005-06-16 20:12 UTC  PFC <lists@boutiquenumerique.com>
` Re: How does the transaction buffer work?
  2005-06-16 21:53 UTC  Josh Berkus <josh@agliodbs.com>
` Re: How does the transaction buffer work?
  2005-06-17 04:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How does the transaction buffer work?
  2005-06-17 05:05 UTC  Rod Taylor <pg@rbt.ca>
  [6+ messages in thread]

Re: Index ot being used
  2005-06-10 15:55 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Index ot being used
  2005-06-10 15:57 UTC  Jacques Caron <jc@directinfos.com>
` Index ot being used
  2005-06-10 16:10 UTC  linux@alteeve.com
` Re: Index ot being used
  2005-06-12 14:12 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-12 15:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index ot being used
  2005-06-12 17:37 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-12 22:52 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 03:00 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 03:13 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 03:35 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 03:42 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 03:53 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 04:29 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 13:28 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 14:34 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Index ot being used
  2005-06-13 14:51 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Index ot being used
  2005-06-13 15:48 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 16:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index ot being used
  2005-06-13 16:46 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Index ot being used
  2005-06-13 16:49 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 16:53 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 17:50 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 17:57 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 18:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index ot being used
  2005-06-13 19:05 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 20:45 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 20:53 UTC  Greg Stark <gsstark@mit.edu>
` Re: Index ot being used
  2005-06-13 21:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index ot being used
  2005-06-13 21:30 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-15 16:52 UTC  Karim Nassar <karim.nassar@acm.org>
` Re: Index ot being used
  2005-06-15 17:33 UTC  Madison Kelly <linux@alteeve.com>
  [31+ messages in thread]

regular expression search
  2005-06-14 16:40 UTC  Pierre A. Fortier <pfortier@uottawa.ca>
` Re: regular expression search
  2005-06-15 01:21 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [2+ messages in thread]

Most effective tuning choices for busy website?
  2005-06-01 19:19 UTC  Mark Stosberg <mark@summersault.com>
` Re: Most effective tuning choices for busy website?
  2005-06-06 02:04 UTC  Neil Conway <neilc@samurai.com>
` Re: Most effective tuning choices for busy website?
  2005-06-14 22:34 UTC  Mark Stosberg <mark@summersault.com>
` Re: Most effective tuning choices for busy website?
  2005-06-14 23:59 UTC  Christopher Weimann <cweimann@k12hq.com>
  [4+ messages in thread]

Re: PGDATA - SOLVED
  2005-06-14 19:34 UTC  operationsengineer1@yahoo.com
` Re: PGDATA - SOLVED
  2005-06-14 20:41 UTC  Mike <1100100@gmail.com>
  [2+ messages in thread]

PGDATA
  2005-06-14 19:18 UTC  operationsengineer1@yahoo.com

need suggestion for server sizing
  2005-06-10 21:12 UTC  Havasvölgyi Ottó <h.otto@freemail.hu>
` Re: need suggestion for server sizing
  2005-06-13 13:25 UTC  János <janos.lobb@yale.edu>
` Re: need suggestion for server sizing
  2005-06-14 16:31 UTC  Havasvölgyi Ottó <h.otto@freemail.hu>
  [3+ messages in thread]

System Requirement
  2005-06-13 19:56 UTC  Saranya Sivakumar <sarlavk@yahoo.com>
` Re: System Requirement
  2005-06-13 20:10 UTC  Madison Kelly <linux@alteeve.com>
` Re: System Requirement
  2005-06-14 08:32 UTC  hubert depesz lubaczewski <depesz@gmail.com>
` Re: System Requirement
  2005-06-14 13:04 UTC  Saranya Sivakumar <sarlavk@yahoo.com>
  [4+ 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