Re: Index size - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Index size
Date
Msg-id c4238849-f813-51fc-41f9-f15bce6b8c86@aklaver.com
Whole thread Raw
In response to Re: Index size  (Samuel Williams <space.ship.traveller@gmail.com>)
Responses Re: Index size  (Samuel Williams <space.ship.traveller@gmail.com>)
List 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.klaver@aklaver.com


pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Verify Option with pg_dump
Next
From: "btober@computer.org"
Date:
Subject: Re: select function alias