pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Vacuum takes a really long time, vacuum full required
  2004-10-19 15:38 UTC  Max Baker <max@warped.org>
` Re: Vacuum takes a really long time, vacuum full required
  2004-10-19 15:40 UTC  Rod Taylor <pg@rbt.ca>
` Re: Vacuum takes a really long time, vacuum full required
  2004-10-19 16:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Vacuum takes a really long time, vacuum full required
  2004-10-19 18:12 UTC  Max Baker <max@warped.org>
` Re: Vacuum takes a really long time, vacuum full required
  2004-10-24 05:08 UTC  Max Baker <max@warped.org>
  [5+ messages in thread]

Insert performance, what should I expect?
  2004-10-20 01:53 UTC  Brock Henry <brock.henry@gmail.com>
` Re: Insert performance, what should I expect?
  2004-10-20 02:12 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: Insert performance, what should I expect?
  2004-10-20 02:12 UTC  Rod Taylor <pg@rbt.ca>
` Re: Insert performance, what should I expect?
  2004-10-20 07:50 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: Insert performance, what should I expect?
  2004-10-20 16:45 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: Insert performance, what should I expect?
  2004-10-20 17:20 UTC  Rod Taylor <pg@rbt.ca>
` Re: Insert performance, what should I expect?
  2004-10-23 10:31 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: Insert performance, what should I expect?
  2004-10-23 11:15 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
  [8+ messages in thread]

mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
  2004-10-15 00:25 UTC  Aaron Werman <aaron.werman@gmail.com>
` Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
  2004-10-15 01:08 UTC  Kevin Brown <kevin@sysexperts.com>
` Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
  2004-10-15 20:09 UTC  Sean Chittenden <sean@chittenden.org>
` Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
  2004-10-15 20:39 UTC  Mark Wong <markw@osdl.org>
` Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
  2004-10-15 21:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
  2004-10-15 21:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
  2004-10-15 21:56 UTC  Mark Wong <markw@osdl.org>
` Re: mmap (was First set of OSDL Shared Mem scalability results,
  2004-10-16 01:22 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
  2004-10-18 15:28 UTC  Mark Wong <markw@osdl.org>
` Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
  2004-10-21 20:29 UTC  Sean Chittenden <sean@chittenden.org>
` Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
  2004-10-22 04:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [11+ messages in thread]

OS desicion
  2004-10-20 13:10 UTC  Tom Fischer <tom.fischer@ebuz.de>
` Re: OS desicion
  2004-10-20 13:23 UTC  Matt Clark <matt@ymogen.net>
` Re: OS desicion
  2004-10-20 16:38 UTC  Josh Berkus <josh@agliodbs.com>
` Re: OS desicion
  2004-10-20 17:12 UTC  Matt Clark <matt@ymogen.net>
` Re: OS desicion
  2004-10-21 22:14 UTC  Jim C. Nasby <decibel@decibel.org>
  [5+ messages in thread]

Does PostgreSQL run with Oracle?
  2004-10-15 16:54 UTC  Richard_D_Levine@raytheon.com
` Re: Does PostgreSQL run with Oracle?
  2004-10-15 17:02 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Does PostgreSQL run with Oracle?
  2004-10-15 17:19 UTC  Steve Atkins <steve@blighty.com>
` Re: Does PostgreSQL run with Oracle?
  2004-10-15 18:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Does PostgreSQL run with Oracle?
  2004-10-15 18:15 UTC  Marc Slemko <identd@gmail.com>
` Re: Does PostgreSQL run with Oracle?
  2004-10-15 19:45 UTC  Mike Rylander <mrylander@gmail.com>
` Re: Does PostgreSQL run with Oracle?
  2004-10-19 23:25 UTC  Greg Sabino Mullane <greg@turnstep.com>
` Re: Does PostgreSQL run with Oracle?
  2004-10-21 22:11 UTC  Jim C. Nasby <decibel@decibel.org>
  [8+ messages in thread]

Links to OSDL test results up
  2004-10-21 20:28 UTC  Josh Berkus <josh@agliodbs.com>

Simple machine-killing query!
  2004-10-21 14:34 UTC  Victor Ciurus <vikcious@gmail.com>
` Re: Simple machine-killing query!
  2004-10-21 15:05 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Simple machine-killing query!
  2004-10-21 15:14 UTC  Aaron Werman <aaron.werman@gmail.com>
` Re: Simple machine-killing query!
  2004-10-21 15:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Simple machine-killing query!
  2004-10-21 17:03 UTC  Victor Ciurus <vikcious@gmail.com>
` Re: Simple machine-killing query!
  2004-10-21 17:14 UTC  Josh Berkus <josh@agliodbs.com>
  [6+ messages in thread]

create index with substr function
  2004-10-21 02:25 UTC  Ray <ray_siu@ge-ts.com.hk>
` Re: create index with substr function
  2004-10-21 02:57 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: create index with substr function
  2004-10-21 02:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: create index with substr function
  2004-10-21 03:11 UTC  Ray <ray_siu@ge-ts.com.hk>
` Re: create index with substr function
  2004-10-21 03:34 UTC  Rosser Schwarz <rosser.schwarz@gmail.com>
` Re: create index with substr function
  2004-10-21 03:37 UTC  Ray <ray_siu@ge-ts.com.hk>
` Re: create index with substr function
  2004-10-21 06:13 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: create index with substr function
  2004-10-21 14:22 UTC  george young <gry@ll.mit.edu>
  [8+ messages in thread]

iostat question
  2004-10-21 00:28 UTC  jelle <jellej@pacbell.net>

how much mem to give postgres?
  2004-10-19 22:31 UTC  Josh Close <narshe@gmail.com>
` Re: how much mem to give postgres?
  2004-10-20 00:33 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: how much mem to give postgres?
  2004-10-20 04:02 UTC  Josh Close <narshe@gmail.com>
` Re: how much mem to give postgres?
  2004-10-20 04:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: how much mem to give postgres?
  2004-10-20 05:23 UTC  Josh Berkus <josh@agliodbs.com>
` Re: how much mem to give postgres?
  2004-10-20 13:36 UTC  Josh Close <narshe@gmail.com>
` Re: how much mem to give postgres?
  2004-10-20 13:39 UTC  Josh Close <narshe@gmail.com>
` Re: how much mem to give postgres?
  2004-10-20 14:07 UTC  Matt Clark <matt@ymogen.net>
` Re: how much mem to give postgres?
  2004-10-20 17:50 UTC  Steve Atkins <steve@blighty.com>
` Re: how much mem to give postgres?
  2004-10-20 18:16 UTC  Matt Clark <matt@ymogen.net>
` Re: how much mem to give postgres?
  2004-10-20 18:39 UTC  Steve Atkins <steve@blighty.com>
  [11+ messages in thread]

Index not used in query. Why?
  2004-10-19 16:26 UTC  Andrei Bintintan <klodoma@ar-sd.net>
` Re: Index not used in query. Why?
  2004-10-19 16:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index not used in query. Why?
  2004-10-19 17:49 UTC  Contact AR-SD.NET <contact@ar-sd.net>
` Re: Index not used in query. Why?
  2004-10-20 16:13 UTC  Thomas F.O'Connell <tfo@sitening.com>
  [4+ messages in thread]

Which plattform do you recommend I run PostgreSQL for best performance?
  2004-10-12 15:45 UTC  nd02tsk@student.hig.se
` Re: Which plattform do you recommend I run PostgreSQL for
  2004-10-12 15:47 UTC  Matt Clark <matt@ymogen.net>
` Re: Which plattform do you recommend I run PostgreSQL for
  2004-10-12 16:27 UTC  Francisco Reyes <lists@natserv.com>
` Re: Which plattform do you recommend I run PostgreSQL for best performance?
  2004-10-12 20:02 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Which plattform do you recommend I run PostgreSQL for best performance?
  2004-10-12 20:32 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Which plattform do you recommend I run PostgreSQL for best
  2004-10-13 08:46 UTC  CoL <col@mportal.hu>
` Re: Which plattform do you recommend I run PostgreSQL
  2004-10-20 12:54 UTC  nd02tsk@student.hig.se
  [7+ messages in thread]

Re: How to time several queries?
  2004-10-18 18:11 UTC  Joshua D. Drake <jd@commandprompt.com>
` How to time several queries?
  2004-10-18 18:28 UTC  nd02tsk@student.hig.se
` Re: How to time several queries?
  2004-10-20 11:50 UTC  nd02tsk@student.hig.se
` Re: How to time several queries?
  2004-10-20 12:50 UTC  Matthew Nuzum <newz@bearfruit.org>
  [4+ messages in thread]

Speeding up this function
  2004-10-19 19:35 UTC  Matt Nuzum <matt.followers@gmail.com>
` Re: Speeding up this function
  2004-10-19 19:49 UTC  Jeremy Dunn <jdunn@autorevenue.com>
` Re: Speeding up this function
  2004-10-19 19:55 UTC  Matt Nuzum <matt.followers@gmail.com>
` Re: Speeding up this function
  2004-10-20 00:08 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
  [4+ messages in thread]

Select with qualified join condition / Batch inserts
  2004-10-15 10:25 UTC  Bernd <bernd_pg@genedata.com>
` Re: Select with qualified join condition / Batch inserts
  2004-10-15 10:36 UTC  Matt Clark <matt@ymogen.net>
` Re: Select with qualified join condition / Batch inserts
  2004-10-15 10:44 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
` Re: Select with qualified join condition / Batch inserts
  2004-10-15 10:47 UTC  Gavin Sherry <swm@linuxworld.com.au>
` Re: Select with qualified join condition / Batch inserts
  2004-10-15 14:17 UTC  Michael Nonemacher <Michael_Nonemacher@messageone.com>
` Re: Select with qualified join condition / Batch inserts
  2004-10-15 17:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Select with qualified join condition / Batch inserts
  2004-10-19 23:18 UTC  Russell Smith <mr-russ@pws.com.au>
  [7+ messages in thread]

Performance on Win32 vs Cygwin
  2004-10-14 17:01 UTC  MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>
` Re: Performance on Win32 vs Cygwin
  2004-10-14 17:29 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: Performance on Win32 vs Cygwin
  2004-10-14 19:40 UTC  Reini Urban <rurban@x-ray.at>
` Re: Performance on Win32 vs Cygwin
  2004-10-14 21:45 UTC  MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>
` Re: Performance on Win32 vs Cygwin
  2004-10-15 15:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance on Win32 vs Cygwin
  2004-10-15 16:22 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: [PERFORM] Performance on Win32 vs Cygwin
  2004-10-15 17:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Performance on Win32 vs Cygwin
  2004-10-19 22:09 UTC  Kevin Barnard <kevin.barnard@gmail.com>
  [8+ messages in thread]

Why isn't this index being used?
  2004-10-19 15:14 UTC  Knutsen, Mark <Mark.Knutsen@nasdaq.com>
` Re: Why isn't this index being used?
  2004-10-19 15:28 UTC  Doug Y <dylists@ptd.net>
` Re: Why isn't this index being used?
  2004-10-19 15:33 UTC  Knutsen, Mark <Mark.Knutsen@nasdaq.com>
` Re: Why isn't this index being used?
  2004-10-19 15:47 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
  [4+ messages in thread]

Indexes performance
  2004-10-18 08:50 UTC  charavay <c.charavay@ibcp.fr>
` Re: Indexes performance
  2004-10-18 19:45 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Indexes performance
  2004-10-19 00:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Autotuning of shared buffer size (was: Re: Getting rid of AtEOXact Buffers (was Re: [Testperf-general] Re: [PERFORM] First set of OSDL Shared Memscalability results, some wierdness ...))
  2004-10-18 21:19 UTC  Jan Wieck <JanWieck@Yahoo.com>

Getting rid of AtEOXact_Buffers (was Re: [Testperf-general] Re: [PERFORM] First set of OSDL Shared Memscalability results, some wierdness ...)
  2004-10-16 16:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Getting rid of AtEOXact_Buffers (was Re: [Testperf-general] Re: [PERFORM] First set of OSDL Shared Memscalability results, some wierdness ...)
  2004-10-16 21:18 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Getting rid of AtEOXact_Buffers (was Re: [Testperf-general] Re: [PERFORM] First set of OSDL Shared Memscalability results, some wierdness ...)
  2004-10-16 21:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Getting rid of AtEOXact_Buffers (was Re: [Testperf-general] Re: [PERFORM] First set of OSDL Shared Memscalability results, some wierdness ...)
  2004-10-16 21:36 UTC  Josh Berkus <josh@agliodbs.com>
`  Re:  Getting rid of AtEOXact Buffers (was Re: [Testperf-general] Re: [PERFORM] First set of OSDL Shared Memscalability results,  some wierdness ...)
  2004-10-17 19:40 UTC  simon@2ndquadrant.com
` Re: Re:  Getting rid of AtEOXact Buffers (was Re: [Testperf-general] Re: [PERFORM] First set of OSDL Shared Memscalability results,  some wierdness ...)
  2004-10-17 20:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] Getting rid of AtEOXact Buffers (was Re: [Testperf-general]
  2004-10-18 00:22 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: Getting rid of AtEOXact Buffers (was Re: [Testperf-general]
  2004-10-18 20:36 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: Getting rid of AtEOXact Buffers (was Re: [Testperf-general] Re: [PERFORM] First set of OSDL Shared Memscalability results, some wierdness ...)
  2004-10-18 21:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [9+ messages in thread]

Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-15 07:55 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-15 16:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-15 19:42 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-15 19:44 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-15 20:13 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-15 20:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-15 20:38 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-15 21:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-15 21:32 UTC  Mark Wong <markw@osdl.org>
` Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-15 21:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-15 22:10 UTC  Mark Wong <markw@osdl.org>
` Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
  2004-10-18 21:00 UTC  Josh Berkus <josh@agliodbs.com>
  [12+ messages in thread]

Re: execute cursor fetch
  2004-10-12 11:43 UTC  my ho <mthoatbanjo@yahoo.com>
` Re: execute cursor fetch
  2004-10-12 12:36 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: execute cursor fetch
  2004-10-12 13:05 UTC  Stef <svb@ucs.co.za>
` Re: execute cursor fetch
  2004-10-12 14:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: execute cursor fetch
  2004-10-15 22:30 UTC  Kris Jurka <books@ejurka.com>
  [5+ messages in thread]

Tuning shared_buffers with ipcs ?
  2004-10-15 16:07 UTC  Doug Y <dylists@ptd.net>
` Re: Tuning shared_buffers with ipcs ?
  2004-10-15 17:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning shared_buffers with ipcs ?
  2004-10-15 18:51 UTC  Doug Y <dylists@ptd.net>
` Re: Tuning shared_buffers with ipcs ?
  2004-10-15 19:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning shared_buffers with ipcs ?
  2004-10-15 21:18 UTC  Doug Y <dylists@ptd.net>
  [5+ messages in thread]

Re: [Testperf-general] Re: First set of OSDL Shared Memscalability
  2004-10-15 16:57 UTC  Bruce Momjian <pgman@candle.pha.pa.us>

View & Query Performance
  2004-10-14 21:02 UTC  Igor Maciel Macaubas <igor@providerst.com.br>
` Re: View & Query Performance
  2004-10-15 07:28 UTC  Alban Medici (NetCentrex) <amedici@fr.netcentrex.net>
` Re: View & Query Performance
  2004-10-15 07:37 UTC  Richard Huxton <dev@archonet.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