pgsql-performance  

Messages by Thread

• • Re: [PERFORM] Number of characters in column preventing index usage David G. Johnston
  • Re: [PERFORM] Number of characters in column preventing index usage Tom Lane
  • Re: [PERFORM] Number of characters in column preventing index usage Hustler DBA
  • Re: [PERFORM] Number of characters in column preventing index usage Alvaro Herrera
• [PERFORM] Correct use of cursors for very large result sets in Postgres Mike Beaton
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres Mike Beaton
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres Tom Lane
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres Mike Beaton
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres Mike Beaton
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres Tom Lane
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres Mike Beaton
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres Mike Beaton
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres Tom Lane
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres Mike Beaton
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres John Gorman
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres Vitalii Tymchyshyn
  • Re: [PERFORM] Correct use of cursors for very large result sets in Postgres John Gorman
• [PERFORM] Inaccurate GiST Index Cost Causes DB Contention PC Drew
• [PERFORM] strange and slow joining of nested views Titus von Boxberg
  • Re: [PERFORM] strange and slow joining of nested views Tom Lane
  • Re: [PERFORM] strange and slow joining of nested views Titus von Boxberg
• [PERFORM] PSA: upgrade your extensions Merlin Moncure
  • Re: [PERFORM] PSA: upgrade your extensions Daniel Blanch Bataller
  • Re: [PERFORM] PSA: upgrade your extensions Jeff Janes
  • Re: [PERFORM] PSA: upgrade your extensions Merlin Moncure
• [PERFORM] pgsql connection timeone Vucomir Ianculov
  • Re: [PERFORM] pgsql connection timeone Vucomir Ianculov
  • Re: [PERFORM] pgsql connection timeone Tom Lane
  • Re: [PERFORM] pgsql connection timeone Vucomir Ianculov
  • Re: [PERFORM] pgsql connection timeone Vucomir Ianculov
  • Re: [PERFORM] pgsql connection timeone Vitalii Tymchyshyn
  • Re: [PERFORM] pgsql connection timeone Vucomir Ianculov
  • Re: [PERFORM] pgsql connection timeone Vitalii Tymchyshyn
  • Re: [PERFORM] pgsql connection timeone Vucomir Ianculov
• [PERFORM] performance contradiction Gabriel Dodan
  • Re: [PERFORM] performance contradiction Feike Steenbergen
• [PERFORM] Backup taking long time !!! Dinesh Chandra 12108
  • Re: [PERFORM] Backup taking long time !!! Madusudanan.B.N
  • Re: [PERFORM] Backup taking long time !!! Dinesh Chandra 12108
  • Re: [PERFORM] Backup taking long time !!! Pavel Stehule
  • Re: [PERFORM] Backup taking long time !!! Dinesh Chandra 12108
  • Re: [PERFORM] Backup taking long time !!! Pavel Stehule
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! Vladimir Borodin
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! Vladimir Borodin
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! Vladimir Borodin
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! Vladimir Borodin
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! Jim Nasby
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! Jim Nasby
  • Re: [PERFORM] Backup taking long time !!! David Steele
  • Re: [PERFORM] Backup taking long time !!! Torsten Zuehlsdorff
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! Madusudanan.B.N
  • Re: [PERFORM] Backup taking long time !!! julyanto SUTANDANG
  • Re: [PERFORM] Backup taking long time !!! julyanto SUTANDANG
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! Jeff Janes
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! Simon Riggs
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! Jeff Janes
  • Re: [PERFORM] Backup taking long time !!! Rick Otten
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! julyanto SUTANDANG
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! julyanto SUTANDANG
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! julyanto SUTANDANG
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
  • Re: [PERFORM] Backup taking long time !!! julyanto SUTANDANG
  • Re: [PERFORM] Backup taking long time !!! Jim Nasby
  • Re: [PERFORM] Backup taking long time !!! Jeff Janes
  • Re: [PERFORM] Backup taking long time !!! Stephen Frost
• [PERFORM] Chaotic query planning ? Philippe Ivaldi
  • Re: [PERFORM] Chaotic query planning ? Albe Laurenz
  • Re: [PERFORM] Chaotic query planning ? Philippe Ivaldi
• [PERFORM] Optimization inner join Clailson
  • Re: [PERFORM] Optimization inner join Phillip Couto
  • Re: [PERFORM] Optimization inner join Clailson
  • Re: [PERFORM] Optimization inner join Phillip Couto
  • Re: [PERFORM] Optimization inner join Gustavo Rezende Montesino
  • Re: [PERFORM] Optimization inner join Tom Lane
  • Re: [PERFORM] Optimization inner join Gustavo Rezende Montesino
  • Re: [PERFORM] Optimization inner join Phillip Couto
  • Re: [PERFORM] Optimization inner join Vitalii Tymchyshyn
  • Re: [PERFORM] Optimization inner join Phillip Couto
• [PERFORM] optimizing immutable vs. stable function calls? Karl Czajkowski
  • Re: [PERFORM] optimizing immutable vs. stable function calls? Tom Lane
  • Re: [PERFORM] optimizing immutable vs. stable function calls? David G. Johnston
  • Re: [PERFORM] optimizing immutable vs. stable function calls? Tom Lane
  • Re: [PERFORM] optimizing immutable vs. stable function calls? David G. Johnston
  • Re: [PERFORM] optimizing immutable vs. stable function calls? Jim Nasby
  • Re: [PERFORM] optimizing immutable vs. stable function calls? Merlin Moncure
  • Re: [PERFORM] optimizing immutable vs. stable function calls? Karl Czajkowski
  • Re: [PERFORM] optimizing immutable vs. stable function calls? Tom Lane
  • Re: [PERFORM] optimizing immutable vs. stable function calls? Karl Czajkowski
• [PERFORM] out of range error while restore using pgdump Samir Magar
  • Re: [PERFORM] out of range error while restore using pgdump Tom Lane
• [PERFORM] How can I find the source of postgresql per-connection memory leaks? Eric Jensen
  • Re: [PERFORM] How can I find the source of postgresql per-connection memory leaks? Joshua D. Drake
• [PERFORM] Sort-of replication for reporting purposes Ivan Voras
  • Re: [PERFORM] Sort-of replication for reporting purposes Scott Marlowe
  • Re: [PERFORM] Sort-of replication for reporting purposes Ivan Voras
  • Re: [PERFORM] Sort-of replication for reporting purposes Stuart Bishop
  • Re: [PERFORM] Sort-of replication for reporting purposes Ivan Voras
  • Re: [PERFORM] Sort-of replication for reporting purposes Stuart Bishop
  • Re: [PERFORM] Sort-of replication for reporting purposes Phillip Couto
  • Re: [PERFORM] Sort-of replication for reporting purposes Rick Otten
  • Re: [PERFORM] Sort-of replication for reporting purposes Stephen Frost
  • Re: [PERFORM] Sort-of replication for reporting purposes ProPAAS DBA
• [PERFORM] Unable to connect to server Vucomir Ianculov
  • Re: [PERFORM] Unable to connect to server Andreas Kretschmer
  • Re: [PERFORM] Unable to connect to server Vucomir Ianculov
  • Re: [PERFORM] Unable to connect to server Andreas Kretschmer
• [PERFORM] Performance issue with castings args of the function Андрей Хозов
  • Re: [PERFORM] Performance issue with castings args of the function Pavel Stehule
  • Re: [PERFORM] Performance issue with castings args of the function Tom Lane
  • Re: [PERFORM] Performance issue with castings args of the function Андрей Хозов
• Re: [PERFORM] copy vs. C function rajmhn
• [PERFORM] Fwd: [pgsql-performance] Daily digest v1.4804 (8 messages) Valerii Valeev
• [PERFORM] Slow query after 9.3 to 9.6 migration Flávio Henrique
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Gerardo Herzig
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Daniel Blanch Bataller
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Kevin Grittner
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Merlin Moncure
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Flávio Henrique
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Kevin Grittner
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Daniel Blanch Bataller
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Peter Geoghegan
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Merlin Moncure
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Filipe Oliveira
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Michael Paquier
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Filipe Oliveira
  • Re: [PERFORM] Slow query after 9.3 to 9.6 migration Scott Marlowe
• [PERFORM] why we do not create indexes on master Valerii Valeev
  • Re: [PERFORM] why we do not create indexes on master Andreas Kretschmer
  • Re: [PERFORM] why we do not create indexes on master David G. Johnston
  • Re: [PERFORM] why we do not create indexes on master Valerii Valeev
  • Re: [PERFORM] why we do not create indexes on master ProPAAS DBA
  • Re: [PERFORM] why we do not create indexes on master David G. Johnston
  • Re: [PERFORM] why we do not create indexes on master Valerii Valeev
• [PERFORM] Invalid page header in block 25561983 of relation pg_tblspc Dinesh Chandra 12108
  • Re: [PERFORM] Invalid page header in block 25561983 of relation pg_tblspc Michael Paquier
• [PERFORM] How to vacuum entire database excluding some tables in PostgreSQL9.1. Dinesh Chandra 12108
  • Re: [PERFORM] How to vacuum entire database excluding some tables in PostgreSQL9.1. ProPAAS DBA
• [PERFORM] bad performance Gabliver Faluker
  • Re: [PERFORM] bad performance Tom Lane
  • Re: [PERFORM] bad performance Jeremy Harris
• [PERFORM] Size of Temporary tablespace is increasing very much in postgresql 9.1. Dinesh Chandra 12108
  • Re: [PERFORM] Size of Temporary tablespace is increasing very much in postgresql 9.1. Mark Kirkwood
  • Re: [PERFORM] Size of Temporary tablespace is increasing very much in postgresql 9.1. Dinesh Chandra 12108
• [PERFORM] Ordering on GIN Index Rory
• [PERFORM] Isolation of tx logs on VMware ProPAAS DBA
  • Re: [PERFORM] Isolation of tx logs on VMware Joshua D. Drake
• [PERFORM] Querying with multicolumn index Eric Jiang
  • Re: [PERFORM] Querying with multicolumn index Andreas Joseph Krogh
  • Re: [PERFORM] Querying with multicolumn index Eric Jiang
  • Re: [PERFORM] Querying with multicolumn index Tom Lane
  • Re: [PERFORM] Querying with multicolumn index Tomas Vondra
  • Re: [PERFORM] Querying with multicolumn index Tom Lane
  • Re: [PERFORM] Querying with multicolumn index Daniel Blanch Bataller
  • Re: [PERFORM] Querying with multicolumn index Daniel Blanch Bataller
  • Re: [PERFORM] Querying with multicolumn index Daniel Blanch Bataller
  • Re: [PERFORM] Querying with multicolumn index Eric Jiang
  • Re: [PERFORM] Querying with multicolumn index Tom Lane
  • Re: [PERFORM] Querying with multicolumn index Eric Jiang
• [PERFORM] Slow query question Andrey Povazhnyi
  • Re: [PERFORM] Slow query question Tom Lane
  • Re: [PERFORM] Slow query question Andrey Povazhnyi
• [PERFORM] Substantial different index use between 9.5 and 9.6 Bill Measday
  • Re: [PERFORM] Substantial different index use between 9.5 and 9.6 Tom Lane
  • Re: [PERFORM] Substantial different index use between 9.5 and 9.6 Bill Measday
  • Re: [PERFORM] Substantial different index use between 9.5 and 9.6 Daniel Blanch Bataller
  • Re: [PERFORM] Substantial different index use between 9.5 and 9.6 Bill Measday
• [PERFORM] performance issue with bitmap index scans on huge amounts of big jsonb documents Marc-Olaf Jaschke
  • Re: [PERFORM] performance issue with bitmap index scans on huge amounts of big jsonb documents Jeff Janes
  • Re: [PERFORM] performance issue with bitmap index scans on huge amounts of big jsonb documents Marc-Olaf Jaschke
  • Re: [PERFORM] performance issue with bitmap index scans on huge amounts of big jsonb documents Merlin Moncure
• [PERFORM] can trigger monitor two tables? zhangkai.gis
  • Re: [PERFORM] can trigger monitor two tables? Andreas Kretschmer
• [PERFORM] Slow UPDATE in logs that's usually fast Aldo Sarmiento
• [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Carmen Mardiros
  • Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Andreas Kretschmer
  • Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Carmen Mardiros
  • Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Imre Samu
  • Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Carmen Mardiros
  • Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware Tom Lane
• [PERFORM] DO I miss something ? Metatrader EA
  • Re: [PERFORM] DO I miss something ? vinny
• [PERFORM] materialized view order by and clustering Rick Otten
  • Re: [PERFORM] materialized view order by and clustering David G. Johnston
• [PERFORM] Query hangs sometimes Metatrader EA
  • Re: [PERFORM] Query hangs sometimes Guillaume Cottenceau
  • Re: [PERFORM] Query hangs sometimes Metatrader EA
  • Re: [PERFORM] Query hangs sometimes Michael Paquier

• Earlier messages
• Later messages