Re: [HACKERS] Batch API for After Triggers

2013-06-11 Thread Simon Riggs
On 10 June 2013 22:50, Robert Haas wrote: > On Sat, Jun 8, 2013 at 5:00 PM, Simon Riggs wrote: >> While fiddling with FK tuning, Noah suggested batching trigger >> executions together to avoid execution overhead. >> >> It turns out there is no easy way to write triggers that can take >> advantage

Re: [HACKERS] DO ... RETURNING

2013-06-11 Thread David Fetter
On Tue, Jun 11, 2013 at 09:30:32AM +0200, Pavel Stehule wrote: > Hello > > > > The current situation is akin to not being able to use queries > > directly but always requiring you to create a view first and > > then do "select ... from myview" > > > > ok > > probably we can allow using DO in CTE

Re: [HACKERS] DO ... RETURNING

2013-06-11 Thread Pavel Stehule
Hello > > The current situation is akin to not being able to use queries > directly but always requiring you to create a view first and > then do "select ... from myview" > ok probably we can allow using DO in CTE without impact on other SQL statements, and for this purpose we need to know return

Re: [HACKERS] Parallell Optimizer

2013-06-11 Thread Hannu Krosing
On 06/10/2013 10:37 PM, Fred&Dani&Pandora&Aquiles wrote: > Hi, > > > >> I asked a while ago in this group about the possibility to > implement a > >> parallel planner in a multithread way, and the replies were > that the > >> proposed approach couldn't be implemented, because

Re: [HACKERS] how to find out whether a view is updatable

2013-06-11 Thread Dean Rasheed
On 11 June 2013 01:03, Michael Paquier wrote: > Sorry for my late reply. > > On Sun, Jun 9, 2013 at 6:45 PM, Dean Rasheed > wrote: >> >> I called it updatable rather than "writable" or "read-only" because it >> might perhaps be extended in the future with separate options for >> "insertable" and

<    1   2