al-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Josh berkus
Sent: 03 February 2016 03:53
To: Bill Ross; pgsql-general@postgresql.org
Subject: Re: [GENERAL] SSD gives disappointing speed up on OSX
On 02/02/2016 07:32 PM, Bill Ross wrote:
> I have a program that inserts 50M re
l.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Josh berkus
Sent: 03 February 2016 03:53
To: Bill Ross; pgsql-general@postgresql.org
Subject: Re: [GENERAL] SSD gives disappointing speed up on OSX
On 02/02/2016 07:32 PM, Bill Ross wrote:
> I have a program that inserts 50M records of
I have a program that inserts 50M records of about 30 bytes each [..]
Now I suspect the limit is OSX throttling per-process CPU.
Does this sound right?
Mmm... I don't think so.
How do you perform the inserts?
- Single inserts per transaction?
- Bundled inserts in transactions (with or with
On 02/02/2016 07:32 PM, Bill Ross wrote:
I have a program that inserts 50M records of about 30 bytes each, with
some simple indexing, using about 5 GB of disk, layout shown below. When
I run the program without the inserts, it takes a few seconds to do just
the calculation part.
With inserts, it
I have a program that inserts 50M records of about 30 bytes each, with
some simple indexing, using about 5 GB of disk, layout shown below. When
I run the program without the inserts, it takes a few seconds to do just
the calculation part.
With inserts, it takes about 90 minutes to run on my ma