anybody know who the damn list owner is? RE: Postgresql ism & Vacuum?
От | Oelkers, Phil |
---|---|
Тема | anybody know who the damn list owner is? RE: Postgresql ism & Vacuum? |
Дата | |
Msg-id | F5F5D222CD70D111886C00805FE69D2101D4A850@schexch1 обсуждение исходный текст |
Ответы |
Re: anybody know who the damn list owner is? RE: Postgresql
ism & Vacuum?
|
Список | 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@DoCS.UU.SE] > Sent: Friday, April 14, 2000 6:59 AM > To: Thomas > Cc: pgsql-general@postgresql.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@gmx.net 75262 Uppsala > http://yi.org/peter-e/ Sweden
В списке pgsql-general по дате отправления: