| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Samuel Williams <space(dot)ship(dot)traveller(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Index size |
| Date: | 2016-12-06 03:12:05 |
| Message-ID: | 5842200d-3f24-1992-40cb-30233c7feae6@commandprompt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/03/2016 03:57 PM, Samuel Williams wrote:
> With some indexes, it looks like MySQL might not be adding all data to
> the index (e.g. ignoring NULL values). Does MySQL ignore null values
> in an index? Can we get the same behaviour in Postgres to minimise
> usage? What would be the recommendation here?
I don't think you are going to find many answers about the MySQL
implementation (since it will be storage engine specific and it isn't
Postgres) on a PostgreSQL list.
Sincerely,
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2016-12-06 04:03:11 | Re: Index size |
| Previous Message | Patrick B | 2016-12-06 02:20:59 | Streaming Replication delay getting bigger |