pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedtwo table join with order by on both tables attributes
2014-08-07 23:21 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: two table join with order by on both tables attributes
2014-08-07 23:42 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: two table join with order by on both tables attributes
2014-08-08 00:02 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: two table join with order by on both tables attributes
2014-08-08 00:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: two table join with order by on both tables attributes
2014-08-08 00:43 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: two table join with order by on both tables attributes
2014-08-08 01:05 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: two table join with order by on both tables attributes
2014-08-08 13:29 UTC Marti Raudsepp <marti@juffo.org>
` Re: two table join with order by on both tables attributes
2014-08-08 13:57 UTC Evgeniy Shishkin <itparanoia@gmail.com>
[8+ messages in thread]
Query performing very bad and sometimes good
2014-08-05 21:38 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Query performing very bad and sometimes good
2014-08-06 00:16 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Query performing very bad and sometimes good
2014-08-06 14:04 UTC Kevin Grittner <kgrittn@ymail.com>
[3+ messages in thread]
Very slow planning performance on partition table
2014-07-23 13:21 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-23 17:35 UTC Douglas J Hunley <doug.hunley@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-24 01:30 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-25 01:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow planning performance on partition table
2014-07-25 03:26 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-25 14:23 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-27 15:44 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-27 16:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow planning performance on partition table
2014-07-28 01:18 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-28 07:01 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-28 13:10 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-28 17:29 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-29 00:10 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-29 08:21 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-29 17:27 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-30 01:13 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-30 04:05 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-30 04:16 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-07-30 10:03 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-08-04 07:23 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Very slow planning performance on partition table
2014-08-04 10:12 UTC Rural Hunter <ruralhunter@gmail.com>
[21+ messages in thread]
Setting a default format for timestamp
2014-07-31 20:43 UTC Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
` Re: Setting a default format for timestamp
2014-07-31 20:59 UTC Scott Whitney <scott@journyx.com>
[2+ messages in thread]
Why you should turn on Checksums with SSDs
2014-07-30 03:12 UTC Josh Berkus <josh@agliodbs.com>
` Re: Why you should turn on Checksums with SSDs
2014-07-30 09:01 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Why you should turn on Checksums with SSDs
2014-07-30 18:53 UTC Merlin Moncure <mmoncure@gmail.com>
[3+ messages in thread]
Slow create temp table
2014-07-30 18:43 UTC Clinton Adams <clinton.adams@gmail.com>
Cursor + upsert (astronomical data)
2014-07-26 10:46 UTC Jiří Nádvorník <nadvornik.ji@gmail.com>
` Re: Cursor + upsert (astronomical data)
2014-07-27 06:05 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: Cursor + upsert (astronomical data)
2014-07-27 14:35 UTC Jiří Nádvorník <nadvornik.ji@gmail.com>
` Re: Cursor + upsert (astronomical data)
2014-07-27 15:35 UTC Craig James <cjames@emolecules.com>
` Re: Cursor + upsert (astronomical data)
2014-07-27 19:05 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Cursor + upsert (astronomical data)
2014-07-27 20:09 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: Cursor + upsert (astronomical data)
2014-07-29 09:44 UTC Jiří Nádvorník <nadvornik.ji@gmail.com>
` Re: Cursor + upsert (astronomical data)
2014-07-29 10:11 UTC Jiří Nádvorník <nadvornik.ji@gmail.com>
` Re: Cursor + upsert (astronomical data)
2014-07-29 14:46 UTC Craig James <cjames@emolecules.com>
` Re: Cursor + upsert (astronomical data)
2014-07-29 17:50 UTC Jiří Nádvorník <nadvornik.ji@gmail.com>
` Re: Cursor + upsert (astronomical data)
2014-07-29 18:36 UTC Jeff Janes <jeff.janes@gmail.com>
[11+ messages in thread]
Re: Full text search with ORDER BY performance issue
2014-07-28 19:55 UTC worthy7 <worthy.vii@gmail.com>
Debugging writing load
2014-07-24 14:22 UTC Borodin Vladimir <root@simply.name>
` Re: Debugging writing load
2014-07-25 09:19 UTC Craig Ringer <craig@2ndquadrant.com>
[2+ messages in thread]
Building multiple indexes on one table.
2014-07-17 22:47 UTC Chris Ruprecht <chris@cdrbill.com>
` Re: Building multiple indexes on one table.
2014-07-17 23:21 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Building multiple indexes on one table.
2014-07-23 19:40 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Building multiple indexes on one table.
2014-07-23 19:49 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Building multiple indexes on one table.
2014-07-23 20:19 UTC Felipe Santos <felipepts@gmail.com>
[5+ messages in thread]
Blocking every 20 sec while mass copying.
2014-07-18 10:52 UTC Benjamin Dugast <bdugast@excilys.com>
` Re: Blocking every 20 sec while mass copying.
2014-07-18 11:11 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Blocking every 20 sec while mass copying.
2014-07-18 15:16 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: Blocking every 20 sec while mass copying.
2014-07-18 17:56 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Blocking every 20 sec while mass copying.
2014-07-21 08:02 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Blocking every 20 sec while mass copying.
2014-07-23 09:39 UTC Benjamin Dugast <bdugast@excilys.com>
[6+ messages in thread]
Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
2014-07-21 21:09 UTC johno <jan.suchal@gmail.com>
` Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
2014-07-21 21:31 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
2014-07-21 21:44 UTC johno <jan.suchal@gmail.com>
` Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
2014-07-21 21:54 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
2014-07-21 22:02 UTC johno <jan.suchal@gmail.com>
` Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
2014-07-21 22:14 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
2014-07-21 22:22 UTC johno <jan.suchal@gmail.com>
` Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
2014-07-22 02:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
2014-07-22 05:57 UTC johno <jan.suchal@gmail.com>
` Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
2014-07-22 06:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
2014-07-22 10:42 UTC johno <jan.suchal@gmail.com>
[11+ messages in thread]
estimate btree index size without creating
2014-07-22 07:38 UTC Евгений Селявка <evg.selyavka@gmail.com>
query performance question
2006-04-28 11:30 UTC gulsah <gulsah_129@yahoo.com>
` Re: query performance question
2006-05-01 00:36 UTC Dave Dutcher <dave@tridecap.com>
` query performance question
2008-06-03 07:57 UTC Marcin Citowicki <marcin.citowicki@m4n.nl>
` Re: query performance question
2008-06-03 08:31 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: query performance question
2008-06-03 08:55 UTC Marcin Citowicki <marcin.citowicki@m4n.nl>
` Re: query performance question
2008-06-03 09:04 UTC tv@fuzzy.cz
` Re: query performance question
2008-06-04 00:10 UTC PFC <lists@peufeu.com>
` Re: query performance question
2008-06-05 15:43 UTC Dan Harris <fbsd@drivefaster.net>
` Re: query performance question
2008-06-05 17:16 UTC Kenneth Marshall <ktm@rice.edu>
` Re: query performance question
2008-06-05 20:22 UTC Dan Harris <fbsd@drivefaster.net>
` Query Performance question
2014-07-13 22:55 UTC Magers, James <James.Magers@turner.com>
` Re: Query Performance question
2014-07-14 00:58 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Query Performance question
2014-07-14 02:20 UTC Magers, James <James.Magers@turner.com>
` Re: Query Performance question
2014-07-14 07:07 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Query Performance question
2014-07-14 13:18 UTC Magers, James <James.Magers@turner.com>
` Re: Query Performance question
2014-07-14 13:48 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Query Performance question
2014-07-14 14:00 UTC Magers, James <James.Magers@turner.com>
` Re: Query Performance question
2014-07-14 14:48 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Query Performance question
2014-07-14 16:02 UTC Magers, James <James.Magers@turner.com>
` Re: Query Performance question
2014-07-14 16:28 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Query Performance question
2014-07-14 17:15 UTC Magers, James <James.Magers@turner.com>
[21+ messages in thread]
GIN index not used
2014-07-11 04:14 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: GIN index not used
2014-07-11 04:44 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: GIN index not used
2014-07-11 04:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: GIN index not used
2014-07-11 05:01 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: GIN index not used
2014-07-11 05:26 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: GIN index not used
2014-07-11 05:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: GIN index not used
2014-07-11 05:47 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: GIN index not used
2014-07-12 08:31 UTC Emre Hasegeli <emre@hasegeli.com>
[8+ messages in thread]
PGSQL 9.3 - billion rows
2014-07-07 13:59 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PGSQL 9.3 - billion rows
2014-07-07 14:27 UTC Felipe Santos <felipepts@gmail.com>
` Re: PGSQL 9.3 - billion rows
2014-07-07 19:40 UTC Sékine Coulibaly <scoulibaly@gmail.com>
` Re: PGSQL 9.3 - billion rows
2014-07-09 00:06 UTC Josh Berkus <josh@agliodbs.com>
[4+ messages in thread]
DB sessions 100 times of DB connections
2014-07-04 01:44 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: DB sessions 100 times of DB connections
2014-07-04 01:59 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: DB sessions 100 times of DB connections
2014-07-08 16:28 UTC Steve Crawford <scrawford@pinpointresearch.com>
[3+ messages in thread]
stored procedure suddenly runs slowly in HOT STANDBY but fast in primary
2014-07-04 21:04 UTC piuschan <pchan@contigo.com>
` Re: stored procedure suddenly runs slowly in HOT STANDBY but fast in primary
2014-07-05 04:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: stored procedure suddenly runs slowly in HOT STANDBY but fast in primary
2014-07-07 18:39 UTC piuschan <pchan@contigo.com>
[3+ messages in thread]
Hash Join node sometimes slow
2014-07-02 13:01 UTC Dave Roberge <droberge@bluetarp.com>
` Re: Hash Join node sometimes slow
2014-07-02 14:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Hash Join node sometimes slow
2014-07-03 15:14 UTC Dave Roberge <droberge@bluetarp.com>
[3+ messages in thread]
fragmention issue with ext4: e4defrag?
2014-07-02 08:51 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: fragmention issue with ext4: e4defrag?
2014-07-02 18:01 UTC Kevin Grittner <kgrittn@ymail.com>
[2+ messages in thread]
Guidelines on best indexing strategy for varying searches on 20+ columns
2014-06-25 08:48 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
` Re: Guidelines on best indexing strategy for varying searches on 20+ columns
2014-06-25 21:48 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Guidelines on best indexing strategy for varying searches on 20+ columns
2014-06-30 07:33 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
` Re: Guidelines on best indexing strategy for varying searches on 20+ columns
2014-06-30 18:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Guidelines on best indexing strategy for varying searches on 20+ columns
2014-07-01 20:08 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
[5+ messages in thread]
Volatility - docs vs behaviour?
2014-06-30 09:24 UTC Craig Ringer <craig@2ndquadrant.com>
` Re: Volatility - docs vs behaviour?
2014-06-30 15:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Volatility - docs vs behaviour?
2014-07-01 01:11 UTC Craig Ringer <craig@2ndquadrant.com>
` Re: Volatility - docs vs behaviour?
2014-07-01 02:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Volatility - docs vs behaviour?
2014-07-01 16:26 UTC Merlin Moncure <mmoncure@gmail.com>
[5+ messages in thread]
GIST optimization to limit calls to operator on sub nodes
2014-06-23 07:20 UTC Pujol Mathieu <mathieu.pujol@realfusio.com>
` Re: GIST optimization to limit calls to operator on sub nodes
2014-06-29 20:14 UTC Emre Hasegeli <emre@hasegeli.com>
` Re: GIST optimization to limit calls to operator on sub nodes
2014-06-29 20:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: GIST optimization to limit calls to operator on sub nodes
2014-06-30 07:26 UTC Pujol Mathieu <mathieu.pujol@realfusio.com>
` Re: GIST optimization to limit calls to operator on sub nodes
2014-06-30 07:40 UTC Pujol Mathieu <mathieu.pujol@realfusio.com>
` Re: GIST optimization to limit calls to operator on sub nodes
2014-06-30 14:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: GIST optimization to limit calls to operator on sub nodes
2014-07-01 07:46 UTC Pujol Mathieu <mathieu.pujol@realfusio.com>
[7+ messages in thread]
Can improve 'limit 1' ? with slow function
2014-06-27 07:30 UTC songtebo <songtebo@126.com>
how to improve perf of 131MM row table?
2014-06-25 20:10 UTC AJ Weber <aweber@comcast.net>
` Re: how to improve perf of 131MM row table?
2014-06-25 20:49 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: how to improve perf of 131MM row table?
2014-06-25 21:40 UTC Aaron Weber <aweber@comcast.net>
` Re: how to improve perf of 131MM row table?
2014-06-25 21:55 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: how to improve perf of 131MM row table?
2014-06-25 22:29 UTC Aaron Weber <aweber@comcast.net>
` Re: how to improve perf of 131MM row table?
2014-06-26 13:26 UTC AJ Weber <aweber@comcast.net>
` Re: how to improve perf of 131MM row table?
2014-06-26 13:56 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: how to improve perf of 131MM row table?
2014-06-26 14:05 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: how to improve perf of 131MM row table?
2014-06-26 14:07 UTC AJ Weber <aweber@comcast.net>
` Re: how to improve perf of 131MM row table?
2014-06-26 14:14 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: how to improve perf of 131MM row table?
2014-06-26 14:22 UTC AJ Weber <aweber@comcast.net>
` Re: how to improve perf of 131MM row table?
2014-06-26 14:37 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: how to improve perf of 131MM row table?
2014-06-26 14:50 UTC AJ Weber <aweber@comcast.net>
` Re: how to improve perf of 131MM row table?
2014-06-26 15:35 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: how to improve perf of 131MM row table?
2014-06-26 15:38 UTC AJ Weber <aweber@comcast.net>
` Re: how to improve perf of 131MM row table?
2014-06-26 15:44 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: how to improve perf of 131MM row table?
2014-06-26 15:48 UTC AJ Weber <aweber@comcast.net>
` Re: how to improve perf of 131MM row table?
2014-06-26 16:19 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: how to improve perf of 131MM row table?
2014-06-26 16:23 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: how to improve perf of 131MM row table?
2014-06-26 17:04 UTC Sébastien Lorion <sl@thestrangefactory.com>
` Re: how to improve perf of 131MM row table?
2014-06-26 18:01 UTC AJ Weber <aweber@comcast.net>
` Re: how to improve perf of 131MM row table?
2014-06-26 20:14 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: how to improve perf of 131MM row table?
2014-06-26 20:26 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: how to improve perf of 131MM row table?
2014-06-26 20:40 UTC Aaron Weber <aweber@comcast.net>
` Re: how to improve perf of 131MM row table?
2014-06-26 20:43 UTC Aaron Weber <aweber@comcast.net>
[25+ 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