time dates - Search results in mailing lists
Mailing lists >> pgsql-performance >> Thread
2025-02-17 23:18:05 | Re: Query planning read a large amount of buffers for partitioned tables (bruno vieira da silva)
DATE, acquisition_time TIME, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) PARTITION BY HASH (sop_uid); -- Create
Mailing lists >> pgsql-performance >> Thread
2024-11-26 00:02:46 | CTE Inline On TPC-DS Query 95 (Ba Jinsheng)
date_sk and ws1.ws_ship_addr_sk = ca_address_sk and ca_state = 'TX' and ws1.ws_web_site_sk = web_site_sk and web_company_name = 'pri' and ws1.ws_order_number
Mailing lists >> pgsql-performance >> Thread
2024-11-25 23:54:36 | Performance of TPC-DS Query 95 (Ba Jinsheng)
time=6.293..52.376 rows=4465 loops=3) Hash Cond: (ws1.ws_ship_date_sk = date
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2024-11-22 14:12:22 | Performance of Query 60 on TPC-DS Benchmark (Ba Jinsheng)
time=13.315..807.438 rows=5426 loops=2) Hash Cond: (store_sales.ss_sold_date_sk = date
Mailing lists >> pgsql-performance >> Thread
2024-11-12 21:24:09 | Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 (Achilleas Mantzios)
time=3.783..14967.029 rows=1683386 loops=1) Output: "ID", "DOC_TYPE", "PARAST", "TRNS_DATE", "VIA_MNG", "VIA_MNG_ID", "FL_UPD", "NOTES
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2024-11-10 22:35:36 | Performance of Query 4 on TPC-DS Benchmark (Ba Jinsheng)
time=69.110..1686.608 rows=2685453 loops=1) Hash Cond: (store_sales.ss_sold_date_sk = date
Mailing lists >> pgsql-performance >> Thread
2024-11-01 16:21:21 | Postgresql 14/15/16/17 partition pruning on dependent table during join (Stepan Yankevych)
date_id, exec_time, qty, price) WITH ordered_data AS ( SELECT order_id, create_date
Mailing lists >> pgsql-performance >> Thread
2024-10-24 22:43:54 | Unexpected Performance for the Function simplify_function (Ba Jinsheng)
time=0.033..62.907 rows=19046 loops=3) Filter: ((o_orderdate >= '1993-08-01'::date) AND (o_orderdate
Mailing lists >> pgsql-performance >> Thread
2024-08-23 12:54:51 | Re: checking for a NULL date in a partitioned table kills performance (Rui DeSousa)
Time: 711.774 ms prod=# select sum(site_id) from emp where contract_date > '3/1/2024'; sum ------------ 1128971203 (1 row) Time
Mailing lists >> pgsql-performance >> Thread
2024-07-04 13:25:44 | How to solve my slow disk i/o throughput during index scan (FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT))
date * Requesting a small subset (100k-1M) lines from this database, always filtering on the primary key (I have a WHERE ... filtering on each ID column. Some are done through dimension tables + join
Mailing lists >> pgsql-performance >> Thread
2024-06-10 06:59:04 | Distinct performance dropped by multiple times in v16 (Vitaliy Litovskiy)
Hello, In our application after upgrading from postgresql from v15 to v16 performance for some
Mailing lists >> pgsql-performance >> Thread >> Search in thread (3)
2024-02-27 00:25:19 | Optimizing count(), but Explain estimates wildly off (Chema)
date" < '2024-01-01' QUERY PLAN Gather (cost=253837.99..1506524.32 rows=1955297 width=823) (actual time
Mailing lists >> pgsql-performance >> Thread
2024-02-02 07:45:47 | Re: Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards (Daniel Blanch Bataller)
date; ps aux | head -n 1; ps aux | grep 6423 vie 02 feb 2024 08:29:24 CET USER PID %CPU %MEM VSZ RSS TTY STAT START TIME
Mailing lists >> pgsql-performance >> Thread >> Search in thread (5)
2023-12-27 16:15:23 | Re: [EXTERNAL] Need help with performance tuning pg12 on linux (Wilson, Maria Louise (LARC-E301)[RSES])
date_times,0,beginning_date_time}'::text[]) > '2015-10-06T23:59:59+00:00'::text
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2023-12-27 13:15:23 | Parallel hints in PostgreSQL with consistent perfromance (mohini mane)
date,starttime timestamp,timezone TIMESTAMP WITH TIME ZONE, status boolean,timenow time,timelater TIME WITH