Hannu Krosing wrote:
> Tom Lane wrote:
> >
> >
> > I've heard lots of people want to increase BLCKSZ, but you're the first
> > one who ever wanted to reduce it. You sure you want to do this? It's
> > going to make the maximum row length uncomfortably short.
>
> And it may even not work, as some
Tom Lane wrote:
>
>
> I've heard lots of people want to increase BLCKSZ, but you're the first
> one who ever wanted to reduce it. You sure you want to do this? It's
> going to make the maximum row length uncomfortably short.
And it may even not work, as some system tables (that are also affec
Alexaki Sofia <[EMAIL PROTECTED]> writes:
> Initially I loaded all data in one transaction. Subsequently, I increased
> the number of buffers and disabled fsync() (-o -F) and I loaded the
> data again but the performance was almost unchanged. Does it make sense??
> How can I improve performance?
Hello,
A)
I am going to load a huge amount of data in the DBMS using JDBC
and I want to reduce as much as possible the required loading time.
Initially I loaded all data in one transaction. Subsequently, I increased
the number of buffers and disabled fsync() (-o -F) and I loaded the
data again