Re: Index size

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(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-11-30 14:43:21
Message-ID: c4238849-f813-51fc-41f9-f15bce6b8c86@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/30/2016 03:38 AM, Samuel Williams wrote:
> Is there any reason why for the same data set, and same indexes, that
> the data in postgres would be significantly larger than
> innodb/mariadb?
>

Hard to say without the table/index definitions and some indication of
what the data is.

What version of Postgres?

Also how are you measuring the size of the data set?

Have you looked at/tried the functions here?:

https://www.postgresql.org/docs/9.5/static/functions-admin.html#FUNCTIONS-ADMIN-DBOBJECT

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message btober@computer.org 2016-11-30 15:15:26 Re: select function alias
Previous Message Karsten Hilbert 2016-11-30 14:10:27 Re: Verify Option with pg_dump