Re: AW: [HACKERS] vacuum

2001-06-13 Thread Andy Samuel
The same question ... how's the size after you vacuum the tables/db ? > continuous UPDATEs happening to his table, no INSERTs, no DELETEs ... and > his tables quicklky grow from a 8k table to 65Meg if there is no vacuum > happening every few *hours* ... TIA Andy ---(en

[HACKERS] large object implementation

2001-06-11 Thread Andy Samuel
Hi I wonder why all large objects is placed in one system table pg_largeobject ). I just want to trow an idea, why not create a similiar table and added pglo ( something like pglo_tablename ). This way, the large objects will be spread in every table that has the blob type. Thank's Andy