Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2C3E09F9F49 for ; Wed, 13 Dec 2006 21:25:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 28324-03 for ; Wed, 13 Dec 2006 21:25:21 -0400 (AST) X-Greylist: delayed 00:18:20.139818 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 77E619FA433 for ; Wed, 13 Dec 2006 21:25:21 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.it-geeks.kiev.ua (ns.it-geeks.kiev.ua [62.149.14.222]) by svr4.postgresql.org (Postfix) with ESMTP id 61B325AF8BE for ; Thu, 14 Dec 2006 01:07:00 +0000 (GMT) Received: by mail.it-geeks.kiev.ua (Postfix, from userid 1000) id 011C68DB85; Thu, 14 Dec 2006 03:06:56 +0200 (EET) Date: Thu, 14 Dec 2006 03:06:56 +0200 From: "Anton P. Linevich" To: pgsql-admin@postgresql.org Subject: Slowly Queries Message-ID: <20061214010656.GA18647@localhost> Mail-Followup-To: pgsql-admin@postgresql.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/194 X-Sequence-Number: 23986 Hi guys. Can you give me a describe what should i do when get a lot of slowly queries? Last week i saw such INFO messages in postgres log: LOG: duration: 8144.361 ms statement: update videos set watched=watched+1, last_view_date='1166057431' where id='106980' LOG: duration: 7825.637 ms statement: update videos set watched=watched+1, last_view_date='1166057431' where id='99337' LOG: duration: 7023.592 ms statement: insert into statistics_search(date,search,type,id_member) VALUES ('1166057432','sexy','V','0') LOG: duration: 6603.307 ms statement: insert into statistics_search(date,search,type,id_member) VALUES ('1166057432','Fun Day','V','0') LOG: duration: 6093.724 ms statement: insert into statistics_search(date,search,type,id_member) VALUES ('1166057433','party','V','0') LOG: duration: 5855.535 ms statement: update videos set watched=watched+1, last_view_date='1166057433' where id='102462' LOG: duration: 5464.827 ms statement: update videos set watched=watched+1, last_view_date='1166057433' where id='103901' LOG: duration: 8917.981 ms statement: update users_auth set date_last='1166057430' where id='384891' LOG: duration: 7584.912 ms statement: update videos set watched=watched+1, last_view_date='1166057431' where id='103164' LOG: duration: 5181.864 ms statement: update videos set watched=watched+1, last_view_date='1166057434' where id='112060' LOG: duration: 38394.879 ms statement: update upload_synchronizer set lock_status='N' where sess_id='103503' How i can tune database for quick updates? I have SATA RAID1. Thank you all for your answers. -- Anton P. Linevich