Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
| Newsgroups | pgsql.general |
|---|---|
| Date | 2016-06-07 12:53 -0700 |
| References | <1bf81bb7-4d60-45d6-9b73-2e8aff34efd1@googlegroups.com> |
| Message-ID | <9d3a72fd-b98f-4297-b6c2-a937e452ae47@googlegroups.com> (permalink) |
| Subject | Re: slow query with count(*) |
| From | mkremer@trialfire.com |
postgresql sucks at counting. See here https://wiki.postgresql.org/wiki/Slow_Counting Running analyze on customers may speed things up if your stats are not upto date
Back to pgsql.general | Previous | Next — Previous in thread | Find similar
slow query with count(*) Vishnu R Krishnan <vgrkrishnan@gmail.com> - 2016-03-22 00:19 -0700 Re: slow query with count(*) mkremer@trialfire.com - 2016-06-07 12:53 -0700
csiph-web