Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CA0084759AA for ; Sun, 11 Aug 2002 10:43:32 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 21EC1475872 for ; Sun, 11 Aug 2002 10:43:32 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g7BEhGVk012770; Sun, 11 Aug 2002 10:43:36 -0400 (EDT) To: h012@ied.com Cc: pgsql-sql@postgresql.org Subject: Re: slowing down too fast - why ? In-reply-to: References: Comments: In-reply-to h012@ied.com message dated "Sun, 11 Aug 2002 00:22:49 -0400" Date: Sun, 11 Aug 2002 10:43:16 -0400 Message-ID: <12769.1029076996@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/182 X-Sequence-Number: 9028 h012@ied.com writes: > while sleep 10 ; do echo 'insert into times values( now(), count(file.id));' | psql -d filerian ; done 2>&1 >/dev/null & Apparently the file table is getting larger. That means the count() aggregate will take more time to run. regards, tom lane