[HACKERS] Multi-process pgbench?

2001-03-04 Thread Matthew Kirkwood
Hi, Did I read allegations here a while ago that someone had a multi-process version of pgbench? I've poked around the website and mail archives, but couldn't find it. I have access to a couple of 4-CPU boxes, and reckon that a single-process benching tool could well prove a bottleneck.

Re: [HACKERS] Multi-process pgbench?

2001-03-04 Thread Tom Lane
Matthew Kirkwood [EMAIL PROTECTED] writes: I have access to a couple of 4-CPU boxes, and reckon that a single-process benching tool could well prove a bottleneck. It's not, as far as I can tell. regards, tom lane ---(end of

[HACKERS] Re: why the DB file size does not reduce when 'delete'the data in DB?

2001-03-04 Thread Mitch Vincent
I know your situations, your DB is not updated and inserted lots of records in few minutes, mine is difference, I have a real time Stock Trading system, you know, stock, its price is changed every minute or even every second , I need update and insert delta change into DB, draw their

[HACKERS] Access 97 PostgreSQL ODBC Driver Problems

2001-03-04 Thread Patrick Dunford
ss of your sins. And you will receive the gift of the Holy Spirit. The promise is for you and your children and for all who are far off—for all whom the Lord our God will call.” -- Acts 2:38 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010304 ==

[HACKERS] How to handle waitingForLock in LockWaitCancel()

2001-03-04 Thread Hiroshi Inoue
Hi, I sometimes encountered SEGV errors in my test case when I canceled the execution. Probably it's due to the almost simultaneous arrival of multiple signals and the following patch seems to fix the bug. However I'm afraid that the change should cause another bug. Comments ? Regards, Hiroshi

Re: [HACKERS] How to handle waitingForLock in LockWaitCancel()

2001-03-04 Thread Tom Lane
Hiroshi Inoue [EMAIL PROTECTED] writes: I sometimes encountered SEGV errors in my test case when I canceled the execution. Can you provide backtraces from these SEGVs? Probably it's due to the almost simultaneous arrival of multiple signals and the following patch seems to fix the bug.

[HACKERS] Getting unique ID through SQL

2001-03-04 Thread Patrick Dunford
will receive the gift of the Holy Spirit. The promise is for you and your children and for all who are far off—for all whom the Lord our God will call.” -- Acts 2:38 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010304