From: | "Oelkers, Phil" <phil(dot)oelkers(at)experian(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | "'postmaster(at)postgresql(dot)org'" <postmaster(at)postgresql(dot)org>, "'postmaster(at)hub(dot)org'" <postmaster(at)hub(dot)org> |
Subject: | anybody know who the damn list owner is? RE: Postgresql ism & Vacuum? |
Date: | 2000-04-14 14:59:09 |
Message-ID: | F5F5D222CD70D111886C00805FE69D2101D4A850@schexch1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've been trying to get off this list forever no luck. I thought
I got the damn thing set to nomail, still get mail.
DOES ANYBODY KNOW WHERE I CAN CONTACT A
LIKE PERSON TO GET OFF THIS DAMN LIST?
> -----Original Message-----
> From: Peter Eisentraut [SMTP:e99re41(at)DoCS(dot)UU(dot)SE]
> Sent: Friday, April 14, 2000 6:59 AM
> To: Thomas
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Postgresqlism & Vacuum?
>
> On Fri, 14 Apr 2000, Thomas wrote:
>
> > I think there must be something wrong with the optimiser that it's
> > "postgresqlism" that you must vacuum analyze frequently.
>
> One thing that is not widely known is that vacuum actually has two
> orthogonal tasks: garbage collection and statistics collection (only when
> you ANALYZE). The fact that this is combined in one command is a
> historical artifact, and there are some voices that want to separate the
> commands.
>
> The way I see it, if you have enough disk space you never have to run
> vacuum to garbage collect. It might lead to obvious problems when the heap
> files get so large that it takes more time to physically access them. The
> alternative is to garbage collect on each transaction commit but that
> bears its own set of performance implications.
>
> The analyze part would probably not need an exclusive lock on the table
> but the vacuum certainly does.
>
>
> --
> Peter Eisentraut Sernanders väg 10:115
> peter_e(at)gmx(dot)net 75262 Uppsala
> http://yi.org/peter-e/ Sweden
From | Date | Subject | |
---|---|---|---|
Next Message | David Warren | 2000-04-14 15:00:13 | PGAccess |
Previous Message | Frank Bax | 2000-04-14 14:47:18 | Re: Postgresqlism & Vacuum? |