Re: slow insert speeds with bytea

2019-12-03 Thread Jeff Janes
On Mon, Dec 2, 2019 at 4:42 AM Alex O'Ree wrote: > Is there anything I can to increase insert speeds for bytea? Currently > running postgres 9.6.15 > > I have a few tables without a bytea and a few with bytea. There is a large > performance difference with inserts between the two. I'm inserting

Re: slow insert speeds with bytea

2019-12-02 Thread Steve Atkins
On 01/12/2019 17:59, Alex O'Ree wrote: Is there anything I can to increase insert speeds for bytea? Currently running postgres 9.6.15 I have a few tables without a bytea and a few with bytea. There is a large performance difference with inserts between the two. I'm inserting a byte[]

Re: slow insert speeds with bytea

2019-12-02 Thread Adrian Klaver
On 12/1/19 9:59 AM, Alex O'Ree wrote: Is there anything I can to increase insert speeds for bytea? Currently running postgres 9.6.15 I have a few tables without a bytea and a few with bytea. There is a large performance difference with inserts between the two. I'm inserting a byte[] that's

slow insert speeds with bytea

2019-12-02 Thread Alex O'Ree
Is there anything I can to increase insert speeds for bytea? Currently running postgres 9.6.15 I have a few tables without a bytea and a few with bytea. There is a large performance difference with inserts between the two. I'm inserting a byte[] that's usually less than 1MB on content. The