From: | "Oelkers, Phil" <phil(dot)oelkers(at)experian(dot)com> |
---|---|
To: | "'Samy Elashmawy'" <samelash(at)ix(dot)netcom(dot)com>, "Oelkers, Phil" <phil(dot)oelkers(at)experian(dot)com>, 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: | RE: anybody know who the damn list owner is? RE: Postgr esqlism & Vacuum? |
Date: | 2000-04-17 15:18:21 |
Message-ID: | F5F5D222CD70D111886C00805FE69D2101D4A865@schexch1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
probably couldn't but even if i could it wouldn't stop inbound mail right?
> -----Original Message-----
> From: Samy Elashmawy [SMTP:samelash(at)ix(dot)netcom(dot)com]
> Sent: Friday, April 14, 2000 12:22 PM
> To: Oelkers, Phil; pgsql-general(at)postgresql(dot)org
> Cc: 'postmaster(at)postgresql(dot)org'; 'postmaster(at)hub(dot)org'
> Subject: Re: anybody know who the damn list owner is? RE: [GENERAL]
> Postgresqlism & Vacuum?
>
> You could change your email address ?
>
> have you tried postgresql.org find the link where you
> subscibe/unsubscirbe.
>
>
> At 07:59 AM 4/14/2000 -0700, Oelkers, Phil wrote:
> >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 | Jim Mercer | 2000-04-17 15:23:19 | Re: safety of vacuum verbose analyze on active tables |
Previous Message | Karel Zak | 2000-04-17 15:10:30 | Re: excell to postgres |