pgsql-performance

Messages by Date

2017/07/10 Re: [PERFORM] Very poor read performance, query independent Igor Neyman
2017/07/10 [PERFORM] vacuum analyze affecting query performance rverghese
2017/07/10 Re: [PERFORM] Very poor read performance, query independent Charles Nadeau
2017/07/10 Re: [PERFORM] Very poor read performance, query independent Andreas Kretschmer
2017/07/10 Re: [PERFORM] Very poor read performance, query independent Rick Otten
2017/07/10 [PERFORM] Very poor read performance, query independent Charles Nadeau
2017/07/07 Re: estimate correlation of index separately from table (Re: [PERFORM] index fragmentation on insert-only table with non-unique column) Peter Geoghegan
2017/07/07 estimate correlation of index separately from table (Re: [PERFORM] index fragmentation on insert-only table with non-unique column) Justin Pryzby
2017/07/07 Re: [PERFORM] partitioning materialized views Shaun Thomas
2017/07/06 Re: [PERFORM] partitioning materialized views Rick Otten
2017/07/06 Re: [PERFORM] partitioning materialized views Rick Otten
2017/07/06 Re: [PERFORM] partitioning materialized views Shaun Thomas
2017/07/06 [PERFORM] partitioning materialized views Rick Otten
2017/07/05 Re: [PERFORM] Unable to start the slave instance Michael Paquier
2017/07/05 Re: [PERFORM] Unable to start the slave instance Daulat Ram
2017/07/05 Re: [PERFORM] Unable to start the slave instance Scott Marlowe
2017/07/05 [PERFORM] Unable to start the slave instance Daulat Ram
2017/07/05 [PERFORM] Unable to start the slave instance Daulat Ram
2017/07/02 Re: [PERFORM] Simple SQL too slow Daviramos Roussenq Fortunato
2017/07/02 Re: [PERFORM] Simple SQL too slow Nicolas CHARLES
2017/07/02 Re: [PERFORM] Simple SQL too slow Tomas Vondra
2017/07/01 Re: [PERFORM] Simple SQL too slow Andreas Kretschmer
2017/07/01 Re: [PERFORM] Simple SQL too slow Daviramos Roussenq Fortunato
2017/07/01 Re: [PERFORM] Simple SQL too slow Julien Rouhaud
2017/07/01 Re: [PERFORM] Simple SQL too slow Tomas Vondra
2017/07/01 Re: [PERFORM] Simple SQL too slow Daviramos Roussenq Fortunato
2017/07/01 Re: [PERFORM] Simple SQL too slow Andreas Kretschmer
2017/07/01 Re: [PERFORM] Simple SQL too slow Daviramos Roussenq Fortunato
2017/06/30 Re: [PERFORM] Simple SQL too slow Andreas Kretschmer
2017/06/30 [PERFORM] Simple SQL too slow Daviramos Roussenq Fortunato
2017/06/30 Re: [PERFORM] Jeff Janes
2017/06/29 Re: [PERFORM] Scott Marlowe
2017/06/29 Re: [PERFORM] Alvaro Herrera
2017/06/29 Re: [PERFORM] Yevhenii Kurtov
2017/06/29 Re: [PERFORM] Jeff Janes
2017/06/29 Re: [PERFORM] Pavel Stehule
2017/06/28 Re: [PERFORM] Yevhenii Kurtov
2017/06/28 Re: [PERFORM] Performance of information_schema with many schemata and tables Ulf Lohbrügge
2017/06/28 Re: [PERFORM] Efficiently merging and sorting collections of sorted rows Merlin Moncure
2017/06/28 Re: [PERFORM] Brad DeJong
2017/06/28 Re: [PERFORM] Gerardo Herzig
2017/06/28 Re: [PERFORM] Performance of information_schema with many schemata and tables Ulf Lohbrügge
2017/06/28 Re: [PERFORM] Pavel Stehule
2017/06/28 Re: [PERFORM] Yevhenii Kurtov
2017/06/28 Re: [PERFORM] Pavel Stehule
2017/06/27 [PERFORM] Yevhenii Kurtov
2017/06/27 Re: [PERFORM] Performance of information_schema with many schemata and tables Pritam Baral
2017/06/27 [PERFORM] Performance of information_schema with many schemata and tables Ulf Lohbrügge
2017/06/27 [PERFORM] Fwd: Stalled post to pgsql-performance Chris Wilson
2017/06/26 Re: [PERFORM] Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each Jeff Janes
2017/06/26 [PERFORM] Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each Karl Czajkowski
2017/06/26 [PERFORM] Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each Karl Czajkowski
2017/06/26 Re: [PERFORM] Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each Chris Wilson
2017/06/26 Re: [PERFORM] Inappropriate inner table for nested loop join Albe Laurenz
2017/06/24 Re: [PERFORM] slow delete due to reference Tom Lane
2017/06/24 [PERFORM] slow delete due to reference Rikard Pavelic
2017/06/23 [PERFORM] Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each Karl Czajkowski
2017/06/23 Re: [PERFORM] Efficiently merging and sorting collections of sorted rows Tom Lane
2017/06/23 Re: [PERFORM] Efficiently merging and sorting collections of sorted rows Peter Geoghegan
2017/06/23 [PERFORM] Efficiently merging and sorting collections of sorted rows Clint Miller
2017/06/23 [PERFORM] Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each Chris Wilson
2017/06/23 Re: [PERFORM] Dataset is fetched from cache but still takes same time to fetch records as first run l...@laurent-hasson.com
2017/06/23 Re: [PERFORM] Inappropriate inner table for nested loop join Albe Laurenz
2017/06/23 Re: [PERFORM] Dataset is fetched from cache but still takes same time to fetch records as first run Adam Brusselback
2017/06/23 Re: [PERFORM] Inappropriate inner table for nested loop join Akihiko Odaki
2017/06/23 Re: [PERFORM] Inappropriate inner table for nested loop join Akihiko Odaki
2017/06/23 Re: [PERFORM] Inappropriate inner table for nested loop join Albe Laurenz
2017/06/23 [PERFORM] Inappropriate inner table for nested loop join Akihiko Odaki
2017/06/23 Re: [PERFORM] Dataset is fetched from cache but still takes same time to fetch records as first run Glyn Astill
2017/06/22 Re: [PERFORM] Dataset is fetched from cache but still takes same time to fetch records as first run Tom Lane
2017/06/22 Re: [PERFORM] Dataset is fetched from cache but still takes same time to fetch records as first run Sumeet Shukla
2017/06/22 Re: [PERFORM] Dataset is fetched from cache but still takes same time to fetch records as first run Dave Stibrany
2017/06/22 [PERFORM] Dataset is fetched from cache but still takes same time to fetch records as first run Sumeet Shukla
2017/06/20 Re: [PERFORM] substring index what is better way to query Tom Lane
2017/06/20 Re: [PERFORM] substring index what is better way to query Tieson Molly
2017/06/20 Re: [PERFORM] substring index what is better way to query Tom Lane
2017/06/20 [PERFORM] substring index what is better way to query Tieson Molly
2017/06/16 Re: [PERFORM] Using array instead of sub table (storage and speed) Stephen Frost
2017/06/16 Re: [PERFORM] Using array instead of sub table (storage and speed) Lutz Fischer
2017/06/15 Re: [PERFORM] Re: join under-estimates with ineq conditions Justin Pryzby
2017/06/15 Re: [PERFORM] Sudden drastic change in performance Andreas Kretschmer
2017/06/15 Re: [PERFORM] Sudden drastic change in performance Tom Lane
2017/06/15 [PERFORM] Sudden drastic change in performance l...@laurent-hasson.com
2017/06/15 Re: [PERFORM] Using array instead of sub table (storage and speed) Stephen Frost
2017/06/15 [PERFORM] Using array instead of sub table (storage and speed) Lutz Fischer
2017/06/13 Re: [PERFORM] [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Michael Paquier
2017/06/13 Re: [PERFORM] [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Michael Paquier
2017/06/12 Re: [PERFORM] [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Michael Paquier
2017/06/12 Re: [PERFORM] [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Jeff Janes
2017/06/11 Re: [PERFORM] Improving PostgreSQL insert performance Alvaro Herrera
2017/06/11 Re: [PERFORM] Improving PostgreSQL insert performance Vladimir Sitnikov
2017/06/11 Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/10 Re: [PERFORM] Improving PostgreSQL insert performance Joe Conway
2017/06/10 Re: [PERFORM] Improving PostgreSQL insert performance Alvaro Herrera
2017/06/10 Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/10 Re: [PERFORM] Improving PostgreSQL insert performance Nicolas Paris
2017/06/10 Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/10 Re: [PERFORM] Rollback table data. phb07
2017/06/09 Re: [PERFORM] [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Michael Paquier
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Vladimir Sitnikov
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Jeff Janes
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Kenneth Marshall
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Scott Marlowe
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance John Gorman
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Kenneth Marshall
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Sunkara, Amrutha
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Kenneth Marshall
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Scott Marlowe
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Kenneth Marshall
2017/06/09 Re: [PERFORM] Improving PostgreSQL insert performance Andreas Kretschmer
2017/06/09 Re: [PERFORM] Client Server performance & UDS kevin.hug...@uk.fujitsu.com
2017/06/09 [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
2017/06/08 Re: [PERFORM] index of only not null, use function index? Merlin Moncure
2017/06/08 Re: [PERFORM] index of only not null, use function index? Jeremy Finzel
2017/06/08 Re: [PERFORM] Re: join under-estimates with ineq conditions Justin Pryzby
2017/06/08 Re: [PERFORM] index of only not null, use function index? Tom Lane
2017/06/08 Re: [PERFORM] index of only not null, use function index? Merlin Moncure
2017/06/07 Re: [PERFORM] Rollback table data. Scott Marlowe
2017/06/07 Re: [PERFORM] Rollback table data. Anthony Sotolongo
2017/06/07 Re: [PERFORM] Rollback table data. Andreas Kretschmer
2017/06/07 Re: [PERFORM] Rollback table data. Moreno Andreo
2017/06/07 [PERFORM] Rollback table data. Dinesh Chandra 12108
2017/06/05 Re: [PERFORM] Re: join estimate of subqueries with range conditions and constraint exclusion Tom Lane
2017/06/03 Re: [PERFORM] join estimate of subqueries with range conditions and constraint exclusion David G. Johnston
2017/06/03 Re: [PERFORM] Monitoring tool for Postgres Database Nikolay Samokhvalov
2017/05/30 Re: [PERFORM] Client Server performance & UDS Karl Czajkowski
2017/05/30 [PERFORM] Re: join estimate of subqueries with range conditions and constraint exclusion Justin Pryzby
2017/05/30 Re: [PERFORM] Client Server performance & UDS Rick Otten
2017/05/30 Re: [PERFORM] Client Server performance & UDS kevin.hug...@uk.fujitsu.com
2017/05/29 Re: [PERFORM] Different plan between 9.6 and 9.4 when using "Group by" Jeff Janes
2017/05/27 Re: [PERFORM] Monitoring tool for Postgres Database phb07
2017/05/27 Re: [PERFORM] Client Server performance & UDS Rick Otten
2017/05/27 [PERFORM] Different plan between 9.6 and 9.4 when using "Group by" 梁海安（Killua Leung）
2017/05/26 Re: [PERFORM] Monitoring tool for Postgres Database Dave Stibrany
2017/05/26 Re: [PERFORM] More cores or higer frequency ? l...@laurent-hasson.com
2017/05/26 Re: [PERFORM] Monitoring tool for Postgres Database Sunkara, Amrutha
2017/05/26 Re: [PERFORM] Monitoring tool for Postgres Database gevans
2017/05/26 Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database Ashish Tiwari
2017/05/26 Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database Tatsuo Ishii
2017/05/26 [PERFORM] Client Server performance & UDS kevin.hug...@uk.fujitsu.com
2017/05/26 Re: FW: Re: [PERFORM] Query is running very slow...... Andreas Kretschmer
2017/05/26 Re: FW: Re: [PERFORM] Query is running very slow...... Dinesh Chandra 12108
2017/05/26 Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database Joshua D. Drake
2017/05/26 Re: [PERFORM] Monitoring tool for Postgres Database Rick Otten
2017/05/25 Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database Scott Mead
2017/05/25 Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database Steven Chang
2017/05/25 Re: [PERFORM] Monitoring tool for Postgres Database Gary Evans
2017/05/25 Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database Scott Whitney
2017/05/25 [PERFORM] Monitoring tool for Postgres Database Ravi Tammineni
2017/05/25 [PERFORM] Multicolumn B-Tree index - order by on 1st column and IN lookup for 2nd Alexandru Lazarev
2017/05/25 Re: FW: Re: [PERFORM] Query is running very slow...... Tomas Vondra
2017/05/25 FW: Re: [PERFORM] Query is running very slow...... Dinesh Chandra 12108
2017/05/25 Re: [PERFORM] Delete, foreign key, index usage Johann Spies
2017/05/25 Re: [PERFORM] Query is very much slow Andreas Kretschmer
2017/05/25 Re: [PERFORM] Query is very much slow Andreas Kretschmer
2017/05/24 [PERFORM] Query is very much slow Daulat Ram
2017/05/24 [PERFORM] join estimate of subqueries with range conditions and constraint exclusion Justin Pryzby
2017/05/24 Re: [PERFORM] Query is running very slow...... Tomas Vondra
2017/05/24 [PERFORM] Query is running very slow...... Dinesh Chandra 12108
2017/05/23 Re: [PERFORM] select subquery versus join subquery Gunnar "Nick" Bluth
2017/05/23 Re: [PERFORM] More cores or higer frequency ? Steve Crawford
2017/05/23 Re: [PERFORM] More cores or higer frequency ? Scott Marlowe
2017/05/23 Re: [PERFORM] More cores or higer frequency ? Sven R. Kunze
2017/05/23 Re: [PERFORM] More cores or higer frequency ? Jarek
2017/05/23 Re: [PERFORM] More cores or higer frequency ? Steve Crawford
2017/05/23 [PERFORM] More cores or higer frequency ? Jarek
2017/05/23 Re: [PERFORM] select subquery versus join subquery Jeff Janes
2017/05/23 Re: [PERFORM] Log update query along with username who has executed the same. Dinesh Chandra 12108
2017/05/23 Re: [PERFORM] Log update query along with username who has executed the same. Rick Otten
2017/05/23 [PERFORM] Log update query along with username who has executed the same. Dinesh Chandra 12108
2017/05/23 Re: [PERFORM] select subquery versus join subquery Gunnar "Nick" Bluth
2017/05/22 Re: [PERFORM] Can postgresql plan a query using multiple CPU cores? Pavel Stehule
2017/05/22 Re: [PERFORM] Can postgresql plan a query using multiple CPU cores? Mark Kirkwood
2017/05/22 Re: [PERFORM] Can postgresql plan a query using multiple CPU cores? David G. Johnston
2017/05/22 [PERFORM] Can postgresql plan a query using multiple CPU cores? Clemens Eisserer
2017/05/22 [PERFORM] select subquery versus join subquery Jeff Janes
2017/05/22 Re: [PERFORM] Bulk persistence strategy Merlin Moncure
2017/05/22 [PERFORM] index of only not null, use function index? Ariel
2017/05/22 Re: [PERFORM] Bulk persistence strategy Tom Lane
2017/05/22 Re: [PERFORM] Bulk persistence strategy Riaan Stander
2017/05/22 Re: [PERFORM] Bulk persistence strategy Simon Riggs
2017/05/22 Re: [PERFORM] Bulk persistence strategy Riaan Stander
2017/05/21 Re: [PERFORM] Bulk persistence strategy Simon Riggs
2017/05/21 Re: [PERFORM] Bulk persistence strategy Riaan Stander
2017/05/21 Re: [PERFORM] Bulk persistence strategy Tom Lane
2017/05/21 Re: [PERFORM] Bulk persistence strategy Riaan Stander
2017/05/21 Re: [PERFORM] Bulk persistence strategy Tom Lane
2017/05/21 Re: [PERFORM] pg_stat_statements with fetch Rick Otten
2017/05/20 [PERFORM] Bulk persistence strategy Riaan Stander
2017/05/20 Re: [PERFORM] Index not being used on composite type for particular query Zac Goldstein
2017/05/20 Re: [PERFORM] Index not being used on composite type for particular query Tom Lane
2017/05/20 [PERFORM] Index not being used on composite type for particular query Zac Goldstein