Benching Queries
От
Jonathan Vanasco
Тема
Benching Queries
Дата
Msg-id
78B2522B-7B2C-4C92-ABB2-4DE079FFACCC@2xlp.com
Ответ на
Re: Postgres tcp_keepalive_xxxx parameters. (José Luis Rando Calvo)
Список
Дерево обсуждения
Postgres tcp_keepalive_xxxx parameters. jlrando <jose.luis.rando.calvo@ericsson.com>
Re: Postgres tcp_keepalive_xxxx parameters. Tom Lane <tgl@sss.pgh.pa.us>
Re: Postgres tcp_keepalive_xxxx parameters. José Luis Rando Calvo<jose.luis.rando.calvo@ericsson.com>
Benching Queries Jonathan Vanasco <postgres@2xlp.com>
Does anyone have a good solution for benching queries under various conditions, and collecting the EXPLAIN data ? I looked at pgbench, but it doesn't seem to be what I want. My situation is this- - For a given query, there are 3-5 different ways that I can run it. - Each form of the query has a completely different execution plan and query time, often using different indexes. - The same query runs differently on first query, vs subsequent queries (when the indexes/tables are already in memory). My goal is to find an overall balance of query time (cold-start vs in-memory) and indexes (number of).
В списке pgsql-general по дате отправления
От: Andrus
Дата: