Re: query speed depends on lifetime of frozen db? - Mailing list pgsql-general

From Andriy Tkachuk
Subject Re: query speed depends on lifetime of frozen db?
Date
Msg-id 20020927125020.N41282-100000@pool.imt.com.ua
Whole thread Raw
In response to Re: query speed depends on lifetime of frozen db?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
On Fri, 27 Sep 2002, Shridhar Daithankar wrote:

> On 27 Sep 2002 at 11:49, Andriy Tkachuk wrote:
> > As I said there was no work with this test database during the time after which
> > query becomes overloading. There was just work with another databases.
>
> >From testing point of view, that is not much good. Try halting all work and
> just do this testing. One variable at a time..

All work was halted. Testing was true, in appropriate enviroment.

>
> I understand it may be difficult if it's a production system but with other DBs
> working on site, too many variables come into picture..

In testing time there was only our testing query, no others.
There was no any noticeable variable.

Thanks,
  Andriy.


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: query speed depends on lifetime of frozen db?
Next
From: Andriy Tkachuk
Date:
Subject: Re: query speed depends on lifetime of frozen db?