[HACKERS] pg_stat_statements query normalization, and the 'in' operator

Поиск
Список
Период
Сортировка
От unixway.drive@gmail.com
Тема [HACKERS] pg_stat_statements query normalization, and the 'in' operator
Дата
Msg-id 4c3140e8-110a-3038-0879-c14e8afdf72b@gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] pg_stat_statements query normalization, and the 'in' operator  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hello there,

Given the following list of queries:
  create table foo (id serial, bar integer);  select * from foo where id in (1);  select * from foo where id in (2,3);
select* from foo where id in (1,3,5);  select * from foo where id in (select id from foo);
 

would it be possible to have first three select queries to be normalized 
into a single one so that 'select query from pg_stat_statements' returns 
something like:
  select * from foo where id in (...);  select * from foo where id in (select id from foo);  (2 rows)

instead of:
  select * from foo where id in (?,?);  select * from foo where id in (?,?,?);  select * from foo where id in (?);
select* from foo where id in (select id from foo);  (4 rows)
 

?



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: [HACKERS] additional contrib test suites
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] POC: Sharing record typmods between backends