Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 21DA064FD1C for ; Thu, 31 Jul 2008 06:45:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 42845-01 for ; Thu, 31 Jul 2008 06:45:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from pih-relay05.plus.net (pih-relay05.plus.net [212.159.14.132]) by postgresql.org (Postfix) with ESMTP id 446CF64FCB8 for ; Thu, 31 Jul 2008 06:45:24 -0300 (ADT) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay05.plus.net with esmtp (Exim) id 1KOUim-00080m-E0; Thu, 31 Jul 2008 10:45:20 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 3939B274062; Thu, 31 Jul 2008 10:45:20 +0100 (BST) Message-ID: <489189B0.5060103@archonet.com> Date: Thu, 31 Jul 2008 10:45:20 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.16 (X11/20080707) MIME-Version: 1.0 To: Miernik CC: pgsql-performance@postgresql.org Subject: Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence References: <20080723152112.30A4.0.NOFFLE@turbacz.local> <20080723203203.31C4.0.NOFFLE@turbacz.local> <488840D3.2090808@archonet.com> <20080731061522.54FE.0.NOFFLE@turbacz.local> <48916B6A.4070203@archonet.com> <20080731082930.553C.0.NOFFLE@turbacz.local> <20080731091720.5576.0.NOFFLE@turbacz.local> In-Reply-To: <20080731091720.5576.0.NOFFLE@turbacz.local> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 220dff53505321a4cdffe8d6b353eef8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/275 X-Sequence-Number: 30875 Miernik wrote: > Theo Kramer wrote: >> file `which psql` >> /usr/bin/psql: ELF 32-bit LSB executable, Intel 80386, version 1 >> (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.9, >> stripped > > miernik@tarnica:~$ file `which psql` > /usr/bin/psql: symbolic link to `../share/postgresql-common/pg_wrapper' > miernik@tarnica:~$ file /usr/share/postgresql-common/pg_wrapper > /usr/share/postgresql-common/pg_wrapper: a /usr/bin/perl -w script text executable That's not psql though, that's Debian's wrapper around it which lets you install multiple versions of PostgreSQL on the same machine. Might be worth bypassing it and calling it directly. -- Richard Huxton Archonet Ltd