Re: Let's make PostgreSQL multi-threaded - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Let's make PostgreSQL multi-threaded
Date
Msg-id ZIOnxKN6L1cRPPO2@tamriel.snowman.net
Whole thread Raw
In response to Re: Let's make PostgreSQL multi-threaded  (Dave Cramer <davecramer@postgres.rocks>)
Responses Re: Let's make PostgreSQL multi-threaded  (Dave Cramer <davecramer@postgres.rocks>)
List pgsql-hackers
Greetings,

* Dave Cramer (davecramer@postgres.rocks) wrote:
> One thing I can think of is upgrading. AFAIK dump and restore is the only
> way to change the on disk format.
> Presuming that eventually we will be forced to change the on disk format it
> would be nice to be able to do so in a manner which does not force long
> down times

There is an ongoing effort moving in this direction.  The $subject isn't
great, but this patch set (which we are currently working on
updating...): https://commitfest.postgresql.org/43/3986/ attempts
changing a lot of currently compile-time block-size pieces to be
run-time which would open up the possibility to have a different page
format for, eg, different tablespaces.  Possibly even different block
sizes.  We'd certainly welcome discussion from others who are
interested.

Thanks,

Stephen

Attachment

pgsql-hackers by date:

Previous
From: Gregory Smith
Date:
Subject: Re: index prefetching
Next
From: Nathan Bossart
Date:
Subject: add non-option reordering to in-tree getopt_long