Facing issue in using special characters

2019-03-14 Thread M Tarkeshwar Rao
Hi all, Facing issue in using special characters. We are trying to insert records to a remote Postgres Server and our application not able to perform this because of errors. It seems that issue is because of the special characters that has been used in one of the field of a row. Regards

Re: impact of auto explain on overall performance

2019-03-14 Thread Jeff Janes
On Thu, Mar 14, 2019 at 3:29 AM Stephan Schmidt wrote: > Hello, > > > > i’m currently working on a high Performance Database and want to make sure > that whenever there are slow queries during regular operations i’ve got all > Information about the query in my logs. So auto_explain come to mind,

Re: Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)

2019-03-14 Thread Justin Pryzby
On Wed, Mar 13, 2019 at 02:44:10PM -0400, Gunther wrote: > You see that I already did a lot to balance IO out to many different > tablespaces that's why there are so many volumes. I wonder if it wouldn't be both better and much easier to have just 1 or 2 tablespaces and combine drives into a

Re: impact of auto explain on overall performance

2019-03-14 Thread Adrien NAYRAT
On 3/14/19 9:23 AM, Justin Pryzby wrote: On Thu, Mar 14, 2019 at 07:29:17AM +, Stephan Schmidt wrote: i’m currently working on a high Performance Database and want to make sure that whenever there are slow queries during regular operations i’ve got all Information about the query in my

Re: impact of auto explain on overall performance

2019-03-14 Thread Justin Pryzby
On Thu, Mar 14, 2019 at 07:29:17AM +, Stephan Schmidt wrote: > i’m currently working on a high Performance Database and want to make sure > that whenever there are slow queries during regular operations i’ve got all > Information about the query in my logs. So auto_explain come to mind, but

impact of auto explain on overall performance

2019-03-14 Thread Stephan Schmidt
Hello, i’m currently working on a high Performance Database and want to make sure that whenever there are slow queries during regular operations i’ve got all Information about the query in my logs. So auto_explain come to mind, but the documentation explicitly states that it Comes at a cost.