Hi There,
We are considering to use NetApp filer for a highly
busy 24*7 postgres database and the reason we chose
netapp, mostly being the "snapshot" functionality for
backing up database online. The filer would be mounted
on a rh linux server (7.3), 4g RAM, dual cpu with a
dedicated card for file
thanks tom. i wasn't sure about create index taking
exclusive locks on tables too. so i could as well
reindex than doing the whole _swap mess during
off-peak hrs.
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Shankar K <[EMAIL PROTECTED]> writes:
> > ... so i then decided
Hi Everyone,
I've a kind of less inserts/mostly updates table,
which we vacuum every half-hour.
here is the output of vacuum analyze
INFO: --Relation public.accounts--
INFO: Index accounts_u1: Pages 1498; Tuples 515:
Deleted 179.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: Index acc
