pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedBig number of connections
2016-03-31 19:08 UTC Jarek <jarek@poczta.srv.pl>
` Re: Big number of connections
2016-03-31 19:12 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Big number of connections
2016-03-31 19:51 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Big number of connections
2016-03-31 22:47 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Big number of connections
2016-03-31 23:12 UTC Chris Cogdon <chris@cogdon.org>
` Re: Big number of connections
2016-03-31 23:27 UTC Karl Denninger <karl@denninger.net>
` Re: Big number of connections
2016-04-01 07:54 UTC jarek <jarek@poczta.srv.pl>
` Re: Big number of connections
2016-04-03 17:18 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Big number of connections
2016-04-04 13:14 UTC Mike Sofen <msofen@runbox.com>
` Re: Big number of connections
2016-04-04 13:33 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Big number of connections
2016-04-04 14:43 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Big number of connections
2016-04-04 14:54 UTC Artem Tomyuk <admin@leboutique.com>
` Re: Big number of connections
2016-04-04 15:00 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Big number of connections
2016-04-04 15:03 UTC Artem Tomyuk <admin@leboutique.com>
` Re: Big number of connections
2016-04-04 15:06 UTC Pavel Stehule <pavel.stehule@gmail.com>
[15+ messages in thread]
Searching GIN-index (FTS) and sort by timestamp-column
2016-03-16 09:00 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-16 13:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-16 13:53 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-16 14:01 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-16 14:52 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-16 15:04 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-16 15:07 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-16 15:08 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-16 15:17 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-17 17:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-17 17:30 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-17 17:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-19 02:44 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-21 14:41 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-21 15:13 UTC Oleg Bartunov <obartunov@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-21 15:33 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-03-22 16:41 UTC Oleg Bartunov <obartunov@gmail.com>
` Re: Searching GIN-index (FTS) and sort by timestamp-column
2016-04-03 02:53 UTC Jeff Janes <jeff.janes@gmail.com>
[18+ messages in thread]
Fast HashJoin only after a cluster/recreate table
2016-04-01 02:44 UTC Alexandre de Arruda Paes <adaldeia@gmail.com>
` Re: Fast HashJoin only after a cluster/recreate table
2016-04-01 13:17 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Fast HashJoin only after a cluster/recreate table
2016-04-01 17:34 UTC Alexandre de Arruda Paes <adaldeia@gmail.com>
[3+ messages in thread]
Query not using index
2005-12-09 09:36 UTC Kaloyan Iliev <news1@faith.digsys.bg>
` Re: Query not using index
2005-12-09 15:06 UTC Jaime Casanova <systemguards@gmail.com>
` Re: Query not using index
2005-12-09 16:38 UTC Kaloyan Iliev <kaloyan@mbox.digsys.bg>
` Re: Query not using index
2005-12-09 16:39 UTC Kaloyan Iliev <news1@faith.digsys.bg>
` query not using index
2013-12-19 13:06 UTC Johann Spies <johann.spies@gmail.com>
` Re: query not using index
2013-12-19 14:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query not using index
2013-12-23 08:58 UTC Johann Spies <johann.spies@gmail.com>
` Re: query not using index
2013-12-28 02:31 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Query not using Index
2016-03-26 13:14 UTC Wei Shan <weishan.ang@gmail.com>
` Re: Query not using Index
2016-03-26 14:13 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Query not using Index
2016-03-27 16:12 UTC Wei Shan <weishan.ang@gmail.com>
` Re: Query not using Index
2016-03-27 19:20 UTC Jeff Janes <jeff.janes@gmail.com>
[12+ messages in thread]
Architectural question
2016-02-11 18:06 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Architectural question
2016-02-18 20:33 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: [SPAM] Re: Architectural question
2016-02-22 14:40 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: [SPAM] Re: Architectural question
2016-03-11 16:37 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: [SPAM] Re: Architectural question
2016-03-23 09:14 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Architectural question
2016-03-23 09:50 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Architectural question
2016-03-23 10:44 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Architectural question
2016-03-23 12:29 UTC Mike Sofen <msofen@runbox.com>
` Re: Architectural question
2016-03-23 13:18 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Architectural question
2016-03-23 18:06 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: [SPAM] Re: Architectural question
2016-03-23 18:51 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: [SPAM] Re: Architectural question
2016-03-24 10:56 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
[12+ messages in thread]
Disk Benchmarking Question
2016-03-17 20:45 UTC Dave Stibrany <dstibrany@gmail.com>
` Re: Disk Benchmarking Question
2016-03-17 21:11 UTC Mike Sofen <msofen@runbox.com>
` Re: Disk Benchmarking Question
2016-03-18 14:48 UTC Dave Stibrany <dstibrany@gmail.com>
` Re: Disk Benchmarking Question
2016-03-19 03:22 UTC Mike Sofen <msofen@runbox.com>
` Re: Disk Benchmarking Question
2016-03-19 10:29 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Disk Benchmarking Question
2016-03-19 10:32 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Disk Benchmarking Question
2016-03-22 14:44 UTC Dave Stibrany <dstibrany@gmail.com>
[7+ messages in thread]
grant select on pg_stat_activity
2016-03-18 20:09 UTC avi Singh <avisingh19811981@gmail.com>
` Re: [GENERAL] grant select on pg_stat_activity
2016-03-18 21:46 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: grant select on pg_stat_activity
2016-03-21 14:15 UTC Vick Khera <vivek@khera.org>
` Re: grant select on pg_stat_activity
2016-03-21 15:19 UTC Adrian Klaver <adrian.klaver@aklaver.com>
[4+ messages in thread]
Performance decline maybe caused by multi-column index?
2016-03-18 13:26 UTC Jan Bauer Nielsen <jbn@dbc.dk>
` Re: Performance decline maybe caused by multi-column index?
2016-03-19 21:48 UTC Jeff Janes <jeff.janes@gmail.com>
[2+ messages in thread]
using shared_buffers during seq_scan
2016-03-17 09:57 UTC Artem Tomyuk <admin@leboutique.com>
` Re: using shared_buffers during seq_scan
2016-03-17 13:07 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: using shared_buffers during seq_scan
2016-03-18 10:30 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[3+ messages in thread]
Nested Loop vs Hash Join based on predicate?
2016-03-16 20:23 UTC Doiron, Daniel <DoironD@advisory.com>
` Re: Nested Loop vs Hash Join based on predicate?
2016-03-16 21:01 UTC Pavel Stehule <pavel.stehule@gmail.com>
[2+ messages in thread]
Merge joins on index scans
2016-02-26 22:07 UTC James Parks <james.parks@meraki.net>
` Re: Merge joins on index scans
2016-02-28 10:06 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Merge joins on index scans
2016-03-01 01:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Merge joins on index scans
2016-03-02 07:36 UTC James Parks <james.parks@meraki.net>
` Re: Merge joins on index scans
2016-03-14 00:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
DIsk I/O from pg_stat_activity
2016-03-13 17:39 UTC Artem Tomyuk <admin@leboutique.com>
` Re: DIsk I/O from pg_stat_activity
2016-03-13 17:50 UTC Vladimir Borodin <root@simply.name>
[2+ messages in thread]
using stale statistics instead of current ones because stats collector is not responding
2016-03-09 00:18 UTC Tory M Blue <tmblue@gmail.com>
` Re: using stale statistics instead of current ones because stats collector is not responding
2016-03-09 11:37 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[2+ messages in thread]
Odd behavior with indices
2016-02-26 19:43 UTC joe meiring <josephmeiring@gmail.com>
` Re: Odd behavior with indices
2016-02-26 20:02 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Odd behavior with indices
2016-02-26 20:38 UTC joe meiring <josephmeiring@gmail.com>
` Re: Odd behavior with indices
2016-02-26 20:56 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Odd behavior with indices
2016-02-28 13:26 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Odd behavior with indices
2016-02-29 18:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Odd behavior with indices
2016-03-04 22:18 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Odd behavior with indices
2016-03-04 23:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
[8+ messages in thread]
autovacuum disk IO
2016-03-02 15:25 UTC Artem Tomyuk <admin@leboutique.com>
` Re: [PERFORM] autovacuum disk IO
2016-03-02 15:31 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: autovacuum disk IO
2016-03-02 15:45 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: autovacuum disk IO
2016-03-02 15:49 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: [SPAM] Re: autovacuum disk IO
2016-03-02 16:11 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: [SPAM] Re: autovacuum disk IO
2016-03-02 16:21 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: [SPAM] Re: autovacuum disk IO
2016-03-02 18:40 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: [SPAM] Re: autovacuum disk IO
2016-03-02 18:54 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: [ADMIN] autovacuum disk IO
2016-03-04 17:28 UTC Jehan-Guillaume de Rorthais <ioguix@free.fr>
[9+ messages in thread]
Filesystem and Disk Partitioning for New Server Setup
2016-02-24 04:28 UTC dstibrany <dstibrany@gmail.com>
` Fwd: Filesystem and Disk Partitioning for New Server Setup
2016-02-24 11:08 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Filesystem and Disk Partitioning for New Server Setup
2016-02-24 14:25 UTC Dave Stibrany <dstibrany@gmail.com>
` Re: Filesystem and Disk Partitioning for New Server Setup
2016-02-24 15:05 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Filesystem and Disk Partitioning for New Server Setup
2016-02-24 15:44 UTC Wes Vaske (wvaske) <wvaske@micron.com>
[5+ messages in thread]
Cloud versus buying my own iron
2016-02-24 05:06 UTC Craig James <cjames@emolecules.com>
` Re: Cloud versus buying my own iron
2016-02-24 09:01 UTC Gunnar "Nick" Bluth <gunnar.bluth.extern@elster.de>
` Fwd: Cloud versus buying my own iron
2016-02-24 11:08 UTC Rick Otten <rottenwindfish@gmail.com>
[3+ messages in thread]
(no subject)
2005-05-03 15:55 UTC Steven Rosenstein <srosenst@us.ibm.com>
` Re:
2005-05-03 16:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re:
2005-05-04 11:08 UTC Mike Rylander <mrylander@gmail.com>
` Why Postgres use a little memory on Windows.
2016-02-20 16:46 UTC tuanhoanganh <hatuan05@gmail.com>
` Re: [GENERAL] Why Postgres use a little memory on Windows.
2016-02-20 18:13 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [GENERAL] Why Postgres use a little memory on Windows.
2016-02-20 18:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why Postgres use a little memory on Windows.
2016-02-20 18:39 UTC Francisco Olarte <folarte@peoplecall.com>
` Re: [GENERAL] Why Postgres use a little memory on Windows.
2016-02-20 18:58 UTC Francisco Olarte <folarte@peoplecall.com>
` Re: [GENERAL] Why Postgres use a little memory on Windows.
2016-02-20 21:49 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [PERFORM] Why Postgres use a little memory on Windows.
2016-02-21 02:21 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Why Postgres use a little memory on Windows.
2016-02-21 16:45 UTC tuanhoanganh <hatuan05@gmail.com>
[11+ messages in thread]
Primary key index suddenly became very slow
2016-02-08 09:45 UTC Gustav Karlsson <gustav.karlsson@bekk.no>
` Re: Primary key index suddenly became very slow
2016-02-08 10:04 UTC Gustav Karlsson <gustav.karlsson@bekk.no>
` Re: Primary key index suddenly became very slow
2016-02-16 12:52 UTC jaime soler <jaime.soler@gmail.com>
` Re: Primary key index suddenly became very slow
2016-02-16 20:06 UTC Venkata Balaji N <nag1010@gmail.com>
[4+ messages in thread]
Running lots of inserts from selects on 9.4.5
2016-02-10 00:09 UTC Dan Langille <dan@langille.org>
` Re: Running lots of inserts from selects on 9.4.5
2016-02-10 07:47 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Running lots of inserts from selects on 9.4.5
2016-02-10 10:13 UTC Dan Langille <dan@langille.org>
` Re: Running lots of inserts from selects on 9.4.5
2016-02-11 21:41 UTC Dan Langille <dan@langille.org>
` Re: Running lots of inserts from selects on 9.4.5
2016-02-13 15:43 UTC Dan Langille <dan@langille.org>
` Re: Running lots of inserts from selects on 9.4.5
2016-02-13 15:45 UTC Dan Langille <dan@langille.org>
[6+ messages in thread]
bad COPY performance with NOTIFY in a trigger
2016-02-04 21:12 UTC Filip Rembiałkowski <filip.rembialkowski@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-04 22:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-05 08:40 UTC Harald Fuchs <hari.fuchs@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-05 12:45 UTC Filip Rembiałkowski <filip.rembialkowski@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-05 15:33 UTC Filip Rembiałkowski <filip.rembialkowski@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-05 19:52 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-06 12:03 UTC Filip Rembiałkowski <filip.rembialkowski@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-08 14:35 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-08 22:58 UTC Merlin Moncure <mmoncure@gmail.com>
[9+ messages in thread]
gin performance issue.
2016-02-05 11:28 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: gin performance issue.
2016-02-05 15:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: gin performance issue.
2016-02-08 10:21 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: gin performance issue.
2016-02-08 19:16 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
Bitmap and-ing between btree and gin?
2016-02-04 11:15 UTC Jordi <jmaillists@promani.be>
` Re: Bitmap and-ing between btree and gin?
2016-02-04 16:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bitmap and-ing between btree and gin?
2016-02-04 17:19 UTC Jordi <jmaillists@promani.be>
` Re: Bitmap and-ing between btree and gin?
2016-02-08 18:13 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 12:30 UTC Hedayat Vatankhah <hedayat.fwd@gmail.com>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 15:57 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 17:14 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 17:31 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 18:52 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 21:50 UTC Hedayat Vatankhah <hedayat.fwd@gmail.com>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-02-08 08:50 UTC Hedayat Vatankhah <hedayat.fwd@gmail.com>
[7+ messages in thread]
View containing a recursive function
2016-02-01 07:23 UTC Mathieu De Zutter <mathieu@dezutter.org>
` Re: View containing a recursive function
2016-02-01 09:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: View containing a recursive function
2016-02-05 15:43 UTC Mathieu De Zutter <mathieu@dezutter.org>
[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