[HACKERS] proposal: custom autovacuum entries

of the autovacuum sequence. Alternatively I would suggest some mechanism for scheduling within PostgreSQL Thanks, Jordan Deitch

Re: [HACKERS] Change in "policy" on dump ordering?

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

Re: [HACKERS] json_agg produces nonstandard json

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

[HACKERS] json_agg produces nonstandard json

ut. Would postgres welcome a patch to handle the empty case of json(b)_agg? Thanks! --- Jordan Deitch

[HACKERS] jsonb problematic operators

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

Re: [HACKERS] COMMIT NOWAIT Performance Option

, 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 online user support in the PostgreSQL

Re: [HACKERS] [PERFORM] Hints proposal

-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 On Thu, 2006-10-12 at 18:02 -0400

Re: [HACKERS] [PERFORM] Hints proposal

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 up

Re: [HACKERS] [PERFORM] Hints proposal

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

Re: [HACKERS] Two-phase commit issues

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 writes: I am

Re: [HACKERS] What can we learn from MySQL?

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: Ease of use is VERY important

Re: [HACKERS] Proposal for a cascaded master-slave replication system

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!! Jordan

Re: [HACKERS] O_DIRECT in freebsd

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 requires considerable tuning

Re: [HACKERS] O_DIRECT in freebsd

to be 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

Re: [HACKERS] 2-phase commit

transactions on crash. Jordan Henderson ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] request for sql3 compliance for the update command

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 [EMAIL PROTECTED] Sent: Wednesday, February 19, 2003 10:18 PM Subject: Re: [HACKERS] request