pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feednested query on last n rows of huge table
2006-02-24 14:13 UTC jcfischer <jcfischer.lists@gmail.com>
` Re: nested query on last n rows of huge table
2006-02-24 14:26 UTC jcfischer <jcfischer.lists@gmail.com>
` Re: nested query on last n rows of huge table
2006-03-01 03:44 UTC Michael Glaesemann <grzm@myrealbox.com>
[3+ messages in thread]
fsync and battery-backed caches
2006-02-27 10:03 UTC Javier Somoza <jsomoza@pandasoftware.es>
` Re: fsync and battery-backed caches
2006-02-27 10:12 UTC Tino Wildenhain <tino@wildenhain.de>
` Re: fsync and battery-backed caches
2006-02-28 00:22 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: fsync and battery-backed caches
2006-02-28 01:06 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: fsync and battery-backed caches
2006-02-28 08:19 UTC Javier Somoza <jsomoza@pandasoftware.es>
` Re: fsync and battery-backed caches
2006-02-28 17:23 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: fsync and battery-backed caches
2006-02-28 17:27 UTC Javier Somoza <jsomoza@pandasoftware.es>
` Re: fsync and battery-backed caches
2006-02-28 21:09 UTC Jim C. Nasby <jnasby@pervasive.com>
[8+ messages in thread]
Different disks for xlogs and data
2006-02-28 09:45 UTC Javier Somoza <jsomoza@pandasoftware.es>
` Re: Different disks for xlogs and data
2006-02-28 13:40 UTC Ron <rjpeace@earthlink.net>
[2+ messages in thread]
vacuum, analyze and reindex
2006-02-28 12:11 UTC Javier Somoza <jsomoza@pandasoftware.es>
` Re: vacuum, analyze and reindex
2006-02-28 13:34 UTC Christopher Browne <cbbrowne@acm.org>
[2+ messages in thread]
Re: rotate records
2006-02-28 03:44 UTC Jeevanandam, Kathirvel (IE10) <Jeevanandam.Kathirvel@honeywell.com>
` Re: rotate records
2006-02-28 05:08 UTC Bruno Wolff III <bruno@wolff.to>
[2+ messages in thread]
triggers, performance Was: Re: rotate records
2006-02-28 05:04 UTC Tino Wildenhain <tino@wildenhain.de>
The trigger can be specified to fire on time condition?
2006-02-27 17:09 UTC Jamal Ghaffour <Jamal.Ghaffour@elios-informatique.fr>
` Re: The trigger can be specified to fire on time condition?
2006-02-27 17:10 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: The trigger can be specified to fire on time condition?
2006-02-27 17:30 UTC Chris Browne <cbbrowne@acm.org>
[3+ messages in thread]
neverending vacuum
2006-02-27 13:31 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: neverending vacuum
2006-02-27 14:31 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: neverending vacuum
2006-02-27 15:03 UTC Csaba Nagy <nagy@ecircle-ag.com>
[3+ messages in thread]
Setting the shared buffers
2006-02-27 12:43 UTC Javier Somoza <jsomoza@pandasoftware.es>
` Re: Setting the shared buffers
2006-02-27 13:17 UTC Claus Guttesen <kometen@gmail.com>
[2+ messages in thread]
Schema vs Independant Databases, ACLS,Overhead,pg_hba.conf
2006-02-24 20:03 UTC Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: Schema vs Independant Databases, ACLS,Overhead,pg_hba.conf
2006-02-25 16:03 UTC Alvaro Herrera <alvherre@commandprompt.com>
[2+ messages in thread]
Reliability recommendations
2006-02-15 16:21 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Reliability recommendations
2006-02-15 17:19 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Reliability recommendations
2006-02-15 17:32 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Reliability recommendations
2006-02-15 18:05 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Reliability recommendations
2006-02-15 18:17 UTC Greg Stark <gsstark@mit.edu>
` Re: Reliability recommendations
2006-02-15 18:44 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Reliability recommendations
2006-02-15 19:11 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Reliability recommendations
2006-02-15 19:53 UTC Ron <rjpeace@earthlink.net>
` Re: Reliability recommendations
2006-02-15 20:57 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Reliability recommendations
2006-02-15 21:20 UTC Josh Rovero <rovero@sonalysts.com>
` Re: Reliability recommendations
2006-02-24 14:29 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Reliability recommendations
2006-02-24 15:04 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Reliability recommendations
2006-02-24 15:14 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Reliability recommendations
2006-02-24 15:41 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Reliability recommendations
2006-02-24 16:27 UTC Vivek Khera <vivek@khera.org>
` Re: Reliability recommendations
2006-02-24 16:32 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Reliability recommendations
2006-02-24 16:40 UTC Vivek Khera <vivek@khera.org>
` Re: Reliability recommendations
2006-02-24 16:51 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Reliability recommendations
2006-02-24 17:19 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Reliability recommendations
2006-02-24 23:12 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Reliability recommendations
2006-02-24 23:59 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Reliability recommendations
2006-02-25 00:06 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Reliability recommendations
2006-02-25 00:18 UTC Philippe Marzin <philippe.marzin@free.fr>
` Re: Reliability recommendations
2006-02-25 00:29 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Reliability recommendations
2006-02-25 00:47 UTC Dan Gorman <dgorman@hi5.com>
` Re: Reliability recommendations
2006-02-25 01:18 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Reliability recommendations
2006-02-25 04:41 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Reliability recommendations
2006-02-25 06:10 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Reliability recommendations
2006-02-25 06:22 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Reliability recommendations
2006-02-25 06:28 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Reliability recommendations
2006-02-25 11:24 UTC Ron <rjpeace@earthlink.net>
` Re: Reliability recommendations
2006-02-25 11:56 UTC Ron <rjpeace@earthlink.net>
` Re: Reliability recommendations
2006-02-25 15:49 UTC Luke Lonergan <llonergan@greenplum.com>
[33+ messages in thread]
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]
[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