PQgetlength vs. octet_length()
| От | Michael Clark |
|---|---|
| Тема | PQgetlength vs. octet_length() |
| Дата | |
| Msg-id | bf5d83510908171528q2ab6ecc6md8d3d08f2c4615f3@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: PQgetlength vs. octet_length()
|
| Список | pgsql-hackers |
Hello everyone.
Having a weird issue.
I have a value inserted into a bytea column, which is about 137megs in size.
If I use octet_length() to check the size of the column for this specific row I get this:
TestDB=# SELECT octet_length(rawdata) FROM LargeData;
octet_length
--------------
143721188
When fetching the row through the C API, and I use PQgetlength() on the column of the row in question I get:
(gdb) p (int)PQgetlength(result, rowIndex, i)
$3 = 544453159
I am wondering if I am lacking knowledge that explains why these values are different, or if something fishy is going on.
What led me to investigating this is that fetching this row in a C application is causing a failure. My programs memory usage balloons to 1.3 gigs after executing this:
const char *valC = PQgetvalue(result, rowIndex, i);
Am I doing something wrong, or is there some ideas what I should investigate next?
This seems quite puzzling to me.
Thanks in advance for any help/insight offered,
Michael.
В списке pgsql-hackers по дате отправления: