Hi
I'm trying to migrate a database from MySQL to postgres and I'm struggling
with the amount of diskspace the resulting db takes.
I may be missing a setting somewhere but I can't see one anywhere obvious
(apologies if I'm being stupid...)
Even postgres' idea of the size of the columns don't mat
Thanks for all the responses
On 5 February 2013 19:36, Rosser Schwarz wrote:
>
> On Tue, Feb 5, 2013 at 11:00 AM, Scott Mead wrote:
>>
>> Agreed, don't forget, you have indexes, free space, vacuum-able stuff,
>> etc... all laying in your datafiles. Your measurements are telling you
>> what
On 5 February 2013 20:33, Geoff Winkless wrote:
> http://www.postgresql.org/docs/9.2/static/storage-page-layout.html gives
> detail...
>
> Let's say around 249MB (23 bytes per row, according to that page) for the
> columns you mention, so that leaves 234MB unexplained.
>
&
On 6 February 2013 11:04, Albe Laurenz wrote:
> I doubt that PostgreSQL has substantially more disk overhead
> than other DBMS with comparable capabilities (comparison with
> flat files or MyISAM would be unfair).
>
You're right, of course; the same data on InnoDB works out if anything
slightly
On 6 February 2013 11:12, Geoff Winkless wrote:
> On 6 February 2013 11:04, Albe Laurenz wrote:
>
>> Have you tried using pg_filedump
>> (http://pgfoundry.org/frs/?group_id=1000541)
>> to dump a page or two of your table and figure
>> out what is where and where th
On 7 May 2013 08:37, Stephen Cook wrote:
> It doesn't matter to me at all, I just go with whatever is generally
> accepted by the mailing list (or perhaps, whatever is generally accepted by
> the most vocal part of the mailing list). Although, I only ever really did
> the whole "inline snippets"