pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAny way to speed up INSERT INTO
2022-03-04 18:31 UTC aditya desai <admad123@gmail.com>
` Re: Any way to speed up INSERT INTO
2022-03-04 18:38 UTC Bruce Momjian <bruce@momjian.us>
` Re: Any way to speed up INSERT INTO
2022-03-04 18:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Any way to speed up INSERT INTO
2022-03-04 18:42 UTC aditya desai <admad123@gmail.com>
` Re: Any way to speed up INSERT INTO
2022-03-04 18:47 UTC Bruce Momjian <bruce@momjian.us>
` Re: Any way to speed up INSERT INTO
2022-03-04 18:52 UTC Andres Freund <andres@anarazel.de>
` Re: Any way to speed up INSERT INTO
2022-03-05 01:22 UTC Imre Samu <pella.samu@gmail.com>
` Re: Any way to speed up INSERT INTO
2022-03-05 07:02 UTC aditya desai <admad123@gmail.com>
` Re: Any way to speed up INSERT INTO
2022-03-08 13:06 UTC aditya desai <admad123@gmail.com>
` Re: Any way to speed up INSERT INTO
2022-03-08 14:53 UTC Bruce Momjian <bruce@momjian.us>
` Re: Any way to speed up INSERT INTO
2022-03-09 06:09 UTC aditya desai <admad123@gmail.com>
[11+ messages in thread]
OOM killer while pg_restore
2022-03-03 08:59 UTC Marc Rechté <marc4@rechte.fr>
` Re: OOM killer while pg_restore
2022-03-03 11:00 UTC Ranier Vilela <ranier.vf@gmail.com>
` Re: OOM killer while pg_restore
2022-03-03 12:18 UTC Marc Rechté <marc4@rechte.fr>
` Re: OOM killer while pg_restore
2022-03-03 12:22 UTC Ranier Vilela <ranier.vf@gmail.com>
` Re: OOM killer while pg_restore
2022-03-03 14:46 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: OOM killer while pg_restore
2022-03-03 15:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: OOM killer while pg_restore
2022-03-03 18:32 UTC Marc Rechté <marc4@rechte.fr>
` Re: OOM killer while pg_restore
2022-03-03 18:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: OOM killer while pg_restore
2022-03-05 08:56 UTC Marc Rechté <marc4@rechte.fr>
` Re: OOM killer while pg_restore
2022-03-05 12:08 UTC Ranier Vilela <ranier.vf@gmail.com>
[10+ messages in thread]
XA transactions much slower on 14.2 than on 13.5
2022-03-05 02:33 UTC Mladen Gogala <gogala.mladen@gmail.com>
` Re: XA transactions much slower on 14.2 than on 13.5
2022-03-05 02:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
RES: Any way to speed up INSERT INTO
2022-03-04 20:04 UTC Edson Richter <edsonrichter@hotmail.com>
Simple task with partitioning which I can't realize
2022-03-01 15:37 UTC Andrew Zakharov <Andrew898@mail.ru>
` Re: Simple task with partitioning which I can't realize
2022-03-01 15:54 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Simple task with partitioning which I can't realize
2022-03-01 16:28 UTC Marc Millas <marc.millas@mokadb.com>
` RE: Simple task with partitioning which I can't realize
2022-03-01 16:37 UTC Andrew Zakharov <Andrew898@mail.ru>
` Re: Simple task with partitioning which I can't realize
2022-03-01 16:43 UTC David G. Johnston <david.g.johnston@gmail.com>
` RE: Simple task with partitioning which I can't realize
2022-03-01 16:45 UTC Andrew Zakharov <Andrew898@mail.ru>
` Re: Simple task with partitioning which I can't realize
2022-03-01 17:59 UTC Marc Millas <marc.millas@mokadb.com>
` RE: Simple task with partitioning which I can't realize
2022-03-01 18:43 UTC Andrew Zakharov <Andrew898@mail.ru>
` RE: Simple task with partitioning which I can't realize
2022-03-02 07:28 UTC Michel SALAIS <msalais@msym.fr>
` Re: Simple task with partitioning which I can't realize
2022-03-02 12:14 UTC Geri Wright <geri.w123@gmail.com>
` Re: Simple task with partitioning which I can't realize
2022-03-02 14:04 UTC Mladen Gogala <gogala.mladen@gmail.com>
[11+ messages in thread]
Advice needed: query performance deteriorates by 2000% within 1 minute
2022-02-24 13:53 UTC Peter Adlersburg <peter.adlersburg@gmail.com>
` Re: Advice needed: query performance deteriorates by 2000% within 1 minute
2022-02-24 15:05 UTC Michael Lewis <mlewis@entrata.com>
` Re: Advice needed: query performance deteriorates by 2000% within 1 minute
2022-02-24 16:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Advice needed: query performance deteriorates by 2000% within 1 minute
2022-03-01 07:29 UTC Peter Adlersburg <peter.adlersburg@gmail.com>
` Re: Advice needed: query performance deteriorates by 2000% within 1 minute
2022-03-02 01:39 UTC Michael Lewis <mlewis@entrata.com>
` Re: Advice needed: query performance deteriorates by 2000% within 1 minute
2022-03-02 01:44 UTC Michael Lewis <mlewis@entrata.com>
[6+ messages in thread]
Never Ending query in PostgreSQL
2022-02-27 04:40 UTC Kumar, Mukesh <MKumar@peabodyenergy.com>
` Re: Never Ending query in PostgreSQL
2022-02-27 12:22 UTC Julien Rouhaud <rjuju123@gmail.com>
` Re: Never Ending query in PostgreSQL
2022-02-27 17:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Never Ending query in PostgreSQL
2022-03-01 03:44 UTC Mladen Gogala <gogala.mladen@gmail.com>
` Re: Never Ending query in PostgreSQL
2022-03-01 03:54 UTC Mladen Gogala <gogala.mladen@gmail.com>
` Re: Never Ending query in PostgreSQL
2022-03-01 14:05 UTC Tomas Vondra <tomas.vondra@enterprisedb.com>
` RE: Never Ending query in PostgreSQL
2022-03-01 15:01 UTC Kumar, Mukesh <MKumar@peabodyenergy.com>
` Re: Never Ending query in PostgreSQL
2022-03-01 15:39 UTC Tomas Vondra <tomas.vondra@enterprisedb.com>
[8+ messages in thread]
RLS not using index scan but seq scan when condition gets a bit complicated
2022-02-28 23:33 UTC Charles Huang <charles.huang@cim.io>
slow query to improve performace
2022-02-25 20:18 UTC Ayub Khan <ayub.hp@gmail.com>
` Re: slow query to improve performace
2022-02-25 22:52 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: slow query to improve performace
2022-02-28 03:18 UTC Jeff Janes <jeff.janes@gmail.com>
[3+ messages in thread]
Slow Running Queries in Azure PostgreSQL
2022-02-22 14:11 UTC Kumar, Mukesh <MKumar@peabodyenergy.com>
` Re: Slow Running Queries in Azure PostgreSQL
2022-02-22 21:27 UTC Justin Pryzby <pryzby@telsasoft.com>
` RE: Slow Running Queries in Azure PostgreSQL
2022-02-25 12:41 UTC Kumar, Mukesh <MKumar@peabodyenergy.com>
[3+ messages in thread]
Slow plan choice with prepared query
2022-02-24 03:37 UTC Mark Saward <mark@manse.cloud>
` Re: Slow plan choice with prepared query
2022-02-24 18:45 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Slow plan choice with prepared query
2022-02-24 19:55 UTC MichaelDBA <MichaelDBA@sqlexec.com>
[3+ messages in thread]
Poor performance PostgreSQL 13/ PostGIS 3.x
2022-01-20 22:50 UTC Lugosi, Jim <JimLug@clackamas.us>
` Re: Poor performance PostgreSQL 13/ PostGIS 3.x
2022-02-18 15:38 UTC Merlin Moncure <mmoncure@gmail.com>
[2+ messages in thread]
Query chooses Bad Index Path
2022-02-09 05:37 UTC Valli Annamalai <aishwaryaanns@gmail.com>
` Re: Query chooses Bad Index Path
2022-02-09 16:51 UTC Tomas Vondra <tomas.vondra@enterprisedb.com>
[2+ messages in thread]
slow "select count(*) from information_schema.tables;" in some cases
2022-02-07 16:56 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: slow "select count(*) from information_schema.tables;" in some cases
2022-02-07 17:09 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: slow "select count(*) from information_schema.tables;" in some cases
2022-02-07 17:39 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: slow "select count(*) from information_schema.tables;" in some cases
2022-02-07 17:48 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: slow "select count(*) from information_schema.tables;" in some cases
2022-02-07 18:55 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: slow "select count(*) from information_schema.tables;" in some cases
2022-02-07 19:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow "select count(*) from information_schema.tables;" in some cases
2022-02-07 19:11 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: slow "select count(*) from information_schema.tables;" in some cases
2022-02-07 19:51 UTC Imre Samu <pella.samu@gmail.com>
` Re: slow "select count(*) from information_schema.tables;" in some cases
2022-02-08 12:28 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
[9+ messages in thread]
Query choosing Bad Index Path (ASC/DESC ordering).
2022-02-08 05:55 UTC Valli Annamalai <aishwaryaanns@gmail.com>
` Re: Query choosing Bad Index Path (ASC/DESC ordering).
2022-02-08 12:04 UTC Mind Body Nature <monika.1234yadav@gmail.com>
[2+ messages in thread]
Query choosing Bad Index Path
2022-02-07 05:15 UTC Valli Annamalai <aishwaryaanns@gmail.com>
` Query choosing Bad Index Path
2022-02-07 06:06 UTC Valli Annamalai <aishwaryaanns@gmail.com>
` Re: Query choosing Bad Index Path
2022-02-07 06:18 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query choosing Bad Index Path
2022-02-07 06:18 UTC Julien Rouhaud <rjuju123@gmail.com>
[4+ messages in thread]
Terribly slow query with very good plan?
2022-02-04 09:11 UTC Les <nagylzs@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-04 09:18 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Terribly slow query with very good plan?
2022-02-04 09:23 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-04 09:32 UTC Les <nagylzs@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-04 09:59 UTC Nick Cleaton <nick@cleaton.net>
` Re: Terribly slow query with very good plan?
2022-02-04 10:00 UTC Les <nagylzs@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-04 10:05 UTC Les <nagylzs@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-04 10:09 UTC Les <nagylzs@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-04 10:38 UTC Les <nagylzs@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-04 10:57 UTC Nick Cleaton <nick@cleaton.net>
` Re: Terribly slow query with very good plan?
2022-02-04 12:27 UTC Les <nagylzs@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-04 12:59 UTC Nick Cleaton <nick@cleaton.net>
` Re: Terribly slow query with very good plan?
2022-02-04 13:07 UTC Les <nagylzs@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-04 13:19 UTC Nick Cleaton <nick@cleaton.net>
` Re: Terribly slow query with very good plan?
2022-02-04 13:21 UTC Les <nagylzs@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-04 13:33 UTC Ninad Shah <ninad.shah@percona.com>
` Re: Terribly slow query with very good plan?
2022-02-04 13:57 UTC Nick Cleaton <nick@cleaton.net>
` Re: Terribly slow query with very good plan?
2022-02-04 14:07 UTC Les <nagylzs@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-04 14:34 UTC Nick Cleaton <nick@cleaton.net>
` Re: Terribly slow query with very good plan?
2022-02-04 14:42 UTC Thomas Kellerer <shammat@gmx.net>
` Re: Terribly slow query with very good plan?
2022-02-04 14:43 UTC Les <nagylzs@gmail.com>
` Re: Terribly slow query with very good plan?
2022-02-05 21:25 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
[22+ messages in thread]
Query runs slower as prepared statement - identical execution plans
2022-01-26 07:18 UTC Thomas Kellerer <shammat@gmx.net>
Slow query fixed by replacing equality with a nested query
2022-01-20 19:04 UTC Valentin Janeiko <val.janeiko@gmail.com>
` Re: Slow query fixed by replacing equality with a nested query
2022-01-21 03:33 UTC Michael Lewis <mlewis@entrata.com>
` RE: Slow query fixed by replacing equality with a nested query
2022-01-21 11:37 UTC val.janeiko@gmail.com
` Re: Slow query fixed by replacing equality with a nested query
2022-01-24 13:22 UTC Valentin Janeiko <val.janeiko@gmail.com>
` Re: Slow query fixed by replacing equality with a nested query
2022-01-24 17:50 UTC Michael Lewis <mlewis@entrata.com>
` Re: Slow query fixed by replacing equality with a nested query
2022-01-24 17:52 UTC Michael Lewis <mlewis@entrata.com>
[6+ messages in thread]
PostgreSQL and Linux CPU's
2022-01-20 23:21 UTC Sbob <sbob@quadratum-braccas.com>
` Re: PostgreSQL and Linux CPU's
2022-01-20 23:27 UTC David G. Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
PostgreSQL 12.8 Same Query Same Execution Plan Different Time
2022-01-19 13:52 UTC Ludwig Isaac Lim <ludz_lim@yahoo.com>
` Re: PostgreSQL 12.8 Same Query Same Execution Plan Different Time
2022-01-19 15:11 UTC David G. Johnston <david.g.johnston@gmail.com>
` RE: PostgreSQL 12.8 Same Query Same Execution Plan Different Time
2022-01-20 13:15 UTC Michel SALAIS <msalais@msym.fr>
[3+ messages in thread]
Unique constraint blues
2022-01-18 17:13 UTC Mladen Gogala <gogala.mladen@gmail.com>
` Re: Unique constraint blues
2022-01-18 17:29 UTC David G. Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
PostgreSQLv14 TPC-H performance GCC vs Clang
2021-11-02 17:13 UTC arjun shetty <arjunshetty955@gmail.com>
` Re: PostgreSQLv14 TPC-H performance GCC vs Clang
2021-11-02 19:29 UTC Imre Samu <pella.samu@gmail.com>
` Re: PostgreSQLv14 TPC-H performance GCC vs Clang
2021-11-05 12:07 UTC arjun shetty <arjunshetty955@gmail.com>
` Re: PostgreSQLv14 TPC-H performance GCC vs Clang
2021-11-05 17:29 UTC Tomas Vondra <tomas.vondra@enterprisedb.com>
` PostgreSQLv14 TPC-H performance GCC vs Clang
2021-11-16 10:10 UTC arjun shetty <arjunshetty955@gmail.com>
` Re: PostgreSQLv14 TPC-H performance GCC vs Clang
2021-12-10 18:21 UTC Imre Samu <pella.samu@gmail.com>
` Re: PostgreSQLv14 TPC-H performance GCC vs Clang
2022-01-18 14:22 UTC arjun shetty <arjunshetty955@gmail.com>
[7+ messages in thread]
PGBench connection issue with -C option only
2022-01-13 01:47 UTC T T <tushar11.takate@gmail.com>
About Query Performaces Problem
2022-01-11 08:41 UTC Hüseyin Ellezer <ellezerh@gmail.com>
` Re: About Query Performaces Problem
2022-01-11 13:31 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: About Query Performaces Problem
2022-01-12 08:23 UTC Hüseyin Ellezer <ellezerh@gmail.com>
` Re: About Query Performaces Problem
2022-01-12 08:31 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: About Query Performaces Problem
2022-01-12 08:35 UTC Julien Rouhaud <rjuju123@gmail.com>
[5+ 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