Re: query speed depends on lifetime of frozen db?

From: Andriy Tkachuk <ant(at)imt(dot)com(dot)ua>
To: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: query speed depends on lifetime of frozen db?
Date: 2002-09-27 10:04:28
Message-ID: 20020927125020.N41282-100000@pool.imt.com.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andriy Tkachuk 2002-09-27 10:28:13 Re: query speed depends on lifetime of frozen db?
Previous Message Martijn van Oosterhout 2002-09-27 10:03:19 Re: query speed depends on lifetime of frozen db?

Browse pgsql-hackers by date

  From Date Subject
Next Message Andriy Tkachuk 2002-09-27 10:28:13 Re: query speed depends on lifetime of frozen db?
Previous Message Martijn van Oosterhout 2002-09-27 10:03:19 Re: query speed depends on lifetime of frozen db?