pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feeddexter on AWS RDS auto tune queries
2021-06-07 04:51 UTC Ayub Khan <ayub.hp@gmail.com>
` Re: dexter on AWS RDS auto tune queries
2021-06-07 04:57 UTC Julien Rouhaud <rjuju123@gmail.com>
` Re: dexter on AWS RDS auto tune queries
2021-06-07 05:00 UTC Christophe Pettus <xof@thebuild.com>
` Re: dexter on AWS RDS auto tune queries
2021-06-07 07:49 UTC Ayub Khan <ayub.hp@gmail.com>
` Re: dexter on AWS RDS auto tune queries
2021-06-07 07:57 UTC Julien Rouhaud <rjuju123@gmail.com>
` Re: dexter on AWS RDS auto tune queries
2021-06-07 10:05 UTC Ayub Khan <ayub.hp@gmail.com>
[6+ messages in thread]
query planner not using index, instead using squential scan
2021-06-05 16:42 UTC Ayub Khan <ayub.hp@gmail.com>
` Re: query planner not using index, instead using squential scan
2021-06-05 19:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query planner not using index, instead using squential scan
2021-06-05 19:52 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: query planner not using index, instead using squential scan
2021-06-05 21:14 UTC Ayub Khan <ayub.hp@gmail.com>
` Re: query planner not using index, instead using squential scan
2021-06-05 21:18 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
[5+ messages in thread]
PgSQL 12 on WinSrv ~3x faster than on Linux
2021-06-04 11:53 UTC Taras Savchuk <taras@1adm.ru>
` Re: PgSQL 12 on WinSrv ~3x faster than on Linux
2021-06-04 12:42 UTC David Rowley <dgrowleyml@gmail.com>
` Re: PgSQL 12 on WinSrv ~3x faster than on Linux
2021-06-04 13:14 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: PgSQL 12 on WinSrv ~3x faster than on Linux
2021-06-04 13:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: PgSQL 12 on WinSrv ~3x faster than on Linux
2021-06-04 14:01 UTC Taras Savchuk <taras@1adm.ru>
[5+ messages in thread]
slow query with inline function on AWS RDS with RDS 24x large
2021-06-04 08:06 UTC Ayub Khan <ayub.hp@gmail.com>
` Re: slow query with inline function on AWS RDS with RDS 24x large
2021-06-04 08:22 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: slow query with inline function on AWS RDS with RDS 24x large
2021-06-04 08:32 UTC Ayub Khan <ayub.hp@gmail.com>
` Re: slow query with inline function on AWS RDS with RDS 24x large
2021-06-04 08:40 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: slow query with inline function on AWS RDS with RDS 24x large
2021-06-04 08:51 UTC Ayub Khan <ayub.hp@gmail.com>
[5+ messages in thread]
transaction blocking on COMMIT
2021-05-24 11:30 UTC Bob Jolliffe <bobjolliffe@gmail.com>
` Re: transaction blocking on COMMIT
2021-05-24 11:35 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: transaction blocking on COMMIT
2021-05-24 13:52 UTC Bob Jolliffe <bobjolliffe@gmail.com>
` Re: transaction blocking on COMMIT
2021-05-24 14:09 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: transaction blocking on COMMIT
2021-05-24 16:22 UTC Bob Jolliffe <bobjolliffe@gmail.com>
` Re: transaction blocking on COMMIT
2021-05-24 16:24 UTC Christophe Pettus <xof@thebuild.com>
` Re: transaction blocking on COMMIT
2021-05-24 21:59 UTC Alexey M Boltenkov <padrebolt@yandex.ru>
` Re: transaction blocking on COMMIT
2021-05-27 13:08 UTC Bob Jolliffe <bobjolliffe@gmail.com>
[8+ messages in thread]
Count (select 1) subquery as constant
2021-05-27 10:37 UTC Eugen Konkov <kes-kes@yandex.ru>
issue partition scan
2021-05-25 22:50 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: issue partition scan
2021-05-25 23:01 UTC Christophe Pettus <xof@thebuild.com>
` Re: issue partition scan
2021-05-25 23:38 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: issue partition scan
2021-05-26 00:16 UTC David Rowley <dgrowleyml@gmail.com>
` Re: issue partition scan
2021-05-26 00:27 UTC Christophe Pettus <xof@thebuild.com>
[5+ messages in thread]
Optimising outer joins in the presence of non-nullable references
2021-05-24 12:10 UTC Philip Lykke Carlsen <philip@hasura.io>
` Re: Optimising outer joins in the presence of non-nullable references
2021-05-24 14:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Partition with check constraint with "like"
2021-05-21 00:32 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Partition with check constraint with "like"
2021-05-21 01:22 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Partition with check constraint with "like"
2021-05-21 02:36 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Partition with check constraint with "like"
2021-05-21 02:38 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Partition with check constraint with "like"
2021-05-21 03:24 UTC Michael Lewis <mlewis@entrata.com>
` Re: Partition with check constraint with "like"
2021-05-21 07:02 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Partition with check constraint with "like"
2021-05-21 08:23 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Partition with check constraint with "like"
2021-05-21 16:38 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Partition with check constraint with "like"
2021-05-21 19:08 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: Partition with check constraint with "like"
2021-05-21 19:26 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` RE: Partition with check constraint with "like"
2021-05-21 21:00 UTC Michel SALAIS <msalais@msym.fr>
` Re: Partition with check constraint with "like"
2021-05-21 22:59 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Partition with check constraint with "like"
2021-05-21 23:28 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Partition with check constraint with "like"
2021-05-22 01:38 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Partition with check constraint with "like"
2021-05-22 01:38 UTC David Rowley <dgrowleyml@gmail.com>
` RE: Partition with check constraint with "like"
2021-05-22 05:41 UTC Michel SALAIS <msalais@msym.fr>
[16+ messages in thread]
logical replication
2021-05-21 12:41 UTC Marc Millas <marc.millas@mokadb.com>
` Re: logical replication
2021-05-21 13:21 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: logical replication
2021-05-21 13:44 UTC Marc Millas <marc.millas@mokadb.com>
[3+ messages in thread]
Index and statistics not used
2021-05-17 20:42 UTC rstander@exa.co.za
` Re: Index and statistics not used
2021-05-17 22:31 UTC David Rowley <dgrowleyml@gmail.com>
[2+ messages in thread]
Re: BUG #16968: Planner does not recognize optimization
2021-05-13 13:35 UTC Eugen Konkov <kes-kes@yandex.ru>
` Re: BUG #16968: Planner does not recognize optimization
2021-05-13 23:52 UTC David Rowley <dgrowleyml@gmail.com>
` Re: BUG #16968: Planner does not recognize optimization
2021-05-14 12:39 UTC KES <kes-kes@yandex.ru>
` Re: BUG #16968: Planner does not recognize optimization
2021-05-15 14:34 UTC Eugen Konkov <kes-kes@yandex.ru>
` Re: BUG #16968: Planner does not recognize optimization
2021-05-15 14:52 UTC David Rowley <dgrowleyml@gmail.com>
` Re: BUG #16968: Planner does not recognize optimization
2021-05-15 14:59 UTC David Rowley <dgrowleyml@gmail.com>
` Re: BUG #16968: Planner does not recognize optimization
2021-05-15 16:10 UTC Eugen Konkov <kes-kes@yandex.ru>
` Re: BUG #16968: Planner does not recognize optimization
2021-05-15 16:10 UTC Eugen Konkov <kes-kes@yandex.ru>
[8+ messages in thread]
Very slow "bloat query"
2021-05-14 11:06 UTC Marcin Gozdalik <gozdal@gmail.com>
` Re: Very slow "bloat query"
2021-05-14 11:50 UTC Gilles Darold <gilles@darold.net>
` Re: Very slow "bloat query"
2021-05-14 12:07 UTC Imre Samu <pella.samu@gmail.com>
` Re: Very slow "bloat query"
2021-05-14 12:11 UTC Marcin Gozdalik <gozdal@gmail.com>
` Re: Very slow "bloat query"
2021-05-14 15:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow "bloat query"
2021-05-14 15:15 UTC Marcin Gozdalik <gozdal@gmail.com>
` Re: Very slow "bloat query"
2021-05-14 15:44 UTC Imre Samu <pella.samu@gmail.com>
` Re: Very slow "bloat query"
2021-05-14 15:47 UTC Marcin Gozdalik <gozdal@gmail.com>
[8+ messages in thread]
PostgreSQL blocked locks query
2021-05-13 13:54 UTC Manoj Kumar <manojkumar@temenos.com>
` Re: PostgreSQL blocked locks query
2021-05-13 20:09 UTC Justin Pryzby <pryzby@telsasoft.com>
` RE: Re: PostgreSQL blocked locks query
2021-05-14 06:51 UTC Manoj Kumar <manojkumar@temenos.com>
[3+ messages in thread]
Very slow Query compared to Oracle / SQL - Server
2021-05-06 14:38 UTC Semen Yefimenko <semen.yefimenko@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-06 16:11 UTC luis.roberto@siscobra.com.br
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-06 18:15 UTC Alexey M Boltenkov <padrebolt@yandex.ru>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-06 18:20 UTC Alexey M Boltenkov <padrebolt@yandex.ru>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-06 18:59 UTC Semen Yefimenko <semen.yefimenko@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-06 19:26 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-06 19:48 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-06 19:58 UTC Alexey M Boltenkov <padrebolt@yandex.ru>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-06 20:01 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-06 20:02 UTC Alexey M Boltenkov <padrebolt@yandex.ru>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-06 20:17 UTC Alexey M Boltenkov <padrebolt@yandex.ru>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-06 21:16 UTC Imre Samu <pella.samu@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-07 08:04 UTC Semen Yefimenko <semen.yefimenko@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-07 08:44 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-07 09:02 UTC Semen Yefimenko <semen.yefimenko@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-07 09:55 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-07 12:50 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-07 15:57 UTC Semen Yefimenko <semen.yefimenko@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-07 16:15 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-07 16:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-07 21:28 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-07 21:43 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-07 22:17 UTC didier <did447@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-08 12:06 UTC Semen Yefimenko <semen.yefimenko@gmail.com>
` Re: Very slow Query compared to Oracle / SQL - Server
2021-05-10 11:14 UTC Semen Yefimenko <semen.yefimenko@gmail.com>
[25+ messages in thread]
Re: [PATCH] force_parallel_mode and GUC categories
2021-05-08 16:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
15x slower PreparedStatement vs raw query
2021-05-02 19:45 UTC Alex <cdalxndr@yahoo.com>
` Re: 15x slower PreparedStatement vs raw query
2021-05-03 20:18 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: 15x slower PreparedStatement vs raw query
2021-05-04 09:21 UTC Alex <cdalxndr@yahoo.com>
` Re: 15x slower PreparedStatement vs raw query
2021-05-04 12:12 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: 15x slower PreparedStatement vs raw query
2021-05-04 13:59 UTC Alex <cdalxndr@yahoo.com>
` Re: 15x slower PreparedStatement vs raw query
2021-05-04 15:22 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: 15x slower PreparedStatement vs raw query
2021-05-04 15:50 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: 15x slower PreparedStatement vs raw query
2021-05-05 06:57 UTC David Rowley <dgrowleyml@gmail.com>
` Re: 15x slower PreparedStatement vs raw query
2021-05-05 06:59 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: 15x slower PreparedStatement vs raw query
2021-05-05 15:21 UTC Alex <cdalxndr@yahoo.com>
[10+ messages in thread]
Re: [HACKERS] proposal: schema variables
2019-04-19 06:32 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: proposal: schema variables
2021-04-04 08:30 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: proposal: schema variables
2021-04-10 06:58 UTC Pavel Stehule <pavel.stehule@gmail.com>
[3+ messages in thread]
SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 13:38 UTC aditya desai <admad123@gmail.com>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 13:47 UTC Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 14:08 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 14:10 UTC Michael Lewis <mlewis@entrata.com>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 14:16 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 14:59 UTC aditya desai <admad123@gmail.com>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 15:04 UTC Bruce Momjian <bruce@momjian.us>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 15:08 UTC aditya desai <admad123@gmail.com>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 15:12 UTC Bruce Momjian <bruce@momjian.us>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 15:22 UTC aditya desai <admad123@gmail.com>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 15:24 UTC Bruce Momjian <bruce@momjian.us>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 15:30 UTC aditya desai <admad123@gmail.com>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 15:33 UTC aditya desai <admad123@gmail.com>
` Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
2021-04-03 15:35 UTC Pavel Stehule <pavel.stehule@gmail.com>
[14+ messages in thread]
High availability management tool.
2021-03-02 11:58 UTC Rodriguez Pablo A <rodriguez.a.pablo@gmail.com>
` Re: High availability management tool.
2021-04-01 07:59 UTC Dorian Hoxha <dorian.hoxha@gmail.com>
` Re: High availability management tool.
2021-04-01 09:08 UTC Hüseyin Demir <demirhuseyinn.94@gmail.com>
` Re: High availability management tool.
2021-04-01 09:23 UTC Adalberto Caccia <adacaccia@gmail.com>
[4+ messages in thread]
High-volume writes - what is the max throughput possible
2021-03-25 18:12 UTC Geervan Hayatnagarkar <pande.arti@gmail.com>
` Re: High-volume writes - what is the max throughput possible
2021-03-26 12:48 UTC Frits Jalvingh <jal@etc.to>
` Re: High-volume writes - what is the max throughput possible
2021-03-30 15:21 UTC Hannu Krosing <hannuk@google.com>
[3+ messages in thread]
How do we hint a query to use index in postgre
2021-03-18 09:14 UTC Manish Lad <manishlad7893@gmail.com>
` Re: How do we hint a query to use index in postgre
2021-03-18 09:15 UTC Gaetano Mendola <mendola@gmail.com>
` Re: How do we hint a query to use index in postgre
2021-03-18 09:37 UTC Manish Lad <manishlad7893@gmail.com>
` Re: How do we hint a query to use index in postgre
2021-03-26 11:41 UTC Nikhil Shetty <nikhil.dba04@gmail.com>
[4+ messages in thread]
Re: proposal: schema variables - doc
2021-03-17 12:05 UTC Erik Rijkers <er@xs4all.nl>
` Re: proposal: schema variables - doc
2021-03-22 09:47 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: proposal: schema variables - doc
2021-03-25 08:05 UTC Pavel Stehule <pavel.stehule@gmail.com>
[3+ messages in thread]
Odd (slow) plan choice with min/max
2021-03-23 04:00 UTC Paul McGarry <paul@paulmcgarry.com>
` Re: Odd (slow) plan choice with min/max
2021-03-23 05:13 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Odd (slow) plan choice with min/max
2021-03-23 06:51 UTC Paul McGarry <paul@paulmcgarry.com>
` Re: Odd (slow) plan choice with min/max
2021-03-23 13:07 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Odd (slow) plan choice with min/max
2021-03-23 21:38 UTC Paul McGarry <paul@paulmcgarry.com>
` Re: Odd (slow) plan choice with min/max
2021-03-24 09:26 UTC Yoan SULTAN <yeyeyo@gmail.com>
[6+ messages in thread]
SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-22 13:10 UTC Chris Stephens <cstephens16@gmail.com>
` Re: SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-22 14:54 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-22 17:28 UTC Chris Stephens <cstephens16@gmail.com>
` Re: SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-22 21:39 UTC Hannu Krosing <hannuk@google.com>
` Re: SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-23 15:21 UTC Chris Stephens <cstephens16@gmail.com>
` Re: SQL performance issue (postgresql chooses a bad plan when a better one is available)
2021-03-23 23:20 UTC Hannu Krosing <hannuk@google.com>
[6+ 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