Skip site navigation (1) Skip section navigation (2)

Re: large objects & space usage

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: large objects & space usage
Date: 2008-01-13 20:12:10
Message-ID: fmdram$rhe$ (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Kevin Kempter написа:
> Hi List;
> I'm engaging with a client who is trying to solve what sounds like a bloat 
> issue. However in further conversations they told me this:
> 1) we have a table that is an integer key and a blob column
> 2) the table was at 30Gig, we went in and deleted the last 2 months of data 
> and it's still at 30Gog
> At this point I thought bloat and that vacuum full or a table rebuild would 
> fix the issue.  However later they told me:
> 3) we did a pg_dump and a reload into a database on the test box and the table 
> is still 30Gig.
> I haven't gotten access to their servers yet so I only have the above info 
> however I wonder is there special space considerations or storage 
> requirements, etc with blobs ?

So what is it - large objects or BYTEA?

Milen A. Radev

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2008-01-13 21:04:25
Subject: Re: large objects & space usage
Previous:From: Kevin KempterDate: 2008-01-13 20:01:04
Subject: large objects & space usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group