pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAllow sorts to use more available memory
2011-09-12 17:33 UTC Robert Schnabel <schnabelr@missouri.edu>
` Re: Allow sorts to use more available memory
2011-09-12 17:47 UTC Andy Colson <andy@squeakycode.net>
` Re: Allow sorts to use more available memory
2011-09-12 17:57 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Allow sorts to use more available memory
2011-09-12 18:02 UTC Andy Colson <andy@squeakycode.net>
` Re: Allow sorts to use more available memory
2011-09-12 18:22 UTC Robert Schnabel <schnabelr@missouri.edu>
` Re: Allow sorts to use more available memory
2011-09-12 18:38 UTC Andy Colson <andy@squeakycode.net>
` Re: Allow sorts to use more available memory
2011-09-12 18:57 UTC Andy Colson <andy@squeakycode.net>
` Re: Allow sorts to use more available memory
2011-09-12 19:12 UTC pasman pasmański <pasman.p@gmail.com>
` Re: Allow sorts to use more available memory
2011-09-12 20:58 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Allow sorts to use more available memory
2011-09-12 22:09 UTC Robert Schnabel <schnabelr@missouri.edu>
` Re: Allow sorts to use more available memory
2011-09-12 22:21 UTC Robert Schnabel <schnabelr@missouri.edu>
` Re: Allow sorts to use more available memory
2011-09-12 23:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Allow sorts to use more available memory
2011-09-13 01:13 UTC Stephen Frost <sfrost@snowman.net>
` Re: Allow sorts to use more available memory
2011-09-13 01:15 UTC Stephen Frost <sfrost@snowman.net>
` Re: Allow sorts to use more available memory
2011-10-05 21:54 UTC Bruce Momjian <bruce@momjian.us>
[15+ messages in thread]
Intel 710 Endurance Test Results
2011-10-05 19:15 UTC David Boreham <david_list@boreham.org>
Query with order by and limit is very slow - wrong index used
2011-10-03 09:44 UTC Nowak Michał <michal.nowak@me.com>
` Re: Query with order by and limit is very slow - wrong index used
2011-10-03 10:02 UTC Gregg Jaskiewicz <gryzman@gmail.com>
` Re: Query with order by and limit is very slow - wrong index used
2011-10-03 10:51 UTC Nowak Michał <michal.nowak@me.com>
` Re: Query with order by and limit is very slow - wrong index used
2011-10-03 11:20 UTC Gregg Jaskiewicz <gryzman@gmail.com>
` Fwd: Query with order by and limit is very slow - wrong index used
2011-10-03 13:08 UTC Nowak Michał <michal.nowak@me.com>
` Re: Query with order by and limit is very slow - wrong index used
2011-10-03 13:59 UTC Nowak Michał <michal.nowak@me.com>
` Re: Query with order by and limit is very slow - wrong index used
2011-10-03 14:28 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: Query with order by and limit is very slow - wrong index used
2011-10-03 15:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query with order by and limit is very slow - wrong index used
2011-10-03 22:45 UTC Marcin Mańk <marcin.mank@gmail.com>
` Re: Query with order by and limit is very slow - wrong index used
2011-10-04 07:10 UTC Nowak Michał <michal.nowak@me.com>
` Re: Query with order by and limit is very slow - wrong index used
2011-10-04 08:08 UTC Gregg Jaskiewicz <gryzman@gmail.com>
` Re: Query with order by and limit is very slow - wrong index used
2011-10-04 08:55 UTC Nowak Michał <michal.nowak@me.com>
` Re: Query with order by and limit is very slow - wrong index used
2011-10-04 23:33 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[13+ messages in thread]
: Column Performance in a query
2011-10-04 10:25 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Column Performance in a query
2011-10-04 22:26 UTC Ondrej Ivanič <ondrej.ivanic@gmail.com>
[2+ messages in thread]
array_except -- Find elements that are not common to both arrays
2011-09-30 02:32 UTC bricklen <bricklen@gmail.com>
` Re: array_except -- Find elements that are not common to both arrays
2011-09-30 03:08 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: array_except -- Find elements that are not common to both arrays
2011-09-30 03:27 UTC bricklen <bricklen@gmail.com>
` Re: array_except -- Find elements that are not common to both arrays
2011-09-30 12:23 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: array_except -- Find elements that are not common to both arrays
2011-09-30 14:28 UTC bricklen <bricklen@gmail.com>
` Re: array_except -- Find elements that are not common to both arrays
2011-09-30 18:07 UTC bricklen <bricklen@gmail.com>
` Re: array_except -- Find elements that are not common to both arrays
2011-09-30 20:15 UTC Ben Chobot <bench@silentmedia.com>
` Re: array_except -- Find elements that are not common to both arrays
2011-09-30 21:12 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: array_except -- Find elements that are not common to both arrays
2011-09-30 23:43 UTC bricklen <bricklen@gmail.com>
` Re: array_except -- Find elements that are not common to both arrays
2011-10-04 07:16 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: array_except -- Find elements that are not common to both arrays
2011-10-04 16:10 UTC Merlin Moncure <mmoncure@gmail.com>
[11+ messages in thread]
Window functions and index usage
2011-10-04 09:39 UTC Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Window functions and index usage
2011-10-04 13:27 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: Window functions and index usage
2011-10-04 14:06 UTC Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Window functions and index usage
2011-10-04 14:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Window functions and index usage
2011-10-04 14:52 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: Window functions and index usage
2011-10-04 15:00 UTC Anssi Kääriäinen <anssi.kaariainen@thl.fi>
` Re: Window functions and index usage
2011-10-04 15:05 UTC Anssi Kääriäinen <anssi.kaariainen@thl.fi>
[7+ messages in thread]
pkey is not used on productive database
2011-10-03 17:48 UTC Soporte @ TEKSOL S.A. <soporte@teksol.com.ar>
` Re: pkey is not used on productive database
2011-10-04 12:55 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: pkey is not used on productive database
2011-10-04 13:01 UTC Scott Marlowe <scott.marlowe@gmail.com>
[3+ messages in thread]
How can i get record by data block not by sql?
2011-10-03 13:52 UTC 姜头 <104186179@qq.com>
` Re: How can i get record by data block not by sql?
2011-10-03 14:29 UTC Ben Chobot <bench@silentmedia.com>
[2+ messages in thread]
Suggestions for Intel 710 SSD test
2011-10-02 02:39 UTC David Boreham <david_list@boreham.org>
` Re: Suggestions for Intel 710 SSD test
2011-10-02 03:22 UTC Andy <angelflow@yahoo.com>
` Re: Suggestions for Intel 710 SSD test
2011-10-02 04:00 UTC Gregory Gerard <ggerard@mac.com>
` Re: Suggestions for Intel 710 SSD test
2011-10-02 08:33 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Suggestions for Intel 710 SSD test
2011-10-02 13:49 UTC David Boreham <david_list@boreham.org>
` Re: Suggestions for Intel 710 SSD test
2011-10-02 14:02 UTC David Boreham <david_list@boreham.org>
` Re: Suggestions for Intel 710 SSD test
2011-10-02 23:33 UTC David Boreham <david_list@boreham.org>
` Re: Suggestions for Intel 710 SSD test
2011-10-03 00:26 UTC Gregory Gerard <ggerard@mac.com>
` Re: Suggestions for Intel 710 SSD test
2011-10-03 00:44 UTC David Boreham <david_list@boreham.org>
` Re: Suggestions for Intel 710 SSD test
2011-10-03 04:35 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Suggestions for Intel 710 SSD test
2011-10-03 04:49 UTC David Boreham <david_list@boreham.org>
` Re: Suggestions for Intel 710 SSD test
2011-10-03 05:24 UTC David Boreham <david_list@boreham.org>
` Re: Suggestions for Intel 710 SSD test
2011-10-03 05:55 UTC Gregory Gerard <ggerard@mac.com>
` Re: Suggestions for Intel 710 SSD test
2011-10-03 05:57 UTC David Boreham <david_list@boreham.org>
[14+ messages in thread]
(no subject)
2011-10-02 09:59 UTC Eduardo Nazor <enazor@gmail.com>
the number of child tables --table partitioning
2011-09-29 14:14 UTC Jian Shi <jshi@unitrends.com>
` Re: the number of child tables --table partitioning
2011-09-29 15:08 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: the number of child tables --table partitioning
2011-09-29 21:12 UTC Ondrej Ivanič <ondrej.ivanic@gmail.com>
` Re: the number of child tables --table partitioning
2011-09-30 17:01 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: the number of child tables --table partitioning
2011-09-30 17:13 UTC alexandre - aldeia digital <adaldeia@gmail.com>
[5+ messages in thread]
: Create table taking time
2011-09-28 17:06 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Create table taking time
2011-09-28 18:55 UTC Josh Berkus <josh@agliodbs.com>
` Re: : Create table taking time
2011-09-28 19:14 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: : Create table taking time
2011-09-29 08:02 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Create table taking time
2011-09-29 13:48 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: : Create table taking time
2011-09-29 16:52 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: : Create table taking time
2011-09-30 05:22 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Create table taking time
2011-09-30 11:20 UTC Venkat Balaji <venkat.balaji@verse.in>
[8+ messages in thread]
postgres constraint triggers
2011-09-26 16:52 UTC Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
` Re: postgres constraint triggers
2011-09-27 04:54 UTC Ben Chobot <bench@silentmedia.com>
` Re: postgres constraint triggers
2011-09-28 00:37 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: postgres constraint triggers
2011-09-30 03:01 UTC Ben Chobot <bench@silentmedia.com>
[4+ messages in thread]
Select se bloquea
2011-09-29 12:43 UTC Numael Vacca Duran <numael07@hotmail.com>
` Re: Select se bloquea
2011-09-29 14:21 UTC Claudio Freire <klaussfreire@gmail.com>
[2+ messages in thread]
: Looking for PG Books
2011-09-28 17:17 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Looking for PG Books
2011-09-28 18:54 UTC Josh Berkus <josh@agliodbs.com>
[2+ messages in thread]
: Tracking Full Table Scans
2011-09-27 12:36 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Tracking Full Table Scans
2011-09-27 14:32 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: : Tracking Full Table Scans
2011-09-27 16:26 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Tracking Full Table Scans
2011-09-27 16:42 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Tracking Full Table Scans
2011-09-27 17:15 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: : Tracking Full Table Scans
2011-09-28 00:55 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: : Tracking Full Table Scans
2011-09-28 06:09 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Tracking Full Table Scans
2011-09-28 06:13 UTC Venkat Balaji <venkat.balaji@verse.in>
[8+ messages in thread]
overzealous sorting?
2011-09-26 06:28 UTC anthony.shipman@symstream.com
` Re: overzealous sorting?
2011-09-26 09:39 UTC Marc Cousin <cousinmarc@gmail.com>
` Re: overzealous sorting?
2011-09-27 02:45 UTC anthony.shipman@symstream.com
` Re: overzealous sorting?
2011-09-27 08:54 UTC Marc Cousin <cousinmarc@gmail.com>
` Re: overzealous sorting?
2011-09-27 09:05 UTC anthony.shipman@symstream.com
` Re: overzealous sorting?
2011-09-27 09:22 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: overzealous sorting?
2011-09-27 15:00 UTC Marc Cousin <cousinmarc@gmail.com>
` Re: overzealous sorting?
2011-09-28 05:13 UTC anthony.shipman@symstream.com
[8+ messages in thread]
[PERFORMANCE] Insights: fseek OR read_cluster?
2011-09-23 20:03 UTC Antonio Rodriges <rodriges@csm.donntu.edu.ua>
` [PERFORMANCE] Insights: fseek OR read_cluster?
2011-09-24 06:49 UTC Antonio Rodriges <antonio.rrz@gmail.com>
` Re: [PERFORMANCE] Insights: fseek OR read_cluster?
2011-09-26 07:59 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: [PERFORMANCE] Insights: fseek OR read_cluster?
2011-09-26 12:51 UTC Antonio Rodriges <antonio.rrz@gmail.com>
` Re: [PERFORMANCE] Insights: fseek OR read_cluster?
2011-09-26 19:06 UTC Marti Raudsepp <marti@juffo.org>
` Re: [PERFORMANCE] Insights: fseek OR read_cluster?
2011-09-27 16:12 UTC Antonio Rodriges <antonio.rrz@gmail.com>
[6+ messages in thread]
Ineffective autovacuum
2011-09-27 03:45 UTC Royce Ausburn <royce.ml@inomial.com>
` Re: Ineffective autovacuum
2011-09-27 04:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Ineffective autovacuum
2011-09-27 05:08 UTC Royce Ausburn <royce.ml@inomial.com>
` Re: Ineffective autovacuum
2011-09-27 10:29 UTC Marti Raudsepp <marti@juffo.org>
` Re: Ineffective autovacuum
2011-09-27 13:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Ineffective autovacuum
2011-09-27 14:00 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Ineffective autovacuum
2011-09-27 14:27 UTC Royce Ausburn <royce.ml@inomial.com>
[7+ messages in thread]
Performance Anomaly with "col in (A, B)" vs. "col = A OR col = B" ver. 9.0.3
2011-09-23 22:37 UTC Timothy Garnett <tgarnett@panjiva.com>
` Re: Performance Anomaly with "col in (A, B)" vs. "col = A OR col = B" ver. 9.0.3
2011-09-26 17:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3
2011-09-26 17:18 UTC Craig James <craig_james@emolecules.com>
` Re: Performance Anomaly with "col in (A, B)" vs. "col = A OR col = B" ver. 9.0.3
2011-09-26 17:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3
2011-09-26 21:11 UTC Timothy Garnett <tgarnett@panjiva.com>
` Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3
2011-09-27 00:09 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Performance Anomaly with "col in (A, B)" vs. "col = A OR col = B" ver. 9.0.3
2011-09-27 00:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3
2011-09-27 05:06 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3
2011-09-27 12:40 UTC Timothy Garnett <tgarnett@panjiva.com>
` Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3
2011-09-27 12:57 UTC Timothy Garnett <tgarnett@panjiva.com>
[10+ messages in thread]
slow query on tables with new columns added.
2011-09-23 17:49 UTC M. D. <lists@turnkey.bz>
` Re: slow query on tables with new columns added.
2011-09-24 06:10 UTC Filip Rembiałkowski <plk.zuber@gmail.com>
` Re: slow query on tables with new columns added.
2011-09-26 20:13 UTC M. D. <lists@turnkey.bz>
` Re: slow query on tables with new columns added.
2011-09-26 23:45 UTC Filip Rembiałkowski <plk.zuber@gmail.com>
[4+ messages in thread]
How to find record having % as part of data.
2011-09-26 13:34 UTC Biswa <brnayak26@yahoo.com>
` Re: How to find record having % as part of data.
2011-09-26 14:19 UTC Biswa <brnayak26@yahoo.com>
[2+ messages in thread]
Query optimization using order by and limit
2011-09-21 23:14 UTC Michael Viscuso <michael.viscuso@getcarbonblack.com>
` Re: Query optimization using order by and limit
2011-09-22 01:48 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Query optimization using order by and limit
2011-09-22 02:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query optimization using order by and limit
2011-09-22 02:55 UTC Michael Viscuso <michael.viscuso@getcarbonblack.com>
` Re: Query optimization using order by and limit
2011-09-22 03:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query optimization using order by and limit
2011-09-22 13:41 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Query optimization using order by and limit
2011-09-22 13:55 UTC Michael Viscuso <michael.viscuso@getcarbonblack.com>
` Re: Query optimization using order by and limit
2011-09-22 14:53 UTC Stephen Frost <sfrost@snowman.net>
` Re: Query optimization using order by and limit
2011-09-22 22:55 UTC Michael Viscuso <michael.viscuso@getcarbonblack.com>
` Re: Query optimization using order by and limit
2011-09-22 23:14 UTC Stephen Frost <sfrost@snowman.net>
` Re: Query optimization using order by and limit
2011-09-22 23:21 UTC Michael Viscuso <michael.viscuso@getcarbonblack.com>
` Re: Query optimization using order by and limit
2011-09-25 22:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query optimization using order by and limit
2011-09-26 00:34 UTC Stephen Frost <sfrost@snowman.net>
` Re: Query optimization using order by and limit
2011-09-26 01:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
[14+ messages in thread]
DBT-5 & Postgres 9.0.3
2011-04-12 07:51 UTC Sethu Prasad <sethuprasad.in@gmail.com>
` Re: DBT-5 & Postgres 9.0.3
2011-05-12 03:22 UTC Robert Haas <robertmhaas@gmail.com>
` Re: DBT-5 & Postgres 9.0.3
2011-05-12 07:18 UTC Sethu Prasad <sethuprasad.in@gmail.com>
` Re: DBT-5 & Postgres 9.0.3
2011-05-15 21:12 UTC Robert Haas <robertmhaas@gmail.com>
` Re: DBT-5 & Postgres 9.0.3
2011-08-17 15:29 UTC bobbyw <bobbyw@sendprobe.com>
` Re: DBT-5 & Postgres 9.0.3
2011-08-17 17:28 UTC Andy Colson <andy@squeakycode.net>
` Re: DBT-5 & Postgres 9.0.3
2011-08-17 17:59 UTC bobbyw <bobbyw@sendprobe.com>
` Re: DBT-5 & Postgres 9.0.3
2011-08-17 18:14 UTC ktm@rice.edu <ktm@rice.edu>
` Re: DBT-5 & Postgres 9.0.3
2011-08-17 20:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: DBT-5 & Postgres 9.0.3
2011-08-17 20:41 UTC Aidan Van Dyk <aidan@highrise.ca>
` Re: DBT-5 & Postgres 9.0.3
2011-08-17 21:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: DBT-5 & Postgres 9.0.3
2011-09-24 15:45 UTC Mark Wong <markwkm@gmail.com>
[12+ messages in thread]
PG 9 adminstrations
2011-09-21 03:57 UTC Hany ABOU-GHOURY <hghoury@gmail.com>
` Re: PG 9 adminstrations
2011-09-21 04:16 UTC Derrick Rice <derrick.rice@gmail.com>
` Re: PG 9 adminstrations
2011-09-21 04:29 UTC Hany ABOU-GHOURY <hghoury@gmail.com>
` Re: PG 9 adminstrations
2011-09-21 12:48 UTC Shaun Thomas <sthomas@peak6.com>
` Fwd: [PERFORM] PG 9 adminstrations
2011-09-23 01:17 UTC Hany ABOU-GHOURY <hghoury@gmail.com>
` Re: Fwd: [PERFORM] PG 9 adminstrations
2011-09-23 01:36 UTC Daniel Staal <DStaal@usa.net>
` Re: Fwd: [PERFORM] PG 9 adminstrations
2011-09-23 03:43 UTC Hany ABOU-GHOURY <hghoury@gmail.com>
[7+ 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