pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedOracle to postgresql
2020-12-18 10:43 UTC bangalore umesh <bangalore.raj@gmail.com>
` Re: Oracle to postgresql
2020-12-18 11:14 UTC Ian Lawrence Barwick <barwick@gmail.com>
[2+ messages in thread]
Performance issues with composite types (partitioned table)
2020-12-14 15:01 UTC Sebastijan Wieser <swieser.hr@gmail.com>
"Required checkpoints occurs too frequently"
2020-12-11 08:12 UTC Atul Kumar <akumar14871@gmail.com>
` Re: "Required checkpoints occurs too frequently"
2020-12-11 08:51 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: "Required checkpoints occurs too frequently"
2020-12-11 09:02 UTC Atul Kumar <akumar14871@gmail.com>
` Re: "Required checkpoints occurs too frequently"
2020-12-11 09:19 UTC Amine Tengilimoglu <aminetengilimoglu@gmail.com>
` Re: "Required checkpoints occurs too frequently"
2020-12-11 14:34 UTC Atul Kumar <akumar14871@gmail.com>
` Re: "Required checkpoints occurs too frequently"
2020-12-11 16:15 UTC Christophe Pettus <xof@thebuild.com>
[6+ messages in thread]
Index for range queries on JSON (user defined fields)
2020-12-04 15:39 UTC Marco Colli <collimarco91@gmail.com>
` Re: Index for range queries on JSON (user defined fields)
2020-12-04 22:39 UTC Nick Cleaton <nick@cleaton.net>
` Re: Index for range queries on JSON (user defined fields)
2020-12-05 10:50 UTC Marco Colli <collimarco91@gmail.com>
[3+ messages in thread]
PostgeSQL JSONB Column with various type of data
2020-12-04 10:45 UTC Riswana Rahman <riswana@temenos.com>
` Re: PostgeSQL JSONB Column with various type of data
2020-12-04 16:31 UTC Michael Lewis <mlewis@entrata.com>
[2+ messages in thread]
Pg_locks and pg_stat_activity
2020-12-01 16:11 UTC aditya desai <admad123@gmail.com>
` Re: Pg_locks and pg_stat_activity
2020-12-02 10:36 UTC aditya desai <admad123@gmail.com>
` Re: Pg_locks and pg_stat_activity
2020-12-04 06:13 UTC aditya desai <admad123@gmail.com>
` Re: Pg_locks and pg_stat_activity
2020-12-04 06:41 UTC Ravikumar Reddy <urravikumarreddy@gmail.com>
` Re: Pg_locks and pg_stat_activity
2020-12-04 06:48 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Pg_locks and pg_stat_activity
2020-12-04 07:52 UTC Kyotaro Horiguchi <horikyota.ntt@gmail.com>
` Re: Pg_locks and pg_stat_activity
2020-12-04 08:01 UTC aditya desai <admad123@gmail.com>
` Re: Pg_locks and pg_stat_activity
2020-12-04 08:04 UTC aditya desai <admad123@gmail.com>
` Re: Pg_locks and pg_stat_activity
2020-12-04 08:17 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Pg_locks and pg_stat_activity
2020-12-04 08:34 UTC aditya desai <admad123@gmail.com>
[10+ messages in thread]
Temporarily disable not null constraints
2020-12-03 19:58 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Temporarily disable not null constraints
2020-12-03 20:09 UTC Michael Lewis <mlewis@entrata.com>
` Re: Temporarily disable not null constraints
2020-12-03 20:13 UTC Milos Babic <milos.babic@gmail.com>
` Re: Temporarily disable not null constraints
2020-12-03 22:34 UTC Justin Pryzby <pryzby@telsasoft.com>
[4+ messages in thread]
time taking deletion on large tables
2020-12-03 08:49 UTC Atul Kumar <akumar14871@gmail.com>
` time taking deletion on large tables
2020-12-03 14:45 UTC Atul Kumar <akumar14871@gmail.com>
` time taking deletion on large tables
2020-12-03 14:45 UTC Atul Kumar <akumar14871@gmail.com>
` time taking deletion on large tables
2020-12-03 14:46 UTC Atul Kumar <akumar14871@gmail.com>
` time taking deletion on large tables
2020-12-03 14:47 UTC Atul Kumar <akumar14871@gmail.com>
` time taking deletion on large tables
2020-12-03 14:49 UTC Atul Kumar <akumar14871@gmail.com>
` Re: time taking deletion on large tables
2020-12-03 14:51 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: time taking deletion on large tables
2020-12-03 15:13 UTC Ravikumar Reddy <urravikumarreddy@gmail.com>
` Re: time taking deletion on large tables
2020-12-03 15:36 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: time taking deletion on large tables
2020-12-03 15:48 UTC Ron <ronljohnsonjr@gmail.com>
` Re: time taking deletion on large tables
2020-12-03 16:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: time taking deletion on large tables
2020-12-03 17:00 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: time taking deletion on large tables
2020-12-03 18:45 UTC Rui DeSousa <rui@crazybean.net>
[13+ messages in thread]
Simple update query is slow
2020-11-21 20:27 UTC Nandakumar M <m.nanda92@gmail.com>
` Re: Simple update query is slow
2020-11-21 20:48 UTC Nandakumar M <m.nanda92@gmail.com>
` Re: Simple update query is slow
2020-11-22 17:30 UTC Justin Pryzby <pryzby@telsasoft.com>
[3+ messages in thread]
How to prioritise walsender reading from pg_wal over WAL writes?
2020-11-13 10:12 UTC Alexey Bashtanov <bashtanov@imap.cc>
` Re: How to prioritise walsender reading from pg_wal over WAL writes?
2020-11-18 11:54 UTC Alexey Bashtanov <bashtanov@imap.cc>
` Re: How to prioritise walsender reading from pg_wal over WAL writes?
2020-11-18 12:11 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: How to prioritise walsender reading from pg_wal over WAL writes?
2020-11-18 12:15 UTC Alexey Bashtanov <bashtanov@imap.cc>
` Re: How to prioritise walsender reading from pg_wal over WAL writes?
2020-11-18 16:20 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: How to prioritise walsender reading from pg_wal over WAL writes?
2020-11-19 13:38 UTC Alexey Bashtanov <bashtanov@imap.cc>
[6+ messages in thread]
Postgres using nested loops despite setting enable_nestloop to false
2020-11-17 13:47 UTC Frits Jalvingh <jal@etc.to>
` Re: Postgres using nested loops despite setting enable_nestloop to false
2020-11-17 14:20 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Postgres using nested loops despite setting enable_nestloop to false
2020-11-17 15:58 UTC Frits Jalvingh <jal@etc.to>
` Re: Postgres using nested loops despite setting enable_nestloop to false
2020-11-17 16:06 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Postgres using nested loops despite setting enable_nestloop to false
2020-11-17 16:08 UTC Frits Jalvingh <jal@etc.to>
` Re: Postgres using nested loops despite setting enable_nestloop to false
2020-11-17 16:14 UTC Frits Jalvingh <jal@etc.to>
` Re: Postgres using nested loops despite setting enable_nestloop to false
2020-11-17 16:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres using nested loops despite setting enable_nestloop to false
2020-11-17 16:42 UTC Frits Jalvingh <jal@etc.to>
` Re: Postgres using nested loops despite setting enable_nestloop to false
2020-11-19 11:52 UTC Frits Jalvingh <jal@etc.to>
[9+ messages in thread]
Install clustered postgres
2020-11-17 13:54 UTC Nunzia Vairo <vairo@planetek.it>
Partition pruning with joins
2020-11-03 13:20 UTC Ehrenreich, Sigrid <Ehrenreich@consist.de>
` Re: Partition pruning with joins
2020-11-03 15:45 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` RE: Partition pruning with joins
2020-11-04 08:47 UTC Ehrenreich, Sigrid <Ehrenreich@consist.de>
` Re: Partition pruning with joins
2020-11-04 20:13 UTC David Rowley <dgrowleyml@gmail.com>
` RE: Partition pruning with joins
2020-11-05 06:23 UTC Ehrenreich, Sigrid <Ehrenreich@consist.de>
[5+ messages in thread]
Adding nextval() to a select caused hang/very slow execution
2020-11-04 17:10 UTC Eric Raskin <eraskin@paslists.com>
` RE: Adding nextval() to a select caused hang/very slow execution
2020-11-04 17:19 UTC Eric Raskin <eraskin@paslists.com>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-04 18:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-04 18:22 UTC Eric Raskin <eraskin@paslists.com>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-04 18:25 UTC Eric Raskin <eraskin@paslists.com>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-04 19:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-04 19:12 UTC Eric Raskin <eraskin@paslists.com>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-04 19:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-04 19:25 UTC Eric Raskin <eraskin@paslists.com>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-04 19:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-04 20:19 UTC Michael Lewis <mlewis@entrata.com>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-04 20:39 UTC Eric Raskin <eraskin@paslists.com>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-04 21:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Adding nextval() to a select caused hang/very slow execution
2020-11-05 04:10 UTC Eric Raskin <eraskin@paslists.com>
[14+ messages in thread]
Low cost query - running longer
2020-11-05 02:58 UTC Koteswara Rao Daliparthi <koti813@gmail.com>
` Re: Low cost query - running longer
2020-11-05 03:02 UTC David G. Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
Understanding bad estimate (related to FKs?)
2020-10-26 16:50 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: Understanding bad estimate (related to FKs?)
2020-10-26 17:04 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Understanding bad estimate (related to FKs?)
2020-10-26 17:14 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: Understanding bad estimate (related to FKs?)
2020-10-26 17:20 UTC Michael Lewis <mlewis@entrata.com>
` Re: Understanding bad estimate (related to FKs?)
2020-10-26 18:55 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: Understanding bad estimate (related to FKs?)
2020-10-29 01:13 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Understanding bad estimate (related to FKs?)
2020-10-29 15:25 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: Understanding bad estimate (related to FKs?)
2020-10-29 22:48 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Understanding bad estimate (related to FKs?)
2020-10-30 14:56 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: Understanding bad estimate (related to FKs?)
2020-10-31 13:53 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: Understanding bad estimate (related to FKs?)
2020-11-02 19:09 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: Understanding bad estimate (related to FKs?)
2020-11-02 19:53 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Understanding bad estimate (related to FKs?)
2020-11-02 20:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Understanding bad estimate (related to FKs?)
2020-11-02 20:48 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: Understanding bad estimate (related to FKs?)
2020-11-02 23:09 UTC Michael Lewis <mlewis@entrata.com>
` Re: Understanding bad estimate (related to FKs?)
2020-11-03 03:17 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Understanding bad estimate (related to FKs?)
2020-11-03 15:07 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: Understanding bad estimate (related to FKs?)
2020-11-03 15:27 UTC Philip Semanchuk <philip@americanefficient.com>
[18+ messages in thread]
query plan using partial index expects a much larger number of rows than is possible
2020-10-28 22:46 UTC Olivier Poquet <opoquet@plumdev.com>
` Re: query plan using partial index expects a much larger number of rows than is possible
2020-10-28 23:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query plan using partial index expects a much larger number of rows than is possible
2020-10-29 00:53 UTC Olivier Poquet <opoquet@plumdev.com>
` Re: query plan using partial index expects a much larger number of rows than is possible
2020-10-29 15:08 UTC Michael Lewis <mlewis@entrata.com>
[4+ messages in thread]
Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join
2020-10-26 15:58 UTC Ehrenreich, Sigrid <Ehrenreich@consist.de>
` Re: Postgres Optimizer ignores information about foreign key relationship, severely misestimating number of returned rows in join
2020-10-26 20:34 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join
2020-10-26 22:25 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join
2020-10-26 22:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join
2020-10-27 07:50 UTC Ehrenreich, Sigrid <Ehrenreich@consist.de>
` Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join
2020-10-28 16:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join
2020-10-29 06:31 UTC Ehrenreich, Sigrid <Ehrenreich@consist.de>
` Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join
2020-10-29 09:57 UTC Magnus Hagander <magnus@hagander.net>
` RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join
2020-10-29 12:12 UTC Ehrenreich, Sigrid <Ehrenreich@consist.de>
[9+ messages in thread]
Query Performance / Planner estimate off
2020-10-20 09:37 UTC Mats Julian Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-20 09:50 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Query Performance / Planner estimate off
2020-10-20 09:59 UTC Mats Julian Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-20 10:50 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query Performance / Planner estimate off
2020-10-20 11:09 UTC Mats Julian Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-20 11:15 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query Performance / Planner estimate off
2020-10-20 11:20 UTC Mats Julian Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-20 13:04 UTC Victor Yegorov <vyegorov@gmail.com>
` Re: Query Performance / Planner estimate off
2020-10-20 13:22 UTC Victor Yegorov <vyegorov@gmail.com>
` Re: Query Performance / Planner estimate off
2020-10-20 13:40 UTC Sushant Pawar <sushantxp@gmail.com>
` Re: Query Performance / Planner estimate off
2020-10-20 14:50 UTC Mats Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-20 16:45 UTC Mats Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-20 16:51 UTC Victor Yegorov <vyegorov@gmail.com>
` Re: Query Performance / Planner estimate off
2020-10-20 17:02 UTC Mats Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-20 17:40 UTC Mats Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-20 17:43 UTC Mats Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-21 12:38 UTC Sebastian Dressler <sebastian@swarm64.com>
` Re: Query Performance / Planner estimate off
2020-10-21 14:42 UTC Mats Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-21 15:29 UTC Michael Lewis <mlewis@entrata.com>
` Re: Query Performance / Planner estimate off
2020-10-21 15:35 UTC Sebastian Dressler <sebastian@swarm64.com>
` Re: Query Performance / Planner estimate off
2020-10-22 06:21 UTC Mats Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-22 06:37 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Query Performance / Planner estimate off
2020-10-22 07:36 UTC Mats Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-22 13:48 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Query Performance / Planner estimate off
2020-10-23 12:16 UTC Mats Olsen <mats@duneanalytics.com>
` Re: Query Performance / Planner estimate off
2020-10-28 06:45 UTC Mats Olsen <mats@duneanalytics.com>
[26+ messages in thread]
Profiling tool for postgresql queries
2020-10-24 22:33 UTC Debajyoti Datta <debajyoti.datta@unb.ca>
CPU Consuming query. Sequential scan despite indexing.
2020-10-15 15:04 UTC aditya desai <admad123@gmail.com>
` Re: CPU Consuming query. Sequential scan despite indexing.
2020-10-15 16:26 UTC Michael Lewis <mlewis@entrata.com>
` Re: CPU Consuming query. Sequential scan despite indexing.
2020-10-16 08:36 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: CPU Consuming query. Sequential scan despite indexing.
2020-10-19 16:20 UTC Michael Lewis <mlewis@entrata.com>
` Re: CPU Consuming query. Sequential scan despite indexing.
2020-10-20 07:17 UTC aditya desai <admad123@gmail.com>
` Re: CPU Consuming query. Sequential scan despite indexing.
2020-10-20 12:30 UTC aditya desai <admad123@gmail.com>
` Re: CPU Consuming query. Sequential scan despite indexing.
2020-10-20 12:56 UTC aditya desai <admad123@gmail.com>
` Re: CPU Consuming query. Sequential scan despite indexing.
2020-10-22 05:21 UTC aditya desai <admad123@gmail.com>
` Re: CPU Consuming query. Sequential scan despite indexing.
2020-10-22 05:27 UTC aditya desai <admad123@gmail.com>
` Re: CPU Consuming query. Sequential scan despite indexing.
2020-10-22 05:32 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: CPU Consuming query. Sequential scan despite indexing.
2020-10-22 05:36 UTC aditya desai <admad123@gmail.com>
[11+ messages in thread]
Poor Performance running Django unit tests after upgrading from 10.6
2020-10-15 05:21 UTC Roger Hunwicks <roger@tonic-solutions.com>
` Re: Poor Performance running Django unit tests after upgrading from 10.6
2020-10-15 06:56 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Poor Performance running Django unit tests after upgrading from 10.6
2020-10-15 10:59 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Poor Performance running Django unit tests after upgrading from 10.6
2020-10-15 13:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Performance issue when we use policies for Row Level Security along with functions
2020-09-16 03:39 UTC Gopisetty, Ramesh <rameshg2@illinois.edu>
` Re: Performance issue when we use policies for Row Level Security along with functions
2020-09-16 10:52 UTC luis.roberto@siscobra.com.br
` Re: Performance issue when we use policies for Row Level Security along with functions
2020-09-16 14:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance issue when we use policies for Row Level Security along with functions
2020-10-12 06:46 UTC Gopisetty, Ramesh <rameshg2@illinois.edu>
` Performance issue when we use policies for Row Level Security along with functions
2020-10-12 07:26 UTC David G. Johnston <david.g.johnston@gmail.com>
[5+ messages in thread]
Indexing an XMLTABLE query?
2020-10-09 05:39 UTC Kanninen Anssi EXT <Anssi.Kanninen@digia.com>
` Re: Indexing an XMLTABLE query?
2020-10-09 05:59 UTC Pavel Stehule <pavel.stehule@gmail.com>
[2+ messages in thread]
Too many waits on extension of relation
2020-10-05 05:02 UTC avinash varma <avinashvarma443@gmail.com>
` Re: Too many waits on extension of relation
2020-10-05 16:44 UTC Michael Lewis <mlewis@entrata.com>
` Re: Too many waits on extension of relation
2020-10-05 17:06 UTC avinash varma <avinashvarma443@gmail.com>
` Re: Too many waits on extension of relation
2020-10-05 17:38 UTC Sushant Pawar <sushant.pawar@ashnik.com>
` Re: Too many waits on extension of relation
2020-10-05 18:03 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Too many waits on extension of relation
2020-10-06 03:37 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Too many waits on extension of relation
2020-10-06 03:59 UTC avinash varma <avinashvarma443@gmail.com>
[7+ 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