[PERFORM] Fast insert, but slow join and updates for table with 4 billion rows

Hi I have two main problems and that is slow updates and joins, but when I build up the table met_vaer_wisline.nora_bc25_observation with more than 4 billion we are able to insert about 85.000 rows pr sekund so thats ok. The problems start when I need to update or joins with other tables usi

Re: [PERFORM] Fast insert, but slow join and updates for table with 4 billion rows

Lane Sendt: 24. oktober 2016 14:52 Til: Lars Aksel Opsahl Kopi: pgsql-performance@postgresql.org Emne: Re: [PERFORM] Fast insert, but slow join and updates for table with 4 billion rows Lars Aksel Opsahl writes: > In this example I have two tables one with 4 billion rows and another with &

Re: [PERFORM] Fast insert, but slow join and updates for table with 4 billion rows

Lars Fra: Scott Marlowe Sendt: 24. oktober 2016 22:23 Til: Lars Aksel Opsahl Kopi: Tom Lane; pgsql-performance@postgresql.org Emne: Re: [PERFORM] Fast insert, but slow join and updates for table with 4 billion rows On Mon, Oct 24, 2016 at 2:07 PM, Lars Aksel Opsahl

Re: [PERFORM] Fast insert, but slow join and updates for table with 4 billion rows

e for sure really fun to work with Postgres/Postgis open source software hold a very high quality. Thanks. Lars Fra: pgsql-performance-ow...@postgresql.org på vegne av Tom Lane Sendt: 24. oktober 2016 14:52 Til: Lars Aksel Opsahl Kopi: pgsql-p