pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Putting files into fields in a table
  2007-12-13 19:10 UTC  Campbell, Lance <lance@uiuc.edu>
` Re: Putting files into fields in a table
  2007-12-13 19:38 UTC  Alexander Staubo <alex@purefiction.net>
` Re: Putting files into fields in a table
  2007-12-13 20:09 UTC  Campbell, Lance <lance@uiuc.edu>
` Re: Putting files into fields in a table
  2007-12-13 20:16 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Putting files into fields in a table
  2007-12-13 20:22 UTC  Erik Jones <erik@myemma.com>
` Re: Putting files into fields in a table
  2007-12-13 20:54 UTC  Campbell, Lance <lance@uiuc.edu>
  [6+ messages in thread]

Index on VARCHAR with text_pattern_ops inside PL/PGSQL procedure.
  2007-12-10 12:58 UTC  Piotr Gasidło <quaker@barbara.eu.org>
` Re: Index on VARCHAR with text_pattern_ops inside PL/PGSQL procedure.
  2007-12-10 13:04 UTC  Richard Huxton <dev@archonet.com>
` Re: Index on VARCHAR with text_pattern_ops inside PL/PGSQL procedure.
  2007-12-10 13:07 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Index on VARCHAR with text_pattern_ops inside PL/PGSQL procedure.
  2007-12-13 11:41 UTC  Piotr Gasidło <quaker@barbara.eu.org>
  [4+ messages in thread]

URI to kind of a benchmark
  2007-12-12 12:58 UTC  Harald Armin Massa <haraldarminmassa@gmail.com>
` Re: URI to kind of a benchmark
  2007-12-12 14:48 UTC  Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
  [2+ messages in thread]

database tuning
  2007-12-07 00:45 UTC  kelvan <kicmcewen@windowslive.com>
` Re: database tuning
  2007-12-07 08:12 UTC  Richard Huxton <dev@archonet.com>
` Re: database tuning
  2007-12-07 08:39 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: database tuning
  2007-12-07 19:13 UTC  kelvan <kicmcewen@windowslive.com>
` Re: database tuning
  2007-12-10 09:31 UTC  Richard Huxton <dev@archonet.com>
` Re: database tuning
  2007-12-10 16:58 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: database tuning
  2007-12-11 00:15 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Fwd: Re: database tuning
  2007-12-11 00:19 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: database tuning
  2007-12-11 00:29 UTC  kelvan <kicmcewen@windowslive.com>
` Re: database tuning
  2007-12-11 00:36 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: database tuning
  2007-12-11 22:27 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: database tuning
  2007-12-11 22:29 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: database tuning
  2007-12-11 22:34 UTC  Erik Jones <erik@myemma.com>
` Re: database tuning
  2007-12-11 23:15 UTC  Richard Huxton <dev@archonet.com>
` Re: database tuning
  2007-12-11 23:18 UTC  kelvan <kicmcewen@windowslive.com>
` Re: database tuning
  2007-12-12 00:07 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: database tuning
  2007-12-12 00:10 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: database tuning
  2007-12-12 00:17 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: database tuning
  2007-12-12 00:27 UTC  kelvan <kicmcewen@windowslive.com>
  [19+ messages in thread]

Is it spam or not?
  2007-12-11 11:57 UTC  Manolo _ <mac_man2005@hotmail.it>
` Is it spam or not?
  2007-12-11 13:23 UTC  Manolo _ <mac_man2005@hotmail.it>
  [2+ messages in thread]

Benchmarking PG
  2007-12-11 11:06 UTC  Manolo _ <mac_man2005@hotmail.it>
` Re: Benchmarking PG
  2007-12-11 11:16 UTC  Josh Tolley <eggyknap@gmail.com>
` Re: Benchmarking PG
  2007-12-11 11:36 UTC  Manolo _ <mac_man2005@hotmail.it>
` Re: Benchmarking PG
  2007-12-11 12:11 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
  [4+ messages in thread]

Utilizing multiple cores for one query
  2007-12-01 13:21 UTC  henk de wit <henk53602@hotmail.com>
` Re: Utilizing multiple cores for one query
  2007-12-01 13:31 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Utilizing multiple cores for one query
  2007-12-01 14:42 UTC  henk de wit <henk53602@hotmail.com>
` Re: Utilizing multiple cores for one query
  2007-12-01 16:39 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: Utilizing multiple cores for one query
  2007-12-01 17:03 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: Utilizing multiple cores for one query
  2007-12-04 13:24 UTC  Matthew <matthew@flymine.org>
` Re: Utilizing multiple cores for one query
  2007-12-10 11:51 UTC  Marko Kreen <markokr@gmail.com>
  [7+ messages in thread]

Vacuum full since 15 hours
  2007-12-09 10:42 UTC  Hervé Piedvache <bill.footcow@gmail.com>
` Re: Vacuum full since 15 hours
  2007-12-09 16:32 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
  [2+ messages in thread]

Combining two bitmap scans out performs a single regular index scan?
  2007-12-08 17:18 UTC  Mark Mielke <mark@mark.mielke.cc>
` Re: Combining two bitmap scans out performs a single regular index scan?
  2007-12-08 20:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Combining two bitmap scans out performs a single regular index scan?
  2007-12-08 22:07 UTC  Mark Mielke <mark@mark.mielke.cc>
  [3+ messages in thread]

Cost-Based Vacuum Delay tuning
  2007-12-07 10:50 UTC  Guillaume Cottenceau <gc@mnc.ch>
` Re: Cost-Based Vacuum Delay tuning
  2007-12-07 15:42 UTC  Erik Jones <erik@myemma.com>
` Re: Cost-Based Vacuum Delay tuning
  2007-12-07 16:44 UTC  Guillaume Cottenceau <gc@mnc.ch>
` Re: Cost-Based Vacuum Delay tuning
  2007-12-07 17:33 UTC  Erik Jones <erik@myemma.com>
` Re: Cost-Based Vacuum Delay tuning
  2007-12-08 13:21 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
  [5+ messages in thread]

Trouble with LEFT JOIN using VIEWS.
  2007-12-07 10:55 UTC  Piotr Gasidło <quaker@barbara.eu.org>
` Re: Trouble with LEFT JOIN using VIEWS.
  2007-12-07 15:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

autovacuum: recommended?
  2007-11-16 09:40 UTC  Gábor Farkas <gabor@nekomancer.net>
` Re: autovacuum: recommended?
  2007-11-16 09:45 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: autovacuum: recommended?
  2007-11-16 11:13 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: autovacuum: recommended?
  2007-11-16 11:56 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: autovacuum: recommended?
  2007-11-16 13:38 UTC  tv@fuzzy.cz
` Re: autovacuum: recommended?
  2007-11-18 19:00 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: autovacuum: recommended?
  2007-11-18 19:26 UTC  gabor <gabor@nekomancer.net>
` Re: autovacuum: recommended?
  2007-11-19 04:08 UTC  Decibel! <decibel@decibel.org>
` Re: autovacuum: recommended?
  2007-11-19 04:11 UTC  Decibel! <decibel@decibel.org>
` Re: autovacuum: recommended?
  2007-11-19 04:14 UTC  Decibel! <decibel@decibel.org>
` Re: autovacuum: recommended?
  2007-11-19 09:53 UTC  tv@fuzzy.cz
` Re: autovacuum: recommended?
  2007-11-19 13:39 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: autovacuum: recommended?
  2007-11-19 13:51 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: autovacuum: recommended?
  2007-11-19 15:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: autovacuum: recommended?
  2007-11-19 15:46 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: autovacuum: recommended?
  2007-11-19 17:18 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: autovacuum: recommended?
  2007-11-19 17:22 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: autovacuum: recommended?
  2007-12-05 23:55 UTC  Decibel! <decibel@decibel.org>
  [18+ messages in thread]

Optimizer Not using the Right plan
  2007-12-04 16:06 UTC  Pallav Kalva <pkalva@livedatagroup.com>
` Re: Optimizer Not using the Right plan
  2007-12-04 16:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizer Not using the Right plan
  2007-12-04 19:15 UTC  Pallav Kalva <pkalva@livedatagroup.com>
` Re: Optimizer Not using the Right plan
  2007-12-05 12:49 UTC  galy lee <galylee4pg@gmail.com>
  [4+ messages in thread]

Bad query plans for queries on partitioned table
  2007-12-04 19:44 UTC  Julian Mehnle <julian@mehnle.net>
` Re: Bad query plans for queries on partitioned table
  2007-12-04 20:03 UTC  Julian Mehnle <julian@mehnle.net>
` Re: Bad query plans for queries on partitioned table
  2007-12-04 20:15 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: Bad query plans for queries on partitioned table
  2007-12-04 20:27 UTC  Julian Mehnle <julian@mehnle.net>
` Re: Bad query plans for queries on partitioned table
  2007-12-05 00:39 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: Bad query plans for queries on partitioned table
  2007-12-05 01:57 UTC  Julian Mehnle <julian@mehnle.net>
` Re: Bad query plans for queries on partitioned table
  2007-12-05 08:39 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: Bad query plans for queries on partitioned table
  2007-12-05 11:26 UTC  Julian Mehnle <julian@mehnle.net>
  [8+ messages in thread]

Training Recommendations
  2007-11-05 16:44 UTC  Campbell, Lance <lance@uiuc.edu>
` Re: Training Recommendations
  2007-11-28 16:20 UTC  Usama Munir Dar <usama.munir@enterprisedb.com>
` Re: Training Recommendations
  2007-11-30 09:15 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Training Recommendations
  2007-12-02 13:30 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Training Recommendations
  2007-12-02 17:32 UTC  Guido Neitzer <lists@event-s.net>
` Re: Training Recommendations
  2007-12-02 20:26 UTC  Usama Munir Dar <usama.munir@enterprisedb.com>
` Re: Training Recommendations
  2007-12-03 16:12 UTC  Paul Lindner <lindner@inuus.com>
` Re: Training Recommendations
  2007-12-03 18:52 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Training Recommendations
  2007-12-03 23:50 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Training Recommendations
  2007-12-04 08:15 UTC  Simon Riggs <simon@2ndquadrant.com>
  [10+ messages in thread]

Dealing with big tables
  2007-12-02 10:26 UTC  Mindaugas <ml@kilimas.com>
` Re: Dealing with big tables
  2007-12-02 11:05 UTC  Sami Dalouche <skoobi@free.fr>
` Re: Dealing with big tables
  2007-12-02 11:37 UTC  Mindaugas <ml@kilimas.com>
` Re: Dealing with big tables
  2007-12-02 11:55 UTC  Guillaume Smet <guillaume.smet@gmail.com>
` Re: Dealing with big tables
  2007-12-02 12:07 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: Dealing with big tables
  2007-12-02 12:35 UTC  Mindaugas <ml@kilimas.com>
` Re: Dealing with big tables
  2007-12-02 23:13 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Dealing with big tables
  2007-12-03 10:35 UTC  Matthew <matthew@flymine.org>
` Re: Dealing with big tables
  2007-12-03 22:14 UTC  Merlin Moncure <mmoncure@gmail.com>
  [9+ messages in thread]

EXPLAIN ANALYZE time calculations
  2007-12-03 00:28 UTC  Michael Glaesemann <grzm@seespotcode.net>
` Re: EXPLAIN ANALYZE time calculations
  2007-12-03 00:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: EXPLAIN ANALYZE time calculations
  2007-12-03 01:06 UTC  Michael Glaesemann <grzm@seespotcode.net>
` Re: EXPLAIN ANALYZE time calculations
  2007-12-03 01:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

PostgreSQL 8.2.5 slow performance on INSERT on Linux
  2007-12-02 21:34 UTC  Beyers Cronje <bcronje@gmail.com>
` Re: PostgreSQL 8.2.5 slow performance on INSERT on Linux
  2007-12-02 21:46 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: PostgreSQL 8.2.5 slow performance on INSERT on Linux
  2007-12-02 22:53 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: PostgreSQL 8.2.5 slow performance on INSERT on Linux
  2007-12-02 23:32 UTC  Beyers Cronje <bcronje@gmail.com>
  [4+ messages in thread]

Appending "LIMIT" to query drastically decreases performance
  2007-11-30 11:16 UTC  cluster <skrald@amossen.dk>
` Re: Appending "LIMIT" to query drastically decreases performance
  2007-11-30 13:30 UTC  Matthew <matthew@flymine.org>
` Re: Appending "LIMIT" to query drastically decreases performance
  2007-11-30 14:20 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Appending "LIMIT" to query drastically decreases performance
  2007-11-30 16:01 UTC  cluster <skrald@amossen.dk>
  [4+ messages in thread]

GiST indexing tuples
  2007-11-27 18:28 UTC  Matthew <matthew@flymine.org>
` Re: GiST indexing tuples
  2007-11-27 18:38 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: GiST indexing tuples
  2007-11-28 13:08 UTC  Matthew <matthew@flymine.org>
` Re: GiST indexing tuples
  2007-11-28 13:36 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: GiST indexing tuples
  2007-11-28 15:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: GiST indexing tuples
  2007-11-28 16:08 UTC  Matthew <matthew@flymine.org>
` Re: GiST indexing tuples
  2007-11-29 20:23 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: GiST indexing tuples
  2007-11-29 20:30 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: GiST indexing tuples
  2007-11-30 13:45 UTC  Matthew <matthew@flymine.org>
  [9+ messages in thread]

Configuring a Large RAM PostgreSQL Server
  2007-11-29 18:28 UTC  Alex Hochberger <alex@dsgi.us>
` Re: Configuring a Large RAM PostgreSQL Server
  2007-11-29 19:15 UTC  Richard Huxton <dev@archonet.com>
` Re: Configuring a Large RAM PostgreSQL Server
  2007-11-29 19:21 UTC  Alex Hochberger <alex@dsgi.us>
` Re: Configuring a Large RAM PostgreSQL Server
  2007-11-29 19:29 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Configuring a Large RAM PostgreSQL Server
  2007-11-30 05:50 UTC  Josh Berkus <josh@agliodbs.com>
  [5+ messages in thread]

clear pg_stats
  2007-11-29 21:46 UTC  Campbell, Lance <lance@uiuc.edu>
` Re: clear pg_stats
  2007-11-29 21:54 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: clear pg_stats
  2007-11-29 21:57 UTC  Magnus Hagander <magnus@hagander.net>
  [3+ messages in thread]

7.4 Checkpoint Question
  2007-11-29 15:10 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: 7.4 Checkpoint Question
  2007-11-29 16:02 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: 7.4 Checkpoint Question
  2007-11-29 16:14 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: 7.4 Checkpoint Question
  2007-11-29 16:18 UTC  Brad Nicholson <bnichols@ca.afilias.info>
  [4+ messages in thread]

Query only slow on first run
  2007-11-27 16:33 UTC  cluster <skrald@amossen.dk>
` Re: Query only slow on first run
  2007-11-27 16:55 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Query only slow on first run
  2007-11-27 16:57 UTC  Kevin Kempter <kevin@kevinkempterllc.com>
` Re: Query only slow on first run
  2007-11-27 17:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query only slow on first run
  2007-11-27 18:21 UTC  cluster <skrald@amossen.dk>
` Re: Query only slow on first run
  2007-11-27 18:55 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Query only slow on first run
  2007-11-27 19:04 UTC  Dave Dutcher <dave@tridecap.com>
` Re: Query only slow on first run
  2007-11-27 22:51 UTC  cluster <skrald@amossen.dk>
` Re: Query only slow on first run
  2007-11-27 23:38 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Query only slow on first run
  2007-11-27 23:47 UTC  Dave Dutcher <dave@tridecap.com>
` Re: Query only slow on first run
  2007-11-28 00:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query only slow on first run
  2007-11-28 00:28 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Query only slow on first run
  2007-11-28 01:08 UTC  tmp <skrald@amossen.dk>
` Re: Query only slow on first run
  2007-11-28 14:56 UTC  Craig James <craig_james@emolecules.com>
` Re: Query only slow on first run
  2007-11-28 16:00 UTC  Dave Dutcher <dave@tridecap.com>
` Re: Query only slow on first run
  2007-11-28 17:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query only slow on first run
  2007-11-28 20:16 UTC  cluster <skrald@amossen.dk>
` Re: Query only slow on first run
  2007-11-28 20:34 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Query only slow on first run
  2007-11-28 21:15 UTC  cluster <skrald@amossen.dk>
` Re: Query only slow on first run
  2007-11-28 22:03 UTC  Jean-David Beyer <jeandavid8@verizon.net>
` Re: Query only slow on first run
  2007-11-28 22:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query only slow on first run
  2007-11-29 06:49 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Query only slow on first run
  2007-11-29 11:07 UTC  cluster <skrald@amossen.dk>
` Re: Query only slow on first run
  2007-11-29 15:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [24+ messages in thread]

Windows XP selects are very slow
  2007-11-28 09:30 UTC  Shadkam Islam <shadkam@ba-sys.com>
` Re: Windows XP selects are very slow
  2007-11-28 12:28 UTC  Richard Huxton <dev@archonet.com>
` Re: Windows XP selects are very slow
  2007-11-28 16:15 UTC  Usama Munir Dar <usama.munir@enterprisedb.com>
  [3+ 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