pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpg12 - partition by column that might have null values
2019-10-02 06:17 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: pg12 - partition by column that might have null values
2019-10-02 07:29 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: pg12 - partition by column that might have null values
2019-10-02 07:37 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` RE: pg12 - partition by column that might have null values
2019-10-02 12:08 UTC Mike Sofen <msofen@runbox.com>
` Re: pg12 - partition by column that might have null values
2019-10-02 13:44 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` RE: pg12 - partition by column that might have null values
2019-10-02 23:14 UTC Mike Sofen <msofen@runbox.com>
` Re: pg12 - partition by column that might have null values
2019-10-03 07:30 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: pg12 - partition by column that might have null values
2019-10-03 17:55 UTC Michael Lewis <mlewis@entrata.com>
[8+ messages in thread]
sequence depends on many tables
2019-09-25 12:39 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: sequence depends on many tables
2019-09-25 19:19 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: sequence depends on many tables
2019-09-25 19:20 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: sequence depends on many tables
2019-09-25 19:23 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: sequence depends on many tables
2019-09-29 06:05 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: sequence depends on many tables
2019-09-29 15:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Slow pg_publication_tables with many schemas and tables
2019-09-26 20:37 UTC Edilmar Alves <edilmaralves@intersite.com.br>
` Re: Slow pg_publication_tables with many schemas and tables
2019-09-26 23:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow pg_publication_tables with many schemas and tables
2019-09-27 14:25 UTC Edilmar Alves <edilmaralves@intersite.com.br>
[3+ messages in thread]
Monitor Postgres database status on Docker
2019-09-24 09:17 UTC Daulat Ram <Daulat.Ram@exponential.com>
` RE: Monitor Postgres database status on Docker
2019-09-24 09:31 UTC Fan Liu <fan.liu@ericsson.com>
` RE: Monitor Postgres database status on Docker
2019-09-24 10:05 UTC Daulat Ram <Daulat.Ram@exponential.com>
` RE: Monitor Postgres database status on Docker
2019-09-27 05:25 UTC Daulat Ram <Daulat.Ram@exponential.com>
` Re: Monitor Postgres database status on Docker
2019-09-27 12:36 UTC Olivier Gautherot <ogautherot@gautherot.net>
[5+ messages in thread]
Analyze on slave promoted.
2019-09-26 07:54 UTC Joao Junior <jcoj2006@gmail.com>
` Re: Analyze on slave promoted.
2019-09-26 08:31 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Analyze on slave promoted.
2019-09-27 10:41 UTC Vik Fearing <vik.fearing@2ndquadrant.com>
[3+ messages in thread]
Autovacuum is cleaning very less dead tuples
2019-09-27 05:40 UTC Amarendra Konda <amar.vijaya@gmail.com>
` Re: Autovacuum is cleaning very less dead tuples
2019-09-27 05:55 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[2+ messages in thread]
Bloom index cost model seems to be wrong
2019-02-12 15:08 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Bloom index cost model seems to be wrong
2019-02-12 15:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bloom index cost model seems to be wrong
2019-02-12 16:58 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Bloom index cost model seems to be wrong
2019-02-12 19:56 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Bloom index cost model seems to be wrong
2019-02-12 21:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bloom index cost model seems to be wrong
2019-02-12 22:38 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Bloom index cost model seems to be wrong
2019-02-24 16:09 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Bloom index cost model seems to be wrong
2019-02-28 18:11 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Bloom index cost model seems to be wrong
2019-02-28 18:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bloom index cost model seems to be wrong
2019-07-07 23:57 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: Bloom index cost model seems to be wrong
2019-09-25 20:12 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Bloom index cost model seems to be wrong
2019-09-26 07:00 UTC Michael Paquier <michael@paquier.xyz>
[12+ messages in thread]
Slow query on V12.
2019-09-23 18:42 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Slow query on V12.
2019-09-23 18:43 UTC nikhil raj <nikhilraj474@gmail.com>
` Re: Slow query on V12.
2019-09-23 19:03 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Slow query on V12.
2019-09-23 19:12 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Slow query on V12.
2019-09-23 19:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query on V12.
2019-09-23 20:23 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
[6+ messages in thread]
pg12 partitions question
2019-09-23 10:59 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: pg12 partitions question
2019-09-23 11:02 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
[2+ messages in thread]
Slow query on a one-tuple table
2019-09-19 16:55 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Slow query on a one-tuple table
2019-09-19 17:21 UTC Michael Lewis <mlewis@entrata.com>
` Re: Slow query on a one-tuple table
2019-09-19 18:30 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` RE: Slow query on a one-tuple table
2019-09-19 18:34 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Slow query on a one-tuple table
2019-09-19 19:59 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` RE: Slow query on a one-tuple table
2019-09-19 20:11 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Slow query on a one-tuple table
2019-09-19 20:24 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Slow query on a one-tuple table
2019-09-19 20:41 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Slow query on a one-tuple table
2019-09-19 22:27 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Slow query on a one-tuple table
2019-09-19 22:32 UTC Michael Lewis <mlewis@entrata.com>
` Re: Slow query on a one-tuple table
2019-09-19 22:46 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Slow query on a one-tuple table
2019-09-19 22:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query on a one-tuple table
2019-09-20 13:09 UTC MichaelDBA <MichaelDBA@sqlexec.com>
[13+ messages in thread]
Surprising benchmark count(1) vs. count(*)
2019-09-19 10:09 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Surprising benchmark count(1) vs. count(*)
2019-09-19 10:22 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Surprising benchmark count(1) vs. count(*)
2019-09-19 11:22 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Surprising benchmark count(1) vs. count(*)
2019-09-19 14:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Surprising benchmark count(1) vs. count(*)
2019-09-19 20:38 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Surprising benchmark count(1) vs. count(*)
2019-09-19 21:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
comparing output of internal pg tables of referenced tables
2019-09-19 15:50 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: comparing output of internal pg tables of referenced tables
2019-09-19 16:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
pg12 - migrate tables to partitions structure
2019-09-18 18:02 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: pg12 - migrate tables to partitions structure
2019-09-18 19:09 UTC Michael Lewis <mlewis@entrata.com>
` Re: pg12 - migrate tables to partitions structure
2019-09-18 19:29 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: pg12 - migrate tables to partitions structure
2019-09-18 20:08 UTC Michael Lewis <mlewis@entrata.com>
` Re: pg12 - migrate tables to partitions structure
2019-09-18 20:13 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: pg12 - migrate tables to partitions structure
2019-09-18 20:56 UTC Michael Lewis <mlewis@entrata.com>
[6+ messages in thread]
Question regarding fast-hashing in PGSQL
2019-09-18 16:41 UTC Stephen Conley <cheetah@tanabi.org>
` Re: Question regarding fast-hashing in PGSQL
2019-09-18 16:49 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Question regarding fast-hashing in PGSQL
2019-09-18 16:56 UTC Stephen Conley <cheetah@tanabi.org>
` Re: Question regarding fast-hashing in PGSQL
2019-09-18 20:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
does max_connections affect the query planner
2019-09-17 08:40 UTC Bob Jolliffe <bobjolliffe@gmail.com>
` Re: does max_connections affect the query planner
2019-09-17 14:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: does max_connections affect the query planner
2019-09-17 14:15 UTC Bob Jolliffe <bobjolliffe@gmail.com>
` Re: does max_connections affect the query planner
2019-09-17 14:25 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
Query execution time Vs Cost
2019-09-13 11:08 UTC Amarendra Konda <amar.vijaya@gmail.com>
` Re: Query execution time Vs Cost
2019-09-13 23:06 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Query execution time Vs Cost
2019-09-14 04:24 UTC Amarendra Konda <amar.vijaya@gmail.com>
[3+ messages in thread]
select distinct runs slow on pg 10.6
2019-09-09 08:30 UTC yash mehta <yash215@gmail.com>
` Re: select distinct runs slow on pg 10.6
2019-09-09 08:38 UTC yash mehta <yash215@gmail.com>
` Re: select distinct runs slow on pg 10.6
2019-09-09 10:00 UTC Flo Rance <trourance@gmail.com>
` Re: select distinct runs slow on pg 10.6
2019-09-09 10:29 UTC yash mehta <yash215@gmail.com>
` Re: select distinct runs slow on pg 10.6
2019-09-09 10:39 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: select distinct runs slow on pg 10.6
2019-09-09 13:16 UTC Flo Rance <trourance@gmail.com>
` Re: select distinct runs slow on pg 10.6
2019-09-09 15:39 UTC Michael Lewis <mlewis@entrata.com>
` Re: select distinct runs slow on pg 10.6
2019-09-10 04:53 UTC yash mehta <yash215@gmail.com>
` Re: select distinct runs slow on pg 10.6
2019-09-10 11:56 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: select distinct runs slow on pg 10.6
2019-09-11 15:54 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: select distinct runs slow on pg 10.6
2019-09-11 16:38 UTC Dinesh Somani <dinesh@opsveda.com>
` Re: select distinct runs slow on pg 10.6
2019-09-11 17:57 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: select distinct runs slow on pg 10.6
2019-09-12 14:19 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: select distinct runs slow on pg 10.6
2019-09-12 16:25 UTC Dinesh Somani <dinesh@opsveda.com>
[14+ messages in thread]
Incorrect choice of Nested Loop for a skewed distribution
2019-09-03 17:47 UTC Oleg Kharin <ok@uvadrev.ru>
` Re: Incorrect choice of Nested Loop for a skewed distribution
2019-09-05 00:18 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Incorrect choice of Nested Loop for a skewed distribution
2019-09-06 05:02 UTC Oleg Kharin <ok@uvadrev.ru>
[3+ messages in thread]
Upsert performance considerations (~1 mil/hour)
2019-09-04 17:29 UTC Fredrik Blomqvist <fredrik.blomqvist.95@gmail.com>
` Re: Upsert performance considerations (~1 mil/hour)
2019-09-04 19:58 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Upsert performance considerations (~1 mil/hour)
2019-09-04 21:18 UTC Fredrik Blomqvist <fredrik.blomqvist.95@gmail.com>
[3+ messages in thread]
UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE
2019-08-18 06:56 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE
2019-08-18 08:41 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE
2019-09-03 17:34 UTC Merlin Moncure <mmoncure@gmail.com>
[3+ messages in thread]
Erratically behaving query needs optimization
2019-08-20 13:54 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-20 14:58 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Erratically behaving query needs optimization
2019-08-20 15:07 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Erratically behaving query needs optimization
2019-08-21 07:30 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-21 11:30 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Erratically behaving query needs optimization
2019-08-22 11:51 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-22 12:10 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Erratically behaving query needs optimization
2019-08-22 12:22 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-22 12:49 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-22 17:43 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: Erratically behaving query needs optimization
2019-08-25 14:50 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-26 08:25 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
` Re: Erratically behaving query needs optimization
2019-08-26 11:51 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Erratically behaving query needs optimization
2019-09-02 21:57 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Erratically behaving query needs optimization
2019-09-03 12:41 UTC Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>
[15+ messages in thread]
Extremely slow HashAggregate in simple UNION query
2019-08-20 15:11 UTC Felix Geisendörfer <felix@felixge.de>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-20 16:19 UTC Michael Lewis <mlewis@entrata.com>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-20 16:57 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-20 17:32 UTC Andres Freund <andres@anarazel.de>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-20 17:55 UTC Felix Geisendörfer <felix@felixge.de>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-20 18:27 UTC Andres Freund <andres@anarazel.de>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-21 18:26 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-22 05:08 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-22 09:06 UTC Felix Geisendörfer <felix@felixge.de>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-24 19:16 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-24 19:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Extremely slow HashAggregate in simple UNION query
2019-08-24 19:54 UTC Andres Freund <andres@anarazel.de>
[12+ messages in thread]
pg_basebackup is taking an unusually long time with Postgres 11.3
2019-08-24 03:24 UTC andy andy <brookline.andy@gmail.com>
Extremely slow count (simple query, with index)
2019-08-22 12:44 UTC Marco Colli <collimarco91@gmail.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 13:19 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 13:25 UTC Ravikumar Reddy <urravikumarreddy@gmail.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 13:25 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 17:37 UTC Michael Lewis <mlewis@entrata.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 17:54 UTC Marco Colli <collimarco91@gmail.com>
` Re: Extremely slow count (simple query, with index)
2019-08-22 18:04 UTC Justin Pryzby <pryzby@telsasoft.com>
[7+ messages in thread]
Partial join
2019-07-29 16:43 UTC Arne Roland <A.Roland@index.de>
` Partial join
2019-08-01 08:07 UTC Arne Roland <A.Roland@index.de>
` Re: Partial join
2019-08-01 11:14 UTC Richard Guo <riguo@pivotal.io>
` Re: Partial join
2019-08-01 11:46 UTC Arne Roland <A.Roland@index.de>
` Re: Partial join
2019-08-01 14:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Partial join
2019-08-01 16:29 UTC Arne Roland <A.Roland@index.de>
` Re: Partial join
2019-08-02 09:33 UTC Richard Guo <riguo@pivotal.io>
` Re: Partial join
2019-08-02 10:00 UTC Richard Guo <riguo@pivotal.io>
` Re: Partial join
2019-08-19 15:17 UTC Arne Roland <A.Roland@index.de>
[9+ 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