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:
http://explain.depesz.com/s/rHOU
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");