On 26/08/14 10:13, Josh Berkus wrote:
On 08/22/2014 07:02 AM, Andres Freund wrote:
On 2014-08-21 14:02:26 -0700, Josh Berkus wrote:
On 08/20/2014 07:40 PM, Bruce Momjian wrote:
Not sure how you can make such a blanket statement when so many people
have tested and shown the benefits of hyper-th
On Monday, August 25, 2014, Jeison Bedoya Delgado
wrote:
> hi, recently i change the hardware of my database 32 cores up to 64 cores
> and 128GB Ram, but the performance is the same. Perhaps i have to change
> any parameter in the postgresql.conf?.
>
PostgreSQL does not (yet) automatically par
On 08/22/2014 07:02 AM, Andres Freund wrote:
> On 2014-08-21 14:02:26 -0700, Josh Berkus wrote:
>> On 08/20/2014 07:40 PM, Bruce Momjian wrote:
>>> Not sure how you can make such a blanket statement when so many people
>>> have tested and shown the benefits of hyper-threading.
>>
>> Actually, I d
Hi pgsql
http://activebillion.com/bring.php?fzuvceubqu3101hcvfvcq
Rich
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
hi, recently i change the hardware of my database 32 cores up to 64
cores and 128GB Ram, but the performance is the same. Perhaps i have to
change any parameter in the postgresql.conf?.
Thanks by your help
--
Atentamente,
JEISON BEDOYA DELGADO
.
--
NOTA VERDE:
No imprima este correo a men
On Fri, Aug 22, 2014 at 1:49 PM, Emi Lu wrote:
> Hello,
>
> Trying to insert into one table with 1 million records through java JDBC
> into psql8.3. May I know (1) or (2) is better please?
>
> (1) set autocommit(true)
> (2) set autocommit(false)
> commit every n records (e.g., 100, 500, 1000
Hi Emi,
Databases that comply to the ACID standard (
http://en.wikipedia.org/wiki/ACID) ensure that that are no data loss by
first writing the data changes to the database log in opposition to
updating the actual data on the filesystem first (on the datafiles).
Each database has its own way of do
On Mon, Aug 25, 2014 at 9:40 AM, Emi Lu wrote:
>
> By the way, could someone let me know why set autocommit(false) is for
> sure faster than true please? Or, some online docs talk about this.
>
>
Not sure about the docs specifically but:
Commit is expensive because as soon as it is issued all o
Good morning,
Trying to insert into one table with 1 million records through java
JDBC into psql8.3. May I know (1) or (2) is better please?
(1) set autocommit(true)
(2) set autocommit(false)
commit every n records (e.g., 100, 500, 1000, etc)
It depends on what you need.
Data will be ava
