Re: Control your disk usage in PG: Introduction to Disk Quota Extension

Thanks David! We rebased this patch with the newest master. Thank you very much! Regards, Haozhou On Wed, Mar 25, 2020 at 12:00 AM David Steele wrote: > On 12/2/19 1:39 AM, Haozhou Wang wrote: > > > > Thank you very much for your email. I rebased the code with the ne

Re: Control your disk usage in PG: Introduction to Disk Quota Extension

Hi Michael, Thank you very much for your email. I rebased the code with the newest master and attached it in the attachment. Thank you very much! Regards, Haozhou On Sun, Dec 1, 2019 at 11:20 AM Michael Paquier wrote: > On Fri, Sep 27, 2019 at 11:30:08AM +0800, Haozhou Wang wrote: &g

Re: Control your disk usage in PG: Introduction to Disk Quota Extension

Thanks Alvaro! I rebased this patch with the newest master branch. Attached the new patch disk_quota_hooks_v5.patch in the attachment. Regards, Haozhou On Thu, Sep 26, 2019 at 3:54 AM Alvaro Herrera wrote: > This patch no longer applies. Can you please rebase? > > -- > Álvaro Herrera >

Re: Control your disk usage in PG: Introduction to Disk Quota Extension

Thanks very much for your comments. To the best of my knowledge, smgr is a layer that abstract the storage operations. Therefore, it is a good place to control or collect information the storage operations without touching the physical storage layer. Moreover, smgr is coming with actual disk IO

Re: Control your disk usage in PG: Introduction to Disk Quota Extension

would like to add a hook just before the smgrextend to get the oid and avoid use RelidByRelfilenode(). New patch is attached in the attachment. Thank a lot! Regards, Haozhou On Wed, Nov 21, 2018 at 10:48 PM Robert Haas wrote: > On Tue, Nov 20, 2018 at 2:20 AM Haozhou Wang wrote: > > We

Re: Control your disk usage in PG: Introduction to Disk Quota Extension

Hi all, We prepared a patch that includes the hook points. And such hook points are needed for disk quota extension. There are two hooks. One is SmgrStat_hook. It's used to perform ad-hoc logic in storage when doing smgr create/extend/truncate in general. As for disk quota extension, this hook is

Re: Vacuum Full does not release the disk size space after delete from table

Thank Tom! We will check it. On Fri, Nov 2, 2018 at 10:35 PM Tom Lane wrote: > Haozhou Wang writes: > > We meet a corner case that related to the behavior of Vacuum Full. > > ... > > If we run both sql scripts on same database in parallel, the "VACUUM FULL > &g

Vacuum Full does not release the disk size space after delete from table

Hi hackers, We meet a corner case that related to the behavior of Vacuum Full. There are two SQL scripts SQL1: - -- Test vacuum full create schema s2; set search_path to s2; create table a (i int); create table b (i int); insert

Re: [PATCH] Add missing type conversion functions for PL/Python

+1, I also think that we may not change the previous behavior of plpython. @Nikita Glukhov maybe we just check the whether pyobject is int or long only in related conversion functions, and fallback otherwise? On Fri, Jul 13, 2018 at 12:09 AM Heikki Linnakangas wrote: > On 12/07/18 18:06,

Re: [PATCH] Add missing type conversion functions for PL/Python

Thanks Nikita! On Tue, Mar 27, 2018 at 12:07 AM, Nikita Glukhov <n.glu...@postgrespro.ru> wrote: > On 26.03.2018 17:19, David Steele wrote: > > On 2/20/18 10:14 AM, Haozhou Wang wrote: >> >>> Thank you very much for your review! >>> >>> I attached

Re: [PATCH] Add missing type conversion functions for PL/Python

Thank you very much for your review! I attached a new patch with typo fixed. Regards, Haozhou On Mon, Feb 19, 2018 at 2:37 PM, Anthony Bykov <a.by...@postgrespro.ru> wrote: > On Wed, 31 Jan 2018 11:57:12 +0800 > Haozhou Wang <haw...@pivotal.io> wrote: > > > Hi All

[PATCH] Add missing type conversion functions for PL/Python

Hi All, PL/Python already has different type conversion functions to convert PostgreSQL datum to Python object. However, the conversion functions from Python object to PostgreSQL datum only has Boolean, Bytea and String functions. In this patch, we add rest of Integer and Float related datatype