erformance@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
> 5 rows and then I try to do a standard simple join between this two
> ta
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
On Mon, Oct 24, 2016 at 2:07 PM, Lars Aksel Opsahl wrote:
> Hi
>
> Yes this makes both the update and both selects much faster. We are now down
> to 3000 ms. for select, but then I get a problem with another SQL where I
> only use epoch in the query.
>
> SELECT count(o.*) FROM met_vaer_wisline.
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
&
Lars Aksel Opsahl writes:
> In this example I have two tables one with 4 billion rows and another with
> 5 rows and then I try to do a standard simple join between this two
> tables and this takes 397391 ms. with this SQL (the query plan is added is
> further down)
This particular query w