On Tue, Jun 3, 2014 at 01:21:51AM -0700, Peter Geoghegan wrote:
> On Sun, May 4, 2014 at 5:46 AM, Bruce Momjian wrote:
> > Feedback expected and welcomed.
>
> One item currently reads "Improve valgrind error reporting". I
> suggest this be changed to "Add support for Valgrind memcheck memory
>
I propose the attached, miscellaneous edits.
The limit on tuplesort.c internal sort size is a limit on the number of
tuples, not on memory usage. Specifically, the cap increased from 44739242
tuples to 2147483647 tuples. I didn't include those numbers, though.
--
Noah Misch
EnterpriseDB
On Sun, May 4, 2014 at 5:46 AM, Bruce Momjian wrote:
> Feedback expected and welcomed.
One item currently reads "Improve valgrind error reporting". I
suggest this be changed to "Add support for Valgrind memcheck memory
error detector". It was possible to use the tool before, but the lack
of coop
On Fri, May 23, 2014 at 10:11:37AM +0900, Tomonari Katsumata wrote:
> Hi,
>
> I have two comments about 9.4 release notes.
>
> 1. typo
> >Pg_upgrade now uses -U to specify the user name (Bruce Momjian)
>
> It should be pg_upgrade.
>
> 2. undesirable link
> >Allow pg_recvlogical to receive data
Hi,
I have two comments about 9.4 release notes.
1. typo
>Pg_upgrade now uses -U to specify the user name (Bruce Momjian)
It should be pg_upgrade.
2. undesirable link
>Allow pg_recvlogical to receive data logical decoding data (Andres Freund)
The term of "pg_recvlogical" jumps to a page of pg
On Mon, May 19, 2014 at 11:30:48AM -0400, David Johnston wrote:
> On Mon, May 19, 2014 at 10:23 AM, Bruce Momjian wrote:
>
> On Thu, May 15, 2014 at 06:08:47PM -0700, David G Johnston wrote:
> > Some errors and suggestions - my apologizes for the format as I do not
> have
> > a pr
On Mon, May 19, 2014 at 12:36 AM, Bruce Momjian wrote:
> On Thu, May 15, 2014 at 06:08:47PM -0700, David G Johnston wrote:
> > Some errors and suggestions - my apologizes for the format as I do not
> have
> > a proper patching routine setup.
> >
> > Patch Review - Top to Bottom (mostly, I think..
On Mon, May 19, 2014 at 10:23 AM, Bruce Momjian wrote:
> On Thu, May 15, 2014 at 06:08:47PM -0700, David G Johnston wrote:
> > Some errors and suggestions - my apologizes for the format as I do not
> have
> > a proper patching routine setup.
> >
>
> Sorry, let me address some items I skipped on y
On Thu, May 15, 2014 at 06:08:47PM -0700, David G Johnston wrote:
> Some errors and suggestions - my apologizes for the format as I do not have
> a proper patching routine setup.
>
Sorry, let me address some items I skipped on your list:
> IIUC: Logical decoding allows for streaming of statement
On Sun, May 18, 2014 at 04:08:41PM -0400, Andrew Dunstan wrote:
>
> On 05/05/2014 07:26 PM, Andrew Dunstan wrote:
> >
> >On 05/05/2014 07:16 PM, Bruce Momjian wrote:
> >>Current text is:
> >>
> >>Add structured (non-text) data type (JSONB) for storing JSON
> >>data (Oleg
> >>Bartunov, Teod
On Thu, May 15, 2014 at 06:08:47PM -0700, David G Johnston wrote:
> Some errors and suggestions - my apologizes for the format as I do not have
> a proper patching routine setup.
>
> Patch Review - Top to Bottom (mostly, I think...)
I have made your suggested adjustments in the attached applied p
On Fri, May 16, 2014 at 02:10:40AM +0200, Andres Freund wrote:
> I am not really sure how to rewrite the notes for the logical decoding
> stuff into a more appropriate format for the release notes. Currently it
> seems to describe too many details and not enough overview. It's also
> probably too l
On Fri, May 16, 2014 at 02:10:40AM +0200, Andres Freund wrote:
> On 2014-05-04 08:46:07 -0400, Bruce Momjian wrote:
> > I have completed the initial version of the 9.4 release notes. You can
> > view them here:
> >
> > http://www.postgresql.org/docs/devel/static/release-9-4.html
> >
> > I wi
On 05/05/2014 07:26 PM, Andrew Dunstan wrote:
On 05/05/2014 07:16 PM, Bruce Momjian wrote:
Current text is:
Add structured (non-text) data type (JSONB) for storing JSON data
(Oleg
Bartunov, Teodor Sigaev, Alexander Korotkov, Peter Geoghegan, and
Andrew
Dunstan)
This allows
Andres Freund-3 wrote
> On 2014-05-04 08:46:07 -0400, Bruce Momjian wrote:
>> I have completed the initial version of the 9.4 release notes. You can
>> view them here:
>>
>> http://www.postgresql.org/docs/devel/static/release-9-4.html
>>
>> I will be adding additional markup in the next few
On 2014-05-04 08:46:07 -0400, Bruce Momjian wrote:
> I have completed the initial version of the 9.4 release notes. You can
> view them here:
>
> http://www.postgresql.org/docs/devel/static/release-9-4.html
>
> I will be adding additional markup in the next few days.
>
> Feedback expected
On Wed, May 14, 2014 at 05:40:04PM +0100, Dean Rasheed wrote:
> > Agreed. Adjusted attached patch applied. I was never happy with the
> > previous awkward auto-update wording.
> >
>
> Thanks. There's a typo in the new text though --- "cals" should be "calls".
Thanks, fixed.
--
Bruce Momjian
On 14 May 2014 15:07, Bruce Momjian wrote:
> On Wed, May 14, 2014 at 08:33:15AM +0100, Dean Rasheed wrote:
>> On 4 May 2014 13:46, Bruce Momjian wrote:
>> > I have completed the initial version of the 9.4 release notes. You can
>> > view them here:
>> >
>> > http://www.postgresql.org/doc
On Wed, May 14, 2014 at 08:33:15AM +0100, Dean Rasheed wrote:
> On 4 May 2014 13:46, Bruce Momjian wrote:
> > I have completed the initial version of the 9.4 release notes. You can
> > view them here:
> >
> > http://www.postgresql.org/docs/devel/static/release-9-4.html
> >
> > I will be a
On 4 May 2014 13:46, Bruce Momjian wrote:
> I have completed the initial version of the 9.4 release notes. You can
> view them here:
>
> http://www.postgresql.org/docs/devel/static/release-9-4.html
>
> I will be adding additional markup in the next few days.
>
> Feedback expected and welc
On Fri, May 9, 2014 at 04:53:18PM +0200, Andres Freund wrote:
> Hi,
>
> I've attached a fair number of fixes for the current state of the
> release notes. Many of them are fixing factual errors, others are more
> minors.
> I think the whole 'logical decoding' section will need an entire
> rewrite
On Fri, May 9, 2014 at 02:50:05AM +0900, MauMau wrote:
> From: "Bruce Momjian"
> >I have completed the initial version of the 9.4 release notes. You can
> >view them here:
> >
> >http://www.postgresql.org/docs/devel/static/release-9-4.html
> >
> >Feedback expected and welcomed. I expect to be m
On Thu, May 8, 2014 at 10:17:27AM +0900, Tatsuo Ishii wrote:
> > I have completed the initial version of the 9.4 release notes. You can
> > view them here:
> >
> > http://www.postgresql.org/docs/devel/static/release-9-4.html
> >
> > I will be adding additional markup in the next few days.
>
On Tue, May 6, 2014 at 03:53:54PM +0200, Nicolas Barbier wrote:
> 2014-05-05 Bruce Momjian :
>
> > On Mon, May 5, 2014 at 10:40:29AM -0700, Josh Berkus wrote:
> >
> >> * ALTER SYSTEM SET
> >>
> >> Lemme know if you need description text for any of the above.
> >
> > OK, great! Once I have the m
Hi,
I've attached a fair number of fixes for the current state of the
release notes. Many of them are fixing factual errors, others are more
minors.
I think the whole 'logical decoding' section will need an entire
rewrite, but I'll do that separately.
I've added a couple of for things that are c
On Fri, May 9, 2014 at 2:50 AM, MauMau wrote:
> From: "Bruce Momjian"
>>
>> I have completed the initial version of the 9.4 release notes. You can
>> view them here:
>>
>> http://www.postgresql.org/docs/devel/static/release-9-4.html
>>
>> Feedback expected and welcomed. I expect to be modifying
On Thu, May 8, 2014 at 10:50 AM, MauMau wrote:
> Could you add the following item, client-only installation on Windows, if
> it's appropriate for release note?
I think that it is appropriate.
--
Peter Geoghegan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make ch
From: "Bruce Momjian"
I have completed the initial version of the 9.4 release notes. You can
view them here:
http://www.postgresql.org/docs/devel/static/release-9-4.html
Feedback expected and welcomed. I expect to be modifying this until we
release 9.4 final. I have marked items where I nee
> I have completed the initial version of the 9.4 release notes. You can
> view them here:
>
> http://www.postgresql.org/docs/devel/static/release-9-4.html
>
> I will be adding additional markup in the next few days.
>
> Feedback expected and welcomed. I expect to be modifying this until
2014-05-05 Bruce Momjian :
> On Mon, May 5, 2014 at 10:40:29AM -0700, Josh Berkus wrote:
>
>> * ALTER SYSTEM SET
>>
>> Lemme know if you need description text for any of the above.
>
> OK, great! Once I have the markup done, I will beef up the descriptions
> if needed and copy the text up to the
On Mon, May 5, 2014 at 05:22:59PM -0700, Peter Geoghegan wrote:
> On Mon, May 5, 2014 at 5:13 PM, Bruce Momjian wrote:
> > OK, I understand now. I also split the item into two separate ones so I
> > could highlight things. Please see the new ouput --- I ended up
> > creating a pg_stat_statement
On Mon, May 5, 2014 at 5:13 PM, Bruce Momjian wrote:
> OK, I understand now. I also split the item into two separate ones so I
> could highlight things. Please see the new ouput --- I ended up
> creating a pg_stat_statements section because there are now three items:
>
> http://momjian.u
On Mon, May 5, 2014 at 04:20:26PM -0700, Peter Geoghegan wrote:
> On Mon, May 5, 2014 at 4:14 PM, Bruce Momjian wrote:
> > We rarely get into specific numers like this. It says "higher limit(s)" and
> > hopefully that is enough. If you want to create a documentation 'id' I
> > can like to that
On 05/05/2014 07:34 PM, Peter Geoghegan wrote:
On Mon, May 5, 2014 at 4:26 PM, Andrew Dunstan wrote:
After all, everything that's not a number or boolean is typed as text (just
as it is in JSON). We don't, for example, map anything to timestamp types.
JSON doesn't have a timestamp primitive t
On Mon, May 5, 2014 at 4:26 PM, Andrew Dunstan wrote:
> After all, everything that's not a number or boolean is typed as text (just
> as it is in JSON). We don't, for example, map anything to timestamp types.
JSON doesn't have a timestamp primitive type. Of those types that it
has, their internal
On 05/05/2014 07:16 PM, Bruce Momjian wrote:
On Mon, May 5, 2014 at 10:58:57AM -0700, Peter Geoghegan wrote:
On Mon, May 5, 2014 at 8:28 AM, Andrew Dunstan wrote:
How about:
This data type allows for faster access to values in the json document
and faster and more useful indexing of jso
On Mon, May 5, 2014 at 4:16 PM, Bruce Momjian wrote:
> This allows for faster access to values in the JSON document and
> faster
> and more useful indexing of JSON. JSONB values are also typed as
> appropriate scalar SQL types.
>
> Is that OK?
That seems reasonable.
--
On Mon, May 5, 2014 at 4:14 PM, Bruce Momjian wrote:
> We rarely get into specific numers like this. It says "higher limit(s)" and
> hopefully that is enough. If you want to create a documentation 'id' I
> can like to that for the "higher limits" text.
You don't have to mention a number. Just t
On Mon, May 5, 2014 at 10:58:57AM -0700, Peter Geoghegan wrote:
> On Mon, May 5, 2014 at 8:28 AM, Andrew Dunstan wrote:
> > How about:
> >
> >This data type allows for faster access to values in the json document
> > and faster and more useful indexing of json.
>
> We should refer to the fac
On Mon, May 5, 2014 at 02:23:13PM -0700, Peter Geoghegan wrote:
> On Sun, May 4, 2014 at 6:49 AM, Andres Freund wrote:
> > +
> > +
> > +Have pg_stat_statements use a flat file for query text storage,
> > allowing higher limits (Peter Geoghegan)
> > +
> > +
> > +
On Sun, May 4, 2014 at 6:49 AM, Andres Freund wrote:
> +
> +
> +Have pg_stat_statements use a flat file for query text storage,
> allowing higher limits (Peter Geoghegan)
> +
> +
> +
> +Also add the ability to retrieve all pg_stat_statements information
On Mon, May 5, 2014 at 10:40:29AM -0700, Josh Berkus wrote:
> Major enhancement list:
>
> Per discussion on the -advocacy list, the features we've picked out as
> "major enhancements" for advocacy reasons this round are:
>
> * Materialized Views (because with refresh concurrently, MatViews are
>
On 05/05/2014 02:33 PM, Josh Berkus wrote:
On 05/05/2014 11:31 AM, Bruce Momjian wrote:
JSONB values are also mapped to SQL scalar data types, rather
than being treated always as strings.
+ ... allowing for correct sorting of JSON according to internal datums.
The problem is that a
On Mon, May 5, 2014 at 1:13 PM, Andrew Dunstan wrote:
> The fact that jsonb maps scalar values to internal postgres types is an
> implementation artefact.
I wouldn't go that far, but I take your point. The fact that the
primitive/scalar JSON types are in a very real sense strongly typed is
a very
On Mon, May 5, 2014 at 11:31 AM, Bruce Momjian wrote:
> JSONB values are also mapped to SQL scalar data types, rather
> than being treated always as strings.
Something like that. Perhaps you should just go with what the
documentation says: "Primitive JSON types described by RFC 7159 are
e
On 05/05/2014 11:31 AM, Bruce Momjian wrote:
> JSONB values are also mapped to SQL scalar data types, rather
> than being treated always as strings.
+ ... allowing for correct sorting of JSON according to internal datums.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Se
On Mon, May 5, 2014 at 10:58:57AM -0700, Peter Geoghegan wrote:
> On Mon, May 5, 2014 at 8:28 AM, Andrew Dunstan wrote:
> > How about:
> >
> >This data type allows for faster access to values in the json document
> > and faster and more useful indexing of json.
>
> We should refer to the fac
On Mon, May 5, 2014 at 8:28 AM, Andrew Dunstan wrote:
> How about:
>
>This data type allows for faster access to values in the json document
> and faster and more useful indexing of json.
We should refer to the fact that jsonb is internally typed. This isn't
all that obvious now, but it is ev
On Mon, May 5, 2014 at 10:40:29AM -0700, Josh Berkus wrote:
> On 05/04/2014 05:46 AM, Bruce Momjian wrote:
> > I have completed the initial version of the 9.4 release notes. You can
> > view them here:
> >
> > http://www.postgresql.org/docs/devel/static/release-9-4.html
> >
> > I will be ad
On 05/04/2014 05:46 AM, Bruce Momjian wrote:
> I have completed the initial version of the 9.4 release notes. You can
> view them here:
>
> http://www.postgresql.org/docs/devel/static/release-9-4.html
>
> I will be adding additional markup in the next few days.
>
> Feedback expected and w
On Mon, May 5, 2014 at 11:28:21AM -0400, Andrew Dunstan wrote:
> No, I think you're missing the point of what I'm saying, and I think
> the addition is at best misleading. I would avoid talk of key value
> pairs, anyway, that's not all that's in a json document (it might be
> an array, for example
On 05/05/2014 09:38 AM, Bruce Momjian wrote:
On Sun, May 4, 2014 at 10:24:54AM -0400, Andrew Dunstan wrote:
On 05/04/2014 10:12 AM, Petr Jelinek wrote:
On 04/05/14 14:46, Bruce Momjian wrote:
I have completed the initial version of the 9.4 release notes. You can
view them here:
http://
On Mon, May 5, 2014 at 10:18:44AM -0400, Alvaro Herrera wrote:
> Bruce Momjian wrote:
> > On Sun, May 4, 2014 at 03:49:27PM +0200, Andres Freund wrote:
>
> > > +
> > > +
> > > +Add huge_pages configuration parameter to attempt to use huge
> > > translation look-aside buffer
Bruce Momjian wrote:
> On Sun, May 4, 2014 at 03:49:27PM +0200, Andres Freund wrote:
> > +
> > +
> > +Add huge_pages configuration parameter to attempt to use huge
> > translation look-aside buffer (TLB) pages on Linux (Christian Kruse,
> > +Richard Poole, Abhijit Me
On Sun, May 4, 2014 at 08:46:07AM -0400, Bruce Momjian wrote:
> I have completed the initial version of the 9.4 release notes. You can
> view them here:
>
> http://www.postgresql.org/docs/devel/static/release-9-4.html
>
> I will be adding additional markup in the next few days.
>
> Feedb
On Mon, May 5, 2014 at 09:23:15AM +0300, Heikki Linnakangas wrote:
> On 05/04/2014 03:46 PM, Bruce Momjian wrote:
> >Auto-resize the catalog cache (Heikki Linnakangas)
> >
> >This reduces memory consumption for backends accessing only a few
> >tables, and improves performance for backend accessing
On Mon, May 5, 2014 at 09:10:11AM +0300, Heikki Linnakangas wrote:
> On 05/04/2014 03:46 PM, Bruce Momjian wrote:
> >I have completed the initial version of the 9.4 release notes.
>
> Thanks!
>
> >You can view them here:
> >
> > http://www.postgresql.org/docs/devel/static/release-9-4.html
>
On Sun, May 4, 2014 at 10:24:54AM -0400, Andrew Dunstan wrote:
>
> On 05/04/2014 10:12 AM, Petr Jelinek wrote:
> >On 04/05/14 14:46, Bruce Momjian wrote:
> >>I have completed the initial version of the 9.4 release notes. You can
> >>view them here:
> >>
> >>http://www.postgresql.org/docs/dev
On Sun, May 4, 2014 at 06:06:52PM +0400, Oleg Bartunov wrote:
> Bruce,
>
> you forgot Alexander Korotkov, who contributed jsonb_hash_ops opclass
> for GIN. Something like
> "Alexander Korotkov introduced an elegant jsonb_hash ops for GIN,
> which competes with MongoDB performance in contains ope
On Sun, May 4, 2014 at 03:49:27PM +0200, Andres Freund wrote:
> Hi,
>
> On 2014-05-04 08:46:07 -0400, Bruce Momjian wrote:
> > Feedback expected and welcomed. I expect to be modifying this until we
> > release 9.4 final. I have marked items where I need help with question
> > marks.
>
> Thanks
On 05/04/2014 03:46 PM, Bruce Momjian wrote:
Auto-resize the catalog cache (Heikki Linnakangas)
This reduces memory consumption for backends accessing only a few
tables, and improves performance for backend accessing many tables.
Move this to "General performance" section.
Improve spinlock s
On 05/04/2014 03:46 PM, Bruce Momjian wrote:
I have completed the initial version of the 9.4 release notes.
Thanks!
You can view them here:
http://www.postgresql.org/docs/devel/static/release-9-4.html
I will be adding additional markup in the next few days.
Feedback expected and we
I agree, no mongo :)
On Sun, May 4, 2014 at 8:47 PM, Magnus Hagander wrote:
>
> On Sun, May 4, 2014 at 4:06 PM, Oleg Bartunov wrote:
>>
>> Bruce,
>>
>> you forgot Alexander Korotkov, who contributed jsonb_hash_ops opclass
>> for GIN. Something like
>> "Alexander Korotkov introduced an elegant j
On Sun, May 4, 2014 at 4:06 PM, Oleg Bartunov wrote:
> Bruce,
>
> you forgot Alexander Korotkov, who contributed jsonb_hash_ops opclass
> for GIN. Something like
> "Alexander Korotkov introduced an elegant jsonb_hash ops for GIN,
> which competes with MongoDB performance in contains operator".
>
On 05/04/2014 10:12 AM, Petr Jelinek wrote:
On 04/05/14 14:46, Bruce Momjian wrote:
I have completed the initial version of the 9.4 release notes. You can
view them here:
http://www.postgresql.org/docs/devel/static/release-9-4.html
I will be adding additional markup in the next few days.
On 04/05/14 14:46, Bruce Momjian wrote:
I have completed the initial version of the 9.4 release notes. You can
view them here:
http://www.postgresql.org/docs/devel/static/release-9-4.html
I will be adding additional markup in the next few days.
Feedback expected and welcomed. I expec
Bruce,
you forgot Alexander Korotkov, who contributed jsonb_hash_ops opclass
for GIN. Something like
"Alexander Korotkov introduced an elegant jsonb_hash ops for GIN,
which competes with MongoDB performance in contains operator".
Here is a link to discussion -
http://www.postgresql.org/message-i
Hi,
On 2014-05-04 08:46:07 -0400, Bruce Momjian wrote:
> Feedback expected and welcomed. I expect to be modifying this until we
> release 9.4 final. I have marked items where I need help with question
> marks.
Thanks for doing that work. Some comments inline:
+
+
+ Remove system
I have completed the initial version of the 9.4 release notes. You can
view them here:
http://www.postgresql.org/docs/devel/static/release-9-4.html
I will be adding additional markup in the next few days.
Feedback expected and welcomed. I expect to be modifying this until we
release 9.
69 matches
Mail list logo
