Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMs4F-0004cm-Dg for pgsql-hackers@arkaria.postgresql.org; Wed, 14 Nov 2018 10:06:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gMs4C-0006jb-Gz for pgsql-hackers@arkaria.postgresql.org; Wed, 14 Nov 2018 10:06:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMs4C-0006jU-9q for pgsql-hackers@lists.postgresql.org; Wed, 14 Nov 2018 10:06:36 +0000 Received: from mx0a-00296801.pphosted.com ([148.163.150.38]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMs44-0004oC-9d for pgsql-hackers@postgresql.org; Wed, 14 Nov 2018 10:06:34 +0000 Received: from pps.filterd (m0114582.ppops.net [127.0.0.1]) by mx0a-00296801.pphosted.com (8.16.0.27/8.16.0.27) with SMTP id wAEA6OLi024272 for ; Wed, 14 Nov 2018 10:06:24 GMT Received: from mail-lf1-f72.google.com (mail-lf1-f72.google.com [209.85.167.72]) by mx0a-00296801.pphosted.com with ESMTP id 2nr7bfrcms-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Wed, 14 Nov 2018 10:06:24 +0000 Received: by mail-lf1-f72.google.com with SMTP id c5so2028231lfi.7 for ; Wed, 14 Nov 2018 02:06:23 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=rF4Sy80RlIPxsltGKFUYsoZLl+gMdLqYqbWWwInFUXk=; b=AWMmgoIWJewrgv7ZKfF7sCp9Fggd+PodxZjI2nob6MNHd1dChpAVaVM87Z9OWdJ3Vr VhWpcduKR0QuIQ12VRDU7o5c0yoNoacbANDucZ5ZafKq8m0Wb4xOih6yTGkmWPEFzctG 9f12ifj9oLu776leNWyB+ruuSZQeNOmxtmXe8XrY2Wl1A2uYHBOhQjTjBnCImFkfbPyw opZ+kiQttucnnMIaSon0Gjwy9L3BYAd7rv04oV2ojcF9cd83cy2VX2q3QWO7qB8sXH// l9DQ4oAqf5Tj8lAFeQede6mcDAizTc7RHYHXe6XQ/oY9fpEIhGN1AapMUr3UC5H5l+FK fjhg== X-Gm-Message-State: AGRZ1gJ7wt1nQvdq8qVID50zPVL0vMvofSdzS686Iofe/jULOepYLkNW a8zM5DxD6BOmbDpyzOe2xiyJoLfBWNTelqMt0WNRDXVk0WoneF1J2h/jZQOZDoWU5gG47HzUgdq 3nvaQde+cdVRLJgmDx/A4bkmkXk4VrKVuSRhlQYGSG18VmNYAIiCwZhpE/ulAAehRbQ== X-Received: by 2002:a19:8d01:: with SMTP id p1mr626415lfd.149.1542189981564; Wed, 14 Nov 2018 02:06:21 -0800 (PST) X-Google-Smtp-Source: AJdET5dyrnJEu99PAdDn7Gs+PX1eT/OY1Mt5yO/hLG7v10hY2dM2F+rtRLL+ol9TRBIqjENbxQWgw3HhR/v0hUDyYfw= X-Received: by 2002:a19:8d01:: with SMTP id p1mr626399lfd.149.1542189981109; Wed, 14 Nov 2018 02:06:21 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Hubert Zhang Date: Wed, 14 Nov 2018 18:06:09 +0800 Message-ID: Subject: Re: Control your disk usage in PG: Introduction to Disk Quota Extension To: tomas.vondra@2ndquadrant.com Cc: PostgreSQL Hackers Content-Type: multipart/alternative; boundary="00000000000000477d057a9d1695" X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:,, definitions=2018-11-14_08:,, signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 priorityscore=1501 malwarescore=0 suspectscore=0 phishscore=0 bulkscore=0 spamscore=0 clxscore=1015 lowpriorityscore=0 mlxscore=0 impostorscore=0 mlxlogscore=999 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1810050000 definitions=main-1811140093 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000000477d057a9d1695 Content-Type: text/plain; charset="UTF-8" Thanks, Tomas, Yes, we want to add the hooks into postgres repo. But before that, we plan to firstly get some feedbacks from community about the diskquota extension implementation and usage? Later, we'll modify our license and submit the hooks into CF. Thanks Hubert On Wed, Nov 14, 2018 at 3:54 AM Tomas Vondra wrote: > On Tue, 2018-11-13 at 16:47 +0800, Hubert Zhang wrote: > > Hi all, > > > > We implement disk quota feature on Postgresql as an extension(link: > > https://github.com/greenplum-db/diskquota), > > If you are interested, try and use it to limit the amount of disk > > space that > > a schema or a role can use in Postgresql. > > Any feedback or question are appreciated. > > > > It's not clear to me what's the goal of this thread? I understand what > quotas are about, but are you sharing it because (a) it's a useful > extension, (b) you propose adding a couple of new hooks (and keep the > extension separate) or (c) you propose adding both the hooks and the > extension (into contrib)? > > I assume it's either (b) and (c), in which case you should add it to > 2019-01 CF: https://commitfest.postgresql.org/21/ > > In either case, it might be useful to add a LICENSE to the github > repository, it's not clear what's the situation in this respect. That > probably matters especially for (b), because for (c) it'd end up with > PostgreSQL license automatically. > > regards > > -- > Tomas Vondra http://www.2ndQuadrant.com > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > > -- Thanks Hubert Zhang --00000000000000477d057a9d1695 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, Tomas,

Yes, we want to add the = hooks into postgres repo.
But before that, we plan to firstly get= some feedbacks from community about the diskquota extension implementation= and usage?=C2=A0
Later, we'll modify our license and submit = the hooks into CF.

Thanks
Hubert

On Wed, Nov 14, 2018 at= 3:54 AM Tomas Vondra <t= omas.vondra@2ndquadrant.com> wrote:
On Tue, 2018-11-13 at 16:47 +0800, Hubert Zhang wrote:
> Hi all,
>
> We implement disk quota feature on Postgresql as an extension(link: > https://github.com/greenplum-db/diskquota),
> If you are interested, try and use it to limit the amount of disk
> space that
> a schema or a role can use in Postgresql.
> Any feedback or question are appreciated.
>

It's not clear to me what's the goal of this thread? I understand w= hat
quotas are about, but are you sharing it because (a) it's a useful
extension, (b) you propose adding a couple of new hooks (and keep the
extension separate) or (c) you propose adding both the hooks and the
extension (into contrib)?

I assume it's either (b) and (c), in which case you should add it to 2019-01 CF: https://commitfest.postgresql.org/21/

In either case, it might be useful to add a LICENSE to the github
repository, it's not clear what's the situation in this respect. Th= at
probably matters especially for (b), because for (c) it'd end up with PostgreSQL license automatically.

regards

--
Tomas Vondra=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


--
Thanks

Hubert Zhang
--00000000000000477d057a9d1695--