Re: [GENERAL] query results different after vacuum analyze? 7.4.0
Klint Gore [EMAIL PROTECTED] writes: There are 55k rows in t1 (103 fields) and 10k in t2 (4 fields, 4 is text). before vacuum analyze the query gave 10k rows like it was doing an inner join. after vacuum analyze gave the full 55k. Sounds like a bug ... 7.4.0, rh linux 7.2, p4 (non ht) cpu. You are of course aware that there are a lot of known bugs in 7.4.0? Please try it on 7.4.2. If you can still make it happen on 7.4.2 then I'd be interested in a test case... regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] Database Size Limiting
Title: Database Size Limiting I wonder if this will work: each DB should assigned a diffrent user with set of premissions ( including insert ). a script that can revoke the inseret privilage will emarge from time to time to check the DB size. --Canaan Surfing Ltd.Internet Service ProvidersBen-Nes Michael - ManagerTel: 972-4-6991122Fax: 972-4-6990098http://www.canaan.net.il-- - Original Message - From: Campano, Troy To: Postgres general mailing list Sent: Thursday, May 27, 2004 8:07 PM Subject: [GENERAL] Database Size Limiting Is there a way to limit the size that an individual database can take up? My understanding is that all your databases go into a file system which is your ‘catalog cluster’. But all the databases can grow until that filesystem is full. Is there a way to limit how big a database can be? Can you allocated space when the database is set up so you can say db1 can only be 100 MB? Thank you! Troy Campano
Re: [GENERAL] Database Size Limiting
Campano, Troy wrote: Is it possible to have a database spread across two data files? So if it fills up filesystem1 then we could add a second filesystem and allow it to grow onto this second filesystem? If you're using Linux there is a tool called the Linux Volume Manager (LVM) which does this. You can change volume sizes dynamically, add new disks etc. I think all modern operating-systems offer something similar. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings