dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlDump Class / BlockSize Property

In This Topic
    BlockSize Property
    In This Topic
    Gets or sets the size of a data block for reading from the large object and dumping to a single INSERT statement (SELECT LOWRITE...). Default value is 0 (large objects will not be split when dumping).
    Syntax
    'Declaration
     
    Public Property BlockSize As Integer
    public int BlockSize {get; set;}

    Property Value

    The size of a data block for dumping large objects.
    Remarks

    If the size of a large object is less than the value of this property, all the dataof this large object are placed to a single INSERT statement. Otherwise, PgSqlDump reads the large object data in parts of the BlockSize size and generates a separate statement for each part.

    If your large objects are not too big, it is better to keep the default value. For bigger large objects it is better to dump data into several statements with less data than in one huge statement, because such statement can cause insufficient memory errors.

    Note that decreasing BlockSize value causes increasing the number of round-trips to the server and longer dump duration.

    We recommend the values for this property from 64Kb to 1Mb.

    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also