On Thu, Sep 19, 2019 at 07:00:01PM +0200, Joao Junior wrote:
A table with 800 gb means 800 files of 1 gb. When I use truncate or drop
table, xfs that is a log based filesystem, will write lots of data in its
log and this is the problem. The problem is not postgres, it is the way
that xfs works
Re: Joao Junior 2019-09-19
> A table with 800 gb means 800 files of 1 gb. When I use truncate or drop
> table, xfs that is a log based filesystem, will write lots of data in its
> log and this is the problem. The problem is not postgres, it is the way
> that xfs works with big files , or being
A table with 800 gb means 800 files of 1 gb. When I use truncate or drop
table, xfs that is a log based filesystem, will write lots of data in its
log and this is the problem. The problem is not postgres, it is the way
that xfs works with big files , or being more clear, the way that it
handles
Am 19.09.19 um 17:59 schrieb Joao Junior:
I have a table that Is not being use anymore, I want to drop it.
The table is huge, around 800GB and it has some index on it.
When I execute the drop table command it goes very slow, I realised
that the problemĀ is the filesystem.
It seems that XFS
Hi,
I am running Postgresql 9.6 XFS as filesystem , kernel Linux 2.6.32.
I have a table that Is not being use anymore, I want to drop it.
The table is huge, around 800GB and it has some index on it.
When I execute the drop table command it goes very slow, I realised that
the problem is the