María Dovale wrote:
> Thanks, I mean, how heavy it is in kB.
You can use lo_lseek64 to find out how big a large object is.
To find out the size of large object 24858, you can
SELECT lo_lseek64(lo_open(24858, 262144), 0, 2);
The last "2" here is SEEK_END from /usr/include/unistd.h, so it may be
t
Thanks, I mean, how heavy is.
2015-03-04 12:17 GMT-03:00 John R Pierce :
> On 3/4/2015 7:03 AM, María Griensu wrote:
>
> I need to figure out how can I weight BLOB objects in a table of a DB, I'm
> not expert on this topics, so I appreciate any help you can give me.
>
>
> postgres's equivalent o
Thanks, I mean, how heavy it is in kB.
2015-03-04 12:17 GMT-03:00 John R Pierce :
> On 3/4/2015 7:03 AM, María Griensu wrote:
>
> I need to figure out how can I weight BLOB objects in a table of a DB, I'm
> not expert on this topics, so I appreciate any help you can give me.
>
>
> postgres's equ
On 3/4/15 10:12 AM, Bill Moran wrote:
From there, if the data is large enough to trigger out-of-line
storage, the data will be broken down into chunks and stored in a
toast table, this increases the overhead because each row in the
toast table will have it's own overhead, and the number of rows
On Wed, 4 Mar 2015 12:36:36 -0300
María Griensu wrote:
> Thanks, I mean, how heavy it is in kB.
If you mean how much overhead is involved in storing the data, that's
a bit complicated.
First off, how the data is stored depends on the size of it, and what
other fields there are in the table and
Here's the answer.
http://pdenya.com/2014/01/16/postgres-bytea-size/
El 04/03/15 a las 12:17, John R Pierce escibió:
On 3/4/2015 7:03 AM, María Griensu wrote:
I need to figure out how can I weight BLOB objects in a table of a
DB, I'm not expert on this topics, so I appreciate any help you can
Thanks, I mean, how heavy it is in kB.
2015-03-04 12:17 GMT-03:00 John R Pierce :
> On 3/4/2015 7:03 AM, María Griensu wrote:
>
> I need to figure out how can I weight BLOB objects in a table of a DB, I'm
> not expert on this topics, so I appreciate any help you can give me.
>
>
> postgres's equ
On 3/4/2015 7:03 AM, María Griensu wrote:
I need to figure out how can I weight BLOB objects in a table of a DB,
I'm not expert on this topics, so I appreciate any help you can give me.
postgres's equivalent of BLOB is BYTEA. I'm not sure what you mean
by 'weight' here.
--
john r pierce
I need to figure out how can I weight BLOB objects in a table of a DB, I'm
not expert on this topics, so I appreciate any help you can give me.
Thanks in advance.
Maria.
