pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: deadlock detected when calling function (Call function_name)
  2007-07-31 15:00 UTC  Sachchida Ojha <sojha@secure-elements.com>
` Re: deadlock detected when calling function (Call function_name)
  2007-07-31 15:28 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: deadlock detected when calling function (Callfunction_name)
  2007-07-31 16:38 UTC  Sachchida Ojha <sojha@secure-elements.com>
  [3+ messages in thread]

Re: disk filling up
  2007-07-26 13:34 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: disk filling up
  2007-07-26 14:37 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: disk filling up
  2007-07-26 14:47 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: disk filling up
  2007-07-26 15:06 UTC  Yudhvir Singh Sidhu <ysidhu@gmail.com>
` disk filling up
  2007-07-26 16:18 UTC  Brandon Shalton <brandon@cydataservices.com>
` Re: disk filling up
  2007-07-27 00:48 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: disk filling up
  2007-07-27 13:44 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: disk filling up
  2007-07-31 05:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: disk filling up
  2007-07-31 16:16 UTC  Merlin Moncure <mmoncure@gmail.com>
  [9+ messages in thread]

Seq scan on join table despite index and high statistics
  2007-07-31 08:23 UTC  Henrik Zagerholm <henke@mac.se>

Vacuum looping?
  2007-07-27 21:32 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: Vacuum looping?
  2007-07-28 14:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Vacuum looping?
  2007-07-28 16:36 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: Vacuum looping?
  2007-07-30 16:04 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: Vacuum looping?
  2007-07-31 01:46 UTC  Decibel! <decibel@decibel.org>
  [5+ messages in thread]

Questions on Tags table schema
  2007-07-29 14:22 UTC  Jay Kang <arrival123@gmail.com>
` Re: Questions on Tags table schema
  2007-07-30 07:21 UTC  Richard Huxton <dev@archonet.com>
` Re: Questions on Tags table schema
  2007-07-30 10:13 UTC  Jay Kang <arrival123@gmail.com>
` Re: Questions on Tags table schema
  2007-07-30 10:28 UTC  Richard Huxton <dev@archonet.com>
` Re: Questions on Tags table schema
  2007-07-30 10:48 UTC  Richard Huxton <dev@archonet.com>
` Re: Questions on Tags table schema
  2007-07-30 11:26 UTC  Jay Kang <arrival123@gmail.com>
` Re: Questions on Tags table schema
  2007-07-30 11:57 UTC  Richard Huxton <dev@archonet.com>
` Re: Questions on Tags table schema
  2007-07-30 14:58 UTC  Richard Huxton <dev@archonet.com>
` Re: Questions on Tags table schema
  2007-07-30 20:40 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>
  [9+ messages in thread]

Slow query with backwards index scan
  2007-07-27 17:27 UTC  Tilmann Singer <tils-pgsql@tils.net>
` Re: Slow query with backwards index scan
  2007-07-27 18:28 UTC  Nis Jørgensen <nis@superlativ.dk>
` Re: Slow query with backwards index scan
  2007-07-28 12:52 UTC  Tilmann Singer <tils-pgsql@tils.net>
` Re: Slow query with backwards index scan
  2007-07-28 19:03 UTC  andrew@pillette.com
` Re: Slow query with backwards index scan
  2007-07-28 19:27 UTC  Tilmann Singer <tils-pgsql@tils.net>
` Re: Slow query with backwards index scan
  2007-07-28 19:40 UTC  Jeremy Harris <jgh@wizmail.org>
` Re: Slow query with backwards index scan
  2007-07-28 20:06 UTC  Craig James <craig_james@emolecules.com>
` Re: Slow query with backwards index scan
  2007-07-28 20:43 UTC  andrew@pillette.com
` Re: Slow query with backwards index scan
  2007-07-28 20:54 UTC  Tilmann Singer <tils-pgsql@tils.net>
` Re: Slow query with backwards index scan
  2007-07-30 16:30 UTC  Nis Jørgensen <nis@superlativ.dk>
` Re: Slow query with backwards index scan
  2007-07-30 19:10 UTC  Tilmann Singer <tils-pgsql@tils.net>
` Re: Slow query with backwards index scan
  2007-07-30 20:05 UTC  Nis Jørgensen <nis@superlativ.dk>
  [12+ messages in thread]

RES: RES: select on 1milion register = 6s
  2007-07-28 22:38 UTC  Bruno Rodrigues Siqueira <bruno@ravnus.com>
` RES: RES: select on 1milion register = 6s
  2007-07-29 16:44 UTC  Bruno Rodrigues Siqueira <bruno@ravnus.com>
` Re: RES: RES: select on 1milion register = 6s
  2007-07-30 01:29 UTC  Decibel! <decibel@decibel.org>
` Re: RES: RES: select on 1milion register = 6s
  2007-07-30 06:52 UTC  Decibel! <decibel@decibel.org>
  [4+ messages in thread]

RES: select on 1milion register = 6s
  2007-07-28 20:12 UTC  Bruno Rodrigues Siqueira <bruno@ravnus.com>
` Re: RES: select on 1milion register = 6s
  2007-07-28 22:36 UTC  Ragnar <gnari@hive.is>
` RES: select on 1milion register = 6s
  2007-07-28 22:40 UTC  Bruno Rodrigues Siqueira <bruno@ravnus.com>
` RES: select on 1milion register = 6s
  2007-07-28 23:07 UTC  Bruno Rodrigues Siqueira <bruno@ravnus.com>
` Re: RES: select on 1milion register = 6s
  2007-07-29 16:35 UTC  Decibel! <decibel@decibel.org>
  [5+ messages in thread]

multicolumn index column order
  2007-07-23 16:47 UTC  valgog <valgog@gmail.com>
` Re: multicolumn index column order
  2007-07-23 17:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: multicolumn index column order
  2007-07-23 17:13 UTC  valgog <valgog@gmail.com>
` Re: multicolumn index column order
  2007-07-24 07:10 UTC  andrew@pillette.com
` Re: multicolumn index column order
  2007-07-24 07:40 UTC  Valentine Gogichashvili <valgog@gmail.com>
` Re: multicolumn index column order
  2007-07-25 08:34 UTC  valgog <valgog@gmail.com>
` Re: multicolumn index column order
  2007-07-27 20:03 UTC  Lew <lew@lewscanon.nospam>
  [7+ messages in thread]

How to use a trigger to write rows to a remote server
  2007-07-18 13:36 UTC  Michael Dengler <michael.dengler@gmail.com>
` Re: How to use a trigger to write rows to a remote server
  2007-07-18 13:46 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: How to use a trigger to write rows to a remote server
  2007-07-18 14:02 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: How to use a trigger to write rows to a remote server
  2007-07-18 14:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to use a trigger to write rows to a remote server
  2007-07-18 15:43 UTC  Adam Tauno Williams <adamtaunowilliams@gmail.com>
` Re: How to use a trigger to write rows to a remote server
  2007-07-18 16:30 UTC  Michael Dengler <michael.dengler@gmail.com>
` Re: How to use a trigger to write rows to a remote server
  2007-07-18 17:06 UTC  Erik Jones <erik@myemma.com>
` Re: How to use a trigger to write rows to a remote server
  2007-07-27 18:27 UTC  Merlin Moncure <mmoncure@gmail.com>
  [8+ messages in thread]

Affect of Reindexing on Vacuum Times
  2007-07-25 18:53 UTC  Y Sidhu <ysidhu@gmail.com>
` Re: Affect of Reindexing on Vacuum Times
  2007-07-26 23:27 UTC  Jim Nasby <decibel@decibel.org>
  [2+ messages in thread]

update, truncate and vacuum
  2007-07-26 22:36 UTC  Scott Feldstein <scott.feldstein@hyperic.com>
` Re: update, truncate and vacuum
  2007-07-26 22:59 UTC  Dave Dutcher <dave@tridecap.com>
` Re: update, truncate and vacuum
  2007-07-26 23:17 UTC  Luke Lonergan <LLonergan@greenplum.com>
  [3+ messages in thread]

performance of postgresql in replication using slony
  2007-07-26 08:44 UTC  angga erwina <by_pacitan@yahoo.com>
` Re: performance of postgresql in replication using slony
  2007-07-26 17:21 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: performance of postgresql in replication using slony
  2007-07-26 18:28 UTC  Chris Browne <cbbrowne@acm.org>
  [3+ messages in thread]

Performance issue with 8.2.3 - "C" application
  2007-07-25 01:20 UTC  Karl Denninger <karl@denninger.net>
` Re: Performance issue with 8.2.3 - "C" application
  2007-07-25 02:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance issue with 8.2.3 - "C" application
  2007-07-25 02:55 UTC  Karl Denninger <karl@denninger.net>
` Re: Performance issue with 8.2.3 - "C" application
  2007-07-25 03:15 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Performance issue with 8.2.3 - "C" application
  2007-07-25 03:16 UTC  Karl Denninger <karl@denninger.net>
` Re: Performance issue with 8.2.3 - "C" application
  2007-07-25 03:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance issue with 8.2.3 - "C" application
  2007-07-25 03:35 UTC  Karl Denninger <karl@denninger.net>
` Re: Performance issue with 8.2.3 - "C" application
  2007-07-25 06:17 UTC  Nis Jørgensen <nis@superlativ.dk>
` Re: Performance issue with 8.2.3 - "C" application
  2007-07-25 07:58 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: Performance issue with 8.2.3 - "C" application
  2007-07-25 21:01 UTC  Karl Denninger <karl@denninger.net>
  [10+ messages in thread]

Insert Statements Hanging
  2007-07-25 20:27 UTC  Pallav Kalva <pkalva@livedatagroup.com>
` Re: Insert Statements Hanging
  2007-07-25 20:55 UTC  Alan Hodgson <ahodgson@simkin.ca>
  [2+ messages in thread]

8.2 -> 8.3 performance numbers
  2007-07-20 04:58 UTC  Jim Nasby <decibel@decibel.org>
` Re: [PERFORM] 8.2 -> 8.3 performance numbers
  2007-07-20 17:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [PERFORM] 8.2 -> 8.3 performance numbers
  2007-07-20 18:32 UTC  Jim Nasby <decibel@decibel.org>
` Re: [PERFORM] 8.2 -> 8.3 performance numbers
  2007-07-25 01:28 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
  2007-07-25 12:52 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
  2007-07-25 13:07 UTC  Mario Weilguni <mweilguni@sime.com>
` Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
  2007-07-25 14:09 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
  2007-07-25 14:09 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
  2007-07-25 14:22 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
  2007-07-25 14:43 UTC  Gregory Stark <stark@enterprisedb.com>
  [10+ messages in thread]

index over timestamp not being used
  2007-07-24 18:27 UTC  Arnau <arnaulist@andromeiberica.com>
` Re: index over timestamp not being used
  2007-07-24 19:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: index over timestamp not being used
  2007-07-24 19:31 UTC  Arnau <arnaulist@andromeiberica.com>
` Re: index over timestamp not being used
  2007-07-24 19:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: index over timestamp not being used
  2007-07-25 13:05 UTC  Mario Weilguni <mweilguni@sime.com>
` Re: index over timestamp not being used
  2007-07-25 13:35 UTC  Ansgar -59cobalt- Wiechers <lists@planetcobalt.net>
  [6+ messages in thread]

Table Statistics with pgAdmin III
  2007-07-24 17:06 UTC  Campbell, Lance <lance@uiuc.edu>
` Re: Table Statistics with pgAdmin III
  2007-07-24 17:23 UTC  Jean-Max Reymond <jmreymond@gmail.com>
` Re: Table Statistics with pgAdmin III
  2007-07-24 17:49 UTC  Dave Page <dpage@postgresql.org>
` Re: Table Statistics with pgAdmin III
  2007-07-24 18:41 UTC  Campbell, Lance <lance@uiuc.edu>
` Re: Table Statistics with pgAdmin III
  2007-07-25 08:59 UTC  Dave Page <dpage@postgresql.org>
  [5+ messages in thread]

disable archiving
  2007-07-23 17:24 UTC  Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
` Re: disable archiving
  2007-07-23 17:34 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: disable archiving
  2007-07-23 17:37 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: disable archiving
  2007-07-23 17:39 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: disable archiving
  2007-07-23 17:42 UTC  Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
` Re: disable archiving
  2007-07-24 07:33 UTC  valgog <valgog@gmail.com>
  [6+ messages in thread]

Second SpecJAppserver2004 with PostgreSQL
  2007-07-24 04:09 UTC  Jignesh K. Shah <J.K.Shah@Sun.COM>

insert vs select into performance
  2007-07-17 19:38 UTC  Thomas Finneid <tfinneid@student.matnat.uio.no>
` Re: insert vs select into performance
  2007-07-17 19:53 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: insert vs select into performance
  2007-07-17 19:54 UTC  Michael Glaesemann <grzm@seespotcode.net>
` Re: insert vs select into performance
  2007-07-17 20:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert vs select into performance
  2007-07-17 20:50 UTC  Thomas Finneid <tfinneid@student.matnat.uio.no>
` Re: insert vs select into performance
  2007-07-17 20:58 UTC  Thomas Finneid <tfinneid@student.matnat.uio.no>
` Re: insert vs select into performance
  2007-07-17 20:58 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: insert vs select into performance
  2007-07-17 20:59 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: insert vs select into performance
  2007-07-17 21:01 UTC  Thomas Finneid <tfinneid@student.matnat.uio.no>
` Re: insert vs select into performance
  2007-07-17 21:07 UTC  Michael Glaesemann <grzm@seespotcode.net>
` Re: insert vs select into performance
  2007-07-17 21:10 UTC  Thomas Finneid <tfinneid@student.matnat.uio.no>
` Re: insert vs select into performance
  2007-07-17 21:14 UTC  PFC <lists@peufeu.com>
` Re: insert vs select into performance
  2007-07-17 21:27 UTC  Thomas Finneid <tfinneid@student.matnat.uio.no>
` Re: insert vs select into performance
  2007-07-18 11:07 UTC  PFC <lists@peufeu.com>
` Re: insert vs select into performance
  2007-07-18 11:31 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: insert vs select into performance
  2007-07-18 11:32 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: insert vs select into performance
  2007-07-18 19:08 UTC  Thomas Finneid <tfinneid@student.matnat.uio.no>
` Re: insert vs select into performance
  2007-07-18 19:11 UTC  Thomas Finneid <tfinneid@student.matnat.uio.no>
` Re: insert vs select into performance
  2007-07-18 19:13 UTC  Thomas Finneid <tfinneid@student.matnat.uio.no>
` Re: insert vs select into performance
  2007-07-18 19:28 UTC  Adriaan van Os <postgres@microbizz.nl>
` Re: insert vs select into performance
  2007-07-18 19:58 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: insert vs select into performance
  2007-07-23 11:51 UTC  Michael Stone <mstone+postgres@mathom.us>
  [22+ messages in thread]

large number of connected connections to postgres database (v8.0)
  2007-07-17 18:51 UTC  Fei Liu <fei.liu@aepnetworks.com>
` Re: large number of connected connections to postgres database (v8.0)
  2007-07-20 23:28 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

Simple query showing 270 hours of CPU time
  2007-07-20 15:43 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: Simple query showing 270 hours of CPU time
  2007-07-20 16:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Simple query showing 270 hours of CPU time
  2007-07-20 16:55 UTC  PFC <lists@peufeu.com>
` Re: Simple query showing 270 hours of CPU time
  2007-07-20 17:18 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: Simple query showing 270 hours of CPU time
  2007-07-20 18:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Improving select peformance
  2007-07-20 00:41 UTC  Carlos H. Reimer <carlos.reimer@opendb.com.br>
` Re: Improving select peformance
  2007-07-20 01:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Problems with posting
  2007-07-20 01:19 UTC  Carlos H. Reimer <carlos.reimer@opendb.com.br>


[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