Search found 8 matches

by Hybred
Mon Feb 10, 2020 8:06 pm
Forum: General topics
Topic: 150k pages taking 2+ minutes to search
Replies: 16
Views: 11005

Re: 150k pages taking 2+ minutes to search

Also signed up for support - let me know if the base tier is enough, can easily upgrade if not.

ID: I-KCN9BW1Y93YN
by Hybred
Mon Feb 10, 2020 6:18 pm
Forum: General topics
Topic: 150k pages taking 2+ minutes to search
Replies: 16
Views: 11005

Re: 150k pages taking 2+ minutes to search

Hello again!

After a project was completed I'm able to jump back into this. I was able to dump the database and import it into a separate PostGRE instance. What settings would I need to update to point it to the new DB? Or would it be better to just start a new install and point the data to the db?
by Hybred
Thu Jan 09, 2020 2:29 pm
Forum: General topics
Topic: 150k pages taking 2+ minutes to search
Replies: 16
Views: 11005

Re: 150k pages taking 2+ minutes to search

Thanks for making it an official concern and feature improvement. I ran the database optimization and it still continues to crash after 120 seconds, so it seems like I need to pull the database out of the docker container and into it's own home. I'll shoot for that early next week and see what comes...
by Hybred
Mon Jan 06, 2020 3:37 pm
Forum: General topics
Topic: 150k pages taking 2+ minutes to search
Replies: 16
Views: 11005

Re: 150k pages taking 2+ minutes to search

Interesting. This would be the first time I've seen PostGRE be the hangup on a deployment. But it's also the first time I've run one within docker, which it seems like it's not a huge fan of.
by Hybred
Mon Jan 06, 2020 2:53 pm
Forum: General topics
Topic: 150k pages taking 2+ minutes to search
Replies: 16
Views: 11005

Re: 150k pages taking 2+ minutes to search

Right now, the Mayan DB is running on PostGRE within Docker on Alpine Linux, per the Mayan instructions.

I have a PostGRE instance on Server 2012 I could migrate to.

Edit: Though I would prefer not to* if possible
by Hybred
Mon Jan 06, 2020 2:20 pm
Forum: General topics
Topic: 150k pages taking 2+ minutes to search
Replies: 16
Views: 11005

Re: 150k pages taking 2+ minutes to search

After doing a top I'm seeing the following: https://i.imgur.com/aT03HZy.png So it seems like it too is having an issue using the full 4 cores allocated to the host. I've tried running the following in an attempt to get the container to use more of the host resources but it doesn't seem to work. dock...
by Hybred
Fri Jan 03, 2020 4:12 pm
Forum: General topics
Topic: 150k pages taking 2+ minutes to search
Replies: 16
Views: 11005

Re: 150k pages taking 2+ minutes to search

Thanks for the quick response! I followed this guide with almost no changes. So yes, it's a PostGRE databse running in a container on the same host as the EDMS. https://docs.mayan-edms.com/topics/docker.html The host specs I've allocated are 4 cores and 8gb memory, but can be doubled on each end fai...
by Hybred
Fri Jan 03, 2020 3:17 pm
Forum: General topics
Topic: 150k pages taking 2+ minutes to search
Replies: 16
Views: 11005

150k pages taking 2+ minutes to search

Hello -- I just recently OCR'ed about 150,000 documents into Mayan. It's taking over 2 minutes to search and ultimately times out. (Due to default docker setting) I'm going to work towards increasing the number of Unicorn workers to 4+1 to match one of the host sockets, but are there any other major...