Text of 6563751

Thank you for contacting EBSCO.

Your EBSCO Customer Support Case Number and Title are: 6563751 - "SI 4758546 | Cornell Metadb: indexing question".
_________________________________________________________________

Hello Sharon,

I have received the following update from the hosting team:

In PostgreSQL, you must be the table owner (or a superuser) to create an index on a table.

There is no separate GRANT permission (such as GRANT INDEX) that allows a non-owner to add an index.

Since Sharon is the owner of local_derived.marc__t table, she will be able to create an index for it.

Table folio_source_record.marc__t is owned by metadb_user account (whichh is the account which the metadb service runs as )
Only metadb_user or the superuser in postgresql would be allowed to create indexes for this table.

We would suggest discussing any new indexing with the metadb developers before making adjustments to any tables which are owned by metadb
(folio_source_record.marc__t )

Please let me know if you have any questions.

Cameron Viveiros
FOLIO Customer Account Specialist
EBSCO Information Services
978-414-0645
cameronviveiros@ebsco.com

This message and its contents are confidential. If you received this message in error, do not use or rely upon it. Instead, please inform the sender and then delete it.


--- Original Message ---
Hi Hosting Team,
We have been having trouble with the folio_source_record.marc__t table, so we set up a query to recreate this table in the local_derived schema. The table works, but queries against it run slowly. I would like to try indexing the table to improve performance. Is it possible for me to index tables with the permissions I currently have on my z_slm5 user account for our Metadb reporting database, or is this something you would need to add?
All the best,
Sharon