Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?

2004-06-06 Thread jihuang
May Users forcely assign a table / database / cluster storage in RAM purely ? or a in-directly-way , like making a RAM-Disk-Device and assign this device as a postgreSQL cluster? I think this feature will push a lot High-Performance usage , any suggestion ? jihuang Gaetano Mendola wrote

Re: [HACKERS] ERROR: heapgettup: failed ReadBuffer

2004-05-05 Thread jihuang
90&id=2653 there are some chinese characters mixed, but I just wanna to show that host a dedicate issue/bug tracking system may improve a software project evloution. June-Yen Tom Lane wrote: jihuang <[EMAIL PROTECTED]> writes: I put 36+ rows in a table , and now any select ,

[HACKERS] ERROR: heapgettup: failed ReadBuffer

2004-05-03 Thread jihuang
I put 36+ rows in a table , and now any select , update , analyze ... command fail. the log shows "ERROR: heapgettup: failed ReadBuffer", but any INSERT sql command success. the table schema is row| type | modifiers ---+--

[HACKERS] FYI , Intel CC and PostgreSQL , benchmark by pgsql

2004-01-15 Thread jihuang
Hi, I have a new server and some time to do an interesting simple benchmark. Compile PostgreSQL 7.4.1R by gcc3.2 and Intel CC 8.0 , and use pgbench to evaluate any difference.. Here is the result. -- CPU: Intel(R) Xeon(TM) CPU 3.06GHz (3052.79-MHz 686-class CPU) Origin = "Ge