Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Clearer documentation for timeout #10

Closed
mwarnock opened this issue Oct 27, 2011 · 1 comment
Closed

Clearer documentation for timeout #10

mwarnock opened this issue Oct 27, 2011 · 1 comment

Comments

@mwarnock
Copy link

Great library, it's been very helpful. But if I was to change anything I'd ask that the documentation about the timeout be a little clearer. In the readme it says the timeout option is for connections when in reality it is also used by the finite state machine to timeout queries.

As you probably already know, that means that using the default of 5 seconds will return an {error,timeout} on any query that takes more than 5 seconds.

Just for context:
I'm using this in conjunction with epgsql_pool and pounding the snot out of a >350,000,000 record table that I haven't bothered to partition yet so it manifested when I was doing ~500 inserts a second. After I looked through pgsql_connection.erl I saw that timeout was being passed to the state record as well. I then upped the timeout to 60,000 in the options I pass in and I stopped getting {error,timeout} returned from queries.

@wg
Copy link
Owner

wg commented Jan 5, 2012

Thanks! I'll add some clarifying words about the timeout.

@wg wg closed this as completed Jan 5, 2012
Gustav-Simonsson pushed a commit to Gustav-Simonsson/epgsql that referenced this issue Jun 5, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants