Re: slowing down too fast - why ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: h012(at)ied(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: slowing down too fast - why ?
Date: 2002-08-11 14:43:16
Message-ID: 12769.1029076996@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

h012(at)ied(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message h012 2002-08-11 18:10:34 Re: slowing down too fast - why ?
Previous Message h012 2002-08-11 04:36:44 Re: slowing down too fast - why ?