pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedgroup 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]
CPU spikes and transactions
2013-10-14 23:00 UTC Tony Kay <tony@teamunify.com>
` Re: CPU spikes and transactions
2013-10-14 23:26 UTC Tony Kay <tony@teamunify.com>
` Re: CPU spikes and transactions
2013-10-14 23:42 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: CPU spikes and transactions
2013-10-14 23:45 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: CPU spikes and transactions
2013-10-15 13:00 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: CPU spikes and transactions
2013-10-15 15:59 UTC Tony Kay <tony@teamunify.com>
` Re: CPU spikes and transactions
2013-10-15 16:09 UTC Tony Kay <tony@teamunify.com>
` Re: CPU spikes and transactions
2013-10-15 17:26 UTC Julien Cigar <jcigar@ulb.ac.be>
` Re: CPU spikes and transactions
2013-10-15 19:07 UTC Tony Kay <tony@teamunify.com>
` Re: CPU spikes and transactions
2013-10-15 19:41 UTC Julien Cigar <jcigar@ulb.ac.be>
` Re: CPU spikes and transactions
2013-10-15 21:46 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: CPU spikes and transactions
2013-10-16 03:14 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: CPU spikes and transactions
2014-05-13 23:04 UTC Dave Owens <dave@teamunify.com>
` Re: CPU spikes and transactions
2014-05-14 13:48 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: CPU spikes and transactions
2014-05-14 16:28 UTC Jeff Janes <jeff.janes@gmail.com>
[15+ messages in thread]
Constraint exclusion won't exclude parent table
2014-05-13 20:02 UTC Tim Kane <tim.kane@gmail.com>
` Re: Constraint exclusion won't exclude parent table
2014-05-13 20:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Constraint exclusion won't exclude parent table
2014-05-13 20:57 UTC Tim Kane <tim.kane@gmail.com>
[3+ messages in thread]
Adaptive query execution
2014-05-13 20:08 UTC Tim Kane <tim.kane@gmail.com>
` Re: Adaptive query execution
2014-05-13 20:13 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Adaptive query execution
2014-05-13 20:33 UTC Tim Kane <tim.kane@gmail.com>
[3+ messages in thread]
Specifications for a new server
2014-05-06 09:13 UTC Johann Spies <johann.spies@gmail.com>
` Re: Specifications for a new server
2014-05-06 09:25 UTC DFE <mimmopasticcio@gmail.com>
` Re: Specifications for a new server
2014-05-06 11:07 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Specifications for a new server
2014-05-06 11:15 UTC Dorian Hoxha <dorian.hoxha@gmail.com>
` Re: Specifications for a new server
2014-05-06 11:24 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Specifications for a new server
2014-05-06 14:43 UTC Dorian Hoxha <dorian.hoxha@gmail.com>
` Re: Specifications for a new server
2014-05-07 21:35 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: [PERFORM] Specifications for a new server
2014-05-08 05:20 UTC r.etzenhammer@t-online.de <r.etzenhammer@t-online.de>
` Re: Specifications for a new server
2014-05-08 08:11 UTC Johann Spies <johann.spies@gmail.com>
` Re: Specifications for a new server
2014-05-08 08:28 UTC Johann Spies <johann.spies@gmail.com>
` Re: Specifications for a new server
2014-05-08 11:44 UTC Dorian Hoxha <dorian.hoxha@gmail.com>
` Re: Specifications for a new server
2014-05-13 14:19 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Specifications for a new server
2014-05-13 17:12 UTC Jeff Janes <jeff.janes@gmail.com>
[13+ messages in thread]
Check memory consumption of postgresql query
2014-05-08 07:04 UTC Phan Công Minh <cphan@hsr.ch>
` Re: Check memory consumption of postgresql query
2014-05-08 14:04 UTC Clinton Adams <clinton.adams@gmail.com>
` Re: Check memory consumption of postgresql query
2014-05-12 07:02 UTC Phan Công Minh <cphan@hsr.ch>
` Re: Check memory consumption of postgresql query
2014-05-12 16:38 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
[4+ messages in thread]
9.2.4 vs 9.3.0 query planning (sort merge join vs hash join)
2014-05-12 10:45 UTC Tim Kane <tim.kane@gmail.com>
` Re: 9.2.4 vs 9.3.0 query planning (sort merge join vs hash join)
2014-05-12 11:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 9.2.4 vs 9.3.0 query planning (sort merge join vs hash join)
2014-05-12 12:22 UTC Tim Kane <tim.kane@gmail.com>
` Re: 9.2.4 vs 9.3.0 query planning (sort merge join vs hash join)
2014-05-12 16:02 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
Postgresql 9.3 for a Mobile Backend
2014-05-08 07:10 UTC Rajiv Kasera <rajiv.kasera@pinelabs.com>
` Re: Postgresql 9.3 for a Mobile Backend
2014-05-08 07:31 UTC desmodemone <desmodemone@gmail.com>
` Re: Postgresql 9.3 for a Mobile Backend
2014-05-08 22:59 UTC Tomas Vondra <tv@fuzzy.cz>
[3+ messages in thread]
Re: recently and selectively slow, but very simple, update query....
2014-05-05 21:21 UTC Stelios Mavromichalis <mstelios@cytech.gr>
` Re: recently and selectively slow, but very simple, update query....
2014-05-05 21:51 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Re: recently and selectively slow, but very simple, update query....
2014-05-05 22:06 UTC Stelios Mavromichalis <mstelios@cytech.gr>
` Re: recently and selectively slow, but very simple, update query....
2014-05-05 23:54 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Re: recently and selectively slow, but very simple, update query....
2014-05-06 13:31 UTC Stelios Mavromichalis <mstelios@cytech.gr>
` Re: Re: recently and selectively slow, but very simple, update query....
2014-05-07 15:57 UTC Stelios Mavromichalis <mstelios@cytech.gr>
[6+ messages in thread]
Re: PostgreSQL's query planner is using the wrong index, what can I do to improve this situation?
2014-05-04 20:51 UTC David G Johnston <david.g.johnston@gmail.com>
Optimize query for listing un-read messages
2014-05-01 11:26 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Optimize query for listing un-read messages
2014-05-01 18:35 UTC Jochem Berndsen <jochem@functor.nl>
` Re: Optimize query for listing un-read messages
2014-05-01 19:17 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Optimize query for listing un-read messages
2014-05-01 19:30 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Optimize query for listing un-read messages
2014-05-01 19:39 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Optimize query for listing un-read messages
2014-05-01 19:53 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Optimize query for listing un-read messages
2014-05-01 20:30 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Optimize query for listing un-read messages
2014-05-01 21:02 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Optimize query for listing un-read messages
2014-05-01 21:19 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Optimize query for listing un-read messages
2014-05-01 21:19 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Optimize query for listing un-read messages
2014-05-01 21:31 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Optimize query for listing un-read messages
2014-05-01 21:45 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Optimize query for listing un-read messages
2014-05-01 21:58 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Optimize query for listing un-read messages
2014-05-01 22:34 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Optimize query for listing un-read messages
2014-05-01 22:38 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Optimize query for listing un-read messages
2014-05-01 22:55 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Optimize query for listing un-read messages
2014-05-01 23:51 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Optimize query for listing un-read messages
2014-05-01 23:58 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Optimize query for listing un-read messages
2014-05-02 00:10 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Optimize query for listing un-read messages
2014-05-02 00:17 UTC Craig James <cjames@emolecules.com>
` Re: Optimize query for listing un-read messages
2014-05-02 07:20 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Optimize query for listing un-read messages
2014-05-02 17:28 UTC Vitalii Tymchyshyn <vit@tym.im>
[22+ messages in thread]
Revisiting disk layout on ZFS systems
2014-04-28 15:47 UTC Karl Denninger <karl@denninger.net>
` Re: Revisiting disk layout on ZFS systems
2014-04-28 18:04 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Revisiting disk layout on ZFS systems
2014-04-28 18:07 UTC Karl Denninger <karl@denninger.net>
` Re: Revisiting disk layout on ZFS systems
2014-04-28 18:22 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Revisiting disk layout on ZFS systems
2014-04-28 18:26 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Revisiting disk layout on ZFS systems
2014-04-28 18:27 UTC Karl Denninger <karl@denninger.net>
` Re: Revisiting disk layout on ZFS systems
2014-04-28 18:29 UTC Karl Denninger <karl@denninger.net>
` Re: Revisiting disk layout on ZFS systems
2014-04-29 08:13 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Revisiting disk layout on ZFS systems
2014-04-29 12:12 UTC Karl Denninger <karl@denninger.net>
` Re: Revisiting disk layout on ZFS systems
2014-05-01 21:34 UTC Josh Berkus <josh@agliodbs.com>
[10+ messages in thread]
Slow queries on 9.3.1 despite use of index
2014-04-28 17:12 UTC Michael van Rooyen <michael@loot.co.za>
` Re: Slow queries on 9.3.1 despite use of index
2014-04-28 17:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow queries on 9.3.1 despite use of index
2014-04-28 17:52 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow queries on 9.3.1 despite use of index
2014-04-28 21:22 UTC Michael van Rooyen <michael@loot.co.za>
` Re: Slow queries on 9.3.1 despite use of index
2014-04-28 23:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow queries on 9.3.1 despite use of index
2014-04-29 14:17 UTC Michael van Rooyen <michael@loot.co.za>
[6+ messages in thread]
Checkpoints and slow queries
2014-04-27 12:08 UTC Elanchezhiyan Elango <elanelango@gmail.com>
` Checkpoints and slow queries
2014-04-27 21:01 UTC Elanchezhiyan Elango <elanelango@gmail.com>
` Re: Checkpoints and slow queries
2014-04-27 22:46 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Checkpoints and slow queries
2014-04-28 05:50 UTC Elanchezhiyan Elango <elanelango@gmail.com>
` Re: Checkpoints and slow queries
2014-04-28 14:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Checkpoints and slow queries
2014-04-28 20:41 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Checkpoints and slow queries
2014-04-28 20:54 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Checkpoints and slow queries
2014-04-28 20:59 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Checkpoints and slow queries
2014-04-28 21:10 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Checkpoints and slow queries
2014-04-28 21:19 UTC Tomas Vondra <tv@fuzzy.cz>
[10+ messages in thread]
Varying performacne results after instance restart
2014-04-28 13:41 UTC MadDamon <soullinuxer@web.de>
[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