Thank you.
But why buffers_backend is so high? As I understood from your article,
buffers_backend shows the number of writes immediately caused by any write
operations, e.g. when an INSERT has to flush something on disk, because it
has no space left for a new data in shared buffers. I suppose
On Mon, Jan 5, 2009 at 11:40 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
While looking at a complex query that is being poorly planned by
PostgreSQL 8.2.9, I discovered that any non-trivial CASE...WHEN
expression seems to produce a selectivity estimate of
Robert Haas robertmh...@gmail.com writes:
Well, presumably CASE WHEN expr1 THEN constant1 WHEN expr2 THEN
constant2 WHEN expr3 THEN constant3 ... END = constantn could
be simplified to exprn.
Not without breaking the order-of-evaluation guarantees. Consider
case when x=0 then 0 when
Hi list,
I would like to ask your help in order to understand if my postgresql
server (ver. 8.2.9) is well configured.
It's a quad-proc system (32 bit) with a 6 disk 1+0 RAID array and 2
separate disks for the OS and write-ahead logs with 4GB of RAM.
I don't know what is the best info to help
On Tue, Jan 6, 2009 at 11:50 AM, Stefano Nichele
stefano.nich...@gmail.com wrote:
Hi list,
I would like to ask your help in order to understand if my postgresql server
(ver. 8.2.9) is well configured.
It's a quad-proc system (32 bit) with a 6 disk 1+0 RAID array and 2 separate
disks for the
I concur with Merlin you're I/O bound.
Adding to his post, what RAID controller are you running, does it have
cache, does the cache have battery backup, is the cache set to write
back or write through?
Also, what do you get for this (need contrib module pgbench installed)
pgbench -i -s 100
I got this bounce message from your account,
stefano.nich...@gmail.com. I'm on gmail too, but don't get a lot of
-perform messages into my spam folder.
Just in case you've got eliminatecc turned on on the mailing list
server, I'm resending it through the mail server without your email
address in
Thanks for your help. I'll give you the info you asked as soon as I'll
have it (i have also to install iostat but I don't have enough privilege
to do that).
BTW, why did you said I/O bound ? Which are the parameters that
highlight that ? Sorry for my ignorance
ste
Merlin Moncure wrote:
On Tue, Jan 6, 2009 at 12:02 PM, Stefano Nichele
stefano.nich...@gmail.com wrote:
Thanks for your help. I'll give you the info you asked as soon as I'll have
it (i have also to install iostat but I don't have enough privilege to do
that).
BTW, why did you said I/O bound ? Which are the
On Tue, Jan 6, 2009 at 11:02 AM, Stefano Nichele
stefano.nich...@gmail.com wrote:
BTW, why did you said I/O bound ? Which are the parameters that highlight
that ? Sorry for my ignorance
In addition to the percentage of time spent in wait as Scott said, you
can also see the number of
Tom Lane wrote:
Ryan Hansen ryan.han...@brightbuilders.com writes:
[...]
but when I set the shared buffer in PG and restart
the service, it fails if it's above about 8 GB.
Fails how? And what PG version is that?
The thread seems to end here as far as the specific question was
concerned. I
Frank Joerdens fr...@joerdens.de writes:
then I take the request size value from the error and do
echo 8810725376 /proc/sys/kernel/shmmax
and get the same error again.
What about shmall?
regards, tom lane
--
Sent via pgsql-performance mailing list
On Wed, Jan 7, 2009 at 3:23 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Frank Joerdens fr...@joerdens.de writes:
then I take the request size value from the error and do
echo 8810725376 /proc/sys/kernel/shmmax
and get the same error again.
What about shmall?
Yes that works, it was set to
David Rees wrote:
On Tue, Jan 6, 2009 at 11:02 AM, Stefano Nichele
stefano.nich...@gmail.com wrote:
BTW, why did you said I/O bound ? Which are the parameters that highlight
that ? Sorry for my ignorance
In addition to the percentage of time spent in wait as Scott said, you
can also
On Tue, 6 Jan 2009, Dmitry Koterov wrote:
But why buffers_backend is so high? As I understood from your article,
buffers_backend shows the number of writes immediately caused by any write
operations, e.g. when an INSERT has to flush something on disk, because it
has no space left for a new data
15 matches
Mail list logo