[PERFORM] Query order of magnitude slower with slightly different where clause

Hey all, i've run into a performance problem with one of my queries that I am really not sure what is causing it. Setup info: Postgres version 9.4.4 on Debian 7. Server is virtual, with a single core and 512 ram available and ssd storage. Changes to postgresql.conf: maintenance_work_mem = 30MB

Re: [PERFORM] Query order of magnitude slower with slightly different where clause

On 18 January 2016 at 10:41, Adam Brusselback wrote: > Hey all, i've run into a performance problem with one of my queries that I > am really not sure what is causing it. > > Setup info: > Postgres version 9.4.4 on Debian 7. Server is virtual, with a single core > and