Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence

От: Theo Kramer
Тема: Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
Дата: ,
Msg-id: A2792D4E-0E8A-4162-9B9C-E086D8E630D2@flame.co.za
(см: обсуждение, исходный текст)
Ответ на: Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Miernik)
Список: pgsql-performance

Скрыть дерево обсуждения

how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Miernik, )
 Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  ("Scott Marlowe", )
 Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Alvaro Herrera, )
 Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Miernik, )
  Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  ("Scott Marlowe", )
  Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Richard Huxton, )
 Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Miernik, )
 Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Albert Cervera Areny, )
 Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Miernik, )
  Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Richard Huxton, )
  Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Steve Crawford, )
 Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Miernik, )
  Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Theo Kramer, )
  Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Richard Huxton, )
  Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Craig Ringer, )
 Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Miernik, )
  Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Richard Huxton, )
  Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence  (Theo Kramer, )

On 31 Jul 2008, at 11:17AM, 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
> miernik@tarnica:~$


Hmm - looks like you are on a debian or debian derivative. However,
pg_wrapper is
not psql. It invokes psql which is written in C. Once psql is invoked
pg_wrapper drops away.
--
Regards
Theo



В списке pgsql-performance по дате сообщения:

От: Steve Crawford
Дата:
Сообщение: Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
От: "Matthew T. O'Connor"
Дата:
Сообщение: SSD Performance Article