pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Odd behaviour with redundant CREATE statement
  2010-09-27 18:50 UTC  Dave Crooke <dcrooke@gmail.com>
` Re: Odd behaviour with redundant CREATE statement
  2010-09-27 19:27 UTC  Gurjeet Singh <singh.gurjeet@gmail.com>
` Re: Odd behaviour with redundant CREATE statement
  2010-10-07 20:40 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Odd behaviour with redundant CREATE statement
  2010-10-07 21:51 UTC  Dave Crooke <dcrooke@gmail.com>
  [4+ messages in thread]

MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-04 14:44 UTC  Hakan Kocaman <hkocam@googlemail.com>
` Re: MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-04 17:13 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-04 17:38 UTC  Michael Glaesemann <grzm@seespotcode.net>
` Re: MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-04 17:47 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-04 17:55 UTC  Dan Ports <drkp@csail.mit.edu>
` Re: MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-04 18:06 UTC  Greg Stark <gsstark@mit.edu>
` Re: MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-04 18:35 UTC  Dan Ports <drkp@csail.mit.edu>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-04 18:49 UTC  Josh Berkus <josh@agliodbs.com>
` Re: MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-04 19:22 UTC  Dan Ports <drkp@csail.mit.edu>
` Re: [PERFORM] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-04 19:35 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-06 22:31 UTC  Ivan Voras <ivoras@freebsd.org>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-06 22:34 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 00:39 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 01:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 01:30 UTC  Stephen Frost <sfrost@snowman.net>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 02:01 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 02:07 UTC  Stephen Frost <sfrost@snowman.net>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 12:19 UTC  Ivan Voras <ivoras@freebsd.org>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 12:33 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 12:47 UTC  Ivan Voras <ivoras@freebsd.org>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 17:21 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 18:06 UTC  Stephen Frost <sfrost@snowman.net>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 18:22 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
  2010-10-07 20:31 UTC  Robert Haas <robertmhaas@gmail.com>
  [24+ messages in thread]

Error message in wal_log for Streaming replication
  2010-10-05 09:11 UTC  Nimesh Satam <nimesh.zedo@gmail.com>
` Re: Error message in wal_log for Streaming replication
  2010-10-05 21:05 UTC  Jeff Davis <pgsql@j-davis.com>
  [2+ messages in thread]

Issue for partitioning with extra check constriants
  2010-10-01 23:46 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Issue for partitioning with extra check constriants
  2010-10-01 23:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Issue for partitioning with extra check constriants
  2010-10-01 23:57 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Issue for partitioning with extra check constriants
  2010-10-02 00:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Issue for partitioning with extra check constriants
  2010-10-04 18:34 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Issue for partitioning with extra check constriants
  2010-10-04 18:44 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Issue for partitioning with extra check constriants
  2010-10-04 23:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [7+ messages in thread]

Wrong index choice
  2010-09-29 16:55 UTC  Fabrício dos Anjos Silva <fabricio.silva@linkcom.com.br>
` Re: Wrong index choice
  2010-09-29 21:00 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Wrong index choice
  2010-10-03 21:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

turn off caching for performance test
  2010-08-26 10:32 UTC  Willy-Bas Loos <willybas@gmail.com>
` Re: turn off caching for performance test
  2010-08-26 16:50 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: turn off caching for performance test
  2010-08-26 17:37 UTC  Pierre C <lists@peufeu.com>
` Re: turn off caching for performance test
  2010-08-27 09:51 UTC  Willy-Bas Loos <willybas@gmail.com>
` Re: turn off caching for performance test
  2010-08-27 17:28 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: turn off caching for performance test
  2010-08-27 17:57 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: turn off caching for performance test
  2010-09-15 21:10 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: turn off caching for performance test
  2010-09-26 03:36 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: turn off caching for performance test
  2010-09-30 16:41 UTC  Willy-Bas Loos <willybas@gmail.com>
` Re: turn off caching for performance test
  2010-10-01 17:51 UTC  Willy-Bas Loos <willybas@gmail.com>
  [10+ messages in thread]

Memory usage - indexes
  2010-09-23 21:50 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Memory usage - indexes
  2010-09-23 22:12 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Memory usage - indexes
  2010-09-24 14:17 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Memory usage - indexes
  2010-09-24 16:23 UTC  Bob Lunney <bob_lunney@yahoo.com>
` Re: Memory usage - indexes
  2010-09-24 16:46 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Memory usage - indexes
  2010-09-24 16:52 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Memory usage - indexes
  2010-09-24 17:16 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: Memory usage - indexes
  2010-09-24 17:41 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Memory usage - indexes
  2010-09-24 17:50 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Memory usage - indexes
  2010-09-24 18:01 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Memory usage - indexes
  2010-09-24 18:05 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Memory usage - indexes
  2010-09-24 18:34 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: Memory usage - indexes
  2010-09-24 19:06 UTC  Bob Lunney <bob_lunney@yahoo.com>
` Re: Memory usage - indexes
  2010-09-24 19:24 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: Memory usage - indexes
  2010-09-24 19:58 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Memory usage - indexes
  2010-09-24 20:00 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Memory usage - indexes
  2010-09-24 20:08 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Memory usage - indexes
  2010-09-24 20:50 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Memory usage - indexes
  2010-09-24 22:00 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Memory usage - indexes
  2010-09-25 10:29 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Memory usage - indexes
  2010-09-29 06:41 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Memory usage - indexes
  2010-09-29 08:03 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Memory usage - indexes
  2010-09-29 12:09 UTC  Tobias Brox <tobixen@gmail.com>
` Re: Memory usage - indexes
  2010-09-30 21:01 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
  [24+ messages in thread]

postgresql-9.0 Windows service stops after database transaction
  2010-09-24 04:39 UTC  adrian.kitchingman@dse.vic.gov.au
` Re: postgresql-9.0 Windows service stops after database transaction
  2010-09-24 07:05 UTC  Thom Brown <thom@linux.com>
` Re: postgresql-9.0 Windows service stops after database transaction
  2010-09-26 23:18 UTC  adrian.kitchingman@dse.vic.gov.au
` Re: postgresql-9.0 Windows service stops after database transaction
  2010-09-27 00:06 UTC  adrian.kitchingman@dse.vic.gov.au
` Re: postgresql-9.0 Windows service stops after database transaction
  2010-09-28 09:11 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: postgresql-9.0 Windows service stops after database transaction
  2010-09-30 06:00 UTC  adrian.kitchingman@dse.vic.gov.au
  [6+ messages in thread]

Performance improvements/regressions from 8.4 to 9.0?
  2010-09-30 00:01 UTC  Andy <angelflow@yahoo.com>
` Re: Performance improvements/regressions from 8.4 to 9.0?
  2010-09-30 05:15 UTC  Greg Smith <greg@2ndquadrant.com>
  [2+ messages in thread]

how to enforce index sub-select over filter+seqscan
  2010-09-23 14:26 UTC  Dmitry Teslenko <dteslenko@gmail.com>
` Re: how to enforce index sub-select over filter+seqscan
  2010-09-23 15:43 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: how to enforce index sub-select over filter+seqscan
  2010-09-23 19:41 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: how to enforce index sub-select over filter+seqscan
  2010-09-27 17:30 UTC  Robert Haas <robertmhaas@gmail.com>
  [4+ messages in thread]

Memory speed testing
  2010-09-21 04:20 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: Memory speed testing
  2010-09-27 16:53 UTC  Greg Smith <greg@2ndquadrant.com>
  [2+ messages in thread]

Is disableing nested_loops a bad idea ?
  2010-09-16 08:23 UTC  Franck Routier <franck.routier@axege.com>
` Re: Is disableing nested_loops a bad idea ?
  2010-09-16 09:55 UTC  Samuel Gendler <sgendler@ideasculptor.com>
` Re: Is disableing nested_loops a bad idea ?
  2010-09-16 13:49 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Is disableing nested_loops a bad idea ?
  2010-09-16 14:13 UTC  Franck Routier <franck.routier@axege.com>
` Re: Is disableing nested_loops a bad idea ?
  2010-09-16 14:25 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Is disableing nested_loops a bad idea ?
  2010-09-26 04:02 UTC  Robert Haas <robertmhaas@gmail.com>
  [6+ messages in thread]

locking issue on simple selects?
  2010-09-15 10:05 UTC  Tobias Brox <tobixen@gmail.com>
` Re: locking issue on simple selects?
  2010-09-15 13:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: locking issue on simple selects?
  2010-09-15 19:07 UTC  Tobias Brox <tobixen@gmail.com>
` Re: locking issue on simple selects?
  2010-09-15 19:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: locking issue on simple selects?
  2010-09-15 19:28 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: locking issue on simple selects?
  2010-09-15 19:32 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: locking issue on simple selects?
  2010-09-15 21:33 UTC  Tobias Brox <tobixen@gmail.com>
` Re: locking issue on simple selects?
  2010-09-16 00:32 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: locking issue on simple selects?
  2010-09-23 20:47 UTC  Tobias Brox <tobixen@gmail.com>
` Re: locking issue on simple selects?
  2010-09-23 20:55 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: locking issue on simple selects?
  2010-09-23 22:25 UTC  Tobias Brox <tobixen@gmail.com>
` Re: locking issue on simple selects?
  2010-09-23 22:50 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [12+ messages in thread]

Using Between
  2010-08-28 00:21 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Using Between
  2010-08-28 00:41 UTC  Craig James <craig_james@emolecules.com>
` Re: Using Between
  2010-08-30 16:51 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Using Between
  2010-09-21 19:35 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Using Between
  2010-09-21 20:04 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Using Between
  2010-09-22 10:51 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Using Between
  2010-09-22 15:18 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Using Between
  2010-09-22 16:27 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Using Between
  2010-09-22 16:28 UTC  Ozer, Pam <pozer@automotive.com>
` Re: Using Between
  2010-09-23 00:51 UTC  mark <dvlhntr@gmail.com>
  [10+ messages in thread]

Performance degradation, index bloat and planner estimates
  2010-09-20 11:59 UTC  Daniele Varrazzo <daniele.varrazzo@gmail.com>
` Re: Performance degradation, index bloat and planner estimates
  2010-09-22 04:09 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: Performance degradation, index bloat and planner estimates
  2010-09-22 04:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

slow DDL creation
  2010-08-30 22:28 UTC  Kevin Kempter <cs_dba@consistentstate.com>
` Re: slow DDL creation
  2010-08-30 23:04 UTC  bricklen <bricklen@gmail.com>
` Re: slow DDL creation
  2010-08-31 00:31 UTC  David Fetter <david@fetter.org>
` Re: slow DDL creation
  2010-08-31 15:35 UTC  Kevin Kempter <cs_dba@consistentstate.com>
` Re: slow DDL creation
  2010-09-21 19:38 UTC  Robert Haas <robertmhaas@gmail.com>
  [5+ messages in thread]

GPU Accelerated Sorting
  2010-08-30 13:46 UTC  Eliot Gable <egable@gmail.com>
` GPU Accelerated Sorting
  2010-08-30 13:51 UTC  Eliot Gable <egable+pgsql-performance@gmail.com>
` Re: GPU Accelerated Sorting
  2010-08-30 14:05 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: GPU Accelerated Sorting
  2010-08-30 14:56 UTC  Gaël Le Mignot <gael@pilotsystems.net>
` Re: GPU Accelerated Sorting
  2010-08-30 18:49 UTC  Eliot Gable <egable+pgsql-performance@gmail.com>
` Re: GPU Accelerated Sorting
  2010-08-30 19:25 UTC  Yeb Havinga <yebhavinga@gmail.com>
` Re: GPU Accelerated Sorting
  2010-08-30 20:43 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: GPU Accelerated Sorting
  2010-08-30 20:47 UTC  David Boreham <david_list@boreham.org>
` Re: GPU Accelerated Sorting
  2010-08-30 21:18 UTC  Chris Browne <cbbrowne@acm.org>
` Re: GPU Accelerated Sorting
  2010-08-30 22:01 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: GPU Accelerated Sorting
  2010-08-30 22:37 UTC  David Boreham <david_list@boreham.org>
` Re: GPU Accelerated Sorting
  2010-08-31 01:17 UTC  Scott Carey <scott@richrelevance.com>
` Re: GPU Accelerated Sorting
  2010-08-31 01:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: GPU Accelerated Sorting
  2010-09-21 19:27 UTC  Robert Haas <robertmhaas@gmail.com>
  [14+ messages in thread]

3ware trivia overload
  2010-09-18 07:50 UTC  Greg Smith <greg@2ndquadrant.com>
` Re: 3ware trivia overload
  2010-09-20 21:54 UTC  George Sexton <georges@mhsoftware.com>
` Re: 3ware trivia overload
  2010-09-20 22:09 UTC  David Rees <drees76@gmail.com>
  [3+ messages in thread]

cleanup on pg_ system tables?
  2010-09-20 17:25 UTC  mark <dvlhntr@gmail.com>
` Re: cleanup on pg_ system tables?
  2010-09-20 19:24 UTC  Josh Kupershmidt <schmiddy@gmail.com>
  [2+ messages in thread]

Need PostgreSQL data warehousing user, on the record
  2010-09-20 18:47 UTC  Josh Berkus <josh@agliodbs.com>

Where does data in pg_stat_user_tables come from?
  2010-09-13 23:06 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-13 23:41 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-13 23:47 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-14 00:12 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-14 00:53 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-14 01:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-14 03:57 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-16 18:39 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-16 19:02 UTC  Guillaume Lelarge <guillaume@lelarge.info>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-16 19:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Where does data in pg_stat_user_tables come from?
  2010-09-16 19:34 UTC  Josh Berkus <josh@agliodbs.com>
  [11+ messages in thread]

Performance problem with joined aggregate query
  2010-09-15 06:26 UTC  Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Performance problem with joined aggregate query
  2010-09-15 22:25 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Performance problem with joined aggregate query
  2010-09-16 05:51 UTC  Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Performance problem with joined aggregate query
  2010-09-16 14:52 UTC  Merlin Moncure <mmoncure@gmail.com>
  [4+ messages in thread]

POSTGRES error
  2010-09-15 11:07 UTC  Timothy.Noonan@emc.com
` Re: POSTGRES error
  2010-09-15 13:38 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [2+ messages in thread]

Held idle connections vs use of a Pooler
  2010-09-14 16:10 UTC  mark <dvlhntr@gmail.com>
` Re: Held idle connections vs use of a Pooler
  2010-09-14 16:44 UTC  Craig James <craig_james@emolecules.com>
` Re: Held idle connections vs use of a Pooler
  2010-09-14 16:58 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Held idle connections vs use of a Pooler
  2010-09-14 17:01 UTC  Merlin Moncure <mmoncure@gmail.com>
  [4+ messages in thread]

Problem with mergejoin performance
  2010-09-13 05:49 UTC  azajac@ang.com.pl
` Re: Problem with mergejoin performance
  2010-09-13 14:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problem with mergejoin performance
  2010-09-13 15:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [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