On 3 Apr 2002, Hannu Krosing wrote:
> On Wed, 2002-04-03 at 06:52, Gavin Sherry wrote:
> > On Wed, 3 Apr 2002, Christopher Kings-Lynne wrote:
> >
> > > Hi,
> > >
> > > Would it be an idea to have pg_dump append an ANALYZE; command to the end of
> > > its dumps to assist newbies / inexperienced
On Wed, 2002-04-03 at 06:52, Gavin Sherry wrote:
> On Wed, 3 Apr 2002, Christopher Kings-Lynne wrote:
>
> > Hi,
> >
> > Would it be an idea to have pg_dump append an ANALYZE; command to the end of
> > its dumps to assist newbies / inexperienced admins?
>
> I do not think this is desired behavio
Tom Lane wrote:
>
> Justin Clift <[EMAIL PROTECTED]> writes:
> > I agree adding an automatic background vacuum thread/process/something
> > will be really, really useful too.
> > Should we instead have this proposed automatic background something also
> > update the statistics every now and again
Justin Clift <[EMAIL PROTECTED]> writes:
> I agree adding an automatic background vacuum thread/process/something
> will be really, really useful too.
> Should we instead have this proposed automatic background something also
> update the statistics every now and again?
Yes, I had always assume
Tom Lane wrote:
>
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > ... And PostgreSQL needs some frequent VACUUM
> > anyway, so after a while this problem solves itself for the
> > average user.
>
> Yes, that's the key point for me too. Anyone who doesn't set up for
> routine vacu
Jan Wieck <[EMAIL PROTECTED]> writes:
> ... And PostgreSQL needs some frequent VACUUM
> anyway, so after a while this problem solves itself for the
> average user.
Yes, that's the key point for me too. Anyone who doesn't set up for
routine vacuums/analyzes is going to have per
Hi Jan,
Jan Wieck wrote:
>
> The defaults after a restore should result in index scans
> most of the time, resulting in some medium decent
> performance. And PostgreSQL needs some frequent VACUUM
> anyway, so after a while this problem solves itself for
Justin Clift wrote:
> Tom Lane wrote:
> >
> > Gavin Sherry <[EMAIL PROTECTED]> writes:
> > > On Wed, 3 Apr 2002, Christopher Kings-Lynne wrote:
> > >> Would it be an idea to have pg_dump append an ANALYZE; command to the end of
> > >> its dumps to assist newbies / inexperienced admins?
> >
> > > I
Tom Lane wrote:
>
> Gavin Sherry <[EMAIL PROTECTED]> writes:
> > On Wed, 3 Apr 2002, Christopher Kings-Lynne wrote:
> >> Would it be an idea to have pg_dump append an ANALYZE; command to the end of
> >> its dumps to assist newbies / inexperienced admins?
>
> > I do not think this is desired beha
Gavin Sherry <[EMAIL PROTECTED]> writes:
> On Wed, 3 Apr 2002, Christopher Kings-Lynne wrote:
>> Would it be an idea to have pg_dump append an ANALYZE; command to the end of
>> its dumps to assist newbies / inexperienced admins?
> I do not think this is desired behaviour.
I agree with Gavin here
On Wed, 3 Apr 2002, Christopher Kings-Lynne wrote:
> Hi,
>
> Would it be an idea to have pg_dump append an ANALYZE; command to the end of
> its dumps to assist newbies / inexperienced admins?
I do not think this is desired behaviour. Firstly, pg_dump is not just for
restoring data to the system
On Wed, 3 Apr 2002 09:40:13 +0800
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Would it be an idea to have pg_dump append an ANALYZE; command to the end of
> its dumps to assist newbies / inexperienced admins?
That strikes me as a good idea; a lot of the questions we get on
-ge
Hi,
Would it be an idea to have pg_dump append an ANALYZE; command to the end of
its dumps to assist newbies / inexperienced admins?
Reason being is that I noticed that when I just restored a 50MB dump that
the pg_statistic table had no contents...
I think it'd be an idea...
Chris
--
13 matches
Mail list logo
