pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedupdate slows down in pl/pgsql function
2003-12-16 23:52 UTC Jenny Zhang <jenny@osdl.org>
` Re: update slows down in pl/pgsql function
2003-12-16 23:54 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: update slows down in pl/pgsql function
2003-12-17 00:07 UTC Jenny Zhang <jenny@osdl.org>
[3+ messages in thread]
a lot of problems with pg 7.4
2003-12-13 18:38 UTC Kari Lavikka <tuner@bdb.fi>
` Re: a lot of problems with pg 7.4
2003-12-14 09:54 UTC Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>
` Re: a lot of problems with pg 7.4
2003-12-14 17:14 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: a lot of problems with pg 7.4
2003-12-16 16:37 UTC scott.marlowe <scott.marlowe@ihs.com>
[4+ messages in thread]
Postgres respond after toomany times to a query view
2003-12-16 15:40 UTC Claudia D'amato <claudia.damato@allaxia.com>
TRUNCATE veeeery slow compared to DELETE in 7.4
2003-12-08 14:03 UTC Hartmut Raschick <hartmut.raschick@ke-elektronik.de>
` Re: TRUNCATE veeeery slow compared to DELETE in 7.4
2003-12-10 17:18 UTC Josh Berkus <josh@agliodbs.com>
` Re: TRUNCATE veeeery slow compared to DELETE in 7.4
2003-12-10 19:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: TRUNCATE veeeery slow compared to DELETE in 7.4
2003-12-12 10:47 UTC Hartmut Raschick <hartmut.raschick@ke-elektronik.de>
` Re: TRUNCATE veeeery slow compared to DELETE in 7.4
2003-12-15 18:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Index problem or function problem?
2003-12-09 23:24 UTC LIANHE SHAO <lshao2@jhmi.edu>
` Re: Index problem or function problem?
2003-12-15 18:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Hardware suggestions for Linux/PGSQL server
2003-12-11 20:19 UTC Jeff Bohmer <bohmer@visionlink.org>
` Re: Hardware suggestions for Linux/PGSQL server
2003-12-11 20:50 UTC William Yu <wyu@talisys.com>
` Re: Hardware suggestions for Linux/PGSQL server
2003-12-11 22:02 UTC Jeff Bohmer <bohmer@visionlink.org>
` Re: Hardware suggestions for Linux/PGSQL server
2003-12-11 22:48 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Hardware suggestions for Linux/PGSQL server
2003-12-11 23:32 UTC William Yu <wyu@talisys.com>
` Re: Hardware suggestions for Linux/PGSQL server
2003-12-12 06:35 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Hardware suggestions for Linux/PGSQL server
2003-12-12 16:35 UTC William Yu <wyu@talisys.com>
` Re: Hardware suggestions for Linux/PGSQL server
2003-12-13 22:57 UTC Jeff Bohmer <bohmer@visionlink.org>
` Re: Hardware suggestions for Linux/PGSQL server
2003-12-13 23:00 UTC Jeff Bohmer <bohmer@visionlink.org>
` Re: Hardware suggestions for Linux/PGSQL server
2003-12-15 04:17 UTC Andrew G. Hammond <drew@xyzzy.dhs.org>
` Re: Hardware suggestions for Linux/PGSQL server
2003-12-15 05:14 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Hardware suggestions for Linux/PGSQL server
2003-12-15 16:37 UTC Jeff Bohmer <bohmer@visionlink.org>
[12+ messages in thread]
Tables Without OIDS and its effect
2003-12-12 16:13 UTC Sai Hertz And Control Systems <sank89@sancharnet.in>
` Re: [PERFORM] Tables Without OIDS and its effect
2003-12-12 23:10 UTC Neil Conway <neilc@samurai.com>
` Re: [PERFORM] Tables Without OIDS and its effect
2003-12-13 10:33 UTC Sai Hertz And Control Systems <sank89@sancharnet.in>
` Re: [PERFORM] Tables Without OIDS and its effect
2003-12-14 22:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Tables Without OIDS and its effect
2003-12-15 02:10 UTC Neil Conway <neilc@samurai.com>
[5+ messages in thread]
Tuning for mid-size server
2003-10-21 14:28 UTC Anjan Dave <adave@vantage.com>
` Re: Tuning for mid-size server
2003-10-21 15:56 UTC Richard Huxton <dev@archonet.com>
` Re: Tuning for mid-size server
2003-10-21 16:20 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
2003-10-21 16:25 UTC William Yu <wyu@talisys.com>
` Re: Tuning for mid-size server
2003-10-21 16:26 UTC Anjan Dave <adave@vantage.com>
` Re: Tuning for mid-size server
2003-10-21 16:48 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Tuning for mid-size server
2003-10-21 17:02 UTC Anjan Dave <adave@vantage.com>
` Re: Tuning for mid-size server
2003-10-21 17:12 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
2003-10-21 17:15 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
2003-10-21 17:22 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
2003-10-21 17:30 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Tuning for mid-size server
2003-10-21 17:33 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Tuning for mid-size server
2003-10-21 17:48 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: Tuning for mid-size server
2003-10-21 17:50 UTC Jeff <threshar@torgo.978.org>
` Re: Tuning for mid-size server
2003-10-21 17:50 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: Tuning for mid-size server
2003-10-21 18:27 UTC William Yu <wyu@talisys.com>
` Re: Tuning for mid-size server
2003-10-21 18:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning for mid-size server
2003-10-21 18:51 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
2003-10-21 18:53 UTC Anjan Dave <adave@vantage.com>
` Re: Tuning for mid-size server
2003-10-21 18:59 UTC Anjan Dave <adave@vantage.com>
` Re: Tuning for mid-size server
2003-10-21 19:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning for mid-size server
2003-10-21 19:27 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Tuning for mid-size server
2003-10-21 20:55 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: Tuning for mid-size server
2003-10-21 21:11 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Tuning for mid-size server
2003-10-21 21:32 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
2003-10-21 21:34 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: Tuning for mid-size server
2003-10-22 21:36 UTC Ron Johnson <ron.l.johnson@cox.net>
` Re: Tuning for mid-size server
2003-12-14 05:42 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Tuning for mid-size server
2003-12-14 17:55 UTC Andrew Sullivan <andrew@libertyrms.info>
[29+ messages in thread]
Query plan - now what?
2003-12-12 08:18 UTC David Shadovitz <david@shadovitz.com>
` Re: Query plan - now what?
2003-12-12 09:14 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Query plan - now what?
2003-12-12 15:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan - now what?
2003-12-12 15:46 UTC David Shadovitz <david@shadovitz.com>
` Re: Query plan - now what?
2003-12-12 16:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan - now what?
2003-12-14 07:21 UTC David Shadovitz <david@shadovitz.com>
[6+ messages in thread]
Update performance doc
2003-12-14 05:44 UTC Bruce Momjian <pgman@candle.pha.pa.us>
Update on putting WAL on ramdisk/
2003-12-12 22:02 UTC William Yu <wyu@talisys.com>
` Re: Update on putting WAL on ramdisk/
2003-12-12 22:36 UTC Russell Garrett <rg@tcslon.com>
` Re: Update on putting WAL on ramdisk/
2003-12-12 22:45 UTC William Yu <wyu@talisys.com>
[3+ messages in thread]
Performance related to size of tables
2003-12-12 18:04 UTC nbarraza@uolsinectis.com.ar
` Re: Performance related to size of tables
2003-12-12 21:11 UTC Mark Kirkwood <markir@paradise.net.nz>
[2+ messages in thread]
ODBC Driver generates a too big "windows swap file" and it's too slow
2003-12-12 12:39 UTC Rhaoni Chiu Pereira <rhaoni@sistemica.info>
` Re: ODBC Driver generates a too big "windows swap file" and
2003-12-12 15:48 UTC scott.marlowe <scott.marlowe@ihs.com>
[2+ messages in thread]
Measuring execution time for sql called from PL/pgSQL
2003-12-12 01:17 UTC Aram Kananov <aram@kananov.com>
` Re: Measuring execution time for sql called from PL/pgSQL
2003-12-12 01:50 UTC David Shadovitz <david@www.shadovitz.com>
` Re: Measuring execution time for sql called from PL/pgSQL
2003-12-12 07:46 UTC Tomasz Myrta <jasiek@klaster.net>
[3+ messages in thread]
Performance problems with a higher number of clients
2003-12-11 04:13 UTC Alfranio Correia Junior <alfranio@lsd.di.uminho.pt>
` Re: Performance problems with a higher number of clients
2003-12-11 06:36 UTC Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: Performance problems with a higher number of clients
2003-12-11 13:28 UTC Jeff <threshar@torgo.978.org>
` Re: Performance problems with a higher number of clients
2003-12-11 14:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problems with a higher number of clients
2003-12-12 02:35 UTC Alfranio Tavares Correia Junior <alfranio@lsd.di.uminho.pt>
[5+ messages in thread]
hints in Postgres?
2003-12-11 16:00 UTC sandra ruiz <mileruiz@hotmail.com>
` Re: hints in Postgres?
2003-12-11 16:22 UTC Pavel Stehule <stehule@kix.fsv.cvut.cz>
` Re: hints in Postgres?
2003-12-11 16:31 UTC Christopher Browne <cbbrowne@acm.org>
` Re: hints in Postgres?
2003-12-11 20:27 UTC Bruno Wolff III <bruno@wolff.to>
[4+ messages in thread]
Command
2003-12-11 16:45 UTC nbarraza@uolsinectis.com.ar
Solaris Performance (Again)
2003-12-10 05:56 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Solaris Performance (Again)
2003-12-10 13:53 UTC Jeff <threshar@torgo.978.org>
` Re: Solaris Performance (Again)
2003-12-10 19:15 UTC Neil Conway <neilc@samurai.com>
` Re: Solaris Performance (Again)
2003-12-11 06:04 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Solaris Performance (Again)
2003-12-11 06:09 UTC Mark Kirkwood <markir@paradise.net.nz>
[5+ messages in thread]
(no subject)
2003-12-10 19:29 UTC nbarraza@uolsinectis.com.ar
` Re:
2003-12-10 20:35 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
[2+ messages in thread]
tuning questions
2003-12-04 16:06 UTC Jack Coates <jack@lyris.com>
` Re: tuning questions
2003-12-04 16:59 UTC Josh Berkus <josh@agliodbs.com>
` Re: tuning questions
2003-12-04 16:59 UTC Jeff <threshar@torgo.978.org>
` Re: tuning questions
2003-12-04 17:13 UTC Rob Fielding <rob@dsvr.net>
` Re: tuning questions
2003-12-04 17:26 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: tuning questions
2003-12-04 17:57 UTC Dror Matalon <dror@zapatec.com>
` Re: tuning questions
2003-12-04 18:03 UTC Josh Berkus <josh@agliodbs.com>
` Re: tuning questions
2003-12-04 18:07 UTC Jord Tanner <jord@indygecko.com>
` Re: tuning questions
2003-12-04 18:11 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: tuning questions
2003-12-04 18:12 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: tuning questions
2003-12-04 19:16 UTC Jack Coates <jack@lyris.com>
` Re: tuning questions
2003-12-04 19:17 UTC Eric Soroos <eric-psql@soroos.net>
` Re: tuning questions
2003-12-04 19:20 UTC Josh Berkus <josh@agliodbs.com>
` Re: tuning questions
2003-12-04 19:50 UTC Jack Coates <jack@lyris.com>
` Re: tuning questions
2003-12-04 20:27 UTC Richard Huxton <dev@archonet.com>
` Re: tuning questions
2003-12-04 20:37 UTC Jack Coates <jack@lyris.com>
` Re: tuning questions
2003-12-04 21:10 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: tuning questions
2003-12-04 21:24 UTC Josh Berkus <josh@agliodbs.com>
` Re: tuning questions
2003-12-04 22:59 UTC Eric Soroos <eric-psql@soroos.net>
` Re: tuning questions
2003-12-04 23:16 UTC Jack Coates <jack@lyris.com>
` Re: tuning questions
2003-12-04 23:20 UTC Jack Coates <jack@lyris.com>
` Re: tuning questions
2003-12-04 23:47 UTC Richard Huxton <dev@archonet.com>
` Re: tuning questions
2003-12-05 00:32 UTC Jack Coates <jack@lyris.com>
` Re: tuning questions
2003-12-05 04:52 UTC Eric Soroos <eric-psql@soroos.net>
` Re: tuning questions
2003-12-05 09:13 UTC Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>
` Re: tuning questions
2003-12-05 17:26 UTC Josh Berkus <josh@agliodbs.com>
` Re: tuning questions
2003-12-06 01:22 UTC Jack Coates <jack@lyris.com>
` Re: tuning questions
2003-12-08 17:43 UTC Jack Coates <jack@lyris.com>
` Re: tuning questions
2003-12-08 19:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: tuning questions
2003-12-09 16:57 UTC Jack Coates <jack@lyris.com>
` Re: tuning questions
2003-12-09 17:07 UTC Matt Clark <matt@ymogen.net>
` Re: tuning questions
2003-12-09 17:35 UTC Josh Berkus <josh@agliodbs.com>
[32+ messages in thread]
Problem with insert into select...
2003-11-20 21:04 UTC stephen farrell <sfarrell@almaden.ibm.com>
` Problem with insert into select...
2003-11-20 21:09 UTC stephen farrell <sfarrell@almaden.ibm.com>
` Re: Problem with insert into select...
2003-11-20 22:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problem with insert into select...
2003-11-21 02:05 UTC stephen farrell <sfarrell@almaden.ibm.com>
` Re: Problem with insert into select...
2003-11-24 19:29 UTC Richard Huxton <dev@archonet.com>
` Re: Problem with insert into select...
2003-12-09 08:32 UTC Neil Conway <neilc@samurai.com>
[6+ messages in thread]
autovacuum daemon stops doing work after about an hour
2003-12-02 20:37 UTC Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-04 05:38 UTC Matthew T. O'Connor <matthew@zeut.net>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-04 16:33 UTC Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-04 18:35 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-04 19:29 UTC Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-04 19:44 UTC Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-04 20:52 UTC Matthew T. O'Connor <matthew@zeut.net>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-04 21:20 UTC Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-04 21:22 UTC Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an
2003-12-04 21:25 UTC Larry Rosenman <ler@lerctr.org>
` Re: autovacuum daemon stops doing work after about an
2003-12-04 21:37 UTC Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an
2003-12-07 21:16 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-08 00:46 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-08 01:17 UTC Christopher Browne <cbbrowne@acm.org>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-08 05:27 UTC Matthew T. O'Connor <matthew@zeut.net>
` Re: autovacuum daemon stops doing work after about an hour
2003-12-08 18:41 UTC Vivek Khera <khera@kcilink.com>
[16+ messages in thread]
Help tracking down problem with inserts slowing down...
2003-12-05 21:51 UTC Steve Wampler <swampler@noao.edu>
` Re: Help tracking down problem with inserts slowing
2003-12-05 23:38 UTC Neil Conway <neilc@samurai.com>
` Re: Help tracking down problem with inserts slowing down...
2003-12-06 02:54 UTC Robert Treat <xzilla@users.sourceforge.net>
` Re: Help tracking down problem with inserts slowing down...
2003-12-07 14:28 UTC Steve Wampler <swampler@noao.edu>
` Re: Help tracking down problem with inserts slowing down...
2003-12-07 14:52 UTC Steve Wampler <swampler@noao.edu>
` Re: Help tracking down problem with inserts slowing down...
2003-12-07 16:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help tracking down problem with inserts slowing
2003-12-07 17:28 UTC Steve Wampler <swampler@noao.edu>
` Re: Help tracking down problem with inserts slowing
2003-12-08 15:14 UTC Steve Wampler <swampler@noao.edu>
` Re: Help tracking down problem with inserts slowing
2003-12-08 15:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
[9+ messages in thread]
Slow UPADTE, compared to INSERT
2003-12-04 18:57 UTC Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
2003-12-04 19:23 UTC Jeff <threshar@torgo.978.org>
` Re: Slow UPADTE, compared to INSERT
2003-12-04 19:51 UTC Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
2003-12-04 19:59 UTC William Yu <wyu@talisys.com>
` Re: Slow UPADTE, compared to INSERT
2003-12-04 20:23 UTC Richard Huxton <dev@archonet.com>
` Re: Slow UPADTE, compared to INSERT
2003-12-04 20:43 UTC Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
2003-12-04 22:13 UTC Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
2003-12-04 22:37 UTC Richard Huxton <dev@archonet.com>
` Re: Slow UPADTE, compared to INSERT
2003-12-04 22:45 UTC Richard Huxton <dev@archonet.com>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 01:45 UTC Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 02:07 UTC Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 02:15 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 10:08 UTC Richard Huxton <dev@archonet.com>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 12:38 UTC Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 12:49 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 13:13 UTC Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 13:23 UTC Richard Huxton <dev@archonet.com>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 13:51 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 16:47 UTC Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 16:52 UTC Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 17:05 UTC Mike C. Fletcher <mcfletch@rogers.com>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 17:12 UTC Mike C. Fletcher <mcfletch@rogers.com>
` Re: Slow UPADTE, compared to INSERT
2003-12-05 17:28 UTC Greg Stark <gsstark@mit.edu>
` Re: Slow UPADTE, compared to INSERT
2003-12-06 19:54 UTC Neil Conway <neilc@samurai.com>
[24+ messages in thread]
query using cpu nearly 100%, why?
2003-12-05 21:03 UTC LIANHE SHAO <lshao2@jhmi.edu>
` Re: query using cpu nearly 100%, why?
2003-12-06 17:46 UTC Richard Huxton <dev@archonet.com>
` Re: query using cpu nearly 100%, why?
2003-12-06 19:41 UTC Neil Conway <neilc@samurai.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