, 2013 at 12:31 PM, Mark Davidson wrote:
>
>> Thanks for your response Vasillis. I've run pgbench on both machines
>> `./pgbench -c 10 -t 1 pgbench` getting 99.800650 tps on my local
>> machine and 23.825332 tps on the server so quite a significant difference.
>
Sorry Vasillis I missed you asking that I just did './pgbench -i pgbench'
didn't specific set any values. I can try some specific ones if you can
suggest any.
On 8 April 2013 21:28, Vasilis Ventirozos wrote:
>
>
>
> On Mon, Apr 8, 2013 at 11:18 PM, Mark Davidson wro
18.976496 (including connections establishing)
> tps = 1119.180126 (excluding connections establishing)
>
> i am assuming that you didn't populate your pgbench db with the default
> values , if you tell me how you did i will be happy to re run the test and
> see the dif
Could anyone suggest a way to bench mark the machines for their
>> postgres performance?
>>
>> Thanks again for everyones input,
>>
>> Mark
>>
>>
>> On 7 April 2013 23:22, Mark Davidson wrote:
>>
>>> Takes a little longer with the I
a lot better since it has more cores or is postgres more affected by the
CPU speed? Could anyone suggest a way to bench mark the machines for their
postgres performance?
Thanks again for everyones input,
Mark
On 7 April 2013 23:22, Mark Davidson wrote:
> Takes a little longer with the IN
Takes a little longer with the INNER join unfortunately. Takes about ~3.5
minutes, here is the query plan http://explain.depesz.com/s/EgBl.
With the JOIN there might not be a match if the data does not fall within
one of the areas that is selected in the IN query.
So if we have data id (10) that
Any other
suggestions?
Thanks very much for your help,
Mark
On 5 April 2013 17:37, Kevin Grittner wrote:
> Mark Davidson wrote:
>
> > CONSTRAINT data_area_pkey PRIMARY KEY (data_id , area_id ),
>
> So the only index on this 250 million row table starts with the ID
> o
tail for someone to be
able to help if there is anything I've missed please let me know and I'll
add any more info needed. Any input on the optimisation of the table
structure, the query, or anything else I can do to sort this issue would be
most appreciated.
Thanks in advance,
Mark Davidson
