From: | Varun Kacholia <varunk(at)cse(dot)iitb(dot)ac(dot)in> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: db grows and grows |
Date: | 2002-06-19 21:08:00 |
Message-ID: | 20020620024041.A12721@voxel.cse.iitb.ac.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> > During the REINDEX-run I see plenty "SELECT (waiting)" with ps. So I can
> > confirm this.
>
> But why would a ShareLock cause SELECT to wait? Anyone? ShareLock
> isn't supposed to prevent that. It _should_ cause UPDATE to wait,
> but not SELECT (or at least, that's what I think the docs say).
Exaclty i also feel that sharelock shud not make select wait..
(unless pgsql goes bunkers? :-D )
> A
>
> --
> ----
> Andrew Sullivan 87 Mowat Avenue
> Liberty RMS Toronto, Ontario Canada
> <andrew(at)libertyrms(dot)info> M6K 3E3
> +1 416 646 3304 x110
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
--
------
Varun
Why doesn't DOS ever say "EXCELLENT command or filename!"
From | Date | Subject | |
---|---|---|---|
Next Message | Varun Kacholia | 2002-06-19 21:14:40 | Idle timeout |
Previous Message | Devrim GUNDUZ | 2002-06-19 20:39:18 | Re: How to see version of pg_dump |