2018-03-20 15:00 GMT+01:00 Adrian Klaver :
> On 03/20/2018 03:16 AM, Jimmy Augustine wrote:
>
>> Thanks all for your response,
>>
>> $du -h $MY_DATA/base/$BASE_OID/ returns 162GB but when I execute this
>> query:
>>
>> |SELECT stats.relname AS
G (relname)
WHERE stats.schemaname = current_schema
ORDER BY live_rows ASC;
I obtain 80GB in total_table_size (half of my database), where are
missing data at?
2018-03-19 19:32 GMT+01:00 Adrian Klaver :
> On 03/19/2018 10:27 AM, Jimmy Augustine wrote:
>
>> I tried this query and my dat
2018-03-19 18:25 GMT+01:00 Andreas Kretschmer :
> On 19 March 2018 18:21:42 CET, Jimmy Augustine
> wrote:
> >2018-03-19 18:15 GMT+01:00 Adrian Klaver :
> >
> >> On 03/19/2018 10:12 AM, Jimmy Augustine wrote:
> >>
> >>
> >>>
I tried this query and my database size is equal to 162GB.
2018-03-19 18:17 GMT+01:00 Melvin Davidson :
>
>
> On Mon, Mar 19, 2018 at 1:12 PM, Jimmy Augustine
> wrote:
>
>>
>>
>> 2018-03-19 18:09 GMT+01:00 Adrian Klaver :
>>
>>&g
2018-03-19 18:15 GMT+01:00 Adrian Klaver :
> On 03/19/2018 10:12 AM, Jimmy Augustine wrote:
>
>
>> On 03/19/2018 09:31 AM, Jimmy Augustine wrote:
>>
>> Dear Friends,
>>
>> I am newbie to postgresql.
>>
Hi,
I used this command and I found the same value in total_size column.
2018-03-19 18:01 GMT+01:00 Melvin Davidson :
>
>
> On Mon, Mar 19, 2018 at 12:45 PM, Adrian Klaver > wrote:
>
>> On 03/19/2018 09:31 AM, Jimmy Augustine wrote:
>>
>>> Dear Friends,
>
2018-03-19 18:09 GMT+01:00 Adrian Klaver :
> On 03/19/2018 10:04 AM, Jimmy Augustine wrote:
>
>>
>>
>> 2018-03-19 17:45 GMT+01:00 Adrian Klaver > <mailto:adrian.kla...@aklaver.com>>:
>>
>> On 03/19/2018 09:31 AM, Jimmy Augustine wrote:
>>
2018-03-19 17:45 GMT+01:00 Adrian Klaver :
> On 03/19/2018 09:31 AM, Jimmy Augustine wrote:
>
>> Dear Friends,
>>
>> I am newbie to postgresql.
>> I have 162 GB on my database but when I check size of all tables, I
>> approximately obtain 80 GB.
>> I al
Hi Andreas thanks for your response,
2018-03-19 17:44 GMT+01:00 Andreas Kretschmer :
> On 19 March 2018 17:31:20 CET, Jimmy Augustine
> wrote:
> >Dear Friends,
> >
> >I am newbie to postgresql.
> >I have 162 GB on my database but when I check size of all tables, I
where are they at? Can
I delete some of them?
All values come from pgAdmin 4 and checked by my own SQL
queries(postgresql-9.6).
I already run vacuum full and there is few dead tuples.
Best regards,
Jimmy AUGUSTINE
10 matches
Mail list logo
