| From: | sangeetha <tune2sangee(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | estimate Index size |
| Date: | 2016-07-06 07:35:02 |
| Message-ID: | 1467790502200-5910738.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Castelli | 2016-07-06 07:43:03 | Re: Avoid deadlocks on alter table |
| Previous Message | Paul A Jungwirth | 2016-07-06 05:40:02 | Re: Possible to create canonicalized range type without being superuser? |