Ken Caruso writes:
> On Tue, Jul 19, 2011 at 2:26 PM, Tom Lane wrote:
>> Ken Caruso writes:
>>> If I look at the total relation size using the following query:
>>> SELECT SUM(pg_relation_size(pg_class.oid)) FROM pg_class ;
>>> This says the total size is around 191GB.
>> What PG version?
> 9.0
On Tue, Jul 19, 2011 at 2:26 PM, Tom Lane wrote:
> Ken Caruso writes:
> > I am trying to trouble shoot a couple of issue related to vacuum and db
> > size. I currently have a postgres DB that is around 390GB on disk (du -hs
> in
> > $PG_DATA/base). If I look at the total relation size using the
Ken Caruso wrote:
> Kevin Grittner
>> Ken Caruso wrote:
>>
>>
>> > SELECT SUM(pg_relation_size(pg_class.oid))
>> > FROM pg_class ;
>>
>> Perhaps you want pg_total_relation_size()?
> The number returned when using pg_total_relation size makes more
> sense: 346GB. However it looked like pg_cla
Ken Caruso writes:
> I am trying to trouble shoot a couple of issue related to vacuum and db
> size. I currently have a postgres DB that is around 390GB on disk (du -hs in
> $PG_DATA/base). If I look at the total relation size using the following
> query:
> SELECT SUM(pg_relation_size(pg_class.oi
On Tue, Jul 19, 2011 at 1:50 PM, Kevin Grittner wrote:
> Ken Caruso wrote:
>
>
> > SELECT SUM(pg_relation_size(pg_class.oid))
> > FROM pg_class ;
>
> Perhaps you want pg_total_relation_size()?
>
> -Kevin
>
The number returned when using pg_total_relation size makes more sense:
346GB. However it
Ken Caruso wrote:
> SELECT SUM(pg_relation_size(pg_class.oid))
> FROM pg_class ;
Perhaps you want pg_total_relation_size()?
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hello,
I am trying to trouble shoot a couple of issue related to vacuum and db
size. I currently have a postgres DB that is around 390GB on disk (du -hs in
$PG_DATA/base). If I look at the total relation size using the following
query:
SELECT SUM(pg_relation_size(pg_class.oid))
FROM pg_class ;
T
On Sun, Jul 17, 2011 at 3:04 AM, Cédric Villemain <
cedric.villemain.deb...@gmail.com> wrote:
> 2011/7/17 Ken Caruso :
> >
> >
> > On Sat, Jul 16, 2011 at 2:30 PM, Tom Lane wrote:
> >>
> >> Ken Caruso writes:
> >> > Sorry, the actual error reported by CLUSTER is:
> >>
> >> > gpup=> cluster verbo
Mario Splivalo wrote:
> I have user foo that is owner of database dbfoo. Now I need to
> create user baz that will have the exact same privileges as user
> foo on database baz. I've tried this:
>
> GRANT ALL ON DATABASE dbfoo TO baz;
>
> but I still can't select form tables.
Did you mean tha
I have user foo that is owner of database dbfoo. Now I need to create
user baz that will have the exact same privileges as user foo on
database baz. I've tried this:
GRANT ALL ON DATABASE dbfoo TO baz;
but I still can't select form tables.
Is there a easier way, or do I need to go trough all
I have a master and slave set up with replication - both xlog and
streaming replication are set up and working great. The slave keeps
up with the master and is available for read-only queries.
I just configured the archive_cleanup_command in my recovery.conf file
on the slave to use pg_archivecle
11 matches
Mail list logo
