jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <msl...@email.cz>
Subject Re: PostgreSQL PersistenceManager disk space (pg_toast)
Date Tue, 29 Jan 2013 13:55:09 GMT
It is how Postgres stores (big) binary data. See http://www.postgresql.org/
docs/9.2/static/storage-toast.html. It is set so when
you save binary data using db persistence manager. In this case binary data 
are stored in db as binary fields.

Marek

-- 
Marek Slama
mslama@email.cz



---------- Původní zpráva ----------
Od: david.wery <david.wery@calysis.be>
Datum: 29. 1. 2013
Předmět: PostgreSQL PersistenceManager disk space (pg_toast)

"Hi the community,

I'm currently importing lots of PDF to JackRabbit and I have a strange
behavior with the disk space usage (or I don't understand it).

I'm using the following configuration :


While importing the PDF (240 000 in total), i have the PostgresQL database
xxx and the /var/xxx/repository/data folder growing at the same speed and
having +/- the same size. For example, for 23 000 documents imported, the
database size is 9.9 G and the /var/xxx/repository/data size is 9.9 G. 

Querying the database to get table size give me :


The full database size is consumed on the table pg_toast.pg_toast_408680.
Does someone have an idea on what is this table and it is used for ?

Many thanks !



-----







David Wery 
CTO @ Manex 
Rue Wagner 127Belgique BE-4100 Boncelles Belgium 

Office : +32 4 330 37 33 Mobile : +32 497 50 53 20 

david.wery@manex.biz www.manex.biz 


Follow us! 






--
View this message in context: http://jackrabbit.510166.n4.nabble.com/
PostgreSQL-PersistenceManager-disk-space-pg-toast-tp4657533.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com."
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message