DB->set_pagesize()
Prev | Chapter 2. The DB Handle | Next

## DB->set_pagesize()

    #include <db.h>

    int
    DB->set_pagesize(DB *db, u_int32_t pagesize);

Set the size of the pages used to hold items in the database, in bytes. The minimum page size is 512 bytes, the maximum page size is 64K bytes, and the page size must be a power-of-two. If the page size is not explicitly set, one is selected based on the underlying filesystem I/O block size. The automatically selected size has a lower limit of 512 bytes and an upper limit of 16K bytes.

For information on tuning the Berkeley DB page size, see Selecting a page size.

The `DB->set_pagesize()` method configures a database, not only operations performed using the specified DB handle.

The `DB->set_pagesize()` method may not be called after the DB->open() method is called. If the database already exists when DB->open() is called, the information specified to `DB->set_pagesize()` will be ignored.

If creating additional databases in a single physical file, information specified to `DB->set_pagesize()` will be ignored and the page size of the existing databases will be used.

The `DB->set_pagesize()` method returns a non-zero error value on failure and 0 on success.

The `DB->set_pagesize()` method returns a non-zero error value on failure and 0 on success.

### Parameters

#### pagesize

The pagesize parameter sets the database page size.

### Errors

The `DB->set_pagesize()` method may fail and return one of the following non-zero errors:

#### EINVAL

If the method was called after DB->open() was called; or if an invalid flag value or parameter was specified.

### Class

DB

### See Also

Database and Related Methods

Prev | Up | Next
DB->set_msgfile() | Home | DB->set_partition()