Hi,
Since our upgrade of hardware, OS and Postgres we experience server stalls
under certain conditions, during that time (up to 2 minutes) all CPUs show 100%
system time. All Postgres processes show BIND in top.
Usually the server only has a load of < 0.5 (12 cores) with up to 30
connections,
On 25/02/2013 12:13 AM, Bèrto ëd Sèra wrote:
and your /etc/sysctl.conf is?
/etc/sysctl.conf only had unrelated options set, here is the output of sysctl
-a:
abi.vsyscall32 = 1
debug.exception-trace = 1
dev.hpet.max-user-freq = 64
kernel.acct = 4230
kernel.acpi_video_flags = 0
kernel.
On 25/02/2013 12:45 AM, Tom Lane wrote:
Odd. I wonder if you are seeing some variant of the old context swap storm problem. The "99.8% system time" reading is suggestive but hardly conclusive. Does top's report of context swap rate go to the moon? It would be interesting to strace a few of the ser
On 27/02/2013 9:29 AM, Josh Berkus wrote:
Andre,
Please see the related thread on this list, "High CPU usage / load
average after upgrading to Ubuntu 12.04". You may be experiencing some
of the same issues. General perspective seems to be that kernels 3.0
through 3.4 have serious p
Hello
Im using source postgresql 8.0.3 under FreeBSD and already install, the database is running well.
I want to install a pgbench, but I cant install it, coz an error occur.
I try to make all in directory ~/src/interfaces/lipq/
The messages are :
. . . . .
. . . . .
"../../../src/Makef
an handle our load or a bigger
system is required. ) Do you have some suggestions, how to measure that?
Do you have experience with postgres on something like HP MSA2000(10-20
disks) or RamSan systems?
Best regards,
Andre
--
Sent via pgsql-performance mailing list (p
Hi,
i think i need a little help with a problem with pg_statistic.
Lets say i have a table to collect traffic-data.
The table has a column time_stamp of type timesamptz.
The table has a single-column index on time_stamp.
The table has around 5 million records.
If i delete all statistical data fro
dex scan cost being more than 25 * seq scan cost, I guess that
> > - all other things held equal - even random_page_cost = 1 wouldn't
> > help.
>
> Oh, you're right, I was comparing the wrong estimated costs. Yeah,
> changing random_page_cost won't fix it.
>
dex scan cost being more than 25 * seq scan cost, I guess that
> > - all other things held equal - even random_page_cost = 1 wouldn't
> > help.
>
> Oh, you're right, I was comparing the wrong estimated costs. Yeah,
> changing random_page_cost won't fix it.
>
On Fri, 27 Jun 2003 10:43:01 +0200
Manfred Koizar <[EMAIL PROTECTED]> wrote:
> On Fri, 27 Jun 2003 08:07:35 +0200, Andre Schubert
> <[EMAIL PROTECTED]> wrote:
> >Traffic data are inserted every 5 minutes with the actual datetime
> >of the transaction, thatswhy the ta
suitable to the available system ram.
Thanks
Andre Felipe
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
t tell postgresql to actually
use windows disk cache.
What parameter must be configured?
Do you have some suggestions?
Regards.
Andre Felipe Machado
www.techforce.com.br
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will i
12 matches
Mail list logo
