Re: performance problem - 10.000 databases

From: Marek Florianczyk <franki(at)tpi(dot)pl>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: performance problem - 10.000 databases
Date: 2003-11-05 16:44:28
Message-ID: 1068050668.28821.143.camel@franki-laptop.tpi.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

W liście z śro, 05-11-2003, godz. 17:24, Andrew Sullivan pisze:
> On Wed, Nov 05, 2003 at 08:48:52AM -0500, Jeff wrote:
> >
> > as far as I know, -HUP won't make things like shared buffer changes
> > take. you need a full restart of PG.
>
> It definitely will not. Anything that can only be set on "startup"
> actually means startup.
>
> > but your numbers are different... I guess it did take. huh.
>
> No, that probably just means that there is more variability to runs
> than people like to imagine.

It look's like I will have to make this tests again. It's not big deal,
just when I solve slow "\d table" problem.
VACUUM ANALYZE in progress...

thanks,

Marek

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-11-05 17:59:49 Re: performance problem - 10.000 databases
Previous Message Andrew Sullivan 2003-11-05 16:24:07 Re: performance problem - 10.000 databases