Return-Path: postman Delivery-Date: Tue, 12 Oct 93 10:27:56 PDT Return-Path: postman Received: by postgres.Berkeley.EDU (5.61/1.29) id AA12454; Tue, 12 Oct 93 10:21:18 -0700 Resent-From: postman (POSTGRES mailing list) Resent-Message-Id: <9310121721.AA12454@postgres.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: aoki@postgres.Berkeley.EDU Received: from faerie.CS.Berkeley.EDU by postgres.Berkeley.EDU (5.61/1.29) id AA12446; Tue, 12 Oct 93 10:21:13 -0700 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.1C/8.1B) with SMTP id KAA23502; Tue, 12 Oct 1993 10:24:33 -0700 Message-Id: <199310121724.KAA23502@faerie.CS.Berkeley.EDU> From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: wolska@maccs.dcss.mcmaster.ca (Ewa Lata-Wolska) Cc: postgres@postgres.Berkeley.EDU Subject: Re: system catalogs In-Reply-To: Your message of Tue, 12 Oct 93 11:10 EDT Date: Tue, 12 Oct 93 10:24:32 -0700 X-Sender: aoki@postgres.Berkeley.EDU X-Mts: smtp Resent-To: postgres-dist Resent-Date: Tue, 12 Oct 93 10:21:17 PDT wolska@maccs.dcss.mcmaster.ca (Ewa Lata-Wolska) writes: > Hi, I have recently browsed through system catalogs and found out that > in pg_class postgres does not update number of tuples in the given relation. > Does it mean that the user should update number of tuples ? the "vacuum" command does this for you. (it's also a side effect of building an index on a class.) -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki