Thanks for your explanations.
Tom Lane wrote:
Richard Neill writes:
Now, I understand that increasing checkpoint_segments is generally a
good thing (subject to some limit), but doesn't that just mean that
instead of say a 1 second outage every minute, it's a 10 second outage
every 10 minutes
Richard Neill wrote:
Now, I understand that increasing checkpoint_segments is generally a
good thing (subject to some limit), but doesn't that just mean that
instead of say a 1 second outage every minute, it's a 10 second outage
every 10 minutes?
That was the case in versions before 8.3. Now,
You mean that backend does not support threading and everything I try
is useless
Is there a way to overcome this issue?
Is there anything I can adjust on backend to enable threading?
Is there any documentation to advise?
Best Regards,
Reydan
On Nov 28, 2009, at 6:42 PM, Tom Lane wrote:
Reyd
Richard Neill writes:
> Now, I understand that increasing checkpoint_segments is generally a
> good thing (subject to some limit), but doesn't that just mean that
> instead of say a 1 second outage every minute, it's a 10 second outage
> every 10 minutes?
In recent PG versions you can spread t
Greg Smith wrote:
Richard Neill wrote:
Or am I barking up the wrong tree entirely?
If you haven't already tuned checkpoint behavior, it's more likely
that's causing a dropout than autovacuum. See the checkpoint_segments
section of http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
Reydan Cankur writes:
> I am trying to run postgresql functions with threads by using OpenMP.
This is pretty much doomed to failure. It's *certainly* doomed to
failure if you just hack up one area of the source code without dealing
with the backend's general lack of support for threading.
Greg Smith wrote:
> Merlin Moncure wrote:
> > I am right now talking to someone on postgresql irc who is measuring
> > 15k iops from x25-e and no data loss following power plug test.
> The funny thing about Murphy is that he doesn't visit when things are
> quiet. It's quite possible the window fo
Hi,
I am trying to run postgresql functions with threads by using OpenMP.
I tried to parallelize slot_deform_tuple function(src/backend/access/
common/heaptuple.c) and added below lines to the code.
#pragma omp parallel
{
#pragma omp sections
{
#pragma omp sec
