Fwd: TOAST table performance problem

2020-02-09 Thread Asya Nevra Buyuksoy
-- Forwarded message - Gönderen: Asya Nevra Buyuksoy Date: 10 Şub 2020 Pzt, 10:51 Subject: Re: TOAST table performance problem To: Andreas Joseph Krogh I copied my data to the CSV file, yes it is very fast. However, this does not solve my problem. After deserializing the on the

Re: Writing 1100 rows per second

2020-02-09 Thread Jeff Janes
On Wed, Feb 5, 2020 at 12:25 PM Arya F wrote: > If I run the database on a server that has enough ram to load all the > indexes and tables into ram. And then it would update the index on the HDD > every x seconds. Would that work to increase performance dramatically? > Perhaps. Probably not