Re: index question

Поиск
Список
Период
Сортировка
От drum.lucas@gmail.com
Тема Re: index question
Дата
Msg-id CAE_gQfWEfAaJ4BraXzDDLWnMeETfdbR_r=35jCOqNofv82ZY1A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: index question  (Melvin Davidson <melvin6925@gmail.com>)
Ответы Re: index question
Re: index question
Список pgsql-general
Sorry @Melvin, sent the previous email just to you..


That's a great one, too! Cheers!


Well.. the index creation did not help...

if possible please have a look on the explain analyze results:


What else can I do?

The indexes I created is:
- CREATE INDEX CONCURRENTLY ix_inode_segments_notes_clientids2 ON gorfs.inode_segments USING btree ("full_path");

- CREATE INDEX CONCURRENTLY ix_inodes_checksum_st_size ON gorfs.inodes USING btree ("checksum_md5","st_size");

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