Reydan Cankur írta:
> I want to do the second. I want to spread out the workload on all
> cores. But also I want to set the core number; for example first I
> want to spread out the workload to 32 cores then 64 cores and see the
> scalability.
You can use taskset(1) or schedtool(8) to set the CPU
I want to do the second. I want to spread out the workload on all
cores. But also I want to set the core number; for example first I
want to spread out the workload to 32 cores then 64 cores and see the
scalability.
On Feb 14, 2010, at 8:25 PM, Scott Marlowe wrote:
With all that info, your
(Apologies if this ends up coming through multiple times - my first attempts
seem to have gotten stuck.)
We recently took the much needed step in moving from 8.1.19 to 8.4.2. We took
the downtime opportunity to also massively upgrade our hardware. Overall, this
has been the major improvement yo
With all that info, your question is still kind of vague. Do you want
to be able to run a single query across all 64 cores? Or do you have
1,000 users and you want them to be spread out on all cores.
PostgreSQL can do the second but has no native features to do the
first.
--
Sent via pgsql-perf
Hi Reydan,
PostgreSQL is unaware of the amount of cpu's and cores and doesn't
really care about that. Its up to your OS to spread the work across the
system.
Be careful with what you test, normal PostgreSQL cannot spread a single
query over multiple cores. But it will of course spread its fu
Hi,
I have seen some work done about scaling PostgreSQL on SMP machines
and see that PostgreSQL has been executed on several numbers of cores.
I have some questions about scaling PostgreSQL on SMP architectures.
System Details that I am running PostgreSQL-8.4.0:
Server: HP Integrity Superdo
2010/2/10 Tom Lane
> Franck Routier writes:
> > I am wondering if deferring foreign key constraints (instead of
> > disableing them) would increase performance, compared to non deferred
> > constraints
>
> No, it wouldn't make any noticeable difference AFAICS. It would
> postpone the work from