Sergey E. Koposov wrote: > Hello hackers, > > I was starting to think about next SOC and the project for it. And for a > long time I wanted to implement the user quotas in PG. > So, I'll try to explain my understanding of the implementation, and I'll > be happy to hear any comments, objections, or pointings to my > misunderstanding. This is very first very rough idea, but I still would > like to hear whether it contains some obvious flaws... > > 1) The main idea is to implement the per-user quota (not per tablespace > for example). So, during the creation of the new user some quota can be > specified, and after that the size of all the relations *owned* by that > user should be limited by that number.
I could see this being useful per database, maybe. It seems like kind of an odd feature. Sincerely, Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq