pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Out of Memory errors are frustrating as heck!
2019-08-23 13:17 UTC Gunther <raj@gusw.net>
` Re: Out of Memory errors are frustrating as heck!
2019-08-23 14:19 UTC Gunther <raj@gusw.net>
` Re: Out of Memory errors are frustrating as heck!
2019-08-23 14:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Out of Memory errors are frustrating as heck!
2019-08-24 15:40 UTC Gunther <raj@gusw.net>
` Re: Out of Memory errors are frustrating as heck!
2019-10-06 21:06 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Out of Memory errors are frustrating as heck!
2019-10-06 21:11 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Out of Memory errors are frustrating as heck!
2019-10-08 17:44 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Out of Memory errors are frustrating as heck!
2019-10-08 17:50 UTC Merlin Moncure <mmoncure@gmail.com>
[8+ messages in thread]
distinct on extract returns composite type
2019-09-29 09:46 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: distinct on extract returns composite type
2019-09-29 10:34 UTC Félix GERZAGUET <felix.gerzaguet@gmail.com>
` Re: distinct on extract returns composite type
2019-09-30 13:42 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: distinct on extract returns composite type
2019-09-30 13:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: distinct on extract returns composite type
2019-09-30 13:51 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: distinct on extract returns composite type
2019-10-07 21:53 UTC Michael Lewis <mlewis@entrata.com>
[6+ messages in thread]
Slow PostgreSQL 10.6 query
2019-10-01 12:37 UTC Behrang Saeedzadeh <behrangsa@gmail.com>
` Re: Slow PostgreSQL 10.6 query
2019-10-01 13:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow PostgreSQL 10.6 query
2019-10-01 13:42 UTC Behrang Saeedzadeh <behrangsa@gmail.com>
` Re: Slow PostgreSQL 10.6 query
2019-10-06 20:37 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Slow PostgreSQL 10.6 query
2019-10-07 08:27 UTC Behrang Saeedzadeh <behrangsa@gmail.com>
[5+ messages in thread]
Delete huge Table under XFS
2019-09-19 15:59 UTC Joao Junior <jcoj2006@gmail.com>
` Re: Delete huge Table under XFS
2019-09-19 16:50 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Delete huge Table under XFS
2019-09-19 17:00 UTC Joao Junior <jcoj2006@gmail.com>
` Re: Delete huge Table under XFS
2019-09-19 17:27 UTC Christoph Berg <myon@debian.org>
` Re: Delete huge Table under XFS
2019-10-06 20:54 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[5+ messages in thread]
Query went slow all of sudden. ON V 11.3
2019-10-04 10:22 UTC nikhil raj <nikhilraj474@gmail.com>
` Re: Query went slow all of sudden. ON V 11.3
2019-10-04 13:20 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Query went slow all of sudden. ON V 11.3
2019-10-04 13:58 UTC nikhil raj <nikhilraj474@gmail.com>
` Re: Query went slow all of sudden. ON V 11.3
2019-10-04 19:07 UTC Michael Lewis <mlewis@entrata.com>
` Re: Query went slow all of sudden. ON V 11.3
2019-10-06 20:30 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[5+ messages in thread]
Some observations on very slow pg_restore operations
2019-10-03 20:30 UTC Ogden Brash <info@litika.com>
` Re: Some observations on very slow pg_restore operations
2019-10-03 21:48 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Some observations on very slow pg_restore operations
2019-10-03 23:19 UTC Ogden Brash <info@litika.com>
` Re: Some observations on very slow pg_restore operations
2019-10-04 06:03 UTC Justin Pryzby <pryzby@telsasoft.com>
[4+ messages in thread]
pg12 - 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]
[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