Re: [GENERAL] ERROR: canceling statement due to statement timeout

2017-01-11 Thread Patrick B
2017-01-12 13:41 GMT+13:00 Adrian Klaver : > On 01/11/2017 04:31 PM, Patrick B wrote: > >> 2017-01-12 13:23 GMT+13:00 Adrian Klaver > >: >> >> On 01/11/2017 04:08 PM, Patrick B wrote: >> >> Hi guys, >> >> I'm using PostgreSQL 9.2 in two differe

Re: [GENERAL] ERROR: canceling statement due to statement timeout

2017-01-11 Thread Adrian Klaver
On 01/11/2017 04:31 PM, Patrick B wrote: 2017-01-12 13:23 GMT+13:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: It is not the same DB if it is on two different servers not connected by replication. More to the point statement_timeout is a client connection setting, so is th

Re: [GENERAL] ERROR: canceling statement due to statement timeout

2017-01-11 Thread Adrian Klaver
On 01/11/2017 04:31 PM, Patrick B wrote: 2017-01-12 13:23 GMT+13:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 01/11/2017 04:08 PM, Patrick B wrote: Hi guys, I'm using PostgreSQL 9.2 in two different servers. server1 (Master Postgres DB server, running Po

Re: [GENERAL] ERROR: canceling statement due to statement timeout

2017-01-11 Thread Patrick B
2017-01-12 13:23 GMT+13:00 Adrian Klaver : > On 01/11/2017 04:08 PM, Patrick B wrote: > >> Hi guys, >> >> I'm using PostgreSQL 9.2 in two different servers. >> >> server1 (Master Postgres DB server, running Postgres 9.2 / 128GB ram) - >> RAID 10 Magnetic disks >> server2 (Master Postgres DB server

Re: [GENERAL] ERROR: canceling statement due to statement timeout

2017-01-11 Thread Adrian Klaver
On 01/11/2017 04:08 PM, Patrick B wrote: Hi guys, I'm using PostgreSQL 9.2 in two different servers. server1 (Master Postgres DB server, running Postgres 9.2 / 128GB ram) - RAID 10 Magnetic disks server2 (Master Postgres DB server, running Postgres 9.2 / 128GB ram) - EBS (AWS) io2 10k IOPS Whe

[GENERAL] ERROR: canceling statement due to statement timeout

2017-01-11 Thread Patrick B
Hi guys, I'm using PostgreSQL 9.2 in two different servers. server1 (Master Postgres DB server, running Postgres 9.2 / 128GB ram) - RAID 10 Magnetic disks server2 (Master Postgres DB server, running Postgres 9.2 / 128GB ram) - EBS (AWS) io2 10k IOPS When I run a query, I get this error: ERROR:

Re: [GENERAL] ERROR: canceling statement due to statement timeout

2010-07-12 Thread Tim
On 6 July 2010 16:36, Vick Khera wrote: > On Fri, Jul 2, 2010 at 12:22 PM, Tim wrote: >> I've had a website up for a couple of months and it's starting to get >> these db timeouts as traffic has increased to say 1k pageviews a day. >> > > Are you using any two-phase commit (ie, prepared transacti

Re: [GENERAL] ERROR: canceling statement due to statement timeout

2010-07-06 Thread Vick Khera
On Fri, Jul 2, 2010 at 12:22 PM, Tim wrote: > I've had a website up for a couple of months and it's starting to get > these db timeouts as traffic has increased to say 1k pageviews a day. > Are you using any two-phase commit (ie, prepared transactions?) We find that if you try to insert data tha

Re: [GENERAL] ERROR: canceling statement due to statement timeout

2010-07-02 Thread Craig Ringer
On 03/07/10 00:22, Tim wrote: > Hi, > > I've had a website up for a couple of months and it's starting to get > these db timeouts as traffic has increased to say 1k pageviews a day. Take note of which queries are timing out. You might need to enable some more logging in your app or the db to find

[GENERAL] ERROR: canceling statement due to statement timeout

2010-07-02 Thread Tim
Hi, I've had a website up for a couple of months and it's starting to get these db timeouts as traffic has increased to say 1k pageviews a day. It uses django with the gis stuff to find distances from user to object and it's hosted on webfaction. I've asked webfaction about it and they say no one