Horton
Menu

Re: Largeobject Access Controls (r2460)

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Cc: "Greg Smith" <greg@2ndquadrant.com>, "KaiGai Kohei" <kaigai@ak.jp.nec.com>, "Robert Haas" <robertmhaas@gmail.com>, "Takahiro Itagaki" <itagaki.takahiro@oss.ntt.co.jp>, pgsql-hackers@postgresql.org, "Jaime Casanova" <jcasanov@systemguards.com.ec>
Date: 2010-01-23T16:32:37Z
Lists: pgsql-hackers 
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> ...  After a few minutes that left me curious just how big
> the database was, so I tried:
 
> select pg_size_pretty(pg_database_size('test'));
 
> I did a Ctrl+C after about five minutes and got:
 
> Cancel request sent
 
> but it didn't return for 15 or 20 minutes.

Hm, we probably are lacking CHECK_FOR_INTERRUPTS in the inner loops in
dbsize.c ...

			regards, tom lane