Postgres Pro
Downloads
Home   >   mailing lists

Re: index question - Mailing list pgsql-general

From drum.lucas@gmail.com
Subject Re: index question
Date
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  (Melvin Davidson <melvin6925@gmail.com>)
Re: index question  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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");

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: index question
Next
From: Melvin Davidson
Date:
Subject: Re: index question