Le mercredi 06 juin 2012 à 21:45 +0200, Frank Lanitz a écrit :
> On Wed, 6 Jun 2012 20:31:36 +0200
> Alban Hertroys wrote:
>
> > On 6 Jun 2012, at 16:33, Frank Lanitz wrote:
> >
> >
> > Is your du reporting sizes in Bytes or blocks or ...?
>
> Should be byte as its a linux.
>
Not sure abou
On Wed, 6 Jun 2012 20:31:36 +0200
Alban Hertroys wrote:
> On 6 Jun 2012, at 16:33, Frank Lanitz wrote:
>
> > the result is much bigger than running a df -s over the postgres
> > folder
> > - Its about factor 5 to 10 depending on database.
>
>
> Is your du reporting sizes in Bytes or blocks or
On Wed, 2012-06-06 at 18:46 +0200, Julien Rouhaud wrote:
> On Wed, Jun 6, 2012 at 6:28 PM, Tom Lane wrote:
>
> > Frank Lanitz writes:
> > > Am 06.06.2012 17:49, schrieb Tom Lane:
> > >> For me, pg_database_size gives numbers that match up fairly well with
> > >> what "du" says. I would not expe
On 6 Jun 2012, at 16:33, Frank Lanitz wrote:
> the result is much bigger than running a df -s over the postgres folder
> - Its about factor 5 to 10 depending on database.
Is your du reporting sizes in Bytes or blocks or ...?
Alban Hertroys
--
The scale of a problem often equals the size of an
On Wed, Jun 6, 2012 at 6:28 PM, Tom Lane wrote:
> Frank Lanitz writes:
> > Am 06.06.2012 17:49, schrieb Tom Lane:
> >> For me, pg_database_size gives numbers that match up fairly well with
> >> what "du" says. I would not expect an exact match, since du probably
> >> knows about filesystem over
Frank Lanitz writes:
> Am 06.06.2012 17:49, schrieb Tom Lane:
>> For me, pg_database_size gives numbers that match up fairly well with
>> what "du" says. I would not expect an exact match, since du probably
>> knows about filesystem overhead (such as metadata) whereas
>> pg_database_size does not
Am 06.06.2012 17:49, schrieb Tom Lane:
> Frank Lanitz writes:
>> I've got an issue I'm not sure I might have a misunderstanding. When
>> calling
>
>> select sum(pg_database_size(datid)) as total_size from pg_stat_database
>
>> the result is much bigger than running a df -s over the postgres fold
Frank Lanitz writes:
> I've got an issue I'm not sure I might have a misunderstanding. When
> calling
> select sum(pg_database_size(datid)) as total_size from pg_stat_database
> the result is much bigger than running a df -s over the postgres folder
> - Its about factor 5 to 10 depending on data
Hi folks,
I've got an issue I'm not sure I might have a misunderstanding. When
calling
select sum(pg_database_size(datid)) as total_size from pg_stat_database
the result is much bigger than running a df -s over the postgres folder
- Its about factor 5 to 10 depending on database.
My understandi
Dhimant Patel wrote:
I have created a database, which I plan to load with several tables. I
am trying to find the size of the databases and came
across pg_database_size(oid) function.
Here's what you probably want:
select datname,pg_size_pretty(pg_database_size(pg_database.oid)) from
pg_data
On Wed, 2010-02-17 at 11:59 -0500, Dhimant Patel wrote:
>
> I have created a database, which I plan to load with several tables. I
> am trying to find the size of the databases and came
> across pg_database_size(oid) function. Since it requires databse oid,
> I thought there must be a view where
Dhimant Patel writes:
> I have created a database, which I plan to load with several tables. I am
> trying to find the size of the databases and came
> across pg_database_size(oid) function. Since it requires databse oid, I
> thought there must be a view where you get it - then came across
> "pg_d
Hi All,
I have just started with postgres and after going through manual nearly for
2 hours, I need help.
I have created a database, which I plan to load with several tables. I am
trying to find the size of the databases and came
across pg_database_size(oid) function. Since it requires databse oi
AI Rumman wrote:
What does pg_database_size resturs?
Bytes or KB?
those functions all return size in bytes. you can use
pg_size_pretty(pg_database_size('dbname')) to pretty print it as MB or
whatever is most appropriate.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
What does pg_database_size resturs?
Bytes or KB?
Please tell.
15 matches
Mail list logo
