[HACKERS] Query Planning time increased 3 times on 7.1 compared to 7.0.3

Hello, We noticed that after upgrading to 7.1beta[245] the execution time for some often used queries went up by a factor of 2 or more. Considering the early beta state I was not alarmed. But since I noticed that yesterday's snapshot still has the problem, I'd really like to tell you about it. H

[HACKERS] Getting unique ID through SQL

d 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=200

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

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 bu

[HACKERS] How to handle waitingForLock in LockWaitCancel()

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 I

[HACKERS] Access 97 & PostgreSQL ODBC Driver Problems

iveness 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] Re: why the DB file size does not reduce when 'delete'the data in DB?

> 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 t

Re: [HACKERS] Multi-process pgbench?

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 broadcast)-

[HACKERS] Multi-process pgbench?

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. Matthe