pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTerrible plan for join to nested union
2012-07-07 22:35 UTC Nate Allan <nallan@ancestry.com>
` Re: Terrible plan for join to nested union
2012-07-08 00:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Terrible plan for join to nested union
2012-07-08 05:50 UTC Nate Allan <nallan@ancestry.com>
` Re: Terrible plan for join to nested union
2012-07-08 06:03 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Terrible plan for join to nested union
2012-07-08 09:43 UTC Nate Allan <nallan@ancestry.com>
` Re: Terrible plan for join to nested union
2012-07-08 15:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Terrible plan for join to nested union
2012-07-09 04:02 UTC Nate Allan <nallan@ancestry.com>
` Re: Terrible plan for join to nested union
2012-07-09 05:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Terrible plan for join to nested union
2012-07-09 06:20 UTC Nate Allan <nallan@ancestry.com>
[9+ messages in thread]
select operations that generate disk writes
2012-07-06 06:10 UTC CSS <css@morefoo.com>
` Re: select operations that generate disk writes
2012-07-06 06:20 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: select operations that generate disk writes
2012-07-06 06:52 UTC Craig Ringer <ringerc@ringerc.id.au>
[3+ messages in thread]
Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-03 23:08 UTC Reza Taheri <rtaheri@vmware.com>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-04 05:19 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-04 18:24 UTC Reza Taheri <rtaheri@vmware.com>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-04 22:35 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-06 01:25 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-06 03:22 UTC Reza Taheri <rtaheri@vmware.com>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-06 03:41 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-06 04:03 UTC Reza Taheri <rtaheri@vmware.com>
[8+ messages in thread]
The overall experience of TPC-V benchmark team with PostgreSQL
2012-07-06 03:56 UTC Reza Taheri <rtaheri@vmware.com>
What would effect planning time?
2012-07-06 02:12 UTC David Kerr <dmk@mr-paradox.net>
MemSQL the "world's fastest database"?
2012-06-25 16:25 UTC Craig James <cjames@emolecules.com>
` Re: MemSQL the "world's fastest database"?
2012-06-25 17:03 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: MemSQL the "world's fastest database"?
2012-06-25 17:23 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: MemSQL the "world's fastest database"?
2012-06-25 17:41 UTC Josh Berkus <josh@agliodbs.com>
` Re: MemSQL the "world's fastest database"?
2012-06-25 18:02 UTC gnuoytr@rcn.com
` Re: MemSQL the "world's fastest database"?
2012-06-25 20:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: MemSQL the "world's fastest database"?
2012-07-01 04:18 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: MemSQL the "world's fastest database"?
2012-07-01 05:00 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: MemSQL the "world's fastest database"?
2012-07-03 21:46 UTC Gregg Jaskiewicz <gryzman@gmail.com>
` Re: MemSQL the "world's fastest database"?
2012-07-06 01:45 UTC Greg Smith <greg@2ndQuadrant.com>
[10+ messages in thread]
Drop statistics?
2012-06-22 17:07 UTC David Kerr <dmk@mr-paradox.net>
` Re: Drop statistics?
2012-06-22 17:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Drop statistics?
2012-06-22 18:04 UTC David Kerr <dmk@mr-paradox.net>
` Re: Drop statistics?
2012-07-03 17:16 UTC Bruce Momjian <bruce@momjian.us>
` Re: Drop statistics?
2012-07-05 05:53 UTC David Kerr <dmk@mr-paradox.net>
[5+ messages in thread]
static virtual columns as result?
2012-07-03 09:29 UTC PV <pstm.spain@gmail.com>
` Re: static virtual columns as result?
2012-07-03 13:44 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: static virtual columns as result?
2012-07-03 15:43 UTC PV <pstm.spain@gmail.com>
` Re: static virtual columns as result?
2012-07-04 10:35 UTC PV <pstm.spain@gmail.com>
[4+ messages in thread]
SSD, Postgres and safe write cache
2012-06-20 14:51 UTC Michal Szymanski <mich20061@gmail.com>
` Re: SSD, Postgres and safe write cache
2012-06-25 16:05 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: SSD, Postgres and safe write cache
2012-07-01 04:37 UTC Greg Smith <greg@2ndQuadrant.com>
[3+ messages in thread]
Performance of a large array access by position (tested version 9.1.3)
2012-06-22 07:02 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 05:03 UTC Jesper Krogh <jesper@krogh.cc>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 07:53 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 08:04 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 08:19 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 08:22 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 09:03 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-28 10:22 UTC Cédric Villemain <cedric@2ndquadrant.com>
[8+ messages in thread]
Can I do better than this heapscan and sort?
2012-06-21 20:07 UTC Andy Halsall <halsall_andy@hotmail.com>
` Re: Can I do better than this heapscan and sort?
2012-06-26 13:36 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Can I do better than this heapscan and sort?
2012-06-26 13:42 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Can I do better than this heapscan and sort?
2012-06-27 16:49 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ messages in thread]
[performance] fast reads on a busy server
2012-06-26 22:16 UTC Willy-Bas Loos <willybas@gmail.com>
` Re: [performance] fast reads on a busy server
2012-06-27 07:34 UTC Hannu Krosing <hannu@2ndQuadrant.com>
` Re: [performance] fast reads on a busy server
2012-06-27 10:01 UTC Willy-Bas Loos <willybas@gmail.com>
` Re: [performance] fast reads on a busy server
2012-06-27 11:28 UTC Willy-Bas Loos <willybas@gmail.com>
` Re: [performance] fast reads on a busy server
2012-06-27 11:58 UTC Willy-Bas Loos <willybas@gmail.com>
` Re: [PERFORM] [performance] fast reads on a busy server
2012-06-27 12:58 UTC Ants Aasma <ants@cybertec.at>
` Re: [PERFORM] [performance] fast reads on a busy server
2012-06-27 13:23 UTC Willy-Bas Loos <willybas@gmail.com>
[7+ messages in thread]
index-only scan is missing the INCLUDE feature
2012-06-20 04:46 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: index-only scan is missing the INCLUDE feature
2012-06-20 14:11 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: index-only scan is missing the INCLUDE feature
2012-06-20 15:32 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: index-only scan is missing the INCLUDE feature
2012-06-21 02:45 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: index-only scan is missing the INCLUDE feature
2012-06-25 15:22 UTC Cédric Villemain <cedric@2ndquadrant.com>
[5+ messages in thread]
"global/pgstat.stat" corrupt
2012-06-22 18:46 UTC David Kerr <dmk@mr-paradox.net>
` Re: "global/pgstat.stat" corrupt
2012-06-22 19:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: "global/pgstat.stat" corrupt
2012-06-22 20:11 UTC David Kerr <dmk@mr-paradox.net>
[3+ messages in thread]
Why is a hash join being used?
2012-06-19 21:34 UTC Tim Jacobs <tjacobs2@email.unc.edu>
` Re: Why is a hash join being used?
2012-06-20 13:36 UTC Sergey Konoplev <sergey.konoplev@postgresql-consulting.com>
` Re: Why is a hash join being used?
2012-06-22 15:59 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[3+ messages in thread]
random char or text variable in pgbench
2012-06-20 19:51 UTC philippe.beaudoin@bull.net
pgbouncer - massive overhead?
2012-06-19 16:00 UTC Strange, John W <john.w.strange@jpmorgan.com>
` Re: pgbouncer - massive overhead?
2012-06-20 15:27 UTC Steve Crawford <scrawford@pinpointresearch.com>
[2+ messages in thread]
scale up (postgresql vs mssql)
2012-04-11 22:11 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-04-13 14:32 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: scale up (postgresql vs mssql)
2012-04-13 14:40 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: scale up (postgresql vs mssql)
2012-04-13 15:04 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-04-13 16:36 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: scale up (postgresql vs mssql)
2012-04-13 16:43 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-04-13 17:49 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: scale up (postgresql vs mssql)
2012-04-13 17:52 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-04-15 12:43 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-04-16 13:10 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-04-16 15:43 UTC Andy Colson <andy@squeakycode.net>
` Re: scale up (postgresql vs mssql)
2012-04-16 15:55 UTC Richard Huxton <dev@archonet.com>
` Re: scale up (postgresql vs mssql)
2012-04-18 07:32 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-04-18 19:47 UTC Andy Colson <andy@squeakycode.net>
` Re: scale up (postgresql vs mssql)
2012-04-18 20:13 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-04-29 13:21 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-05-03 13:40 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-05-03 17:07 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-05-04 13:04 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-05-09 07:11 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: scale up (postgresql vs mssql)
2012-05-09 12:53 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-06-20 06:01 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-06-20 13:43 UTC Andy Colson <andy@squeakycode.net>
` Re: scale up (postgresql vs mssql)
2012-06-20 14:55 UTC Merlin Moncure <mmoncure@gmail.com>
[24+ messages in thread]
Expected performance of querying 5k records from 4 million records?
2012-06-15 16:17 UTC Anish Kejariwal <anishkej@gmail.com>
` Re: Expected performance of querying 5k records from 4 million records?
2012-06-15 17:44 UTC Josh Berkus <josh@agliodbs.com>
` Re: Expected performance of querying 5k records from 4 million records?
2012-06-15 18:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Expected performance of querying 5k records from 4 million records?
2012-06-18 16:39 UTC Anish Kejariwal <anishkej@gmail.com>
` Re: Expected performance of querying 5k records from 4 million records?
2012-06-18 16:49 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: Expected performance of querying 5k records from 4 million records?
2012-06-18 19:08 UTC Josh Berkus <josh@agliodbs.com>
[6+ messages in thread]
correlated exists with join is slow.
2012-06-18 13:47 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: correlated exists with join is slow.
2012-06-18 14:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: correlated exists with join is slow.
2012-06-18 14:58 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: correlated exists with join is slow.
2012-06-18 15:02 UTC Віталій Тимчишин <tivv00@gmail.com>
[4+ messages in thread]
Update blocking a select count(*)?
2012-06-15 18:22 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 18:32 UTC Peter Geoghegan <peter@2ndquadrant.com>
` Re: Update blocking a select count(*)?
2012-06-15 18:41 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 18:43 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 18:46 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 18:46 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 18:54 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 19:03 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 19:04 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 19:12 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 19:27 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 19:32 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 19:45 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 19:51 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 19:58 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 20:00 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 20:29 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 20:38 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[18+ messages in thread]
Performance of pg_basebackup
2012-06-12 14:54 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Performance of pg_basebackup
2012-06-12 14:57 UTC Magnus Hagander <magnus@hagander.net>
` Re: Performance of pg_basebackup
2012-06-12 15:00 UTC Shaun Thomas <sthomas@optionshouse.com>
[3+ messages in thread]
Performance of CLUSTER
2012-06-10 08:20 UTC Mark Thornton <mthornton@optrak.com>
` Re: Performance of CLUSTER
2012-06-11 13:42 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Performance of CLUSTER
2012-06-11 14:02 UTC Mark Thornton <mthornton@optrak.com>
` Re: Performance of CLUSTER
2012-06-11 14:14 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Performance of CLUSTER
2012-06-11 14:44 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Performance of CLUSTER
2012-06-11 23:53 UTC Jeff Davis <pgsql@j-davis.com>
[6+ messages in thread]
how to change the index chosen in plan?
2012-06-08 13:33 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: how to change the index chosen in plan?
2012-06-08 14:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: how to change the index chosen in plan?
2012-06-08 14:23 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: how to change the index chosen in plan?
2012-06-08 14:37 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: how to change the index chosen in plan?
2012-06-08 16:23 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: how to change the index chosen in plan?
2012-06-08 16:39 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: how to change the index chosen in plan?
2012-06-09 02:08 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: how to change the index chosen in plan?
2012-06-09 14:39 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: how to change the index chosen in plan?
2012-06-09 15:38 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: how to change the index chosen in plan?
2012-06-11 04:46 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: how to change the index chosen in plan?
2012-06-11 12:07 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: how to change the index chosen in plan?
2012-06-11 12:55 UTC Rural Hunter <ruralhunter@gmail.com>
[12+ messages in thread]
Tablespaces and query planning
2012-06-08 08:15 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Tablespaces and query planning
2012-06-08 10:36 UTC Cédric Villemain <cedric@2ndquadrant.com>
` Re: Tablespaces and query planning
2012-06-11 07:01 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[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