pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedCPU 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>
pl/pgsql performance
2014-04-25 08:48 UTC Mehdi Ravanbakhsh <babakco@gmail.com>
` Re: pl/pgsql performance
2014-04-25 08:53 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: pl/pgsql performance
2014-04-27 12:41 UTC Michael Paquier <michael.paquier@gmail.com>
[3+ messages in thread]
Poor performance for delete query
2014-04-24 19:42 UTC Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>
` Re: Poor performance for delete query
2014-04-24 20:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor performance for delete query
2014-04-24 20:57 UTC Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>
` Re: Poor performance for delete query
2014-04-24 21:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor performance for delete query
2014-04-25 05:04 UTC Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>
` Re: Poor performance for delete query
2014-04-25 14:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Server vacuuming the same table again and again
2014-04-25 07:47 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: Server vacuuming the same table again and again
2014-04-25 08:12 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Server vacuuming the same table again and again
2014-04-25 08:22 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: Server vacuuming the same table again and again
2014-04-25 08:29 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: Server vacuuming the same table again and again
2014-04-25 09:19 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Server vacuuming the same table again and again
2014-04-25 09:22 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Server vacuuming the same table again and again
2014-04-25 09:31 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: Server vacuuming the same table again and again
2014-04-25 09:46 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Server vacuuming the same table again and again
2014-04-25 09:47 UTC Torsten Förtsch <torsten.foertsch@gmx.net>
` Re: Server vacuuming the same table again and again
2014-04-25 10:36 UTC Дмитрий Шалашов <skaurus@gmail.com>
[10+ messages in thread]
tsearch2, large data and indexes
2014-04-19 23:15 UTC Ivan Voras <ivoras@freebsd.org>
` Re: tsearch2, large data and indexes
2014-04-22 06:40 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: tsearch2, large data and indexes
2014-04-22 07:57 UTC Ivan Voras <ivoras@freebsd.org>
` Re: tsearch2, large data and indexes
2014-04-22 15:58 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: tsearch2, large data and indexes
2014-04-23 11:08 UTC Ivan Voras <ivoras@freebsd.org>
` Re: tsearch2, large data and indexes
2014-04-23 12:26 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: tsearch2, large data and indexes
2014-04-23 13:00 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: tsearch2, large data and indexes
2014-04-23 22:56 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: tsearch2, large data and indexes
2014-04-24 11:34 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: tsearch2, large data and indexes
2014-04-24 12:34 UTC Ivan Voras <ivoras@freebsd.org>
` Re: tsearch2, large data and indexes
2014-04-24 19:27 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: tsearch2, large data and indexes
2014-04-24 19:57 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: tsearch2, large data and indexes
2014-04-25 06:37 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
[13+ messages in thread]
HFS+ pg_test_fsync performance
2014-04-14 22:32 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: HFS+ pg_test_fsync performance
2014-04-15 12:18 UTC desmodemone <desmodemone@gmail.com>
` Re: HFS+ pg_test_fsync performance
2014-04-15 14:31 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: HFS+ pg_test_fsync performance
2014-04-23 18:04 UTC Josh Berkus <josh@agliodbs.com>
` Re: HFS+ pg_test_fsync performance
2014-04-23 18:19 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: HFS+ pg_test_fsync performance
2014-04-23 18:29 UTC Josh Berkus <josh@agliodbs.com>
[6+ messages in thread]
Adding new field to big table
2014-03-14 11:30 UTC acanada <acanada@cnio.es>
` Re: Adding new field to big table
2014-03-14 16:49 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Adding new field to big table
2014-03-14 17:06 UTC acanada <acanada@cnio.es>
` Re: Adding new field to big table
2014-03-14 19:29 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Adding new field to big table
2014-03-17 09:39 UTC acanada <acanada@cnio.es>
` Re: Adding new field to big table
2014-03-18 06:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Adding new field to big table
2014-04-23 17:59 UTC RichmondDyes@monroehosp.org
[7+ messages in thread]
Best practices for update timestamp with/without triggers
2014-04-22 01:16 UTC Verghese, Riya <rverghese@cobalt.com>
` Re: Best practices for update timestamp with/without triggers
2014-04-23 10:28 UTC hubert depesz lubaczewski <depesz@depesz.com>
[2+ messages in thread]
Stalls on PGSemaphoreLock
2014-03-25 12:46 UTC Matthew Spilich <mspilich@tripadvisor.com>
` Re: Stalls on PGSemaphoreLock
2014-03-25 17:17 UTC Ray Stell <stellr@vt.edu>
` Re: Stalls on PGSemaphoreLock
2014-03-25 18:38 UTC Matthew Spilich <mspilich@tripadvisor.com>
` Re: Stalls on PGSemaphoreLock
2014-03-25 20:10 UTC Pavy Philippe <Philippe.Pavy@worldline.com>
` Re: Stalls on PGSemaphoreLock
2014-03-25 20:35 UTC Emre Hasegeli <emre@hasegeli.com>
` Re: Stalls on PGSemaphoreLock
2014-03-26 06:26 UTC Takashi Horikawa <t-horikawa@aj.jp.nec.com>
` Re: Stalls on PGSemaphoreLock
2014-03-27 07:38 UTC Gudmundsson Martin (mg) <martin.mg.gudmundsson@volvo.com>
` Re: Stalls on PGSemaphoreLock
2014-04-22 15:12 UTC Matthew Spilich <mspilich@tripadvisor.com>
` Re: Stalls on PGSemaphoreLock
2014-04-22 15:48 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
[9+ messages in thread]
Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-20 04:30 UTC Laurence Parry <greenreaper@hotmail.com>
` Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-20 04:46 UTC Oleg Bartunov <obartunov@gmail.com>
` Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-20 05:44 UTC Laurence Parry <greenreaper@hotmail.com>
` Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-22 06:28 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-22 07:15 UTC Oleg Bartunov <obartunov@gmail.com>
` Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-22 13:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Query on partitioned table not using index
2014-04-22 10:14 UTC Souquieres Adam <adam.souquieres@axege.com>
Best practice question
2014-04-22 01:19 UTC Tory M Blue <tmblue@gmail.com>
` Re: Best practice question
2014-04-22 01:31 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Best practice question
2014-04-22 02:01 UTC Sergey Konoplev <gray.ru@gmail.com>
[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