pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedIs there any tool which will help me run and explain analyze about 150 queries?
2023-04-07 17:57 UTC kunwar singh <krishsingh.111@gmail.com>
` Re: Is there any tool which will help me run and explain analyze about 150 queries?
2023-04-07 18:19 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: Is there any tool which will help me run and explain analyze about 150 queries?
2023-04-07 18:40 UTC kyle Hailey <kylelf@gmail.com>
` Re: Is there any tool which will help me run and explain analyze about 150 queries?
2023-04-07 20:48 UTC kunwar singh <krishsingh.111@gmail.com>
` Re: Is there any tool which will help me run and explain analyze about 150 queries?
2023-04-08 04:40 UTC Jerry Sievers <gsievers19@comcast.net>
` Re: Is there any tool which will help me run and explain analyze about 150 queries?
2023-04-08 21:44 UTC kyle Hailey <kylelf@gmail.com>
` Re: Is there any tool which will help me run and explain analyze about 150 queries?
2023-04-09 22:15 UTC kunwar singh <krishsingh.111@gmail.com>
` Re: Is there any tool which will help me run and explain analyze about 150 queries?
2023-04-12 09:17 UTC Michael Christofides <michael@pgmustard.com>
[8+ messages in thread]
Query unable to utilize index without typecast to fixed length character
2023-04-06 10:23 UTC ahi <ahm3d.hisham@gmail.com>
` Re: Query unable to utilize index without typecast to fixed length character
2023-04-06 14:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query unable to utilize index without typecast to fixed length character
2023-04-07 07:09 UTC ahi <ahm3d.hisham@gmail.com>
` RE: Query unable to utilize index without typecast to fixed length character
2023-04-08 17:58 UTC msalais@msym.fr
[4+ messages in thread]
Why are commits consuming most of the database time?
2023-04-04 14:46 UTC Tim Slechta <trslechta@gmail.com>
` Re: Why are commits consuming most of the database time?
2023-04-04 14:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why are commits consuming most of the database time?
2023-04-04 20:24 UTC Tim Slechta <trslechta@gmail.com>
[3+ messages in thread]
Explain plan shows fewer shared blocks when index+table compared to index alone?
2023-04-04 06:21 UTC Amin Jaffer <aminjaffer@gmail.com>
` Re:Explain plan shows fewer shared blocks when index+table compared to index alone?
2023-04-04 07:51 UTC Sergei Kornilov <sk@zsrv.org>
[2+ messages in thread]
multicolumn partitioning help
2023-03-12 17:59 UTC James Robertson <james@jsrobertson.net>
` Re: multicolumn partitioning help
2023-03-14 17:54 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: multicolumn partitioning help
2023-03-14 21:41 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: multicolumn partitioning help
2023-03-14 23:33 UTC James Robertson <james@jsrobertson.net>
` Re: multicolumn partitioning help
2023-03-15 07:37 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: multicolumn partitioning help
2023-03-15 20:46 UTC David Rowley <dgrowleyml@gmail.com>
` Re: multicolumn partitioning help
2023-03-15 21:20 UTC David Rowley <dgrowleyml@gmail.com>
[7+ messages in thread]
Huge Tables
2023-03-11 11:47 UTC André Rodrigues <db.andre@gmail.com>
` Re: Huge Tables
2023-03-13 12:45 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Huge Tables
2023-03-13 12:51 UTC André Rodrigues <db.andre@gmail.com>
[3+ messages in thread]
Planner choosing nested loop in place of Hashjoin
2023-03-07 12:14 UTC Praneel Devisetty <devisettypraneel@gmail.com>
` Re: Planner choosing nested loop in place of Hashjoin
2023-03-11 10:31 UTC Samed YILDIRIM <samed@reddoc.net>
` Re: Planner choosing nested loop in place of Hashjoin
2023-03-11 22:13 UTC Jeff Janes <jeff.janes@gmail.com>
[3+ messages in thread]
INSERT statement going in IPC Wait_event
2023-03-01 20:40 UTC aditya desai <admad123@gmail.com>
` Re: INSERT statement going in IPC Wait_event
2023-03-01 21:36 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: INSERT statement going in IPC Wait_event
2023-03-11 10:37 UTC Samed YILDIRIM <samed@reddoc.net>
[3+ messages in thread]
BRIN index worse than sequential scan for large search set
2023-02-24 16:40 UTC Mickael van der Beek <mickael.van.der.beek@gmail.com>
` Re: BRIN index worse than sequential scan for large search set
2023-02-24 17:19 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: BRIN index worse than sequential scan for large search set
2023-02-24 17:51 UTC Mickael van der Beek <mickael.van.der.beek@gmail.com>
` Re: BRIN index worse than sequential scan for large search set
2023-02-24 20:37 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: BRIN index worse than sequential scan for large search set
2023-02-25 16:18 UTC Tomas Vondra <tomas.vondra@enterprisedb.com>
[5+ messages in thread]
Window Functions & Table Partitions
2023-02-08 19:45 UTC Benjamin Tingle <ben@tingle.org>
` Re: Window Functions & Table Partitions
2023-02-08 22:35 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Window Functions & Table Partitions
2023-02-09 17:40 UTC Benjamin Tingle <ben@tingle.org>
` Re: Window Functions & Table Partitions
2023-02-21 03:18 UTC David Rowley <dgrowleyml@gmail.com>
[4+ messages in thread]
Connection forcibly closed remote server error.
2023-02-15 12:13 UTC aditya desai <admad123@gmail.com>
` Re: Connection forcibly closed remote server error.
2023-02-15 12:35 UTC aditya desai <admad123@gmail.com>
` Re: Connection forcibly closed remote server error.
2023-02-15 14:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Connection forcibly closed remote server error.
2023-02-15 18:36 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Connection forcibly closed remote server error.
2023-02-15 18:55 UTC aditya desai <admad123@gmail.com>
` Re: Connection forcibly closed remote server error.
2023-02-15 19:02 UTC Ranier Vilela <ranier.vf@gmail.com>
[6+ messages in thread]
For loop execution times in PostgreSQL 12 vs 15
2023-02-10 18:53 UTC Adithya Kumaranchath <akumaranchath@live.com>
` Re: For loop execution times in PostgreSQL 12 vs 15
2023-02-10 19:35 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: For loop execution times in PostgreSQL 12 vs 15
2023-02-10 19:45 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: For loop execution times in PostgreSQL 12 vs 15
2023-02-13 21:21 UTC Andres Freund <andres@anarazel.de>
` Re: For loop execution times in PostgreSQL 12 vs 15
2023-02-14 05:53 UTC Pavel Stehule <pavel.stehule@gmail.com>
[5+ messages in thread]
Performance of UPDATE operation
2023-02-13 15:09 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: Performance of UPDATE operation
2023-02-13 17:47 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Performance of UPDATE operation
2023-02-13 20:52 UTC Oluwatobi Ogunsola <tobfis@yahoo.com>
` Re: Performance of UPDATE operation
2023-02-13 21:49 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
Domain check taking place unnecessarily?
2023-02-08 18:01 UTC Mark Hills <mark@xwax.org>
` Re: Domain check taking place unnecessarily?
2023-02-08 18:09 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Domain check taking place unnecessarily?
2023-02-08 19:47 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Domain check taking place unnecessarily?
2023-02-09 10:56 UTC Mark Hills <mark@xwax.org>
` Re: Domain check taking place unnecessarily?
2023-02-09 11:01 UTC Mark Hills <mark@xwax.org>
` Re: Domain check taking place unnecessarily?
2023-02-09 15:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Domain check taking place unnecessarily?
2023-02-10 10:49 UTC Mark Hills <mark@xwax.org>
[7+ messages in thread]
max_wal_senders
2023-02-08 23:07 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: max_wal_senders
2023-02-09 05:59 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: max_wal_senders
2023-02-09 06:40 UTC Andres Freund <andres@anarazel.de>
[3+ messages in thread]
Routing & Concurrency with trigger functions
2023-02-07 09:03 UTC chanukya SDS <chanukyasds@gmail.com>
Database Stalls
2023-01-30 17:47 UTC Mok <gurmokh@gmail.com>
` Re: Database Stalls
2023-01-30 17:51 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Database Stalls
2023-01-30 18:10 UTC José Arthur Benetasso Villanova <jose.arthur@gmail.com>
` Re: Database Stalls
2023-01-30 18:47 UTC Shiv Iyer <shiv@minervadb.com>
` Re: Database Stalls
2023-01-30 21:31 UTC Mok <gurmokh@gmail.com>
` Fwd: Database Stalls
2023-01-30 22:47 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Database Stalls
2023-02-03 16:25 UTC Craig Jackson <craig.jackson@broadcom.com>
[7+ messages in thread]
Getting an index scan to be a parallel index scan
2023-02-01 05:39 UTC Alex Kaiser <alextkaiser@gmail.com>
` Re: Getting an index scan to be a parallel index scan
2023-02-01 11:17 UTC Ranier Vilela <ranier.vf@gmail.com>
` Re: Getting an index scan to be a parallel index scan
2023-02-01 11:30 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Getting an index scan to be a parallel index scan
2023-02-01 19:22 UTC Alex Kaiser <alextkaiser@gmail.com>
` Re: Getting an index scan to be a parallel index scan
2023-02-01 20:02 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Getting an index scan to be a parallel index scan
2023-02-01 21:51 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: Getting an index scan to be a parallel index scan
2023-02-02 00:54 UTC Alex Kaiser <alextkaiser@gmail.com>
` Re: Getting an index scan to be a parallel index scan
2023-02-02 01:48 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: Getting an index scan to be a parallel index scan
2023-02-02 02:11 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Getting an index scan to be a parallel index scan
2023-02-02 05:00 UTC Alex Kaiser <alextkaiser@gmail.com>
[10+ messages in thread]
LIKE CLAUSE on VIEWS
2023-01-22 11:33 UTC aditya desai <admad123@gmail.com>
` Re: LIKE CLAUSE on VIEWS
2023-01-22 11:40 UTC Samed YILDIRIM <samed@reddoc.net>
` Re: LIKE CLAUSE on VIEWS
2023-01-22 15:55 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: LIKE CLAUSE on VIEWS
2023-01-22 17:49 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
ALTER STATEMENT getting blocked
2023-01-19 17:30 UTC aditya desai <admad123@gmail.com>
` Re: ALTER STATEMENT getting blocked
2023-01-19 17:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: ALTER STATEMENT getting blocked
2023-01-19 21:06 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: ALTER STATEMENT getting blocked
2023-01-22 11:29 UTC aditya desai <admad123@gmail.com>
[4+ messages in thread]
change the default value of enable_bitmapscan to off
2023-01-14 14:51 UTC hehaochen@hotmail.com <hehaochen@hotmail.com>
` Re: change the default value of enable_bitmapscan to off
2023-01-14 15:00 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: change the default value of enable_bitmapscan to off
2023-01-14 15:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Advice on best way to store a large amount of data in postgresql
2023-01-08 12:02 UTC spiral <spiral@spiral.sh>
` Re: Advice on best way to store a large amount of data in postgresql
2023-01-09 10:39 UTC Michaeldba@sqlexec.com <Michaeldba@sqlexec.com>
` Re: Advice on best way to store a large amount of data in postgresql
2023-01-09 17:56 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Advice on best way to store a large amount of data in postgresql
2023-01-09 23:14 UTC Samed YILDIRIM <samed@reddoc.net>
` Re: Advice on best way to store a large amount of data in postgresql
2023-01-10 09:25 UTC spiral <spiral@spiral.sh>
[5+ messages in thread]
Max write throughput for single COPY
2023-01-06 21:09 UTC Joe Wildish <joe@lateraljoin.com>
How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2022-12-31 12:26 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2022-12-31 14:32 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2023-01-01 11:34 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2023-01-01 13:27 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2023-01-01 16:30 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2023-01-01 16:43 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2023-01-01 16:51 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2023-01-01 16:54 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2023-01-01 17:06 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2023-01-05 10:57 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2023-01-05 11:31 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2023-01-05 11:44 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
2023-01-05 11:46 UTC MichaelDBA <MichaelDBA@sqlexec.com>
[13+ messages in thread]
When you really want to force a certain join type?
2022-12-28 15:39 UTC Gunther Schadow <raj@gusw.net>
` Re: When you really want to force a certain join type?
2022-12-28 15:48 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: When you really want to force a certain join type?
2022-12-29 07:31 UTC Gunther Schadow <raj@gusw.net>
` Re: When you really want to force a certain join type?
2022-12-29 07:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
[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