| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andreas Karlsson <andreas(at)proxel(dot)se>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: Cutting initdb's runtime (Perl question embedded) |
| Date: | 2017-04-13 16:41:32 |
| Message-ID: | 20170413164132.3nhobp4z4wnnvhca@alap3.anarazel.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2017-04-13 12:13:30 -0400, Tom Lane wrote:
> Andreas Karlsson <andreas(at)proxel(dot)se> writes:
> > Here is my proof of concept patch. It does basically the same thing as
> > Andres's patch except that it handles quoted values a bit better and
> > does not try to support anything other than the regproc type.
>
> > The patch speeds up initdb without fsync from 0.80 seconds to 0.55
> > seconds, which is a nice speedup, while adding a negligible amount of
> > extra work on compilation.
>
> I've pushed this with some mostly-cosmetic adjustments:
Cool. I wonder if we also should remove AtEOXact_CatCache()'s
cross-checks - the resowner replacement has been in place for a while,
and seems robust enough. They're now the biggest user of time.
- Andres
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-04-13 16:53:27 | Re: Re: Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f) |
| Previous Message | Heikki Linnakangas | 2017-04-13 16:37:33 | Re: Letting the client choose the protocol to use during a SASL exchange |