News for hackers. Stuff that matters.
Re:Squeeze the hell out of the system you have by catalypso on Saturday August 12, 2023 @09:43AM (#37100082)
Thanks for the effort.

Probably nitpicking but these types of measures are usually tricky to interpret because there is a high chance your indexes (maybe even rows) are still on PostgreSQL shared buffers and OS cache and might not reflect real usage performance.

To get a more "worst-case" measure, after your inserts and indexes creation, you can restart your database server + flush OS pages cache (e.g. drop_caches for Linux), then do the measure.

Sometimes the difference is huge, although I don't suspect it will be in this case.

Re:Squeeze the hell out of the system you have by ElatedOwl on Saturday August 12, 2023 @11:02AM (#37100882)
imo a properly configured Postgres server should have enough RAM to keep any hot data in cache. The cached path is the accurate measurement.