Re: adding new pages bulky way

From: "Victor Y(dot) Yegorov" <viy(at)mits(dot)lv>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Postgres Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: adding new pages bulky way
Date: 2005-06-07 16:52:57
Message-ID: 20050607165257.GA9424@mits.lv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [07.06.2005 07:59]:
> Why bother? Just write each page when you need to --- there's no law
> that says you must use P_NEW.

This means 2 things:
1) I cannot mix P_NEW and exact-number ReadBuffer() calls;
2) thus, I have to track next-block-number myself.

Is it so?

BTW, are there any differences in buffer seeking speed, if buffer
block-numbers are mixed and if they're not (i.e. P_NEW is used)?

--

Victor Y. Yegorov

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tim Vadnais 2005-06-07 16:58:18 Issue with adding ORDER BY to EXCEPT.
Previous Message Tom Lane 2005-06-07 16:42:03 Re: CPU-intensive autovacuuming