pgsql-performance  

Messages by Thread

• • Re: [PERFORM] Postgres performance issue Scott Marlowe
  • Re: [PERFORM] Postgres performance issue Scott Marlowe
• [PERFORM] Inefficient max query when using group by jesse.hietanen
  • Re: [PERFORM] Inefficient max query when using group by bricklen
  • Re: [PERFORM] Inefficient max query when using group by David Rowley
• [PERFORM] EXCLUDE CONSTRAINT with intarray Alexey Vasiliev
• [PERFORM] Slow query with 3 table joins Alessandro Ferrucci
  • Re: [PERFORM] Slow query with 3 table joins Alessandro Ferrucci
  • Re: [PERFORM] Slow query with 3 table joins David Rowley
  • Re: [PERFORM] Slow query with 3 table joins Alessandro Ferrucci
  • Re: [PERFORM] Slow query with 3 table joins Alessandro Ferrucci
  • Re: [PERFORM] Slow query with 3 table joins Johan Fredriksson
  • Re: [PERFORM] Slow query with 3 table joins Alessandro Ferrucci
  • Re: [PERFORM] Slow query with 3 table joins Johan Fredriksson
  • Re: [PERFORM] Slow query with 3 table joins Gerardo Herzig
  • Re: [PERFORM] Slow query with 3 table joins Gerardo Herzig
  • Re: [PERFORM] Slow query with 3 table joins Matthew Bellew
• [PERFORM] Questionaire: Common WAL write rates on busy servers. Andres Freund
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Vladimir Borodin
  • Re: [PERFORM] [GENERAL] Questionaire: Common WAL write rates on busy servers. bricklen
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Claudio Freire
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Andres Freund
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Joshua D. Drake
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Andres Freund
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Joshua D. Drake
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Andres Freund
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Tomas Vondra
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Andres Freund
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Tomas Vondra
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Tomas Vondra
  • Re: [PERFORM] Questionaire: Common WAL write rates on busy servers. Tomas Vondra
• [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause Marco Renzi
  • Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause Marco Renzi
  • Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause vinny
  • Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause Marco Renzi
  • Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause Pavel Stehule
  • Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause Pavel Stehule
  • Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause Marco Renzi
  • Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause Pavel Stehule
  • Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause Marco Renzi
  • Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause Pavel Stehule
• [PERFORM] update from performance question Armand Pirvu (home)
  • Re: [PERFORM] update from performance question Albe Laurenz
  • Re: [PERFORM] update from performance question Armand Pirvu (home)
• [PERFORM] Insert Concurrency ROBERT PRICE
  • Re: [PERFORM] Insert Concurrency David Rowley
  • Re: [PERFORM] Insert Concurrency Daniel Blanch Bataller
  • Re: [PERFORM] Insert Concurrency Claudio Freire
  • Re: [PERFORM] Insert Concurrency Scott Marlowe
  • Re: [PERFORM] Insert Concurrency David McKelvie
  • Re: [PERFORM] Insert Concurrency ROBERT PRICE
• [PERFORM] Create a materialized view in PostgreSQL which can be access by all the user account Dinesh Chandra 12108
  • Re: [PERFORM] Create a materialized view in PostgreSQL which can be access by all the user account David G. Johnston
• [PERFORM] Restoring Postgres Dump is very slow with Ubuntu 16.04 Hans Braxmeier
  • Re: [PERFORM] Restoring Postgres Dump is very slow with Ubuntu 16.04 Andreas Kretschmer
• [PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow Hans Braxmeier
  • Re: [PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow Tom Lane
• [PERFORM] Impact of track_activity_query_size on high traffic OLTP system Jeremy Finzel
  • Re: [PERFORM] Impact of track_activity_query_size on high traffic OLTP system Rick Otten
• [PERFORM] Postgresql, and ODBC handles Reza Taheri
• [PERFORM] Hi Daulat Ram
  • Re: [PERFORM] Hi Glyn Astill
  • Re: [PERFORM] Hi Daulat Ram
  • Re: [PERFORM] Hi David G. Johnston
• [PERFORM] Understanding PostgreSQL query execution time Haider Ali
  • Re: [PERFORM] Understanding PostgreSQL query execution time l...@laurent-hasson.com
  • Re: [PERFORM] Understanding PostgreSQL query execution time Gerardo Herzig
  • Re: [PERFORM] Understanding PostgreSQL query execution time vinny
• [PERFORM] Filter certain range of IP address. Dinesh Chandra 12108
  • Re: [PERFORM] Filter certain range of IP address. vinny
  • Re: [PERFORM] Filter certain range of IP address. Dinesh Chandra 12108
  • Re: [PERFORM] Filter certain range of IP address. David G. Johnston
  • Re: [PERFORM] Filter certain range of IP address. Rick Otten
  • Re: [PERFORM] Filter certain range of IP address. Dinesh Chandra 12108
  • Re: [PERFORM] Filter certain range of IP address. Moreno Andreo
  • Re: [PERFORM] Filter certain range of IP address. vinny
• [PERFORM] Table not using tsvector gin index and performance much worse than when it uses it. rverghese
  • Re: [PERFORM] Table not using tsvector gin index and performance much worse than when it uses it. Tom Lane
  • [PERFORM] Re: Table not using tsvector gin index and performance much worse than when it uses it. rverghese
  • Re: -EXT-[PERFORM] Re: Table not using tsvector gin index and performance much worse than when it uses it. Sfiligoi, Igor
  • Re: -EXT-[PERFORM] Re: Table not using tsvector gin index and performance much worse than when it uses it. rverghese
  • Re: -EXT-[PERFORM] Re: Table not using tsvector gin index and performance much worse than when it uses it. Tom Lane
  • Re: -EXT-[PERFORM] Re: Table not using tsvector gin index and performance much worse than when it uses it. rverghese
• [PERFORM] How to send content of log file in official mailid. Dinesh Chandra 12108
• [PERFORM] Delete, foreign key, index usage Johann Spies
  • Re: [PERFORM] Delete, foreign key, index usage Johann Spies
  • Re: [PERFORM] Delete, foreign key, index usage Rick Otten
  • Re: [PERFORM] Delete, foreign key, index usage Johann Spies
  • Re: [PERFORM] Delete, foreign key, index usage Tomas Vondra
  • Re: [PERFORM] Delete, foreign key, index usage Johann Spies
  • Re: [PERFORM] Delete, foreign key, index usage David Rowley
  • Re: [PERFORM] Delete, foreign key, index usage Tomas Vondra
  • Re: [PERFORM] Delete, foreign key, index usage Johann Spies
• [PERFORM] Best design for performance Riaan Stander
  • Re: [PERFORM] Best design for performance Claudio Freire
  • Re: [PERFORM] Best design for performance Riaan Stander
  • Re: [PERFORM] Best design for performance Claudio Freire
  • Re: [PERFORM] Best design for performance Riaan Stander
  • Re: [PERFORM] Best design for performance Claudio Freire
  • Re: [PERFORM] Best design for performance Riaan Stander
• [PERFORM] self join estimate and constraint exclusion Justin Pryzby
  • [PERFORM] self join estimate and constraint exclusion Justin Pryzby
  • [PERFORM] join estimate of subqueries with range conditions and constraint exclusion Justin Pryzby
  • [PERFORM] Re: join estimate of subqueries with range conditions and constraint exclusion Justin Pryzby
  • Re: [PERFORM] Re: join estimate of subqueries with range conditions and constraint exclusion Tom Lane
  • Re: [PERFORM] Re: join under-estimates with ineq conditions Justin Pryzby
  • Re: [PERFORM] Re: join under-estimates with ineq conditions Justin Pryzby
  • Re: [PERFORM] join estimate of subqueries with range conditions and constraint exclusion David G. Johnston
• [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Pietro Pugni
  • Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Andrew Kerber
  • Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Scott Marlowe
  • Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Merlin Moncure
  • Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Álvaro Hernández Tortosa
  • Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Shaun Thomas
  • Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system) trafdev
• [PERFORM] Optimizing around retained tuples James Parks
  • Re: [PERFORM] Optimizing around retained tuples Claudio Freire
  • Re: [PERFORM] Optimizing around retained tuples Claudio Freire
  • Re: [PERFORM] Optimizing around retained tuples Brad DeJong
• [PERFORM] Auto generate number in Postgres-9.1. Dinesh Chandra 12108
  • Re: [PERFORM] Auto generate number in Postgres-9.1. Josh Berkus
  • Re: [PERFORM] Auto generate number in Postgres-9.1. Andreas Karlsson
  • Re: [PERFORM] Auto generate number in Postgres-9.1. John Gorman
  • Re: [PERFORM] Auto generate number in Postgres-9.1. Dinesh Chandra 12108
  • Re: [PERFORM] Auto generate number in Postgres-9.1. Andreas Karlsson
• [PERFORM] Please help with a slow query: there are millions of records, what can we do? Pat Maddox
  • Re: [PERFORM] Please help with a slow query: there are millions of records, what can we do? Albe Laurenz
  • Re: [PERFORM] Please help with a slow query: there are millions of records, what can we do? Jeff Janes
  • Re: [PERFORM] Please help with a slow query: there are millions of records, what can we do? Pat Maddox
• [PERFORM] Huge difference between ASC and DESC ordering twoflower
  • Re: [PERFORM] Huge difference between ASC and DESC ordering Jeff Janes
  • Re: [PERFORM] Huge difference between ASC and DESC ordering twoflower
  • Re: [PERFORM] Huge difference between ASC and DESC ordering Jeff Janes
  • Re: [PERFORM] Huge difference between ASC and DESC ordering twoflower
• [PERFORM] Performance issue after upgrading from 9.4 to 9.6 Piotr Gasidło
  • Re: [PERFORM] Performance issue after upgrading from 9.4 to 9.6 Merlin Moncure
• [PERFORM] Performance issue in PostgreSQL server... Dinesh Chandra 12108
  • Re: [PERFORM] Performance issue in PostgreSQL server... Nur Agus
  • Re: [PERFORM] Performance issue in PostgreSQL server... Dinesh Chandra 12108
  • Re: [PERFORM] Performance issue in PostgreSQL server... Tom Lane
  • Re: [PERFORM] Performance issue in PostgreSQL server... Jeff Janes
  • Re: [PERFORM] Performance issue in PostgreSQL server... Justin Pryzby
  • Re: [PERFORM] Performance issue in PostgreSQL server... Dinesh Chandra 12108
  • Re: [PERFORM] Performance issue in PostgreSQL server... Justin Pryzby
• [PERFORM] anti-join with small table via text/varchar cannot estimate rows correctly Stefan Andreatta
  • Re: [PERFORM] anti-join with small table via text/varchar cannot estimate rows correctly David G. Johnston
  • Re: [PERFORM] anti-join with small table via text/varchar cannot estimate rows correctly Jeff Janes
  • Re: [PERFORM] anti-join with small table via text/varchar cannot estimate rows correctly David G. Johnston
  • Re: [PERFORM] anti-join with small table via text/varchar cannot estimate rows correctly Tom Lane
  • Re: [PERFORM] anti-join with small table via text/varchar cannot estimate rows correctly Stefan Andreatta
• [PERFORM] How Can I check PostgreSQL backup is successfully or not ? Dinesh Chandra 12108
  • Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? Rick Otten
  • Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? John Gorman
  • Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? vinny
  • Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? Dinesh Chandra 12108
  • Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? Dinesh Chandra 12108
  • Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? Rick Otten
  • Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? Dinesh Chandra 12108
  • Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? l...@laurent-hasson.com
  • Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? Dinesh Chandra 12108
  • Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? Gustavo Vargas
• [PERFORM] Speeding up JSON + TSQUERY + GIN Sven R. Kunze
  • Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Oleg Bartunov
  • Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Sven R. Kunze
  • Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Jeff Janes
  • Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Sven R. Kunze
  • Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Jeff Janes
  • Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Sven R. Kunze
  • Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Jeff Janes
  • Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Sven R. Kunze
  • Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Jeff Janes
  • Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Sven R. Kunze
• Re: [PERFORM] How to log quires which are taking time in PostgreSQL 9.1. Luis Fernando Simone
  • Re: [PERFORM] How to log quires which are taking time in PostgreSQL 9.1. Dinesh Chandra 12108
• [PERFORM] How to log quires which are taking time in PostgreSQL 9.1. Dinesh Chandra 12108
  • Re: [PERFORM] How to log quires which are taking time in PostgreSQL 9.1. ProPAAS DBA
  • Re: [PERFORM] How to log quires which are taking time in PostgreSQL 9.1. Dinesh Chandra 12108
• [PERFORM] Query performance changes significantly depending on limit value Rowan Seymour
  • Re: [PERFORM] Query performance changes significantly depending on limit value Pavel Stehule
  • Re: [PERFORM] Query performance changes significantly depending on limit value Rowan Seymour
  • Re: [PERFORM] Query performance changes significantly depending on limit value Pavel Stehule
  • Re: [PERFORM] Query performance changes significantly depending on limit value Rowan Seymour
  • Re: [PERFORM] Query performance changes significantly depending on limit value Pavel Stehule
• [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Pietro Pugni
  • Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Merlin Moncure
  • Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Wes Vaske (wvaske)
  • Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Merlin Moncure
  • Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Wes Vaske (wvaske)
  • Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Pietro Pugni
  • Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Wes Vaske (wvaske)
  • Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Pietro Pugni
  • Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Merlin Moncure
  • Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Pietro Pugni
  • Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Scott Marlowe
  • Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Pietro Pugni
• [PERFORM] Number of characters in column preventing index usage Hustler DBA
  • Re: [PERFORM] Number of characters in column preventing index usage David G. Johnston
  • Re: [PERFORM] Number of characters in column preventing index usage Tomas Vondra
  • Re: [PERFORM] Number of characters in column preventing index usage Hustler DBA
  • Re: [PERFORM] Number of characters in column preventing index usage Tomas Vondra

• Earlier messages
• Later messages