pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedquery 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]
[PATCH v2 4/4] Change force_parallel_mode to a DEVELOPER GUC, and remove it from sample config..
2021-04-04 00:24 UTC Justin Pryzby <pryzbyj@telsasoft.com>
` [PATCH v3 3/3] Change force_parallel_mode to a DEVELOPER GUC, and remove it from sample config..
2021-04-04 00:24 UTC Justin Pryzby <pryzbyj@telsasoft.com>
` [PATCH 4/4] Change force_parallel_mode to a DEVELOPER GUC, and remove it from sample config..
2021-04-04 00:24 UTC Justin Pryzby <pryzbyj@telsasoft.com>
[3+ messages in thread]
[PATCH 3/4] track_commit_timestamp is REPLICATION_SENDING
2021-04-04 00:17 UTC Justin Pryzby <pryzbyj@telsasoft.com>
` [PATCH v3 2/3] track_commit_timestamp is REPLICATION_SENDING
2021-04-04 00:17 UTC Justin Pryzby <pryzbyj@telsasoft.com>
` [PATCH v2 3/4] track_commit_timestamp is REPLICATION_SENDING
2021-04-04 00:17 UTC Justin Pryzby <pryzbyj@telsasoft.com>
[3+ messages in thread]
[PATCH v2 2/4] log_autovacuum_min_duration is LOGGING_WHAT
2021-04-04 00:10 UTC Justin Pryzby <pryzbyj@telsasoft.com>
` [PATCH 2/4] log_autovacuum_min_duration is LOGGING_WHAT
2021-04-04 00:10 UTC Justin Pryzby <pryzbyj@telsasoft.com>
[2+ messages in thread]
[PATCH v2 1/4] track_activity_query_size is STATS_COLLECTOR category
2021-04-04 00:06 UTC Justin Pryzby <pryzbyj@telsasoft.com>
` [PATCH 1/4] track_activity_query_size is STATS_COLLECTOR category
2021-04-04 00:06 UTC Justin Pryzby <pryzbyj@telsasoft.com>
` [PATCH v3 1/3] track_activity_query_size is STATS_COLLECTOR category
2021-04-04 00:06 UTC Justin Pryzby <pryzbyj@telsasoft.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]
[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