public inbox for [email protected]help / color / mirror / Atom feed
Messages from [email protected] Re: how to switch user in postgres 2026-04-11 19:29 UTC Tom Lane <[email protected]> Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE 2025-01-09 19:39 UTC Tom Lane <[email protected]> Re: Query planner gaining the ability to replanning after start of query execution. 2017-11-13 22:49 UTC Tom Lane <[email protected]> Re: DB slowness after upgrade from Postgres 9.1 to 9.4 2017-11-12 19:37 UTC Tom Lane <[email protected]> Re: overestimate on empty table 2017-11-11 17:43 UTC Tom Lane <[email protected]> Re: overestimate on empty table 2017-11-10 21:19 UTC Tom Lane <[email protected]> Re: Slow execution of SET ROLE, SET search_path and RESET ROLE 2017-11-07 23:45 UTC Tom Lane <[email protected]> Re: proposal: schema variables 2017-11-02 15:48 UTC Tom Lane <[email protected]> Re: Cheaper subquery scan not considered unless offset 0 2017-10-29 14:58 UTC Tom Lane <[email protected]> Re: Row level security policy policy versus SQL constraints. Any performance difference? 2017-10-17 22:06 UTC Tom Lane <[email protected]> Re: Rowcount estimation changes based on from clause order 2017-10-12 20:50 UTC Tom Lane <[email protected]> Re: Regression from 9.4-9.6 2017-10-08 20:37 UTC Tom Lane <[email protected]> Re: Regression from 9.4-9.6 2017-10-08 19:34 UTC Tom Lane <[email protected]> Re: select with max functions 2017-10-02 15:29 UTC Tom Lane <[email protected]> Re: Pageinspect bt_metap help 2017-09-19 03:28 UTC Tom Lane <[email protected]> Re: max partitions behind a view? 2017-09-18 13:55 UTC Tom Lane <[email protected]> Re: query of partitioned object doesnt use index in qa 2017-09-15 22:05 UTC Tom Lane <[email protected]> Re: query of partitioned object doesnt use index in qa 2017-09-15 20:42 UTC Tom Lane <[email protected]> Re: postgresql 9.6 data directory fs becomes full 2017-09-11 12:02 UTC Tom Lane <[email protected]> Re: Explain Analyze - actual time in loops 2017-09-08 14:07 UTC Tom Lane <[email protected]> Re: Explain Analyze - actual time in loops 2017-09-08 13:44 UTC Tom Lane <[email protected]> Re: 10x faster sort performance on Skylake CPU vs Ivy Bridge 2017-08-25 15:07 UTC Tom Lane <[email protected]> Re: Postgres Dump - Creating index never stops 2017-07-12 19:41 UTC Tom Lane <[email protected]> Re: slow delete due to reference 2017-06-24 16:14 UTC Tom Lane <[email protected]> Re: Efficiently merging and sorting collections of sorted rows 2017-06-23 23:33 UTC Tom Lane <[email protected]> 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 <[email protected]> Re: substring index what is better way to query 2017-06-20 14:45 UTC Tom Lane <[email protected]> Re: substring index what is better way to query 2017-06-20 14:19 UTC Tom Lane <[email protected]> Re: Sudden drastic change in performance 2017-06-15 15:09 UTC Tom Lane <[email protected]> Re: index of only not null, use function index? 2017-06-08 14:58 UTC Tom Lane <[email protected]> Re: Re: join estimate of subqueries with range conditions and constraint exclusion 2017-06-05 21:02 UTC Tom Lane <[email protected]> Re: Seeing execution plan of foreign key constraint check? 2016-07-21 21:59 UTC Tom Lane <[email protected]> Re: Seeing execution plan of foreign key constraint check? 2016-07-19 20:10 UTC Tom Lane <[email protected]> Re: less than 2 sec for response - possible? 2016-07-02 01:23 UTC Tom Lane <[email protected]> Re: Random slow queries 2016-06-29 21:44 UTC Tom Lane <[email protected]> Re: Random slow queries 2016-06-29 20:20 UTC Tom Lane <[email protected]> Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s 2016-06-25 18:08 UTC Tom Lane <[email protected]> Re: 9.6 query slower than 9.5.3 2016-06-17 15:22 UTC Tom Lane <[email protected]> Re: 9.6 query slower than 9.5.3 2016-06-17 03:57 UTC Tom Lane <[email protected]> Re: 9.6 query slower than 9.5.3 2016-06-17 02:45 UTC Tom Lane <[email protected]> Re: 9.6 query slower than 9.5.3 2016-06-17 02:04 UTC Tom Lane <[email protected]> Re: Index not used 2016-06-16 15:05 UTC Tom Lane <[email protected]> Re: Many-to-many performance problem 2016-06-10 15:23 UTC Tom Lane <[email protected]> Re: Many-to-many performance problem 2016-06-10 14:13 UTC Tom Lane <[email protected]> Re: array size exceeds the maximum allowed (1073741823) when building a json 2016-06-08 06:04 UTC Tom Lane <[email protected]> Re: Locking concurrency: select for update vs update 2016-06-07 13:24 UTC Tom Lane <[email protected]> Re: index fragmentation on insert-only table with non-unique column 2016-06-05 16:03 UTC Tom Lane <[email protected]> Re: Re: Planner chooses slow index heap scan despite accurate row estimates 2016-05-28 00:16 UTC Tom Lane <[email protected]> Re: Planner chooses slow index heap scan despite accurate row estimates 2016-05-27 23:17 UTC Tom Lane <[email protected]> Re: Performance problems with 9.2.15 2016-05-27 13:46 UTC Tom Lane <[email protected]> Re: index fragmentation on insert-only table with non-unique column 2016-05-25 04:43 UTC Tom Lane <[email protected]> Re: LIKE pattern 2016-05-12 17:25 UTC Tom Lane <[email protected]> Re: Adding a ROLLUP switches to GroupAggregate unexpectedly 2016-03-31 18:56 UTC Tom Lane <[email protected]> Re: Searching GIN-index (FTS) and sort by timestamp-column 2016-03-17 17:57 UTC Tom Lane <[email protected]> Re: Searching GIN-index (FTS) and sort by timestamp-column 2016-03-17 17:20 UTC Tom Lane <[email protected]> Re: Searching GIN-index (FTS) and sort by timestamp-column 2016-03-16 13:37 UTC Tom Lane <[email protected]> Re: Merge joins on index scans 2016-03-14 00:57 UTC Tom Lane <[email protected]> Re: Odd behavior with indices 2016-03-04 23:53 UTC Tom Lane <[email protected]> Re: Merge joins on index scans 2016-03-01 01:22 UTC Tom Lane <[email protected]> Re: Odd behavior with indices 2016-02-29 18:47 UTC Tom Lane <[email protected]> Re: [GENERAL] Why Postgres use a little memory on Windows. 2016-02-20 18:37 UTC Tom Lane <[email protected]> Re: gin performance issue. 2016-02-05 15:07 UTC Tom Lane <[email protected]> Re: bad COPY performance with NOTIFY in a trigger 2016-02-04 22:41 UTC Tom Lane <[email protected]> Re: Bitmap and-ing between btree and gin? 2016-02-04 16:08 UTC Tom Lane <[email protected]> Re: View containing a recursive function 2016-02-01 09:44 UTC Tom Lane <[email protected]> Re: High Planning Time 2016-01-22 14:35 UTC Tom Lane <[email protected]> Re: Queries intermittently slow 2016-01-07 18:34 UTC Tom Lane <[email protected]> Re: Queries intermittently slow 2016-01-07 15:19 UTC Tom Lane <[email protected]> Re: Queries intermittently slow 2016-01-06 16:32 UTC Tom Lane <[email protected]> Re: Queries intermittently slow 2016-01-06 16:14 UTC Tom Lane <[email protected]> Re: Queries intermittently slow 2016-01-06 15:38 UTC Tom Lane <[email protected]> Re: Queries intermittently slow 2016-01-06 15:19 UTC Tom Lane <[email protected]> Re: Plan differences 2015-12-31 17:11 UTC Tom Lane <[email protected]> Re: Plan differences 2015-12-31 15:02 UTC Tom Lane <[email protected]> Re: Terrible plan choice for view with distinct on clause 2015-12-17 17:00 UTC Tom Lane <[email protected]> Re: Selectivity for lopsided foreign key columns 2015-12-17 15:23 UTC Tom Lane <[email protected]> Re: Getting an optimal plan on the first execution of a pl/pgsql function 2015-12-14 20:41 UTC Tom Lane <[email protected]> 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 <[email protected]> Re: Index scan cost calculation 2015-11-26 18:26 UTC Tom Lane <[email protected]> Re: Index scan cost calculation 2015-11-26 16:44 UTC Tom Lane <[email protected]> Re: No index only scan on md5 index 2015-11-26 01:01 UTC Tom Lane <[email protected]> Re: Why is now()::date so much faster than current_date 2015-11-17 15:26 UTC Tom Lane <[email protected]> Re: Simple delete query is taking too long (never ends) 2015-11-12 22:26 UTC Tom Lane <[email protected]> Re: Simple delete query is taking too long (never ends) 2015-11-12 15:36 UTC Tom Lane <[email protected]> Re: Simple delete query is taking too long (never ends) 2015-11-11 19:33 UTC Tom Lane <[email protected]> Re: Slow 3 Table Join with v bad row estimate 2015-11-10 17:05 UTC Tom Lane <[email protected]> Re: Slow 3 Table Join with v bad row estimate 2015-11-10 15:03 UTC Tom Lane <[email protected]> Re: querying jsonb for arrays inside a hash 2015-11-08 00:00 UTC Tom Lane <[email protected]> Re: Slow query in trigger function 2015-11-02 18:10 UTC Tom Lane <[email protected]> Re: Slow query in trigger function 2015-11-02 14:45 UTC Tom Lane <[email protected]> Re: Query optimizer plans with very small selectivity estimates 2015-10-29 18:24 UTC Tom Lane <[email protected]> Re: Query planner wants to use seq scan 2015-10-27 12:03 UTC Tom Lane <[email protected]> Re: query partitioned table is very slow 2015-10-16 23:02 UTC Tom Lane <[email protected]> Re: LIMIT 1 poor query plan 2015-10-10 15:45 UTC Tom Lane <[email protected]> Re: Partitions and work_mem? 2014-11-17 15:13 UTC Tom Lane <[email protected]> Re: Query with large number of joins 2014-10-21 16:50 UTC Tom Lane <[email protected]> Re: Query with large number of joins 2014-10-21 16:46 UTC Tom Lane <[email protected]> Re: Query with large number of joins 2014-10-20 23:59 UTC Tom Lane <[email protected]> Re: IS NOT NULL and LEFT JOIN 2014-10-20 13:58 UTC Tom Lane <[email protected]> Re: Partitions and work_mem? 2014-10-15 22:58 UTC Tom Lane <[email protected]> Re: Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660 2014-10-07 13:56 UTC Tom Lane <[email protected]> Re: query plan question, nested loop vs hash join 2014-10-05 19:47 UTC Tom Lane <[email protected]> Re: performance of SELECT * much faster than SELECT <colname> with large offset 2014-10-03 02:39 UTC Tom Lane <[email protected]> Re: Yet another abort-early plan disaster on 9.3 2014-09-30 16:32 UTC Tom Lane <[email protected]> Re: Yet another abort-early plan disaster on 9.3 2014-09-29 23:00 UTC Tom Lane <[email protected]> Re: Yet another abort-early plan disaster on 9.3 2014-09-20 15:01 UTC Tom Lane <[email protected]> Re: query on parent partition table has bad performance 2014-08-21 05:10 UTC Tom Lane <[email protected]> Re: query on parent partition table has bad performance 2014-08-20 14:12 UTC Tom Lane <[email protected]> Re: query against pg_locks leads to large memory alloc 2014-08-18 23:24 UTC Tom Lane <[email protected]> Re: select on index column,why PG still use seq scan? 2014-08-18 03:49 UTC Tom Lane <[email protected]> Re: two table join with order by on both tables attributes 2014-08-08 00:19 UTC Tom Lane <[email protected]> Re: 60 core performance with 9.3 2014-07-30 12:39 UTC Tom Lane <[email protected]> Re: Very slow planning performance on partition table 2014-07-27 16:28 UTC Tom Lane <[email protected]> Re: Very slow planning performance on partition table 2014-07-25 01:53 UTC Tom Lane <[email protected]> Re: GIN index not used 2014-07-11 05:43 UTC Tom Lane <[email protected]> Re: GIN index not used 2014-07-11 04:56 UTC Tom Lane <[email protected]> Re: stored procedure suddenly runs slowly in HOT STANDBY but fast in primary 2014-07-05 04:31 UTC Tom Lane <[email protected]> Re: Postgres Replaying WAL slowly 2014-07-02 19:14 UTC Tom Lane <[email protected]> Re: Hash Join node sometimes slow 2014-07-02 14:11 UTC Tom Lane <[email protected]> Re: Postgres Replaying WAL slowly 2014-07-01 19:20 UTC Tom Lane <[email protected]> Re: Volatility - docs vs behaviour? 2014-07-01 02:15 UTC Tom Lane <[email protected]> Re: Postgres Replaying WAL slowly 2014-06-30 23:04 UTC Tom Lane <[email protected]> Re: Postgres Replaying WAL slowly 2014-06-30 20:39 UTC Tom Lane <[email protected]> Re: Postgres Replaying WAL slowly 2014-06-30 19:32 UTC Tom Lane <[email protected]> Re: Volatility - docs vs behaviour? 2014-06-30 15:49 UTC Tom Lane <[email protected]> Re: GIST optimization to limit calls to operator on sub nodes 2014-06-30 14:04 UTC Tom Lane <[email protected]> Re: GIST optimization to limit calls to operator on sub nodes 2014-06-29 20:30 UTC Tom Lane <[email protected]> Re: Unable to allocate 2G of shared memory on wheezy 2014-06-18 19:37 UTC Tom Lane <[email protected]> Re: Unable to allocate 2G of shared memory on wheezy 2014-06-18 19:15 UTC Tom Lane <[email protected]> Re: Query memory usage greatly in excess of work_mem * query plan steps 2014-06-14 14:26 UTC Tom Lane <[email protected]> Re: OFFSET/LIMIT - Disparate Performance w/ Go application 2014-06-12 14:58 UTC Tom Lane <[email protected]> Re: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 2014-06-10 22:07 UTC Tom Lane <[email protected]> Re: 2014-06-07 01:38 UTC Tom Lane <[email protected]> Re: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 2014-06-06 02:02 UTC Tom Lane <[email protected]> Re: High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available 2014-06-05 13:47 UTC Tom Lane <[email protected]> Re: Profiling PostgreSQL 2014-05-22 13:48 UTC Tom Lane <[email protected]> Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 2014-05-20 04:13 UTC Tom Lane <[email protected]> Re: same query different execution plan (hash join vs. semi-hash join) 2014-05-19 14:22 UTC Tom Lane <[email protected]> Re: same query different execution plan (hash join vs. semi-hash join) 2014-05-16 02:58 UTC Tom Lane <[email protected]> Re: Query plan good in 8.4, bad in 9.2 and better in 9.3 2014-05-15 16:52 UTC Tom Lane <[email protected]> Re: Constraint exclusion won't exclude parent table 2014-05-13 20:24 UTC Tom Lane <[email protected]> Re: 9.2.4 vs 9.3.0 query planning (sort merge join vs hash join) 2014-05-12 11:23 UTC Tom Lane <[email protected]> Re: Why we don't want hints Was: Slow count(*) again... 2011-02-10 21:12 UTC Tom Lane <[email protected]> Re: Why we don't want hints Was: Slow count(*) again... 2011-02-10 17:01 UTC Tom Lane <[email protected]> Re: Does auto-analyze work on dirty writes? (was: Re: [HACKERS] Slow count(*) again...) 2011-02-04 15:41 UTC Tom Lane <[email protected]> Re: [HACKERS] Slow count(*) again... 2011-02-03 17:46 UTC Tom Lane <[email protected]> Re: [HACKERS] Slow count(*) again... 2011-02-03 17:27 UTC Tom Lane <[email protected]> Re: [PERFORM] Slow count(*) again... 2011-02-01 23:12 UTC Tom Lane <[email protected]> Re: [PERFORM] Slow BLOBs restoring 2010-12-09 15:05 UTC Tom Lane <[email protected]> Re: [PERFORM] Slow BLOBs restoring 2010-12-09 14:50 UTC Tom Lane <[email protected]> Re: Slow BLOBs restoring 2010-12-09 05:28 UTC Tom Lane <[email protected]> Re: Performance under contention 2010-12-08 22:02 UTC Tom Lane <[email protected]> Re: hashed subplan 5000x slower than two sequential operations 2010-12-08 20:12 UTC Tom Lane <[email protected]> Re: Slow BLOBs restoring 2010-12-08 14:46 UTC Tom Lane <[email protected]> Re: Performance under contention 2010-12-08 14:34 UTC Tom Lane <[email protected]> Re: Performance under contention 2010-12-07 17:50 UTC Tom Lane <[email protected]> Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT 2010-12-06 18:03 UTC Tom Lane <[email protected]> Re: Group commit and commit delay/siblings 2010-12-06 17:55 UTC Tom Lane <[email protected]> Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT 2010-12-05 20:14 UTC Tom Lane <[email protected]> Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT 2010-12-05 16:56 UTC Tom Lane <[email protected]> Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT 2010-12-04 22:40 UTC Tom Lane <[email protected]> Re: problem with from_collapse_limit and joined views 2010-12-04 16:59 UTC Tom Lane <[email protected]> Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT 2010-12-04 16:42 UTC Tom Lane <[email protected]> Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT 2010-12-04 06:20 UTC Tom Lane <[email protected]> Re: tidscan not work ? Pg 8.4.5 + WinXP 2010-11-30 16:49 UTC Tom Lane <[email protected]> Re: Query Performance SQL Server vs. Postgresql 2010-11-21 17:16 UTC Tom Lane <[email protected]> Re: Anyone seen this kind of lock pileup? 2010-11-17 23:56 UTC Tom Lane <[email protected]> Re: Query Performance SQL Server vs. Postgresql 2010-11-17 23:21 UTC Tom Lane <[email protected]> Re: Anyone seen this kind of lock pileup? 2010-11-17 21:58 UTC Tom Lane <[email protected]> Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? 2010-11-17 01:22 UTC Tom Lane <[email protected]> Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? 2010-11-17 01:17 UTC Tom Lane <[email protected]> Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? 2010-11-17 01:04 UTC Tom Lane <[email protected]> Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? 2010-11-17 00:51 UTC Tom Lane <[email protected]> Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? 2010-11-16 23:31 UTC Tom Lane <[email protected]> Re: Difference between explain analyze and real execution time 2010-11-15 21:03 UTC Tom Lane <[email protected]> Re: Difference between explain analyze and real execution time 2010-11-15 15:12 UTC Tom Lane <[email protected]> Re: temporary tables, indexes, and query plans 2010-11-14 15:55 UTC Tom Lane <[email protected]> Re: temporary tables, indexes, and query plans 2010-11-14 00:54 UTC Tom Lane <[email protected]> Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? 2010-11-13 18:01 UTC Tom Lane <[email protected]> Re: temporary tables, indexes, and query plans 2010-11-13 16:42 UTC Tom Lane <[email protected]> Re: temporary tables, indexes, and query plans 2010-11-13 15:41 UTC Tom Lane <[email protected]> Re: do temporary tables have hint bits? 2010-11-13 14:57 UTC Tom Lane <[email protected]> Re: anti-join chosen even when slower than old plan 2010-11-12 16:43 UTC Tom Lane <[email protected]> Re: MVCC performance issue 2010-11-12 16:28 UTC Tom Lane <[email protected]> Re: equivalent queries lead to different query plans for self-joins with group by? 2010-11-11 22:37 UTC Tom Lane <[email protected]> Re: anti-join chosen even when slower than old plan 2010-11-11 19:41 UTC Tom Lane <[email protected]> Re: anti-join chosen even when slower than old plan 2010-11-11 19:35 UTC Tom Lane <[email protected]> Re: anti-join chosen even when slower than old plan 2010-11-11 19:17 UTC Tom Lane <[email protected]> Re: anti-join chosen even when slower than old plan 2010-11-11 18:58 UTC Tom Lane <[email protected]> Re: anti-join chosen even when slower than old plan 2010-11-11 18:23 UTC Tom Lane <[email protected]> Re: anti-join chosen even when slower than old plan 2010-11-11 17:45 UTC Tom Lane <[email protected]> Re: anti-join chosen even when slower than old plan 2010-11-10 23:07 UTC Tom Lane <[email protected]> Re: anti-join chosen even when slower than old plan 2010-11-10 15:33 UTC Tom Lane <[email protected]> Re: anti-join chosen even when slower than old plan 2010-11-10 00:08 UTC Tom Lane <[email protected]> Re: Huge overestimation in rows expected results in bad plan 2010-11-09 23:55 UTC Tom Lane <[email protected]> Re: Huge overestimation in rows expected results in bad plan 2010-11-09 23:29 UTC Tom Lane <[email protected]> Re: anti-join chosen even when slower than old plan 2010-11-09 23:17 UTC Tom Lane <[email protected]> Re: out of memory problem 2010-11-09 15:22 UTC Tom Lane <[email protected]> Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? 2010-11-08 18:40 UTC Tom Lane <[email protected]> Re: [PERFORM] typoed column name, but postgres didn't grump 2010-11-05 20:23 UTC Tom Lane <[email protected]> 200+ results
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox