pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump and diffrent sizes
2+ messages / 2 participants
[nested] [flat]
* pg_dump and diffrent sizes
@ 2006-03-03 20:10 Maciej Piekielniak <piechcio@isb.com.pl>
0 siblings, 1 reply; 2+ messages in thread
From: Maciej Piekielniak @ 2006-03-03 20:10 UTC (permalink / raw)
To: pgsql-sql
Hello pgsql-sql,
I dump db with pg_dump v.8.1.3 on database postgresql server 7.4.7.
Data directory with my db on pg 7.4.7 had 1,8GB and
file with dump had 2,7GB.
Database have blob fields.
When I restore db on pg 8.1 - data directory have only 1GB, why?
--
Best regards,
Maciej mailto:piechcio@isb.com.pl
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_dump and diffrent sizes
@ 2006-03-03 20:15 Scott Marlowe <smarlowe@g2switchworks.com>
parent: Maciej Piekielniak <piechcio@isb.com.pl>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2006-03-03 20:15 UTC (permalink / raw)
To: Maciej Piekielniak <piechcio@isb.com.pl>; +Cc: pgsql-sql
On Fri, 2006-03-03 at 14:10, Maciej Piekielniak wrote:
> Hello pgsql-sql,
>
> I dump db with pg_dump v.8.1.3 on database postgresql server 7.4.7.
> Data directory with my db on pg 7.4.7 had 1,8GB and
> file with dump had 2,7GB.
> Database have blob fields.
>
> When I restore db on pg 8.1 - data directory have only 1GB, why?
I would guess that you have lots of highly compressible text entries,
and postgresql is compressing them for you. The difference in size
between 7.4 and 8.1 is likely due to unrecycled tuples in the data
store. Even with regular vacuuming, some small percentage of dead
tuples is normal.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-03-03 20:15 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-03 20:10 pg_dump and diffrent sizes Maciej Piekielniak <piechcio@isb.com.pl>
2006-03-03 20:15 ` Scott Marlowe <smarlowe@g2switchworks.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox