foo> - Search results in mailing lists
Mailing lists >> pgsql-performance >> Thread
2025-02-22 02:46:15 | Unfortunate Nested Loop + Missing Autovacuum (Lincoln Swaine-Moore)
FOO' ) r JOIN ( SELECT * FROM cleandata WHERE timestamp >= NOW() - interval '2 weeks' AND sn ='FOO' ) c ON r.id = c.raw_table
Mailing lists >> pgsql-performance >> Thread
2024-12-19 20:52:27 | Why a bitmap scan in this case? (Jon Zeppieri)
foo on my_tbl (start_on) where end_on is null and bar_id is null
Mailing lists >> pgsql-performance >> Thread
2024-11-09 18:41:26 | Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 (Tomas Vondra)
foo FROM mssql_bdynacom."ACDOC" \watch 1 4) once the recording stops, generate report perf
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2024-11-08 04:21:52 | Re: Major performance degradation with joins in 15.8 or 15.7? (Ed Sabol)
foo_'::text || a.name) END = "*SELECT* 1".table_name) Rows Removed by Join Filter: 1009 Buffers
Mailing lists >> pgsql-performance >> Thread
2024-07-29 20:51:40 | Help with row estimate problem (Jon Zeppieri)
foo-population','bar-population','baz-population','quux-population'] and v.start_on < u.expires_on group
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2023-04-07 20:48:59 | Re: Is there any tool which will help me run and explain analyze about 150 (kunwar singh)
foo.sql by including queries with bind variables defined and bind values populated ( speaking in Oracle
Mailing lists >> pgsql-performance >> Thread
2022-11-16 10:39:13 | When can joins be avoided? (Stefan Fehrenbach)
foo text ); create table b ( b_id int primary key, c_id int references c(c_id), b_bar text
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2022-02-24 03:37:59 | Slow plan choice with prepared query (Mark Saward)
foo_test(null, null, 5, 500, true); execute foo_test(null, null, 5, 500, true
Mailing lists >> pgsql-performance >> Thread
2021-12-21 05:33:06 | Re: Query is slower with a large proportion of NULLs in several columns (Tom Lane)
foo (cost=0.00..843334.10 rows=11000010 width=508) (actual time=0. 015..1897.492 rows=11000000 loops
Mailing lists >> pgsql-performance >> Thread
2021-09-19 10:05:25 | Query executed during pg_dump leads to excessive memory usage (Ulf Lohbrügge)
foo) AS typacl, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT
Mailing lists >> pgsql-performance >> Thread
2021-09-15 12:16:52 | Re: Postgres chooses slow query plan from time to time (Tom Lane)
foo where f2 = 11 and f1 = 'bar'; QUERY PLAN -------------------------------------------------------------------------- Index Only Scan using foo_pkey
Mailing lists >> pgsql-performance >> Thread
2021-07-16 21:27:24 | Linear slow-down while inserting into a table with an ON INSERT trigger ? (Tobias Gierke)
foo is weak today but I couldn't find any (convincing) explanation for this. I'm running
Mailing lists >> pgsql-performance >> Thread
2021-06-10 16:58:59 | Re: waiting for client write (Vijaykumar Jain)
foo where (u1 = :r1 and u2 = :r2); -- insert into foo values (:u1v, :u2v) on conflict
Mailing lists >> pgsql-performance >> Thread
2021-05-14 11:06:33 | Very slow "bloat query" (Marcin Gozdalik)
foo.nspname,foo.relname, (datawidth+32)::numeric AS datahdr, (maxfracsum*(nullhdr+8-(case when nullhdr
Mailing lists >> pgsql-performance >> Thread
2021-01-21 18:21:20 | Understanding logical replication lag (Patrick Molgaard)
foo(bar,baz) values (1, 1); -- session 2 begin; insert into foo(bar,baz) values