autovacuum sequence.
Alternatively I would suggest some mechanism for scheduling within
PostgreSQL
Thanks,
Jordan Deitch
But why should a superuser need the ACL to be applied before being allowed
access? If you make the permission-checking function check if the user is a
superuser before looking for per-user grants, wouldn't that solve the issue?
On 26 July 2017 at 16:30, Tom Lane wrote:
> Robert Haas writes:
> >
e sum() and json_agg().
So the select jsonb_agg((select 1 where false)); would return null as
opposed to [null]. In this case it would be compatible with coalesce()
---
Thanks
Jordan Deitch
riate output.
Would postgres welcome a patch to handle the empty case of json(b)_agg?
Thanks!
---
Jordan Deitch
There is this problem with the jsonb operators "? text" "?| text[]"
and "?& text[]" that the question mark is typically used for prepared
statement parameters in the most used abstraction APIs in Java and
PHP.
This really needs an alternative. Something like "HAS text", "HAS
ANY(text[])" and "HAS
ating
the one search query where materialized views would be useful, because it's
heavy.
2015-05-27 13:42 GMT+03:00 Marko Tiikkaja :
> On 5/27/15 12:39 PM, Jordan Gigov wrote:
>
>> I found myself in need of triggers that are run only once per transaction,
>> rather than per
I found myself in need of triggers that are run only once per transaction,
rather than per row or statement within the transaction. Meaning it will
always be deferred and never called twice for the same transaction.
Perhaps in 9.6 this part of syntax for trigger creation can be changed from:
[ FO
, not an engine perspective. Perhaps some network traffic could
be pruned, not sending the response.
Jordan Henderson
On Tuesday 27 February 2007, Joshua D. Drake wrote:
> Josh Berkus wrote:
> > Simon,
> >
> > One of the things I love about doing informal onlin
> I completely agree that it's much better *in the long run* to improve
> the planner and the statistics system so that we don't need hints. But
> there's been no plan put forward for how to do that, which means we
also
> have no idea when some of these problems will be resolved. If someone
> comes
> -Original Message-
> From: Jeff Davis [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 13, 2006 1:00 PM
> To: Alvaro Herrera
> Cc: Bucky Jordan; josh@agliodbs.com; Jim C. Nasby; pgsql-
> [EMAIL PROTECTED]
> Subject: Re: [HACKERS] [PERFORM] Hints proposal
>
&g
> > Well, one nice thing about the per-query method is you can post
before
> > and after EXPLAIN ANALYZE along with the hints.
>
> One bad thing is that application designers will tend to use the hint,
fix
> the immediate issue, and never report a problem at all. And query
hints
> would not be co
Exactly. A 2PC expects every participant that makes it to the prepare to commit phase to survive a server restart, controller or otherwise. Anything less is not 2PC.
Jordan Henderson
On Fri, 2005-05-20 at 12:07 -0400, Tom Lane wrote:
Bruce Momjian <pgman@candle.pha.pa.us> write
ll of
the difference. We need to remember who the audience
is. We cannot gain mass market share otherwise.
My 2 cents, won't buy coffee,
Jordan Henderson
--- Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Fri, Apr 23, 2004 at 16:36:57 -0400,
> [EMAIL PROTECTED] wrote:
> &
Jan,
I am wondering if you are familar with the work covered in 'Recovery in
Parallel Database Systems' by Svein-Olaf Hvasshovd (Vieweg) ? The book is an
excellent detailed description covering high availablility DB
implementations.
I think your right on by not thinking smaller
forced into
using a product in a specific manner. Instead, I would let them decide
whether to choose a simple setup or, if they are up to it, something with
better performance. I would not prune the options out. In doing so, we
limit what a knowledgeable person can do a priori.
Jordan Henderson
ative overhead.
Jordan Henderson
On Thursday 30 October 2003 12:55, Sailesh Krishnamurthy wrote:
> DB2 supports cooked and raw file systems - SMS (System Manged Space)
> and DMS (Database Managed Space) tablespaces.
>
> The DB2 experience is that DMS tends to outperform SMS but requir
dard transaction
> implementation) aborts all transactions on crash.
Jordan Henderson
---(end of broadcast)---
TIP 8: explain analyze is your friend
and reasonable.
Jordan
- Original Message -
From: "Dave Cramer" <[EMAIL PROTECTED]>
To: "Justin Clift" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>; "Peter Eisentraut" <[EMAIL PROTECTED]>;
"Pgsql Hackers&quo
18 matches
Mail list logo
