public inbox for pgsql-performance@postgresql.orghelp / color / mirror / Atom feed
Messages from tgl@sss.pgh.pa.us Re: how to switch user in postgres 2026-04-11 19:29 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE 2025-01-09 19:39 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Query planner gaining the ability to replanning after start of query execution. 2017-11-13 22:49 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: DB slowness after upgrade from Postgres 9.1 to 9.4 2017-11-12 19:37 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: overestimate on empty table 2017-11-11 17:43 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: overestimate on empty table 2017-11-10 21:19 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Slow execution of SET ROLE, SET search_path and RESET ROLE 2017-11-07 23:45 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: proposal: schema variables 2017-11-02 15:48 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Cheaper subquery scan not considered unless offset 0 2017-10-29 14:58 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Row level security policy policy versus SQL constraints. Any performance difference? 2017-10-17 22:06 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Rowcount estimation changes based on from clause order 2017-10-12 20:50 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Regression from 9.4-9.6 2017-10-08 20:37 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Regression from 9.4-9.6 2017-10-08 19:34 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: select with max functions 2017-10-02 15:29 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Pageinspect bt_metap help 2017-09-19 03:28 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: max partitions behind a view? 2017-09-18 13:55 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: query of partitioned object doesnt use index in qa 2017-09-15 22:05 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: query of partitioned object doesnt use index in qa 2017-09-15 20:42 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: postgresql 9.6 data directory fs becomes full 2017-09-11 12:02 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Explain Analyze - actual time in loops 2017-09-08 14:07 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Explain Analyze - actual time in loops 2017-09-08 13:44 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: 10x faster sort performance on Skylake CPU vs Ivy Bridge 2017-08-25 15:07 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Postgres Dump - Creating index never stops 2017-07-12 19:41 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: slow delete due to reference 2017-06-24 16:14 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Efficiently merging and sorting collections of sorted rows 2017-06-23 23:33 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Dataset is fetched from cache but still takes same time to fetch records as first run 2017-06-23 04:50 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: substring index what is better way to query 2017-06-20 14:45 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: substring index what is better way to query 2017-06-20 14:19 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Sudden drastic change in performance 2017-06-15 15:09 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: index of only not null, use function index? 2017-06-08 14:58 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Re: join estimate of subqueries with range conditions and constraint exclusion 2017-06-05 21:02 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Seeing execution plan of foreign key constraint check? 2016-07-21 21:59 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Seeing execution plan of foreign key constraint check? 2016-07-19 20:10 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: less than 2 sec for response - possible? 2016-07-02 01:23 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Random slow queries 2016-06-29 21:44 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Random slow queries 2016-06-29 20:20 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s 2016-06-25 18:08 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: 9.6 query slower than 9.5.3 2016-06-17 15:22 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: 9.6 query slower than 9.5.3 2016-06-17 03:57 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: 9.6 query slower than 9.5.3 2016-06-17 02:45 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: 9.6 query slower than 9.5.3 2016-06-17 02:04 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Index not used 2016-06-16 15:05 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Many-to-many performance problem 2016-06-10 15:23 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Many-to-many performance problem 2016-06-10 14:13 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: array size exceeds the maximum allowed (1073741823) when building a json 2016-06-08 06:04 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Locking concurrency: select for update vs update 2016-06-07 13:24 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: index fragmentation on insert-only table with non-unique column 2016-06-05 16:03 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Re: Planner chooses slow index heap scan despite accurate row estimates 2016-05-28 00:16 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Planner chooses slow index heap scan despite accurate row estimates 2016-05-27 23:17 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Performance problems with 9.2.15 2016-05-27 13:46 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: index fragmentation on insert-only table with non-unique column 2016-05-25 04:43 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: LIKE pattern 2016-05-12 17:25 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Adding a ROLLUP switches to GroupAggregate unexpectedly 2016-03-31 18:56 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Searching GIN-index (FTS) and sort by timestamp-column 2016-03-17 17:57 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Searching GIN-index (FTS) and sort by timestamp-column 2016-03-17 17:20 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Searching GIN-index (FTS) and sort by timestamp-column 2016-03-16 13:37 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Merge joins on index scans 2016-03-14 00:57 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Odd behavior with indices 2016-03-04 23:53 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Merge joins on index scans 2016-03-01 01:22 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Odd behavior with indices 2016-02-29 18:47 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: [GENERAL] Why Postgres use a little memory on Windows. 2016-02-20 18:37 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: gin performance issue. 2016-02-05 15:07 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: bad COPY performance with NOTIFY in a trigger 2016-02-04 22:41 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Bitmap and-ing between btree and gin? 2016-02-04 16:08 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: View containing a recursive function 2016-02-01 09:44 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: High Planning Time 2016-01-22 14:35 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Queries intermittently slow 2016-01-07 18:34 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Queries intermittently slow 2016-01-07 15:19 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Queries intermittently slow 2016-01-06 16:32 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Queries intermittently slow 2016-01-06 16:14 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Queries intermittently slow 2016-01-06 15:38 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Queries intermittently slow 2016-01-06 15:19 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Plan differences 2015-12-31 17:11 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Plan differences 2015-12-31 15:02 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Terrible plan choice for view with distinct on clause 2015-12-17 17:00 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Selectivity for lopsided foreign key columns 2015-12-17 15:23 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Getting an optimal plan on the first execution of a pl/pgsql function 2015-12-14 20:41 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Query that took a lot of time in Postgresql when not using trim in order by 2015-11-29 17:58 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Index scan cost calculation 2015-11-26 18:26 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Index scan cost calculation 2015-11-26 16:44 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: No index only scan on md5 index 2015-11-26 01:01 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Why is now()::date so much faster than current_date 2015-11-17 15:26 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Simple delete query is taking too long (never ends) 2015-11-12 22:26 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Simple delete query is taking too long (never ends) 2015-11-12 15:36 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Simple delete query is taking too long (never ends) 2015-11-11 19:33 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Slow 3 Table Join with v bad row estimate 2015-11-10 17:05 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Slow 3 Table Join with v bad row estimate 2015-11-10 15:03 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: querying jsonb for arrays inside a hash 2015-11-08 00:00 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Slow query in trigger function 2015-11-02 18:10 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Slow query in trigger function 2015-11-02 14:45 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Query optimizer plans with very small selectivity estimates 2015-10-29 18:24 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Query planner wants to use seq scan 2015-10-27 12:03 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: query partitioned table is very slow 2015-10-16 23:02 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: LIMIT 1 poor query plan 2015-10-10 15:45 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Yet another abort-early plan disaster on 9.3 2014-09-30 16:32 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Yet another abort-early plan disaster on 9.3 2014-09-29 23:00 UTC Tom Lane <tgl@sss.pgh.pa.us> Re: Yet another abort-early plan disaster on 9.3 2014-09-20 15:01 UTC Tom Lane <tgl@sss.pgh.pa.us> 97+ results
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox