pgsql-performance
Thread
Date
Earlier messages
Messages by Thread
[PERFORM] Migration to pglister - Before
Stephen Frost
[PERFORM] PostgreSQL 9.6 wals management
Mariel Cherkassky
Re: [PERFORM] PostgreSQL 9.6 wals management
Michael Paquier
Re: [PERFORM] PostgreSQL 9.6 wals management
Mariel Cherkassky
[PERFORM] POWA doesn't show queries executed
Neto pr
[PERFORM] CREATE STATISTICS and join selectivity
Justin Pryzby
Re: [PERFORM] CREATE STATISTICS and join selectivity
David Rowley
[PERFORM] query performance issue
Samir Magar
Re: [PERFORM] query performance issue
Pavel Stehule
Re: [PERFORM] query performance issue
Samir Magar
Re: [PERFORM] query performance issue
Pavel Stehule
Re: [PERFORM] query performance issue
Gunther
Re: [PERFORM] query performance issue
Pavel Stehule
Re: [PERFORM] query performance issue
Justin Pryzby
[PERFORM] Query planner gaining the ability to replanning after start of query execution.
Oliver Mattos
Re: [PERFORM] Query planner gaining the ability to replanning after start of query execution.
Arne Roland
Re: [PERFORM] Query planner gaining the ability to replanning after start of query execution.
Oliver Mattos
Re: [PERFORM] Query planner gaining the ability to replanning after start of query execution.
Tom Lane
Re: [PERFORM] Query planner gaining the ability to replanning after start of query execution.
Oliver Mattos
[PERFORM] Re: Query planner gaining the ability to replanning after start of query execution.
legrand legrand
Re: [PERFORM] Query planner gaining the ability to replanning after start of query execution.
Arne Roland
[PERFORM] Re: Query planner gaining the ability to replanning after start of query execution.
Gunter
[PERFORM] DB slowness after upgrade from Postgres 9.1 to 9.4
p kirti
Re: [PERFORM] DB slowness after upgrade from Postgres 9.1 to 9.4
Tom Lane
[PERFORM] overestimate on empty table
Justin Pryzby
Re: [PERFORM] overestimate on empty table
Tom Lane
Re: [PERFORM] overestimate on empty table
Justin Pryzby
Re: [PERFORM] overestimate on empty table
Tom Lane
[PERFORM] Dynamic performance issues
Arne Roland
[PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Ulf Lohbrügge
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Andres Freund
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Ulf Lohbrügge
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Andres Freund
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Ulf Lohbrügge
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Scott Marlowe
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Ulf Lohbrügge
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Tom Lane
Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Ulf Lohbrügge
[PERFORM] Performance loss upgrading from 9.3 to 9.6
Adam Torres
Re: [PERFORM] Performance loss upgrading from 9.3 to 9.6
Justin Pryzby
Re: [PERFORM] Performance loss upgrading from 9.3 to 9.6
Adam Torres
Re: [PERFORM] Performance loss upgrading from 9.3 to 9.6
Adam Brusselback
Re: [PERFORM] Performance loss upgrading from 9.3 to 9.6
Justin Pryzby
[PERFORM] Unnecessary DISTINCT while primary key in SQL
刘瑞
Re: [PERFORM] Unnecessary DISTINCT while primary key in SQL
David Rowley
[PERFORM] OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
Gunther
Re: [PERFORM] OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
l...@laurent-hasson.com
Re: [PERFORM] OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
Gunther
Re: [PERFORM] OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
Laurenz Albe
Re: [PERFORM] OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
Gunther
[PERFORM] Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
legrand legrand
Re: [PERFORM] OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
Laurenz Albe
[PERFORM] Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
Thomas Kellerer
Re: [PERFORM] Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
Adam Brusselback
Re: [PERFORM] Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
Gunther
Re: [PERFORM] Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
Gunther
[PERFORM] Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
legrand legrand
Re: [PERFORM] Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
Gunther
Re: [PERFORM] Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices
Dave Nicponski
[PERFORM] Cursor vs Set Operation
patibandlakoshal
Re: [PERFORM] Cursor vs Set Operation
Merlin Moncure
[PERFORM] Index-Advisor Tools
Neto pr
Re: [PERFORM] Index-Advisor Tools
Anthony Sotolongo
Re: [PERFORM] Index-Advisor Tools
Neto pr
Re: [PERFORM] Index-Advisor Tools
Alexandre de Arruda Paes
Re: [PERFORM] Index-Advisor Tools
Julien Rouhaud
Re: [PERFORM] Index-Advisor Tools
Baron Schwartz
Re: [PERFORM] Index-Advisor Tools
Yves Dorfsman
[PERFORM] Massive insert vs heavy contention in LWLock:buffer_content
luisfpg
[PERFORM] Cheaper subquery scan not considered unless offset 0
Benjamin Coutu
Re: [PERFORM] Cheaper subquery scan not considered unless offset 0
David Rowley
Re: [PERFORM] Cheaper subquery scan not considered unless offset 0
Tom Lane
Re: [PERFORM] Cheaper subquery scan not considered unless offset 0
Benjamin Coutu
Re: [PERFORM] Cheaper subquery scan not considered unless offset 0
Benjamin Coutu
[PERFORM] Row-level security performance
Jason Borg
[PERFORM] WAL still kept in pg_xlog even long after heavy workload is done
Stefan Petrea
Re: [PERFORM] WAL still kept in pg_xlog even long after heavy workload is done
MichaelDBA
[PERFORM] postgresql tuning with perf
Purav Chovatia
Re: [PERFORM] postgresql tuning with perf
legrand legrand
Re: [PERFORM] postgresql tuning with perf
Purav Chovatia
Re: [PERFORM] postgresql tuning with perf
legrand legrand
Re: [PERFORM] postgresql tuning with perf
Purav Chovatia
Re: [PERFORM] postgresql tuning with perf
Tomas Vondra
Re: [PERFORM] postgresql tuning with perf
legrand legrand
Re: [PERFORM] postgresql tuning with perf
Steve Atkins
Re: [PERFORM] postgresql tuning with perf
Purav Chovatia
[PERFORM] Low priority batch insert
Jean Baro
Re: [PERFORM] Low priority batch insert
Michael Paquier
[PERFORM] memory allocation
nijam J
Re: [PERFORM] memory allocation
Laurenz Albe
[PERFORM] Row level security policy policy versus SQL constraints. Any performance difference?
Joe Carlson
Re: [PERFORM] Row level security policy policy versus SQL constraints. Any performance difference?
Tomas Vondra
Re: [PERFORM] Row level security policy policy versus SQL constraints. Any performance difference?
Tom Lane
Re: [PERFORM] Row level security policy policy versus SQL constraints. Any performance difference?
Joe Carlson
[PERFORM] 99% time spent in WAL wait events
Purav Chovatia
Re: [PERFORM] 99% time spent in WAL wait events
Purav Chovatia
[PERFORM] Wrong plane for limit after group by
Денис Смирнов
[PERFORM] synchronization between PostgreSQL and Oracle
ROS Didier
Re: [PERFORM] synchronization between PostgreSQL and Oracle
Rick Otten
Re: [PERFORM] synchronization between PostgreSQL and Oracle
Laurenz Albe
[PERFORM] blocking index creation
Neto pr
Re: [PERFORM] blocking index creation
Laurenz Albe
Re: [PERFORM] blocking index creation
Neto pr
Re: [PERFORM] blocking index creation
Tomas Vondra
Re: [PERFORM] blocking index creation
Neto pr
Re: [PERFORM] blocking index creation
Neto pr
Re: [PERFORM] blocking index creation
Scott Marlowe
[PERFORM] performance drop after upgrade (9.6 > 10)
johannes graën
Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Pavel Stehule
Re: [PERFORM] performance drop after upgrade (9.6 > 10)
johannes graën
Re: [PERFORM] performance drop after upgrade (9.6 > 10)
johannes graën
Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Justin Pryzby
Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Johannes Graën
Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Alvaro Herrera
Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Justin Pryzby
[PERFORM] Rowcount estimation changes based on from clause order
Ants Aasma
Re: [PERFORM] Rowcount estimation changes based on from clause order
Tom Lane
Re: [PERFORM] Rowcount estimation changes based on from clause order
Ants Aasma
[PERFORM] Cursor With_Hold Performance Workarounds/Optimization
Leon Winter
[PERFORM] Regression from 9.4-9.6
Jim Nasby
Re: [PERFORM] Regression from 9.4-9.6
Tom Lane
Re: [PERFORM] Regression from 9.4-9.6
Jim Nasby
Re: [PERFORM] Regression from 9.4-9.6
Jim Nasby
Re: [PERFORM] Regression from 9.4-9.6
Tom Lane
Re: [PERFORM] Regression from 9.4-9.6
Jim Nasby
[PERFORM] How does max_parallel_workers_per_gather change load averages?
Ben Nachtrieb
Re: [PERFORM] How does max_parallel_workers_per_gather change load averages?
David Rowley
[PERFORM] Stored Procedure Performance
Purav Chovatia
Re: [PERFORM] Stored Procedure Performance
Laurenz Albe
Re: [PERFORM] Stored Procedure Performance
Adam Brusselback
Re: [PERFORM] Stored Procedure Performance
Pavel Stehule
Re: [PERFORM] Stored Procedure Performance
Purav Chovatia
Re: [PERFORM] Stored Procedure Performance
phb07
Re: [PERFORM] Stored Procedure Performance
Purav Chovatia
Re: [PERFORM] Stored Procedure Performance
Pavel Stehule
Re: [PERFORM] Stored Procedure Performance
Purav Chovatia
Re: [PERFORM] Stored Procedure Performance
Adam Brusselback
Re: [PERFORM] Stored Procedure Performance
Purav Chovatia
Re: [PERFORM] Stored Procedure Performance
Adam Brusselback
Re: [PERFORM] Stored Procedure Performance
Pavel Stehule
[PERFORM] select with max functions
Mariel Cherkassky
Re: [PERFORM] select with max functions
Gerardo Herzig
Re: [PERFORM] select with max functions
Andreas Kretschmer
Re: [PERFORM] select with max functions
Mariel Cherkassky
Re: [PERFORM] select with max functions
Gerardo Herzig
Re: [PERFORM] select with max functions
Mariel Cherkassky
Re: [PERFORM] select with max functions
Tom Lane
Re: [PERFORM] select with max functions
Mark Kirkwood
[PERFORM] BDR, wal sender, high system cpu, mutex_lock_common
milist ujang
Re: [PERFORM] BDR, wal sender, high system cpu, mutex_lock_common
milist ujang
[PERFORM] Slow query in JDBC
Subramaniam C
Re: [PERFORM] Slow query in JDBC
Julien Rouhaud
Re: [PERFORM] Slow query in JDBC
Subramaniam C
Re: [PERFORM] Slow query in JDBC
Julien Rouhaud
Re: [PERFORM] Slow query in JDBC
Pavy Philippe
Re: [PERFORM] Slow query in JDBC
Subramaniam C
Re: [PERFORM] Slow query in JDBC
Dave Cramer
Re: [PERFORM] Slow query in JDBC
Subramaniam C
Re: [PERFORM] Slow query in JDBC
Dave Cramer
Re: [PERFORM] Slow query in JDBC
Subramaniam C
Re: [PERFORM] Slow query in JDBC
Jeff Janes
Re: [PERFORM] Slow query in JDBC
Subramaniam C
Re: [PERFORM] Slow query in JDBC
Dave Cramer
[PERFORM] Parallel sequential scan not supported for stored procedure with RETURN QUERY EXECUTE ?
Tobias Gierke
[PERFORM] Query regarding EXPLAIN (ANALYZE,BUFFERS)
Subramaniam C
Re: [PERFORM] Query regarding EXPLAIN (ANALYZE,BUFFERS)
Pavel Stehule
[PERFORM] repeated subplan execution
Jeff Janes
Re: [PERFORM] repeated subplan execution
monika yadav
Re: [PERFORM] repeated subplan execution
Jeff Janes
Re: [PERFORM] repeated subplan execution
monika yadav
[PERFORM] https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
園田祥平
Re: [PERFORM] https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
Tomas Vondra
Re: [PERFORM] https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
George Neuner
Re: [PERFORM] https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
Jonathan Rogers
[PERFORM] max partitions behind a view?
Rick Otten
Re: [PERFORM] max partitions behind a view?
Tom Lane
[PERFORM] Pageinspect bt_metap help
Neto pr
Re: [PERFORM] Pageinspect bt_metap help
Peter Geoghegan
Re: [PERFORM] Pageinspect bt_metap help
Neto pr
Re: [PERFORM] Pageinspect bt_metap help
Peter Geoghegan
Re: [PERFORM] Pageinspect bt_metap help
Tom Lane
[PERFORM] Partitioning perfomance issue
Konstantin Kivi
[PERFORM] Indexing an array of two separate columns
Jeremy Finzel
[PERFORM] Store/Retrieve time series data from PostgreSQL
Subramaniam C
Re: [PERFORM] Store/Retrieve time series data from PostgreSQL
vinny
Re: [PERFORM] Store/Retrieve time series data from PostgreSQL
Subramaniam C
Re: [PERFORM] Store/Retrieve time series data from PostgreSQL
Subramaniam C
[PERFORM] query of partitioned object doesnt use index in qa
Mike Broers
Re: [PERFORM] query of partitioned object doesnt use index in qa
David Rowley
Re: [PERFORM] query of partitioned object doesnt use index in qa
Mike Broers
Re: [PERFORM] query of partitioned object doesnt use index in qa
Mike Broers
Re: [PERFORM] query of partitioned object doesnt use index in qa
Tom Lane
Re: [PERFORM] query of partitioned object doesnt use index in qa
Mike Broers
Re: [PERFORM] query of partitioned object doesnt use index in qa
Mike Broers
Re: [PERFORM] query of partitioned object doesnt use index in qa
David Rowley
Re: [PERFORM] query of partitioned object doesnt use index in qa
Mike Broers
Re: [PERFORM] query of partitioned object doesnt use index in qa
Andres Freund
Re: [PERFORM] query of partitioned object doesnt use index in qa
Tom Lane
Re: [PERFORM] query of partitioned object doesnt use index in qa
Tomas Vondra
Re: [PERFORM] postgresql 9.6 data directory fs becomes full
Tom Lane
Earlier messages