Re: [PERFORM] Very poor read performance, query independent

2017-07-17 Thread Claudio Freire
On Fri, Jul 14, 2017 at 12:34 PM, Charles Nadeau wrote: > Workers Planned: 12 > Workers Launched: 12 > Buffers: shared hit=728798037 read=82974833 > -> Hash Semi Joi

Re: [PERFORM] Very poor read performance, query independent

2017-07-17 Thread Charles Nadeau
Igor, The 1st clause of the where statement won't select addresses the same way as the one I wrote using the extension for IPv6 and IPv6 data types. flowstimestamp is a view: flows=# \d+ flowstimestamp View "public.flowstimestamp" Column| Type |