Re:Improving Postgres text search speed
by dealforager on Friday August 12, 2022 @09:51PM
(#32446175)
If you're discussing performance of SQL queries, showing the output of EXPLAIN ANALYZE is the bare minimum. There's too many variables that can affect performance and if you can't see what's happening under the hood it's not very useful.
[ Parent
| on HN ]
Re:Improving Postgres text search speed
by jerryjerryjerry on Saturday August 13, 2022 @12:16AM
(#32446842)
Same here, and I'd also like to see what explain analyze shows about the plan and execution details. Also, some system setup may also help, e.g., memory size and check if spill kicks in, etc.