| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Non-Stored Generated Columns |
| Date: | 2024-02-29 12:24:55 |
| Message-ID: | 3c7e0de87eedeb66a127394202db8f12af36c424.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2024-02-29 at 12:07 +0100, Dominique Devienne wrote:
> But I'm sure indexes on columns "not used at all in a statement" are eliminated early and easily/cheaply,
> w/o even getting into more complex consideration like statistics and co. Aren't they?
You may want a "SELECT count(*) FROM tab" to consider an index-only
scan on a small index, right? I'm not saying that it is a large
overhead, but if you actually have dozens of indexes, it can
make processing slower.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anthony Codjoe - IQ-C | 2024-02-29 12:31:06 | Voluntary Product Assessment For pgAdmin 8.3 |
| Previous Message | Or Cohen | 2024-02-29 11:47:57 | RE: SUSE repositories not longer available |