[GENERAL] PQexecFinish blocked forever in localhost also

2016-09-20 Thread sangeetha
Hi, PQexecFinish blocked in pqsocketpoll. As per blogs, it will not happen in localhost. We are using Postgres9.4 and server is running locally. Still it blocks in PQExecFinish. Since our application is multithreaded, We are using semaphore for each DB connection. please guide how to proceed. T

[GENERAL] estimate Index size

2016-07-06 Thread sangeetha
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 r

[GENERAL] Alternate or Optimization for with hold cursor

2016-05-12 Thread sangeetha
Currently , I am using "With hold" cursor. In our case , the With hold cursor is used to fetch the next record of the given primary key . The performance is very slow for large data set. Can you provide me some alternative ways like having own copy of table , or optimization for With hold cursor?

[GENERAL] reg:bitmap index

2007-04-25 Thread sangeetha k.s
hello, Thanks for your reply. will that be possible for me to get the simple bitmapindex implementation code now. i went through the ondiskimplementation code i cant understand that properply. i want a simplified implementation of that.could you kindly help me out. Sangeetha.K.S.

[GENERAL] reg: bitmap index implementation

2007-04-25 Thread sangeetha k.s
hello sir, does postgre sql support bitmap indexing for indexing the datatables. will that be possible to get the source of that. Sangeetha.K.S

[GENERAL] what compression is used in on disk bitmap index implementation

2007-02-21 Thread sangeetha k.s
i want to know 1.what compression technique used in on disk implementation of bitmap index. 2.if we want add a new thing to the development how we can test that with the database

[GENERAL] doubts

2007-01-08 Thread sangeetha k.s
hello, postgresql uses bitmap indexing for indexing in databases. *Is there any technique used* * used to compress the bitmap indices in postgresql*,like oracle that uses Byte Aligned bitmap compression to compress bitmaps. regards, sangeetha.