pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedError install -pgmemcache
2013-11-20 12:36 UTC Rogerio Pereira <rogerio.pereira@riosoft.com.br>
` Re: Error install -pgmemcache
2013-12-29 20:08 UTC Devrim GÜNDÜZ <devrim@gunduz.org>
[2+ messages in thread]
Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order.
2013-12-27 06:35 UTC Michael Kolomeitsev <mkolomeitsev@gmail.com>
` Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order.
2013-12-28 21:03 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order.
2013-12-28 21:19 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order.
2013-12-28 21:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order.
2013-12-29 00:52 UTC Michael Kolomeitsev <mkolomeitsev@gmail.com>
[5+ messages in thread]
Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 05:19 UTC ankush upadhyay <ankush.upadhyay@gmail.com>
` Re: Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 09:54 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 11:40 UTC ankush upadhyay <ankush.upadhyay@gmail.com>
` Re: Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 13:20 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 13:46 UTC ankush upadhyay <ankush.upadhyay@gmail.com>
` Re: Are there some additional postgres tuning to improve performance in multi tenant system
2013-12-28 13:54 UTC Andrew Dunstan <andrew@dunslane.net>
[6+ messages in thread]
Does fsync on/off for wal AND Checkpoint?
2013-12-27 15:55 UTC GR Vishwanath <grv144@gmail.com>
` Re: Does fsync on/off for wal AND Checkpoint?
2013-12-27 16:27 UTC Andreas Karlsson <andreas@proxel.se>
[2+ messages in thread]
Re: How to completely delete iPhone all data before selling?
2013-12-26 08:46 UTC shirleymi <shirleymi@yeah.net>
Bytea(TOAST) vs large object facility(OID)
2013-12-23 20:16 UTC kosalram Babu Chellappa <kosalram@yahoo.com>
` Re: Bytea(TOAST) vs large object facility(OID)
2013-12-24 07:55 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[2+ messages in thread]
Optimizing a query
2006-12-13 18:48 UTC James Cloos <cloos@jhcloos.com>
` Re: Optimizing a query
2006-12-13 19:25 UTC Tomeh, Husam <htomeh@firstam.com>
` Re: Optimizing a query
2006-12-13 21:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizing a query
2006-12-13 22:35 UTC James Cloos <cloos@jhcloos.com>
` Re: Optimizing a query
2006-12-13 23:15 UTC Tomeh, Husam <htomeh@firstam.com>
` Optimizing a query
2013-12-18 02:48 UTC Kai Sellgren <kaisellgren@gmail.com>
` Re: Optimizing a query
2013-12-19 17:53 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Optimizing a query
2013-12-24 00:32 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[8+ messages in thread]
slow query - will CLUSTER help?
2013-12-12 17:30 UTC Sev Zaslavsky <sevzas@gmail.com>
` Re: slow query - will CLUSTER help?
2013-12-19 18:19 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: slow query - will CLUSTER help?
2013-12-19 20:14 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: slow query - will CLUSTER help?
2013-12-19 20:33 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: slow query - will CLUSTER help?
2013-12-19 20:34 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: slow query - will CLUSTER help?
2013-12-19 21:24 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: slow query - will CLUSTER help?
2013-12-20 14:42 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: slow query - will CLUSTER help?
2013-12-20 16:11 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: slow query - will CLUSTER help?
2013-12-20 21:19 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: slow query - will CLUSTER help?
2013-12-23 16:41 UTC Shaun Thomas <sthomas@optionshouse.com>
[10+ messages in thread]
Strange number of rows in plan cost
2013-12-23 06:32 UTC Алексей Кузнецов <alex_kuznetcov@mail.ru>
Unexpected pgbench result
2013-12-19 17:00 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Unexpected pgbench result
2013-12-19 17:44 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Unexpected pgbench result
2013-12-19 22:06 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Unexpected pgbench result
2013-12-20 14:10 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Unexpected pgbench result
2013-12-20 15:02 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Unexpected pgbench result
2013-12-20 15:22 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Unexpected pgbench result
2013-12-20 15:40 UTC Dave Johansen <davejohansen@gmail.com>
[7+ messages in thread]
Regarding Hardware Tuning
2013-12-18 20:12 UTC prashant Pandey <prashantpandeyfun10@gmail.com>
` Re: Regarding Hardware Tuning
2013-12-19 23:40 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Regarding Hardware Tuning
2013-12-20 00:37 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Regarding Hardware Tuning
2013-12-20 14:29 UTC Shaun Thomas <sthomas@optionshouse.com>
[4+ messages in thread]
Problem with slow query with WHERE conditions with OR clause on primary keys
2013-12-10 23:30 UTC Krzysztof Olszewski <kolszew73@gmail.com>
` Re: Problem with slow query with WHERE conditions with OR clause on primary keys
2013-12-11 07:18 UTC David Johnston <polobo@yahoo.com>
` Re: Problem with slow query with WHERE conditions with OR clause on primary keys
2013-12-18 19:23 UTC kolszew73@gmail.com <kolszew73@gmail.com>
` Re: Problem with slow query with WHERE conditions with OR clause on primary keys
2013-12-18 20:12 UTC David Johnston <polobo@yahoo.com>
` Re: Problem with slow query with WHERE conditions with OR clause on primary keys
2013-12-19 01:32 UTC Andreas Karlsson <andreas@proxel.se>
` Re: Re: Problem with slow query with WHERE conditions with OR clause on primary keys
2013-12-19 17:29 UTC Pavel Stehule <pavel.stehule@gmail.com>
[6+ messages in thread]
Current query of the PL/pgsql procedure.
2013-12-15 16:18 UTC Yuri Levinsky <yuril@celltick.com>
` Re: Current query of the PL/pgsql procedure.
2013-12-15 18:05 UTC Craig James <cjames@emolecules.com>
` Re: Current query of the PL/pgsql procedure.
2013-12-16 10:26 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Current query of the PL/pgsql procedure.
2013-12-16 11:42 UTC Yuri Levinsky <yuril@celltick.com>
` Re: Current query of the PL/pgsql procedure.
2013-12-16 12:47 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Current query of the PL/pgsql procedure.
2013-12-16 13:29 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Current query of the PL/pgsql procedure.
2013-12-18 08:30 UTC Guillaume Lelarge <guillaume@lelarge.info>
[7+ messages in thread]
Adding an additional join causes very different/slow query plan
2013-12-16 21:52 UTC Joe Van Dyk <joe@tanga.com>
` Re: Adding an additional join causes very different/slow query plan
2013-12-16 21:59 UTC Joe Van Dyk <joe@tanga.com>
` Re: Adding an additional join causes very different/slow query plan
2013-12-17 00:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Adding an additional join causes very different/slow query plan
2013-12-17 00:37 UTC Joe Van Dyk <joe@tanga.com>
` Re: Adding an additional join causes very different/slow query plan
2013-12-17 14:01 UTC Stephen Frost <sfrost@snowman.net>
[5+ messages in thread]
Help with cursor query that is intermittently slow
2013-12-16 20:54 UTC Drew Jetter <djetter@micronetsol.net>
Slow query due to slow I/O
2013-12-12 20:10 UTC Bryce Covert <bryce@brycecovertoperations.com>
` Re: Slow query due to slow I/O
2013-12-12 20:15 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Slow query due to slow I/O
2013-12-12 20:20 UTC Bryce Covert <bryce@brycecovertoperations.com>
` Re: Slow query due to slow I/O
2013-12-12 20:48 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Slow query due to slow I/O
2013-12-12 21:16 UTC Bryce Covert <bryce@brycecovertoperations.com>
` Re: Slow query due to slow I/O
2013-12-12 21:24 UTC Bryce Covert <bryce@brycecovertoperations.com>
` Re: Slow query due to slow I/O
2013-12-12 21:35 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Slow query due to slow I/O
2013-12-12 21:49 UTC Bryce Covert <bryce@brycecovertoperations.com>
` Re: Slow query due to slow I/O
2013-12-12 23:04 UTC Bryce Covert <bryce@brycecovertoperations.com>
` Re: Slow query due to slow I/O
2013-12-12 23:39 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Slow query due to slow I/O
2013-12-13 00:01 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow query due to slow I/O
2013-12-13 00:03 UTC Bryce Covert <bryce@brycecovertoperations.com>
[12+ messages in thread]
slow loading of pages for SELECT query - will CLUSTER help?
2013-12-12 21:08 UTC Sev Zaslavsky <sevzas@gmail.com>
Debugging shared memory issues on CentOS
2013-12-07 03:21 UTC Mack Talcott <mack.talcott@gmail.com>
` Re: Debugging shared memory issues on CentOS
2013-12-11 04:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Debugging shared memory issues on CentOS
2013-12-11 08:23 UTC Mack Talcott <mack.talcott@gmail.com>
` Re: Debugging shared memory issues on CentOS
2013-12-12 03:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Debugging shared memory issues on CentOS
2013-12-12 08:25 UTC Mack Talcott <mack.talcott@gmail.com>
` Re: Debugging shared memory issues on CentOS
2013-12-12 14:56 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Debugging shared memory issues on CentOS
2013-12-12 15:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
[7+ messages in thread]
ORDER BY using index, tsearch2
2013-12-11 22:29 UTC Janek Sendrowski <janek12@web.de>
` Re: ORDER BY using index, tsearch2
2013-12-11 23:38 UTC Craig James <cjames@emolecules.com>
` Re: ORDER BY using index, tsearch2
2013-12-11 23:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: ORDER BY using index, tsearch2
2013-12-12 01:00 UTC Janek Sendrowski <janek12@web.de>
` Re: ORDER BY using index, tsearch2
2013-12-12 03:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: ORDER BY using index, tsearch2
2013-12-12 13:16 UTC Janek Sendrowski <janek12@web.de>
[6+ messages in thread]
select count(distinct ...) is slower than select distinct in about 5x
2013-12-06 02:10 UTC jacket41142 <jacket41142@gmail.com>
` select count(distinct ...) is slower than select distinct in about 5x
2013-12-10 17:28 UTC jacket41142 <jacket41142@gmail.com>
` Re: select count(distinct ...) is slower than select distinct in about 5x
2013-12-10 18:16 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: select count(distinct ...) is slower than select distinct in about 5x
2013-12-10 18:19 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: select count(distinct ...) is slower than select distinct in about 5x
2013-12-11 01:23 UTC jacket41142 <jacket41142@gmail.com>
` Re: select count(distinct ...) is slower than select distinct in about 5x
2013-12-11 01:57 UTC jacket41142 <jacket41142@gmail.com>
` Re: select count(distinct ...) is slower than select distinct in about 5x
2013-12-11 02:24 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: select count(distinct ...) is slower than select distinct in about 5x
2013-12-12 03:22 UTC jacket41142 <jacket41142@gmail.com>
[8+ messages in thread]
ORDER BY using index, tsearch2 [READ THIS!]
2013-12-11 22:31 UTC Janek Sendrowski <janek12@web.de>
` Re: ORDER BY using index, tsearch2 [READ THIS!]
2013-12-11 23:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
When is a query slow?
2013-12-11 15:41 UTC Michael Sacket <msacket@gammastream.com>
Explain analyze time overhead
2013-12-05 14:09 UTC salah jubeh <s_jubeh@yahoo.com>
` Re: Explain analyze time overhead
2013-12-05 14:21 UTC vincent elschot <vinny@xs4all.nl>
` Re: Explain analyze time overhead
2013-12-05 14:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Explain analyze time overhead
2013-12-05 14:43 UTC salah jubeh <s_jubeh@yahoo.com>
` Re: Explain analyze time overhead
2013-12-05 20:29 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Explain analyze time overhead
2013-12-10 20:40 UTC Bruce Momjian <bruce@momjian.us>
` Re: Explain analyze time overhead
2013-12-10 21:53 UTC salah jubeh <s_jubeh@yahoo.com>
` Re: Explain analyze time overhead
2013-12-10 21:59 UTC Bruce Momjian <bruce@momjian.us>
[8+ messages in thread]
Parallel Select query performance and shared buffers
2013-11-27 08:28 UTC Metin Doslu <metin@citusdata.com>
` Parallel Select query performance and shared buffers
2013-12-03 13:41 UTC Metin Doslu <metin@citusdata.com>
` Parallel Select query performance and shared buffers
2013-12-03 13:49 UTC Metin Doslu <metin@citusdata.com>
` Re: Parallel Select query performance and shared buffers
2013-12-03 13:53 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Parallel Select query performance and shared buffers
2013-12-03 15:56 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Parallel Select query performance and shared buffers
2013-12-03 16:24 UTC Metin Doslu <metin@citusdata.com>
` Re: Parallel Select query performance and shared buffers
2013-12-03 16:32 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Parallel Select query performance and shared buffers
2013-12-04 03:57 UTC Amit Kapila <amit.kapila16@gmail.com>
` Re: Parallel Select query performance and shared buffers
2013-12-04 05:10 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Parallel Select query performance and shared buffers
2013-12-04 12:19 UTC Metin Doslu <metin@citusdata.com>
` Re: [PERFORM] Parallel Select query performance and shared buffers
2013-12-04 13:19 UTC Metin Doslu <metin@citusdata.com>
` Re: [HACKERS] Parallel Select query performance and shared buffers
2013-12-04 16:27 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: [HACKERS] Parallel Select query performance and shared buffers
2013-12-04 16:33 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Parallel Select query performance and shared buffers
2013-12-04 16:35 UTC Metin Doslu <metin@citusdata.com>
` Re: Parallel Select query performance and shared buffers
2013-12-04 16:43 UTC Metin Doslu <metin@citusdata.com>
` Re: Parallel Select query performance and shared buffers
2013-12-04 16:54 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Parallel Select query performance and shared buffers
2013-12-04 18:00 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: [HACKERS] Parallel Select query performance and shared buffers
2013-12-04 18:03 UTC Metin Doslu <metin@citusdata.com>
` Re: Parallel Select query performance and shared buffers
2013-12-04 18:04 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Parallel Select query performance and shared buffers
2013-12-04 18:06 UTC Metin Doslu <metin@citusdata.com>
` Re: Parallel Select query performance and shared buffers
2013-12-04 18:19 UTC Metin Doslu <metin@citusdata.com>
` Re: [HACKERS] Parallel Select query performance and shared buffers
2013-12-04 18:26 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Parallel Select query performance and shared buffers
2013-12-04 18:28 UTC Metin Doslu <metin@citusdata.com>
` Re: Parallel Select query performance and shared buffers
2013-12-05 04:03 UTC Amit Kapila <amit.kapila16@gmail.com>
` Re: Parallel Select query performance and shared buffers
2013-12-05 04:16 UTC Amit Kapila <amit.kapila16@gmail.com>
` Re: Parallel Select query performance and shared buffers
2013-12-05 09:15 UTC Metin Doslu <metin@citusdata.com>
` Re: Parallel Select query performance and shared buffers
2013-12-05 09:18 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Parallel Select query performance and shared buffers
2013-12-05 09:33 UTC Metin Doslu <metin@citusdata.com>
` Re: Parallel Select query performance and shared buffers
2013-12-05 09:42 UTC Andres Freund <andres@2ndquadrant.com>
` Re: [HACKERS] Parallel Select query performance and shared buffers
2013-12-05 15:46 UTC Metin Doslu <metin@citusdata.com>
` Re: [HACKERS] Parallel Select query performance and shared buffers
2013-12-05 15:52 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Parallel Select query performance and shared buffers
2013-12-05 15:57 UTC Metin Doslu <metin@citusdata.com>
` Re: Parallel Select query performance and shared buffers
2013-12-05 16:03 UTC Metin Doslu <metin@citusdata.com>
` Re: Parallel Select query performance and shared buffers
2013-12-05 18:13 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Parallel Select query performance and shared buffers
2013-12-10 20:03 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Parallel Select query performance and shared buffers
2013-12-10 20:06 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Parallel Select query performance and shared buffers
2013-12-10 20:20 UTC Merlin Moncure <mmoncure@gmail.com>
[37+ messages in thread]
Hash join
2013-12-10 09:45 UTC mspasic@openlinksw.com
[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