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 behaviour.
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 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 behaviour.
I
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 do not think this is
Hi Jan,
Jan Wieck wrote:
snip
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
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
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 vacuums/analyzes
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 assumed
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?
Yes, I
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
-general
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.
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 ... a
12 matches
Mail list logo