pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedWhy Postgres doesn't use TID scan?
2018-12-18 01:16 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why Postgres doesn't use TID scan?
2018-12-18 01:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why Postgres doesn't use TID scan?
2018-12-18 01:54 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why Postgres doesn't use TID scan?
2018-12-18 02:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why Postgres doesn't use TID scan?
2018-12-18 02:40 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why Postgres doesn't use TID scan?
2018-12-18 16:40 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Why Postgres doesn't use TID scan?
2018-12-19 11:41 UTC Andrew Gierth <andrew@tao11.riddles.org.uk>
` Re: Why Postgres doesn't use TID scan?
2018-12-19 20:22 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why Postgres doesn't use TID scan?
2018-12-19 22:23 UTC Andrew Gierth <andrew@tao11.riddles.org.uk>
` Re: Why Postgres doesn't use TID scan?
2018-12-19 23:44 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why Postgres doesn't use TID scan?
2018-12-20 13:46 UTC Rick Otten <rottenwindfish@gmail.com>
[11+ messages in thread]
Increasing parallelism of queries while using file fdw and partitions
2018-12-19 04:39 UTC Patrick Mulrooney <mulroony@gmail.com>
` Re: Increasing parallelism of queries while using file fdw and partitions
2018-12-19 06:51 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Increasing parallelism of queries while using file fdw and partitions
2018-12-19 07:36 UTC Patrick Mulrooney <mulroony@gmail.com>
[3+ messages in thread]
PostgreSQL VS MongoDB: a use case comparison
2018-11-19 15:38 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-19 17:26 UTC Stephen Frost <sfrost@snowman.net>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-20 13:11 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-20 13:34 UTC Stephen Frost <sfrost@snowman.net>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-20 15:53 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-20 16:41 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-20 16:43 UTC Stephen Frost <sfrost@snowman.net>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-20 17:02 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-20 17:28 UTC Stephen Frost <sfrost@snowman.net>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-20 19:45 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-20 19:46 UTC Stephen Frost <sfrost@snowman.net>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-21 06:48 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-11-29 21:14 UTC Oleg Bartunov <obartunov@postgrespro.ru>
` Re: PostgreSQL VS MongoDB: a use case comparison
2018-12-12 22:37 UTC Nicolas Paris <nicolas.paris@riseup.net>
[14+ messages in thread]
Database size 1T but unclear why
2018-12-09 15:18 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: Database size 1T but unclear why
2018-12-09 15:42 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Database size 1T but unclear why
2018-12-09 16:01 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Database size 1T but unclear why
2018-12-11 18:55 UTC Justin Pryzby <pryzby@telsasoft.com>
[4+ messages in thread]
amazon aroura config - seriously overcommited defaults? (May be Off Topic)
2018-12-08 19:00 UTC Square Bob <square_bob@yahoo.com>
` Fwd: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
2018-12-08 19:03 UTC Square Bob <square_bob@yahoo.com>
` Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
2018-12-08 19:21 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
2018-12-08 19:48 UTC Bob Lunney <bob_lunney@yahoo.com>
` Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
2018-12-08 20:06 UTC Jeremy Schneider <schnjere@amazon.com>
` Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
2018-12-08 23:12 UTC Andres Freund <andres@anarazel.de>
` Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
2018-12-08 23:23 UTC Rob Sargent <robjsargent@gmail.com>
` Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
2018-12-08 23:38 UTC Andres Freund <andres@anarazel.de>
` Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
2018-12-09 12:51 UTC Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
` Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
2018-12-09 15:20 UTC Square Bob <square_bob@yahoo.com>
[10+ messages in thread]
Slow Bitmap Index Scan
2018-11-28 19:08 UTC Scott Rankin <srankin@motus.com>
` Re: Slow Bitmap Index Scan
2018-11-28 19:17 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Slow Bitmap Index Scan
2018-11-28 19:31 UTC Scott Rankin <srankin@motus.com>
` Re: Slow Bitmap Index Scan
2018-12-03 18:41 UTC Scott Rankin <srankin@motus.com>
` Re: Slow Bitmap Index Scan
2018-12-03 18:51 UTC Alan Hodgson <ahodgson@lists.simkin.ca>
[5+ messages in thread]
autovacuum run but last_autovacuum is empty
2018-11-26 15:12 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: autovacuum run but last_autovacuum is empty
2018-11-26 15:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: autovacuum run but last_autovacuum is empty
2018-11-26 15:51 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: autovacuum run but last_autovacuum is empty
2018-11-26 16:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
explain analyze faster then query
2018-11-25 13:08 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: explain analyze faster then query
2018-11-25 13:30 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: explain analyze faster then query
2018-11-25 13:37 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: explain analyze faster then query
2018-11-25 14:12 UTC Justin Pryzby <pryzby@telsasoft.com>
[4+ messages in thread]
Performance impact of updating target columns with unchanged values ON CONFLICT
2018-11-22 19:32 UTC Abi Noda <a@abinoda.com>
` Re: Performance impact of updating target columns with unchanged values ON CONFLICT
2018-11-22 21:31 UTC Abi Noda <a@abinoda.com>
` Re: Performance impact of updating target columns with unchanged values ON CONFLICT
2018-11-22 22:40 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Performance impact of updating target columns with unchanged values ON CONFLICT
2018-11-24 03:44 UTC Abi Noda <a@abinoda.com>
` Re: Performance impact of updating target columns with unchanged values ON CONFLICT
2018-11-24 03:53 UTC Abi Noda <a@abinoda.com>
[5+ messages in thread]
performance statistics monitoring without spamming logs
2018-07-10 17:54 UTC Patrick Hemmer <postgresql@stormcloud9.net>
` Re: performance statistics monitoring without spamming logs
2018-07-10 18:38 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: performance statistics monitoring without spamming logs
2018-07-12 22:25 UTC Lukas Fittl <lukas@fittl.com>
` Re: performance statistics monitoring without spamming logs
2018-07-13 07:23 UTC Adrien NAYRAT <adrien.nayrat@anayrat.info>
` Re: performance statistics monitoring without spamming logs
2018-07-13 07:24 UTC Adrien NAYRAT <adrien.nayrat@anayrat.info>
` Re: performance statistics monitoring without spamming logs
2018-07-13 07:55 UTC Julien Rouhaud <rjuju123@gmail.com>
` Re: performance statistics monitoring without spamming logs
2018-11-22 05:41 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: performance statistics monitoring without spamming logs
2018-11-22 08:20 UTC Adrien NAYRAT <adrien.nayrat@anayrat.info>
[8+ messages in thread]
autovacuum is running but pg_stat_all_tables empty
2018-11-19 17:31 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: autovacuum is running but pg_stat_all_tables empty
2018-11-19 18:52 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[2+ messages in thread]
checkpoint occurs very often when vacuum full running
2018-11-15 18:53 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: checkpoint occurs very often when vacuum full running
2018-11-15 19:10 UTC Sergei Kornilov <sk@zsrv.org>
` Re: checkpoint occurs very often when vacuum full running
2018-11-15 19:29 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: checkpoint occurs very often when vacuum full running
2018-11-15 20:28 UTC Sergei Kornilov <sk@zsrv.org>
` Re: checkpoint occurs very often when vacuum full running
2018-11-15 20:32 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: checkpoint occurs very often when vacuum full running
2018-11-15 20:46 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: checkpoint occurs very often when vacuum full running
2018-11-17 11:31 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: checkpoint occurs very often when vacuum full running
2018-11-17 11:36 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: checkpoint occurs very often when vacuum full running
2018-11-17 19:28 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[9+ messages in thread]
NOT IN vs. NOT EXISTS performance
2018-11-08 19:35 UTC Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: NOT IN vs. NOT EXISTS performance
2018-11-08 21:11 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: NOT IN vs. NOT EXISTS performance
2018-11-09 13:45 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: NOT IN vs. NOT EXISTS performance
2018-11-10 00:06 UTC Lincoln Swaine-Moore <lswainemoore@gmail.com>
[4+ messages in thread]
Fwd: Query with high planning time compared to execution time
2018-11-02 09:36 UTC Richard Lee <swift1984@gmail.com>
` Re: Fwd: Query with high planning time compared to execution time
2018-11-02 13:55 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Fwd: Query with high planning time compared to execution time
2018-11-02 22:51 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: Fwd: Query with high planning time compared to execution time
2018-11-05 03:36 UTC Richard Lee <swift1984@gmail.com>
` Re: Fwd: Query with high planning time compared to execution time
2018-11-05 04:10 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Fwd: Query with high planning time compared to execution time
2018-11-05 07:04 UTC Richard Lee <swift1984@gmail.com>
` Re: Fwd: Query with high planning time compared to execution time
2018-11-05 13:55 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Fwd: Query with high planning time compared to execution time
2018-11-06 11:40 UTC Richard Lee <swift1984@gmail.com>
[8+ messages in thread]
SCRAM question
2018-10-30 17:51 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: SCRAM question
2018-10-30 18:03 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: SCRAM question
2018-10-31 09:55 UTC Michael Paquier <michael@paquier.xyz>
[3+ messages in thread]
High CPU Usage of "SET ROLE"
2018-10-22 13:44 UTC Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
` Re: High CPU Usage of "SET ROLE"
2018-10-22 13:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: High CPU Usage of "SET ROLE"
2018-10-30 19:49 UTC Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
` Re: High CPU Usage of "SET ROLE"
2018-10-30 20:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: High CPU Usage of "SET ROLE"
2018-10-30 22:34 UTC Jeff Janes <jeff.janes@gmail.com>
[5+ messages in thread]
Indexes on UUID - Fragmentation Issue
2018-10-29 13:29 UTC Uday Bhaskar V <uday.bhaskar579@gmail.com>
` Re: Indexes on UUID - Fragmentation Issue
2018-10-29 14:28 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Indexes on UUID - Fragmentation Issue
2018-10-29 14:52 UTC Andreas Karlsson <andreas@proxel.se>
` Re: Indexes on UUID - Fragmentation Issue
2018-10-29 14:56 UTC Uday Bhaskar V <uday.bhaskar579@gmail.com>
` Re: Indexes on UUID - Fragmentation Issue
2018-10-29 19:12 UTC MichaelDBA <MichaelDBA@sqlexec.com>
[5+ messages in thread]
DELETE / UPDATE from partition not optimized (11.0)
2018-10-25 16:43 UTC Dave E Martin <postgresql2-to.dave@dave.to>
` Re: DELETE / UPDATE from partition not optimized (11.0)
2018-10-26 15:45 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: DELETE / UPDATE from partition not optimized (11.0)
2018-10-28 21:49 UTC Justin Pryzby <pryzby@telsasoft.com>
[3+ messages in thread]
Ynt: Gained %20 performance after disabling bitmapscan
2018-10-22 06:52 UTC Yavuz Selim Sertoglu <yavuzselim.sertoglu@medyasoft.com.tr>
` Ynt: Gained %20 performance after disabling bitmapscan
2018-10-22 06:55 UTC Yavuz Selim Sertoglu <yavuzselim.sertoglu@medyasoft.com.tr>
` Ynt: Gained %20 performance after disabling bitmapscan
2018-10-22 07:20 UTC Yavuz Selim Sertoglu <yavuzselim.sertoglu@medyasoft.com.tr>
[3+ messages in thread]
One big table or split data? Writing data. From disk point of view. With a good storage (GBs/s, writing speed)
2018-10-12 16:27 UTC Sam R. <samruohola@yahoo.com>
` Re: One big table or split data? Writing data. From disk point of view. With a good storage (GBs/s, writing speed)
2018-10-16 03:47 UTC Sam R. <samruohola@yahoo.com>
[2+ messages in thread]
Import csv in PostgreSQL
2018-10-15 05:42 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Import csv in PostgreSQL
2018-10-15 06:09 UTC Gabi D <gabid33@gmail.com>
[2+ messages in thread]
does work_mem is used on temp tables?
2018-10-11 06:56 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: does work_mem is used on temp tables?
2018-10-11 07:41 UTC Andrew Gierth <andrew@tao11.riddles.org.uk>
` Re: does work_mem is used on temp tables?
2018-10-11 07:58 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
[3+ messages in thread]
Why could different data in a table be processed with different performance?
2018-09-21 00:07 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-21 00:42 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-21 01:54 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-21 02:29 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-21 03:17 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Why could different data in a table be processed with different performance?
2018-09-21 06:28 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-21 13:08 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: Why could different data in a table be processed with different performance?
2018-09-21 13:12 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: Why could different data in a table be processed with different performance?
2018-09-22 09:19 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-22 10:32 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-22 14:49 UTC didier <did447@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-24 07:44 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-24 14:47 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: Why could different data in a table be processed with different performance?
2018-09-24 22:28 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-24 23:34 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-25 00:21 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-25 00:59 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-25 01:11 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-25 02:19 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-25 02:31 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-25 02:38 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-25 03:40 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-25 06:32 UTC Gasper Zejn <zejn@owca.info>
` Re: Why could different data in a table be processed with different performance?
2018-09-25 09:14 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: Why could different data in a table be processed with different performance?
2018-09-25 20:28 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-26 17:15 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-27 09:25 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: Why could different data in a table be processed with different performance?
2018-09-28 09:16 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-28 09:56 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-09-28 14:15 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: Why could different data in a table be processed with different performance?
2018-09-28 19:51 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why could different data in a table be processed with different performance?
2018-10-01 07:35 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: Why could different data in a table be processed with different performance?
2018-10-10 10:59 UTC Vladimir Ryabtsev <greatvovan@gmail.com>
[33+ messages in thread]
understand query on partition table
2018-10-09 09:19 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: understand query on partition table
2018-10-09 13:12 UTC Samed YILDIRIM <samed@reddoc.net>
[2+ messages in thread]
Partial index plan/cardinality costing
2018-09-07 16:17 UTC James Coleman <jtc331@gmail.com>
` Re: Partial index plan/cardinality costing
2018-10-08 22:05 UTC James Coleman <jtc331@gmail.com>
` Re: Partial index plan/cardinality costing
2018-10-09 00:49 UTC Justin Pryzby <pryzby@telsasoft.com>
[3+ 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