Postgres Pro
Downloads
Home   >   mailing lists

Re: much slower query in production - Mailing list pgsql-performance

From Michael Lewis
Subject Re: much slower query in production
Date
Msg-id CAHOFxGp9K3LHR8ejzDvMyNNv9WmpyyA6CvctZGTeh3iJ38kcwg@mail.gmail.com
Whole thread Raw
In response to Re: much slower query in production  (Guillaume Cottenceau <gc@mnc.ch>)
Responses Re: much slower query in production  ("MichaelDBA@sqlexec.com" <michaeldba@sqlexec.com>)
Re: much slower query in production  (Guillaume Cottenceau <gc@mnc.ch>)
List pgsql-performance
Tree view
UPDATE multicards
   SET defacements = COALESCE( count, 0 )
  FROM ( SELECT multicard_uid, COUNT(*) AS count FROM tickets GROUP BY multicard_uid ) AS sub
 WHERE uid = multicard_uid OR multicard_uid is null;

I expect this should work. Not sure of performance of course.

pgsql-performance by date:

Previous
From: Guillaume Cottenceau
Date:
Subject: Re: much slower query in production
Next
From: "MichaelDBA@sqlexec.com"
Date:
Subject: Re: much slower query in production