On Sun, Aug 11, 2002 at 02:10:34PM -0400, [EMAIL PROTECTED] wrote:
>
> I've even launched the backend with "-F" and removed BEGIN/COMMIT and
> LOCK TABLE and FOR UPDATE, but I still get slow response.
>
> only when count(*) from file is 16000, I get about 2-3 rows / second on
> average. When
I've even launched the backend with "-F" and removed BEGIN/COMMIT and
LOCK TABLE and FOR UPDATE, but I still get slow response.
only when count(*) from file is 16000, I get about 2-3 rows / second on
average. When count(*) from file was 100, I get about 20-30 rows / second.
Help !
T
[EMAIL PROTECTED] 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
