Re: [SQL] A long-running transaction

2007-04-10 Thread John Summerfield
Andrew Sullivan wrote: On Wed, Apr 11, 2007 at 12:41:23AM +0800, John Summerfield wrote: The Linux kernel's clearly doing a lot of work, and the disk supports You might also be into context-switch hell. What processor, which kernel, and which Postgres version again? on opensuse 10.2 (the la

Re: [SQL] A long-running transaction

2007-04-10 Thread Andrew Sullivan
On Wed, Apr 11, 2007 at 12:41:23AM +0800, John Summerfield wrote: > The Linux kernel's clearly doing a lot of work, and the disk supports You might also be into context-switch hell. What processor, which kernel, and which Postgres version again? > >>For each record, I update a non-key field in

Re: [SQL] A long-running transaction

2007-04-10 Thread John Summerfield
Andrew Sullivan wrote: On Tue, Apr 03, 2007 at 10:16:13PM +0800, John Summerfield wrote: It is hitting the disk pretty hard now on this machine, but the laptop's still going too, and the disk seems to run about half the time, part of a second running, part idle (but the intervals are getting sh

Re: [SQL] Question about undefinably query...

2007-04-10 Thread Tom Lane
"A. Kretschmer" <[EMAIL PROTECTED]> writes: > there was a question on #postgresql (irc-channel) from CyberDuck without > an answer. A little example: Multiple SRFs in a targetlist behave, um, strangely. I think the rule is that all are cycled until they all chance to report "done" at the same tim

[SQL] EXECUTE in a funtion to return a VIEW object ID

2007-04-10 Thread Wilkinson, Jim
Hi there, I have tried many ideas to get this working but no luck. Can some show me or explain what is happening EXAMPLE == I am trying to read to 2 text fields to combine them togther to form the name of a VIEW. example SELECT * FROM ( 'april'||'may') ; I have tried the EXECUTE i

[SQL] Question about undefinably query...

2007-04-10 Thread A. Kretschmer
Hi all, there was a question on #postgresql (irc-channel) from CyberDuck without an answer. A little example: test=*# select generate_series(1,5), generate_series(6,10) order by 1; generate_series | generate_series -+- 1 | 6