Re: Delete huge Table under XFS

2019-09-19 Thread Christoph Berg
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

Re: Postgresql Sort cost Poor performance?

2019-04-01 Thread Christoph Berg
Re: Gavin Flower 2019-04-01 <3113f2f4-a4da-4862-8596-2e189398c...@archidevsys.co.nz> > Would it be possible to optionally enable the system to create a hidden > system column for the text field to be sorted, the new column would be the > original column preprocessed to sort correctly & efficiently

Re: Performance regressions found using sqlfuzz

2019-02-12 Thread Christoph Berg
Re: Jung, Jinho 2019-02-11 > We are developing a tool called sqlfuzz for automatically finding performance > regressions in PostgreSQL. sqlfuzz performs mutational fuzzing to generate > SQL queries that take more time to execute on the latest version of > PostgreSQL compared to prior versions.