Jump to content

PostgreSql Server Timeout


Recommended Posts

With what queries the server times out?


It will be better for us to optimize the queries, rather than changing the time-out limits, because there are WFC and Client timeouts also.


This issue might be resolved on the next minor update if the problem appears after Folders selection.

Link to comment
Share on other sites

It happens when we select multiple folder groups for categorisation.


I wish I could give you a benchmark (like saying it happens when you select 20 folders or something like that) but I can't.


The queries are more likely to time out when:

  • More than one user is connected
  • Other background tasks like Auto Sync or import is also running
  • Queries increase in complexity

The SQL queries' complexity can be reduced by assigning categories (or other non-folder tags) to groups of images... This worked for me.


You are right - it is an issue with folder tags...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...