estimate Index size

Started by sangeethaalmost 10 years ago1 messagesgeneral
Jump to latest
#1sangeetha
tune2sangee@gmail.com

Hi All,
I want to calculate bytes taken for a record before inserting it into table.
Now I am doing bulk inserts into table with 200 records using PQputCopyData.
Before inserting 200 records, I want to verify if the size of DB is
sufficient for that insertion. I think for that I have to calculate record
size + index size for each record *before insertion*.

Please guide on this.

Thanks and Regards,
S.Sangeetha

--
View this message in context: http://postgresql.nabble.com/estimate-Index-size-tp5910738.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general