pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Creating a correct and real benchmark
  2006-02-20 10:50 UTC  Marcos <mjs_ops@gmx.net>
` Re: Creating a correct and real benchmark
  2006-02-21 00:14 UTC  PFC <lists@peufeu.com>
` Re: Creating a correct and real benchmark
  2006-02-21 00:21 UTC  Chris <dmagick@gmail.com>
` Re: Creating a correct and real benchmark
  2006-02-24 17:06 UTC  Marcos <mjs_ops@gmx.net>
  [4+ messages in thread]

Really really slow query. What's a better way?
  2006-02-24 06:54 UTC  Brendan Duddridge <brendan@clickspace.com>
` Re: Really really slow query. What's a better way?
  2006-02-24 07:06 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Really really slow query. What's a better way?
  2006-02-24 07:24 UTC  Brendan Duddridge <brendan@clickspace.com>
  [3+ messages in thread]

0ut of Memory Error during Vacuum Analyze
  2006-02-14 16:45 UTC  Tomeh, Husam <htomeh@firstam.com>
` Re: 0ut of Memory Error during Vacuum Analyze
  2006-02-14 17:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 0ut of Memory Error during Vacuum Analyze and
  2006-02-14 22:01 UTC  Tomeh, Husam <htomeh@firstam.com>
` Re: 0ut of Memory Error during Vacuum Analyze and Create Index
  2006-02-14 22:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 0ut of Memory Error during Vacuum Analyze and
  2006-02-14 23:40 UTC  Tomeh, Husam <htomeh@firstam.com>
` Re: 0ut of Memory Error during Vacuum Analyze and Create Index
  2006-02-14 23:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 0ut of Memory Error during Vacuum Analyze and
  2006-02-23 19:57 UTC  Tomeh, Husam <htomeh@firstam.com>
` Re: 0ut of Memory Error during Vacuum Analyze and
  2006-02-23 22:42 UTC  Tomeh, Husam <htomeh@firstam.com>
` Re: 0ut of Memory Error during Vacuum Analyze and
  2006-02-23 22:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [9+ messages in thread]

Good News re count(*) in 8.1
  2006-02-22 16:57 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Good News re count(*) in 8.1
  2006-02-22 17:11 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: Good News re count(*) in 8.1
  2006-02-22 17:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Good News re count(*) in 8.1
  2006-02-23 03:52 UTC  Greg Stark <gsstark@mit.edu>
` Re: Good News re count(*) in 8.1
  2006-02-23 18:54 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Good News re count(*) in 8.1
  2006-02-23 20:25 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [6+ messages in thread]

how to interpret/improve bad row estimates
  2006-02-23 16:29 UTC  Robert Treat <xzilla@users.sourceforge.net>

Created Index is not used
  2006-02-23 12:35 UTC  Kjeld Peters <kjeld.peters@profiling-company.de>
` Re: Created Index is not used
  2006-02-23 12:46 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: Created Index is not used
  2006-02-23 13:03 UTC  Ragnar <gnari@hive.is>
` Re: Created Index is not used
  2006-02-23 14:09 UTC  Kjeld Peters <kjeld.peters@profiling-company.de>
  [4+ messages in thread]

LIKE query on indexes
  2006-02-21 15:57 UTC  Ibrahim Tekin <itekin@gmail.com>
` Re: LIKE query on indexes
  2006-02-21 16:18 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: LIKE query on indexes
  2006-02-21 16:34 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: LIKE query on indexes
  2006-02-21 16:42 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: LIKE query on indexes
  2006-02-21 17:40 UTC  mark@mark.mielke.cc
` Re: LIKE query on indexes
  2006-02-21 20:12 UTC  Ibrahim Tekin <itekin@gmail.com>
` Re: LIKE query on indexes
  2006-02-21 20:28 UTC  Ibrahim Tekin <itekin@gmail.com>
` Re: LIKE query on indexes
  2006-02-22 15:48 UTC  Brendan Duddridge <brendan@clickspace.com>
` Re: LIKE query on indexes
  2006-02-23 12:52 UTC  Ibrahim Tekin <itekin@gmail.com>
  [9+ messages in thread]

Joins and full index scans...mysql vs postgres?
  2006-02-22 17:26 UTC  ryan groth <postgres@cpusoftware.com>
` Re: Joins and full index scans...mysql vs postgres?
  2006-02-22 17:52 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Joins and full index scans...mysql vs postgres?
  2006-02-22 18:11 UTC  ryan groth <postgres@cpusoftware.com>
` Re: Joins and full index scans...mysql vs postgres?
  2006-02-22 18:21 UTC  ryan groth <postgres@cpusoftware.com>
` Re: Joins and full index scans...mysql vs postgres?
  2006-02-22 18:28 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Joins and full index scans...mysql vs postgres?
  2006-02-22 18:52 UTC  ryan groth <postgres@cpusoftware.com>
` Re: Joins and full index scans...mysql vs postgres?
  2006-02-22 19:13 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Joins and full index scans...mysql vs postgres?
  2006-02-22 23:18 UTC  PFC <lists@peufeu.com>
` Re: Joins and full index scans...mysql vs postgres?
  2006-02-22 23:58 UTC  Chris <dmagick@gmail.com>
` Re: Joins and full index scans...mysql vs postgres?
  2006-02-23 02:52 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Joins and full index scans...mysql vs postgres?
  2006-02-23 10:21 UTC  Andreas Pflug <pgadmin@pse-consulting.de>
  [11+ messages in thread]

Large Database Design Help
  2006-02-09 19:07 UTC  Orion Henry <lab@orangekids.org>
` Re: Large Database Design Help
  2006-02-09 19:45 UTC  Greg Stark <gsstark@mit.edu>
` Re: Large Database Design Help
  2006-02-09 19:45 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Large Database Design Help
  2006-02-09 21:49 UTC  Matthew Nuzum <mattnuzum@gmail.com>
` Re: Large Database Design Help
  2006-02-10 10:04 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: Large Database Design Help
  2006-02-10 10:24 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: Large Database Design Help
  2006-02-10 19:48 UTC  PFC <lists@peufeu.com>
` Re: Large Database Design Help
  2006-02-10 22:39 UTC  Ragnar <gnari@hive.is>
` Re: Large Database Design Help
  2006-02-10 22:42 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Large Database Design Help
  2006-02-22 22:07 UTC  Orion <lab@orangekids.org>
  [10+ messages in thread]

Help with nested loop left join performance
  2006-02-21 20:12 UTC  George Woodring <george.woodring@iglass.net>
` Re: Help with nested loop left join performance
  2006-02-22 09:38 UTC  Richard Huxton <dev@archonet.com>
` Re: Help with nested loop left join performance
  2006-02-22 15:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

How to optimize a JOIN with BETWEEN?
  2006-02-20 04:06 UTC  andrew@pillette.com
` Re: How to optimize a JOIN with BETWEEN?
  2006-02-22 00:14 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [2+ messages in thread]

Cost Issue - How do I force a Hash Join
  2006-02-21 05:13 UTC  Virag Saksena <virag@auptyma.com>
` Re: Cost Issue - How do I force a Hash Join
  2006-02-21 05:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cost Issue - How do I force a Hash Join
  2006-02-21 05:54 UTC  Craig A. James <cjames@modgraph-usa.com>
` Re: Cost Issue - How do I force a Hash Join
  2006-02-21 06:33 UTC  Virag Saksena <virag@auptyma.com>
  [4+ messages in thread]

Force another plan.
  2006-02-18 16:04 UTC  Fredrik Olsson <fredrik.olsson@treyst.se>
` Re: Force another plan.
  2006-02-18 18:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Force another plan.
  2006-02-19 12:38 UTC  Fredrik Olsson <fredrik.olsson@treyst.se>
` Re: Force another plan.
  2006-02-19 17:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Force another plan.
  2006-02-20 09:58 UTC  Fredrik Olsson <fredrik.olsson@treyst.se>
` Re: Force another plan.
  2006-02-20 15:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

Avoiding cartesian product
  2006-01-04 04:12 UTC  Virag Saksena <virag@auptyma.com>
` Re: Avoiding cartesian product
  2006-01-09 15:59 UTC  Szűcs Gábor <surrano@gmail.com>
` Re: Avoiding cartesian product
  2006-02-20 06:42 UTC  Virag Saksena <virag@auptyma.com>
  [3+ messages in thread]

Need pointers to "standard" pg database(s) for testing
  2006-02-17 16:51 UTC  Ron <rjpeace@earthlink.net>
` Re: [PERFORM] Need pointers to "standard" pg database(s) for
  2006-02-17 16:56 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Need pointers to "standard" pg database(s) for testing
  2006-02-17 17:09 UTC  Michael Paesold <mpaesold@gmx.at>
` Re: [PERFORM] Need pointers to "standard" pg database(s) for testing
  2006-02-20 02:02 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [PERFORM] Need pointers to "standard" pg database(s) for
  2006-02-20 04:47 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [5+ messages in thread]

Question about query planner
  2006-02-19 13:58 UTC  Emil Briggs <emil@baymountain.com>
` Re: Question about query planner
  2006-02-19 18:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Index Choice Problem
  2006-02-16 17:03 UTC  Adam Alkins <adam.alkins@gmail.com>
` Re: Index Choice Problem
  2006-02-18 05:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index Choice Problem
  2006-02-18 07:29 UTC  Adam Alkins <adam.alkins@gmail.com>
` Re: Index Choice Problem
  2006-02-18 07:39 UTC  Adam Alkins <adam.alkins@gmail.com>
  [4+ messages in thread]

Measuring Lock Performance
  2006-02-17 20:26 UTC  Lane Van Ingen <lvaningen@esncc.com>

split partitioned table across several postgres servers
  2006-02-17 08:12 UTC  martial.bizel@free.fr
` Re: split partitioned table across several postgres servers
  2006-02-17 14:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: split partitioned table across several postgres servers
  2006-02-17 15:18 UTC  martial.bizel@free.fr
  [3+ messages in thread]

Re: [HACKERS] qsort again (was Re: Strange Create
  2006-02-17 09:24 UTC  Ragnar <gnari@hive.is>
` Re: [HACKERS] qsort again (was Re: Strange Create
  2006-02-17 10:55 UTC  PFC <lists@peufeu.com>
  [2+ messages in thread]

Re: [HACKERS] qsort again (was Re: Strange Create Index
  2006-02-16 11:06 UTC  Gary Doades <gpd@gpdnet.co.uk>
` Re: qsort again (was Re: Strange Create Index
  2006-02-16 11:35 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: [HACKERS] qsort again (was Re: Strange Create Index
  2006-02-16 15:42 UTC  Gary Doades <gpd@gpdnet.co.uk>
` Re: [HACKERS] qsort again (was Re: Strange Create Index
  2006-02-16 23:05 UTC  PFC <lists@peufeu.com>
` Re: [HACKERS] qsort again (was Re: Strange Create Index
  2006-02-17 00:18 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: [HACKERS] qsort again (was Re: Strange Create Index
  2006-02-17 02:02 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
  [6+ messages in thread]

Why does not perform index combination
  2006-02-16 16:56 UTC  Adnan DURSUN <a_dursun@hotmail.com>
` Re: Why does not perform index combination
  2006-02-16 17:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why does not perform index combination
  2006-02-16 22:14 UTC  Adnan DURSUN <a_dursun@hotmail.com>
  [3+ messages in thread]

Future of Table Partitioning
  2006-02-16 17:03 UTC  Patrick Carriere <patrick.carriere@nexustelecom.com>

Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour)
  2006-02-16 14:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>

Re: qsort again
  2006-02-16 12:10 UTC  Florian Weimer <fw@deneb.enyo.de>
` Re: qsort again
  2006-02-16 12:49 UTC  Martijn van Oosterhout <kleptog@svana.org>
` Re: [PERFORM] qsort again
  2006-02-16 13:08 UTC  Sven Geisler <sgeisler@aeccom.com>
` Re: [PERFORM] qsort again
  2006-02-16 13:38 UTC  Ron <rjpeace@earthlink.net>
  [4+ 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