| From: | John Naylor <john(dot)naylor(at)enterprisedb(dot)com> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [RFC] speed up count(*) |
| Date: | 2021-10-20 19:01:13 |
| Message-ID: | CAFBsxsFMe9FrRoAaEB1nwGy0v6fo6urtxxoMQ1E+pDxz+R2tLA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Oct 20, 2021 at 2:41 PM Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
wrote:
> BTW you mentioned using BRIN indexes for min/max - I've been thinking
> about using BRIN indexes for ordering/sorting, which seems related. And
> I think it's actually doable, so I wonder why you concluded using BRIN
> indexes for min/max is not possible?
I just gathered it was not implemented in the planner, going by the explain
plan in the toy query I tried, and then I got the lightbulb in my head
about count(*).
--
John Naylor
EDB: http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Dilger | 2021-10-20 19:06:01 | Re: Extending amcheck to check toast size and compression |
| Previous Message | Thomas Munro | 2021-10-20 18:55:54 | Interrupts vs signals |