| From: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, "Jamison, Kirk" <k(dot)jamison(at)jp(dot)fujitsu(dot)com>, "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, "Ideriha, Takeshi" <ideriha(dot)takeshi(at)jp(dot)fujitsu(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Cache relation sizes? |
| Date: | 2020-02-14 00:50:27 |
| Message-ID: | CA+hUKG+jhY4zi93VLZjXQ0fb_e1K9Oe8ZuLsfHEqWn52euZB7g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Feb 13, 2020 at 7:18 PM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
> ... (1) I'm pretty sure some systems would not be happy
> about that (see claims in this thread) ...
I poked a couple of people off-list and learned that, although the
Linux and FreeBSD systems I tried could do a million lseek(SEEK_END)
calls in 60-100ms, a couple of different Windows systems took between
1.1 and 3.4 seconds (worse times when running as non-administrator),
which seems to be clearly in the territory that can put a dent in your
recovery speeds on that OS. I also learned that GetFileSizeEx() is
"only" about twice as fast, which is useful information for that other
thread about which syscall to use for this, but it's kind of
irrelevant this thread about how we can get rid of these crazy
syscalls altogether.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2020-02-14 01:26:38 | Re: Marking some contrib modules as trusted extensions |
| Previous Message | Tom Lane | 2020-02-14 00:09:18 | Re: Marking some contrib modules as trusted extensions |