pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedClustered/covering indexes (or lack thereof :-)
2007-11-12 06:59 UTC adrobj <adrobj@yahoo.com>
` Re: Clustered/covering indexes (or lack thereof :-)
2007-11-16 19:33 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Clustered/covering indexes (or lack thereof :-)
2007-11-16 19:34 UTC Jeff Davis <pgsql@j-davis.com>
` Re: Clustered/covering indexes (or lack thereof :-)
2007-11-16 19:51 UTC Bill Moran <wmoran@collaborativefusion.com>
[4+ messages in thread]
8.3beta1 testing on Solaris
2007-10-25 20:24 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-25 20:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.3beta1 testing on Solaris
2007-10-25 22:37 UTC Gregory Stark <stark@enterprisedb.com>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-25 22:43 UTC Gregory Stark <stark@enterprisedb.com>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-26 00:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-26 02:56 UTC Josh Berkus <josh@agliodbs.com>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-26 03:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-26 08:07 UTC Gregory Stark <stark@enterprisedb.com>
` Re: 8.3beta1 testing on Solaris
2007-10-26 13:20 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-26 13:25 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-26 13:36 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-26 15:45 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-26 16:46 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-26 19:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-10-26 21:45 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: [HACKERS] 8.3beta1 testing on Solaris
2007-11-15 20:49 UTC Bruce Momjian <bruce@momjian.us>
[16+ messages in thread]
dell versus hp
2007-11-06 10:12 UTC Tore Halset <halset@pvv.ntnu.no>
` Re: dell versus hp
2007-11-06 11:36 UTC Claus Guttesen <kometen@gmail.com>
` Re: dell versus hp
2007-11-06 11:53 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: dell versus hp
2007-11-06 13:48 UTC Stephen Frost <sfrost@snowman.net>
` Re: dell versus hp
2007-11-06 14:14 UTC Tore Halset <halset@pvv.ntnu.no>
` Re: dell versus hp
2007-11-06 14:15 UTC Tore Halset <halset@pvv.ntnu.no>
` Re: dell versus hp
2007-11-06 15:18 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: dell versus hp
2007-11-06 18:10 UTC Greg Smith <gsmith@gregsmith.com>
` Re: dell versus hp
2007-11-08 16:41 UTC Vivek Khera <vivek@khera.org>
` Re: dell versus hp
2007-11-08 16:43 UTC Vivek Khera <khera@kcilink.com>
` Re: dell versus hp
2007-11-08 18:22 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: dell versus hp
2007-11-08 20:14 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: dell versus hp
2007-11-08 20:31 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: dell versus hp
2007-11-08 20:56 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: dell versus hp
2007-11-08 22:01 UTC Vivek Khera <vivek@khera.org>
` Re: dell versus hp
2007-11-08 23:24 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: dell versus hp
2007-11-09 11:30 UTC Florian Weimer <fweimer@bfk.de>
` Re: dell versus hp
2007-11-09 16:01 UTC Jurgen Haan <jurgen@easyflex.nl>
` Re: dell versus hp
2007-11-09 16:40 UTC Claus Guttesen <kometen@gmail.com>
` Re: dell versus hp
2007-11-09 16:55 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: dell versus hp
2007-11-09 18:03 UTC Greg Smith <gsmith@gregsmith.com>
` Re: dell versus hp
2007-11-09 19:08 UTC Vivek Khera <khera@kcilink.com>
` Re: dell versus hp
2007-11-13 15:49 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: dell versus hp
2007-11-13 20:32 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: dell versus hp
2007-11-14 03:20 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: dell versus hp
2007-11-14 22:24 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: dell versus hp
2007-11-14 22:36 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: dell versus hp
2007-11-14 22:39 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: dell versus hp
2007-11-15 01:56 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: dell versus hp
2007-11-15 02:19 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: dell versus hp
2007-11-15 14:41 UTC Jeff Trout <threshar@torgo.978.org>
` Re: dell versus hp
2007-11-15 20:28 UTC Vivek Khera <vivek@khera.org>
[32+ messages in thread]
ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table
2007-11-12 19:57 UTC Stephane Bailliez <sbailliez@gmail.com>
` Re: ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table
2007-11-12 22:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table
2007-11-13 15:06 UTC Stephane Bailliez <sbailliez@gmail.com>
[3+ messages in thread]
random_page_cost etc. per tablespace?
2007-11-13 10:24 UTC Jens-Wolfhard Schicke <drahflow@gmx.de>
Need to run CLUSTER to keep performance
2007-11-08 10:36 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Need to run CLUSTER to keep performance
2007-11-08 11:12 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Need to run CLUSTER to keep performance
2007-11-08 11:20 UTC Tomáš Vondra <tv@fuzzy.cz>
` Re: Need to run CLUSTER to keep performance
2007-11-08 14:49 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Need to run CLUSTER to keep performance
2007-11-08 14:56 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Need to run CLUSTER to keep performance
2007-11-08 15:09 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Need to run CLUSTER to keep performance
2007-11-08 15:10 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Need to run CLUSTER to keep performance
2007-11-08 15:15 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Need to run CLUSTER to keep performance
2007-11-08 15:17 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Need to run CLUSTER to keep performance
2007-11-08 15:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Need to run CLUSTER to keep performance
2007-11-08 15:47 UTC Chris Browne <cbbrowne@acm.org>
` Re: Need to run CLUSTER to keep performance
2007-11-12 15:38 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Need to run CLUSTER to keep performance
2007-11-12 16:11 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Need to run CLUSTER to keep performance
2007-11-12 16:31 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Need to run CLUSTER to keep performance
2007-11-12 16:35 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Need to run CLUSTER to keep performance
2007-11-12 16:37 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Need to run CLUSTER to keep performance
2007-11-12 17:01 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Need to run CLUSTER to keep performance
2007-11-12 17:04 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Need to run CLUSTER to keep performance
2007-11-12 18:03 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Need to run CLUSTER to keep performance
2007-11-13 08:49 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Need to run CLUSTER to keep performance
2007-11-13 09:03 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
[21+ messages in thread]
difference between a unique constraint and a unique index ???
2007-11-12 14:51 UTC Dave Cramer <pg@fastcrypt.com>
` Re: difference between a unique constraint and a unique index ???
2007-11-12 14:56 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: difference between a unique constraint and a unique index ???
2007-11-12 15:13 UTC Dave Cramer <pg@fastcrypt.com>
` Re: difference between a unique constraint and a unique index ???
2007-11-12 16:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: difference between a unique constraint and a unique index ???
2007-11-12 18:32 UTC Dave Cramer <pg@fastcrypt.com>
[5+ messages in thread]
Join performance
2004-07-28 16:53 UTC Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Join performance
2007-11-08 22:47 UTC Pepe Barbe <elventear@gmail.com>
` Re: Join performance
2007-11-08 22:51 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Join performance
2007-11-09 00:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Join performance
2007-11-09 00:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Join performance
2007-11-09 00:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Join performance
2007-11-10 05:26 UTC Russell Smith <mr-russ@pws.com.au>
[7+ messages in thread]
Can I Determine if AutoVacuum Does Anything?
2007-11-09 21:44 UTC David Crane <davidc@donorschoose.org>
` Re: Can I Determine if AutoVacuum Does Anything?
2007-11-09 21:49 UTC Alvaro Herrera <alvherre@commandprompt.com>
[2+ messages in thread]
Estimation problem with a LIKE clause containing a /
2007-11-07 12:53 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-07 13:25 UTC Alexander Staubo <alex@purefiction.net>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-07 13:38 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-07 16:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-07 16:52 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-07 16:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-07 23:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-07 23:32 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-07 23:36 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-08 10:08 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-08 15:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-08 15:29 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-08 17:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-08 23:10 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Estimation problem with a LIKE clause containing a /
2007-11-09 00:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] Estimation problem with a LIKE clause containing a /
2007-11-09 02:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] Estimation problem with a LIKE clause containing a /
2007-11-09 07:52 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: [HACKERS] Estimation problem with a LIKE clause containing a /
2007-11-09 09:21 UTC Gregory Stark <stark@enterprisedb.com>
` Re: [HACKERS] Estimation problem with a LIKE clause containing a /
2007-11-09 16:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] Estimation problem with a LIKE clause containing a /
2007-11-09 16:39 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: [HACKERS] Estimation problem with a LIKE clause containing a /
2007-11-09 20:57 UTC Guillaume Smet <guillaume.smet@gmail.com>
[21+ messages in thread]
Help understanding stat numbers
2007-11-08 14:49 UTC Chris Hoover <revoohc@gmail.com>
` Re: Help understanding stat numbers
2007-11-09 07:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Hardware for PostgreSQL
2007-10-31 16:45 UTC Ketema <ketema@gmail.com>
` Re: Hardware for PostgreSQL
2007-10-31 19:15 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Hardware for PostgreSQL
2007-10-31 19:27 UTC Magnus Hagander <magnus@hagander.net>
` Re: Hardware for PostgreSQL
2007-10-31 21:54 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Hardware for PostgreSQL
2007-10-31 21:58 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hardware for PostgreSQL
2007-10-31 23:03 UTC Ericson Smith <esconsult1@gmail.com>
` Re: Hardware for PostgreSQL
2007-11-01 03:53 UTC Ow Mun Heng <Ow.Mun.Heng@wdc.com>
` Re: Hardware for PostgreSQL
2007-11-01 06:52 UTC Magnus Hagander <magnus@hagander.net>
` Re: Hardware for PostgreSQL
2007-11-01 06:54 UTC Magnus Hagander <magnus@hagander.net>
` Re: Hardware for PostgreSQL
2007-11-01 07:46 UTC Ow Mun Heng <Ow.Mun.Heng@wdc.com>
` Re: Hardware for PostgreSQL
2007-11-01 07:52 UTC Magnus Hagander <magnus@hagander.net>
` Re: Hardware for PostgreSQL
2007-11-01 12:56 UTC Adam Tauno Williams <adamtaunowilliams@gmail.com>
` Re: Hardware for PostgreSQL
2007-11-01 16:20 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Hardware for PostgreSQL
2007-11-01 18:16 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Hardware for PostgreSQL
2007-11-02 00:26 UTC Ow Mun Heng <Ow.Mun.Heng@wdc.com>
` hardware for PostgreSQL
2007-11-02 01:15 UTC Mark Floyd <mfloyd@evryx.com>
` Re: hardware for PostgreSQL
2007-11-02 03:31 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Hardware for PostgreSQL
2007-11-02 14:05 UTC Jurgen Haan <jurgen@easyflex.nl>
` Re: Hardware for PostgreSQL
2007-11-08 17:14 UTC Robert Treat <xzilla@users.sourceforge.net>
[19+ messages in thread]
hp ciss on freebsd
2007-11-05 13:19 UTC Claus Guttesen <kometen@gmail.com>
` Re: hp ciss on freebsd
2007-11-05 15:47 UTC Jeff Trout <threshar@torgo.978.org>
` Re: hp ciss on freebsd
2007-11-05 16:32 UTC Greg Smith <gsmith@gregsmith.com>
` Re: hp ciss on freebsd
2007-11-08 16:37 UTC Vivek Khera <khera@kcilink.com>
[4+ messages in thread]
index stat
2007-11-05 16:42 UTC Campbell, Lance <lance@uiuc.edu>
` Re: index stat
2007-11-07 16:32 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[2+ messages in thread]
Subpar Execution Plan
2007-11-06 20:48 UTC Jens-Wolfhard Schicke <drahflow@gmx.de>
Is ANALYZE transactional?
2007-11-06 05:12 UTC Craig James <craig_james@emolecules.com>
` Re: Is ANALYZE transactional?
2007-11-06 05:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Database connections and stored procs (functions)
2007-11-05 15:32 UTC Radhika S <radhika.sambamurti@gmail.com>
` Re: Database connections and stored procs (functions)
2007-11-06 02:47 UTC Merlin Moncure <mmoncure@gmail.com>
[2+ messages in thread]
Which index methodology is better?-
2007-11-05 18:43 UTC Chris Hoover <revoohc@gmail.com>
` Re: Which index methodology is better?-
2007-11-05 19:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Which index methodology is better?-
2007-11-05 20:07 UTC Heikki Linnakangas <heikki@enterprisedb.com>
[3+ messages in thread]
Migrating to 8.3 - checkpoints and background writer
2007-11-05 00:33 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Migrating to 8.3 - checkpoints and background writer
2007-11-05 00:39 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Migrating to 8.3 - checkpoints and background writer
2007-11-05 03:06 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Migrating to 8.3 - checkpoints and background writer
2007-11-05 16:54 UTC Erik Jones <erik@myemma.com>
[4+ messages in thread]
Postgresql.conf Settings
2007-11-04 16:28 UTC smiley2211 <smiley2211@yahoo.com>
` Re: Postgresql.conf Settings
2007-11-04 17:37 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgresql.conf Settings
2007-11-04 18:30 UTC smiley2211 <smiley2211@yahoo.com>
` Re: Postgresql.conf Settings
2007-11-04 19:30 UTC Heikki Linnakangas <heikki@enterprisedb.com>
[4+ messages in thread]
Unfortunate expansion of composite types in union
2007-11-02 09:38 UTC Jens-Wolfhard Schicke <drahflow@gmx.de>
` Re: Unfortunate expansion of composite types in union
2007-11-02 10:32 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Unfortunate expansion of composite types in union
2007-11-04 16:59 UTC Jens-Wolfhard Schicke <drahflow@gmx.de>
[3+ messages in thread]
Union within View vs.Union of Views
2007-11-03 20:22 UTC Jeff Larsen <jlar310@gmail.com>
` Re: Union within View vs.Union of Views
2007-11-03 21:39 UTC Mark Mielke <mark@mark.mielke.cc>
` Re: Union within View vs.Union of Views
2007-11-03 23:03 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Union within View vs.Union of Views
2007-11-04 01:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Union within View vs.Union of Views
2007-11-04 01:57 UTC Jeff Larsen <jlar310@gmail.com>
` Re: Union within View vs.Union of Views
2007-11-04 10:11 UTC Jeff Larsen <jlar310@gmail.com>
[6+ messages in thread]
"MixedCase sensitive quoted" names
2007-11-03 23:40 UTC Whatever Deep <whatever.deep@gmail.com>
` Re: "MixedCase sensitive quoted" names
2007-11-04 01:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Re: Hardware for PostgreSQL (RAID configurations)
2007-11-02 21:23 UTC Mark F <enigma_3319@hotmail.com>
Re: [Fwd: Re: Outer joins and Seq scans]
2007-11-02 18:45 UTC Alvaro Herrera <alvherre@commandprompt.com>
[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