pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedGIN 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]
postgres files in use not staying in linux file cache
2014-06-05 21:32 UTC Brio <brianoraas@gmail.com>
` Re: postgres files in use not staying in linux file cache
2014-06-10 21:07 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: postgres files in use not staying in linux file cache
2014-06-13 07:19 UTC Tim Kane <tim.kane@gmail.com>
` Re: postgres files in use not staying in linux file cache
2014-06-13 16:11 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: postgres files in use not staying in linux file cache
2014-06-16 18:14 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: postgres files in use not staying in linux file cache
2014-06-25 00:13 UTC Brio <brianoraas@gmail.com>
[6+ messages in thread]
huge pgstat.stat file on PostgreSQL 8.3.24
2014-06-19 04:38 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: huge pgstat.stat file on PostgreSQL 8.3.24
2014-06-19 05:28 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: huge pgstat.stat file on PostgreSQL 8.3.24
2014-06-19 05:35 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: huge pgstat.stat file on PostgreSQL 8.3.24
2014-06-19 05:41 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: huge pgstat.stat file on PostgreSQL 8.3.24
2014-06-19 10:01 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: huge pgstat.stat file on PostgreSQL 8.3.24
2014-06-19 23:44 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: huge pgstat.stat file on PostgreSQL 8.3.24
2014-06-20 03:33 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: huge pgstat.stat file on PostgreSQL 8.3.24
2014-06-20 10:14 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: huge pgstat.stat file on PostgreSQL 8.3.24
2014-06-24 07:07 UTC Huang, Suya <Suya.Huang@au.experian.com>
[9+ messages in thread]
autovacuum vacuum creates bad statistics for planner when it log index scans: 0
2014-05-19 00:35 UTC tim_wilson <tim.wilson@telogis.com>
` Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
2014-05-19 03:56 UTC tim_wilson <tim.wilson@telogis.com>
` Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
2014-05-20 04:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
2014-06-06 00:55 UTC tim_wilson <tim.wilson@telogis.com>
` Re: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
2014-06-06 02:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
2014-06-06 06:43 UTC tim_wilson <tim.wilson@telogis.com>
` Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
2014-06-06 11:22 UTC tim_wilson <tim.wilson@telogis.com>
` Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
2014-06-10 21:37 UTC tim_wilson <tim.wilson@telogis.com>
` Re: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
2014-06-10 22:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
2014-06-10 22:41 UTC tim_wilson <tim.wilson@telogis.com>
` Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
2014-06-24 00:39 UTC tim_wilson <tim.wilson@telogis.com>
[11+ messages in thread]
Unable to allocate 2G of shared memory on wheezy
2014-06-18 19:00 UTC Dave Cramer <davecramer@gmail.com>
` Re: Unable to allocate 2G of shared memory on wheezy
2014-06-18 19:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unable to allocate 2G of shared memory on wheezy
2014-06-18 19:24 UTC Dave Cramer <davecramer@gmail.com>
` Re: Unable to allocate 2G of shared memory on wheezy
2014-06-18 19:33 UTC Dave Cramer <davecramer@gmail.com>
` Re: Unable to allocate 2G of shared memory on wheezy
2014-06-18 19:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
1 machine + master DB with postgres_fdw + multiple DB instances on different ports
2014-06-17 00:24 UTC Gezeala M. Bacuño II <gezeala@gmail.com>
` Re: 1 machine + master DB with postgres_fdw + multiple DB instances on different ports
2014-06-17 07:17 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: 1 machine + master DB with postgres_fdw + multiple DB instances on different ports
2014-06-17 16:41 UTC Gezeala M. Bacuño II <gezeala@gmail.com>
[3+ messages in thread]
Query memory usage greatly in excess of work_mem * query plan steps
2014-06-11 22:02 UTC Timothy Garnett <tgarnett@panjiva.com>
` Re: Query memory usage greatly in excess of work_mem * query plan steps
2014-06-14 02:18 UTC Franklin, Dan <dan.franklin@pearson.com>
` Re: Query memory usage greatly in excess of work_mem * query plan steps
2014-06-14 14:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
OFFSET/LIMIT - Disparate Performance w/ Go application
2014-06-12 07:08 UTC Matt Silverlock <matt@eatsleeprepeat.net>
` Re: OFFSET/LIMIT - Disparate Performance w/ Go application
2014-06-12 14:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: OFFSET/LIMIT - Disparate Performance w/ Go application
2014-06-12 16:15 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: OFFSET/LIMIT - Disparate Performance w/ Go application
2014-06-12 19:48 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: OFFSET/LIMIT - Disparate Performance w/ Go application
2014-06-12 19:58 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: OFFSET/LIMIT - Disparate Performance w/ Go application
2014-06-12 20:46 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: OFFSET/LIMIT - Disparate Performance w/ Go application
2014-06-12 22:39 UTC Matt Silverlock <matt@eatsleeprepeat.net>
[7+ messages in thread]
UNION and bad performance
2010-12-09 10:52 UTC Olivier Pala <olivier.pala@xgs-france.com>
` Re: UNION and bad performance
2010-12-11 10:27 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: UNION and bad performance
2010-12-11 13:45 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: UNION and bad performance
2010-12-12 13:12 UTC pasman pasmański <pasman.p@gmail.com>
` Re: UNION and bad performance
2010-12-20 18:57 UTC Robert Haas <robertmhaas@gmail.com>
` Re: UNION and bad performance
2014-06-08 13:58 UTC pinker <pinker@onet.eu>
` Re: UNION and bad performance
2014-06-08 15:53 UTC David G Johnston <david.g.johnston@gmail.com>
[7+ messages in thread]
(no subject)
2014-06-06 22:15 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re:
2014-06-07 01:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re:
2014-06-07 01:45 UTC Scott Marlowe <scott.marlowe@gmail.com>
[3+ messages in thread]
CPU load spikes when CentOS tries to reclaim 'cached' memory
2014-06-05 00:27 UTC vlasmarias <vlasmarias@contigo.com>
` Re: CPU load spikes when CentOS tries to reclaim 'cached' memory
2014-06-05 15:58 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: CPU load spikes when CentOS tries to reclaim 'cached' memory
2014-06-05 19:23 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: CPU load spikes when CentOS tries to reclaim 'cached' memory
2014-06-05 19:47 UTC Deron <fecastle@gmail.com>
` Re: CPU load spikes when CentOS tries to reclaim 'cached' memory
2014-06-05 19:57 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: CPU load spikes when CentOS tries to reclaim 'cached' memory
2014-06-05 23:57 UTC Vincent Lasmarias <vlasmarias@contigo.com>
` Re: CPU load spikes when CentOS tries to reclaim 'cached' memory
2014-06-06 09:17 UTC Steven Crandell <steven.crandell@gmail.com>
` Re: CPU load spikes when CentOS tries to reclaim 'cached' memory
2014-06-06 21:32 UTC Merlin Moncure <mmoncure@gmail.com>
[8+ messages in thread]
Seqscan on big table, when an Index-Usage should be possible
2014-06-05 19:36 UTC Weinzierl Stefan <Stefan@weinzierl-stefan.de>
` Re: Seqscan on big table, when an Index-Usage should be possible
2014-06-05 20:20 UTC Igor Neyman <ineyman@perceptron.com>
[2+ messages in thread]
High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available
2014-06-02 23:43 UTC Vince Lasmarias <vincent.lasmarias@gmail.com>
` Re: High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available
2014-06-05 13:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available
2014-06-05 20:03 UTC Merlin Moncure <mmoncure@gmail.com>
[3+ messages in thread]
Possible performance regression in PostgreSQL 9.2/9.3?
2014-06-04 13:56 UTC Linos <info@linos.es>
` Re: Possible performance regression in PostgreSQL 9.2/9.3?
2014-06-04 19:36 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Possible performance regression in PostgreSQL 9.2/9.3?
2014-06-04 19:58 UTC Linos <info@linos.es>
` Re: Possible performance regression in PostgreSQL 9.2/9.3?
2014-06-04 20:57 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Possible performance regression in PostgreSQL 9.2/9.3?
2014-06-04 22:09 UTC Linos <info@linos.es>
` Re: Possible performance regression in PostgreSQL 9.2/9.3?
2014-06-05 13:29 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Possible performance regression in PostgreSQL 9.2/9.3?
2014-06-05 13:36 UTC Linos <info@linos.es>
[7+ messages in thread]
parse/bind/execute
2014-06-05 01:32 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: parse/bind/execute
2014-06-05 01:57 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: parse/bind/execute
2014-06-05 02:20 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: parse/bind/execute
2014-06-05 02:34 UTC David Johnston <david.g.johnston@gmail.com>
[4+ 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