Home > mailing lists

Re: index question - Mailing list pgsql-general

From	drum.lucas@gmail.com
Subject	Re: index question
Date	May 2, 2016 05:28:44
Msg-id	CAE_gQfWEfAaJ4BraXzDDLWnMeETfdbR_r=35jCOqNofv82ZY1A@mail.gmail.com Whole thread Raw
In response to	Re: index question (Melvin Davidson <melvin6925@gmail.com>)
Responses	Re: index question Re: index question
List	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");

From: Melvin Davidson
Date: 02 May 2016, 04:51:48
Subject: Re: index question

From: Melvin Davidson
Date: 02 May 2016, 05:38:02
Subject: Re: index question