Re: [PERFORM] pgsql-performance issue

Hi, On 2016-08-20 08:38:43 +, debasis.mohar...@ipathsolutions.co.in wrote: > I have a PostgreSQL 9.5 instance running on Windows 8 machine with 4GB of > RAM.This server is mainly used for inserting/updating large amounts of data > via copy/insert/update commands, and seldom for running select

Re: [PERFORM] Slow query with big tables

On Sat, Aug 27, 2016 at 18:33 GMT+03:00, Jeff Janes wrote: > Partitioning the Feature and Point tables on measurement_time (or > measurement_start_time, > you are not consistent on what it is called) might be helpful. However, > measurement_time does not exist