pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres 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]
group commit
2014-06-04 18:44 UTC Evgeny Shishkin <itparanoia@gmail.com>
` Re: group commit
2014-06-04 19:37 UTC David G Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
Re[2]: [PERFORM] SELECT outage in semop
2014-05-31 09:03 UTC Suren Arustamyan <suren-a@inbox.ru>
SELECT outage in semop
2014-05-30 14:55 UTC Сурен Арустамян <suren-a@inbox.ru>
` Re: SELECT outage in semop
2014-05-30 15:00 UTC Сурен Арустамян <suren-a@inbox.ru>
` Re: SELECT outage in semop
2014-05-30 15:19 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[3+ messages in thread]
NFS, file system cache and shared_buffers
2014-05-27 11:06 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: NFS, file system cache and shared_buffers
2014-05-27 12:26 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: NFS, file system cache and shared_buffers
2014-05-27 14:40 UTC Stephen Frost <sfrost@snowman.net>
` Re: NFS, file system cache and shared_buffers
2014-05-27 15:00 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: NFS, file system cache and shared_buffers
2014-05-27 15:09 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: NFS, file system cache and shared_buffers
2014-05-27 15:18 UTC David Boreham <david_list@boreham.org>
` Re: NFS, file system cache and shared_buffers
2014-05-27 15:32 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: NFS, file system cache and shared_buffers
2014-05-27 16:54 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: NFS, file system cache and shared_buffers
2014-05-27 18:20 UTC John Melesky <john.melesky@rentrakmail.com>
` Re: NFS, file system cache and shared_buffers
2014-05-28 07:50 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: NFS, file system cache and shared_buffers
2014-05-28 08:41 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: NFS, file system cache and shared_buffers
2014-05-29 00:36 UTC Josh Berkus <josh@agliodbs.com>
` Re: NFS, file system cache and shared_buffers
2014-05-30 07:12 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[13+ messages in thread]
Planner doesn't take indexes into account
2014-05-27 21:09 UTC Grzegorz Olszewski <grzegorz.olszewski@outlook.com>
` Re: Planner doesn't take indexes into account
2014-05-27 21:14 UTC AI Rumman <rummandba@gmail.com>
` Re: Planner doesn't take indexes into account
2014-05-28 09:59 UTC Grzegorz Olszewski <grzegorz.olszewski@outlook.com>
` Re: Planner doesn't take indexes into account
2014-05-28 10:22 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Planner doesn't take indexes into account
2014-05-28 13:31 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Planner doesn't take indexes into account
2014-05-28 21:03 UTC Grzegorz Olszewski <grzegorz.olszewski@outlook.com>
[6+ messages in thread]
Profiling PostgreSQL
2014-05-22 13:27 UTC Dimitris Karampinas <dkarampin@gmail.com>
` Re: Profiling PostgreSQL
2014-05-22 13:34 UTC David Boreham <david_list@boreham.org>
` Re: Profiling PostgreSQL
2014-05-22 13:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Profiling PostgreSQL
2014-05-22 23:39 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: Profiling PostgreSQL
2014-05-23 14:40 UTC Dimitris Karampinas <dkarampin@gmail.com>
` Re: Profiling PostgreSQL
2014-05-23 15:13 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Profiling PostgreSQL
2014-05-23 16:52 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Profiling PostgreSQL
2014-05-23 17:25 UTC Dimitris Karampinas <dkarampin@gmail.com>
` Re: Profiling PostgreSQL
2014-05-23 17:57 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Profiling PostgreSQL
2014-05-25 16:26 UTC Dimitris Karampinas <dkarampin@gmail.com>
` Re: Profiling PostgreSQL
2014-05-25 22:45 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
[11+ messages in thread]
same query different execution plan (hash join vs. semi-hash join)
2014-05-16 02:38 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: same query different execution plan (hash join vs. semi-hash join)
2014-05-16 02:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: same query different execution plan (hash join vs. semi-hash join)
2014-05-19 06:14 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: same query different execution plan (hash join vs. semi-hash join)
2014-05-19 14:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: same query different execution plan (hash join vs. semi-hash join)
2014-05-23 00:16 UTC Huang, Suya <Suya.Huang@au.experian.com>
[5+ messages in thread]
View has different query plan than select statement
2014-05-19 04:47 UTC Geoff Hull <geoff.hull@mccarthy.co.nz>
` Re: View has different query plan than select statement
2014-05-19 07:19 UTC David Rowley <dgrowleyml@gmail.com>
` Re: View has different query plan than select statement
2014-05-20 23:06 UTC Geoff Hull <geoff.hull@mccarthy.co.nz>
[3+ messages in thread]
Query plan good in 8.4, bad in 9.2 and better in 9.3
2014-05-15 16:35 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Query plan good in 8.4, bad in 9.2 and better in 9.3
2014-05-15 16:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan good in 8.4, bad in 9.2 and better in 9.3
2014-05-15 16:54 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Query plan good in 8.4, bad in 9.2 and better in 9.3
2014-05-19 14:50 UTC Scott Marlowe <scott.marlowe@gmail.com>
[4+ messages in thread]
Stats collector constant I/O
2014-05-15 04:18 UTC Craig James <cjames@emolecules.com>
` Re: Stats collector constant I/O
2014-05-15 08:18 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Stats collector constant I/O
2014-05-15 08:25 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Stats collector constant I/O
2014-05-15 23:27 UTC Tomas Vondra <tv@fuzzy.cz>
[4+ messages in thread]
how do functions affect query plan?
2014-05-15 05:16 UTC 常超 <chang-chao@hotmail.com>
` Re: how do functions affect query plan?
2014-05-15 05:43 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: how do functions affect query plan?
2014-05-15 06:19 UTC changchao <chang-chao@hotmail.com>
` Re: how do functions affect query plan?
2014-05-15 07:59 UTC changchao <chang-chao@hotmail.com>
` Re: FW: how do functions affect query plan?
2014-05-15 08:31 UTC 楊新波 <silent0608@gmail.com>
` Re: how do functions affect query plan?
2014-05-15 08:44 UTC changchao <chang-chao@hotmail.com>
[6+ 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