public inbox for [email protected]
help / color / mirror / Atom feedUpdated documentation for new sequence binding
6+ messages / 3 participants
[nested] [flat]
* Updated documentation for new sequence binding
@ 2005-10-03 02:45 Bruce Momjian <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2005-10-03 02:45 UTC (permalink / raw)
To: PostgreSQL-development <[email protected]>; pgsql-docs
I have marged Tom's description of the new sequence binding with text I
was working on. I modified it to follow the existing "we used to do X,
now we do Y" pattern in the surrounding entries:
http://candle.pha.pa.us/tmp/pgsql/release.html#RELEASE-8-1
I also added an SQL query that will show and update a pre-8.1 loaded
schema to the new oid-based sequence storage use.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Updated documentation for new sequence binding
@ 2005-10-03 02:54 Bruce Momjian <[email protected]>
2005-10-03 06:23 ` Re: [HACKERS] Updated documentation for new sequence binding Michael Paesold <[email protected]>
2005-10-05 18:58 ` Re: Updated documentation for new sequence binding Jim C. Nasby <[email protected]>
0 siblings, 2 replies; 6+ messages in thread
From: Bruce Momjian @ 2005-10-03 02:54 UTC (permalink / raw)
To: PostgreSQL-development <[email protected]>; pgsql-docs
pgman wrote:
> I have marged Tom's description of the new sequence binding with text I
> was working on. I modified it to follow the existing "we used to do X,
> now we do Y" pattern in the surrounding entries:
>
> http://candle.pha.pa.us/tmp/pgsql/release.html#RELEASE-8-1
Sorry, this is a better URL:
http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [HACKERS] Updated documentation for new sequence binding
2005-10-03 02:54 Re: Updated documentation for new sequence binding Bruce Momjian <[email protected]>
@ 2005-10-03 06:23 ` Michael Paesold <[email protected]>
2005-10-03 13:52 ` Re: [HACKERS] Updated documentation for new sequence binding Bruce Momjian <[email protected]>
1 sibling, 1 reply; 6+ messages in thread
From: Michael Paesold @ 2005-10-03 06:23 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; PostgreSQL-development <[email protected]>; pgsql-docs
Bruce Momjian wrote:
> pgman wrote:
>> I have marged Tom's description of the new sequence binding with text I
>> was working on. I modified it to follow the existing "we used to do X,
>> now we do Y" pattern in the surrounding entries:
>>
>> http://candle.pha.pa.us/tmp/pgsql/release.html#RELEASE-8-1
>
> Sorry, this is a better URL:
>
> http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
Btw. I think the header "Add proper sequence function dependencies for
DEFAULT" is in the wrong font, i.e. it's all monospace.
Best Regards
Michael Paesold
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [HACKERS] Updated documentation for new sequence binding
2005-10-03 02:54 Re: Updated documentation for new sequence binding Bruce Momjian <[email protected]>
2005-10-03 06:23 ` Re: [HACKERS] Updated documentation for new sequence binding Michael Paesold <[email protected]>
@ 2005-10-03 13:52 ` Bruce Momjian <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2005-10-03 13:52 UTC (permalink / raw)
To: Michael Paesold <[email protected]>; +Cc: PostgreSQL-development <[email protected]>; pgsql-docs
Thanks, fixed.
---------------------------------------------------------------------------
Michael Paesold wrote:
> Bruce Momjian wrote:
>
> > pgman wrote:
> >> I have marged Tom's description of the new sequence binding with text I
> >> was working on. I modified it to follow the existing "we used to do X,
> >> now we do Y" pattern in the surrounding entries:
> >>
> >> http://candle.pha.pa.us/tmp/pgsql/release.html#RELEASE-8-1
> >
> > Sorry, this is a better URL:
> >
> > http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
>
> Btw. I think the header "Add proper sequence function dependencies for
> DEFAULT" is in the wrong font, i.e. it's all monospace.
>
> Best Regards
> Michael Paesold
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Updated documentation for new sequence binding
2005-10-03 02:54 Re: Updated documentation for new sequence binding Bruce Momjian <[email protected]>
@ 2005-10-05 18:58 ` Jim C. Nasby <[email protected]>
2005-10-05 19:52 ` Re: Updated documentation for new sequence binding Bruce Momjian <[email protected]>
1 sibling, 1 reply; 6+ messages in thread
From: Jim C. Nasby @ 2005-10-05 18:58 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: PostgreSQL-development <[email protected]>; pgsql-docs
On Sun, Oct 02, 2005 at 10:54:10PM -0400, Bruce Momjian wrote:
> pgman wrote:
> > I have marged Tom's description of the new sequence binding with text I
> > was working on. I modified it to follow the existing "we used to do X,
> > now we do Y" pattern in the surrounding entries:
> >
> > http://candle.pha.pa.us/tmp/pgsql/release.html#RELEASE-8-1
>
> Sorry, this is a better URL:
>
> http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
Out of curiosity, how is this file maintained as development is done?
The reason I'm asking is because it would be nice to have links to more
information, especially for the 'one-liner' items in 1.3.1 for example,
and it seems like that would be easier to do along-the-way rather than
waiting for the end. Even a link to a mailing list discussion would be
better than nothing...
That said, what's
Improve the optimizer, including auto-resizing of hash joins (Tom)
mean?
On full_page_writes, are we certain that all battery-backed disk caches
ensure that partial-page writes can't happen?
Maybe pg_column_size should just be included in the item for all the
other size functions brought into the backend? If not, ISTM they should
at least be one after the other in the list...
Finally, weren't more changes made it contrib than what's listed?
Nothing's said about pg_autovacuum for example.
--
Jim C. Nasby, Sr. Engineering Consultant [email protected]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Updated documentation for new sequence binding
2005-10-03 02:54 Re: Updated documentation for new sequence binding Bruce Momjian <[email protected]>
2005-10-05 18:58 ` Re: Updated documentation for new sequence binding Jim C. Nasby <[email protected]>
@ 2005-10-05 19:52 ` Bruce Momjian <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2005-10-05 19:52 UTC (permalink / raw)
To: Jim C. Nasby <[email protected]>; +Cc: PostgreSQL-development <[email protected]>; pgsql-docs
Jim C. Nasby wrote:
> On Sun, Oct 02, 2005 at 10:54:10PM -0400, Bruce Momjian wrote:
> > pgman wrote:
> > > I have marged Tom's description of the new sequence binding with text I
> > > was working on. I modified it to follow the existing "we used to do X,
> > > now we do Y" pattern in the surrounding entries:
> > >
> > > http://candle.pha.pa.us/tmp/pgsql/release.html#RELEASE-8-1
> >
> > Sorry, this is a better URL:
> >
> > http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
>
> Out of curiosity, how is this file maintained as development is done?
> The reason I'm asking is because it would be nice to have links to more
> information, especially for the 'one-liner' items in 1.3.1 for example,
> and it seems like that would be easier to do along-the-way rather than
> waiting for the end. Even a link to a mailing list discussion would be
> better than nothing...
I go through the CVS commits and make the release notes just before
beta. During it incrementally is much more work.
> That said, what's
>
> Improve the optimizer, including auto-resizing of hash joins (Tom)
>
> mean?
We would sometimes fail in a query where the allocated memory was larger
than our hash could hold. This fixed that.
>
> On full_page_writes, are we certain that all battery-backed disk caches
> ensure that partial-page writes can't happen?
Well, I would think so, but I have no documentation to state that. The
battery-backed memory is supposed to allow for power failure and keep
writes in the cache until they hit the disk.
> Maybe pg_column_siz should just be included in the item for all the
> other size functions brought into the backend? If not, ISTM they should
> at least be one after the other in the list...
Not really. It is different in that is does not aggregate values, but
just the storage of a column.
> Finally, weren't more changes made it contrib than what's listed?
> Nothing's said about pg_autovacuum for example.
Moved to the main server. That is mentioned.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2005-10-05 19:52 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-03 02:45 Updated documentation for new sequence binding Bruce Momjian <[email protected]>
2005-10-03 02:54 Re: Updated documentation for new sequence binding Bruce Momjian <[email protected]>
2005-10-03 06:23 ` Michael Paesold <[email protected]>
2005-10-03 13:52 ` Bruce Momjian <[email protected]>
2005-10-05 18:58 ` Jim C. Nasby <[email protected]>
2005-10-05 19:52 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox