Re: [ZODB-Dev] Question about relstorage and pack-gc

2012-07-13 Thread Shane Hathaway
On 07/13/2012 02:42 PM, Santi Camps wrote: On Fri, Jul 13, 2012 at 7:05 PM, Shane Hathaway mailto:sh...@hathawaymix.org>> wrote: On 07/12/2012 01:30 PM, Santi Camps wrote: My specific question is: if I disable pack-gc, can I safety empty object_ref table and free this space?

Re: [ZODB-Dev] Question about relstorage and pack-gc

2012-07-13 Thread Santi Camps
On Fri, Jul 13, 2012 at 7:05 PM, Shane Hathaway wrote: > On 07/12/2012 01:30 PM, Santi Camps wrote: > >> My specific question is: if I disable pack-gc, can I safety empty >> object_ref table and free this space? >> > > Certainly. However, most of the 23 GB probably consists of blobs; blobs > are

Re: [ZODB-Dev] Question about relstorage and pack-gc

2012-07-13 Thread Shane Hathaway
On 07/12/2012 01:30 PM, Santi Camps wrote: My specific question is: if I disable pack-gc, can I safety empty object_ref table and free this space? Certainly. However, most of the 23 GB probably consists of blobs; blobs are not shown in the query results you posted. Shane ___

[ZODB-Dev] Question about relstorage and pack-gc

2012-07-12 Thread Santi Camps
Hi I've been using relstorage for years in production environments and it's really amazing, zero big problems. However, I have now some big databases. I'm examining one of them, 23 GB in total, postgresql 8.3 and RelStorage 1.5.1 and I see that biggest objects are objects_ref and it's index: