Обсуждение: Speed or Performance
We have a VB/ADO application, which talks via PostgreSQL/ODBC to our Linux Server. (RedHat 7.2, PostgreSQL 7.1, PostgreSQL ODBC 7.1.9) I have found PostgreSQL to be great for enquiry on our ~350Mb database. Read speed is very good. We have Primary key and some secondary indexes. However, I have a speed issue with writing back. Are there any speed tweaks regarding buffering or configuration that I should check? Does PostgreSQL rewrite indexes every write? -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au
Keith Gray wrote: > > We have a VB/ADO application, which talks > via PostgreSQL/ODBC to our Linux Server. > > (RedHat 7.2, PostgreSQL 7.1, PostgreSQL ODBC 7.1.9) > > I have found PostgreSQL to be great for enquiry > on our ~350Mb database. Read speed is very good. > > We have Primary key and some secondary indexes. > > However, I have a speed issue with writing back. How are you writing back for example ? > Are there any speed tweaks regarding buffering > or configuration that I should check? > > Does PostgreSQL rewrite indexes every write? Yes though slightly different. PostgreSQL writes indexes every write. regards, Hiroshi Inoue http://w2422.nsk.ne.jp/~inoue/