Thanks Alban & Gregg.
i will describe little more about that table
- We are using PHP application with Apache server & Postgresql 9.0.3 in a
dedicated server.
- stk_source table is mainly used to track the transactions from parent
to child
Table "_100
On Fri, Oct 28, 2011 at 2:20 PM, Merlin Moncure wrote:
>
> hrm -- it doesn't look like you are i/o bound -- postgres is
> definitely the bottleneck. taking a dump off of production is
> throwing something else out of whack which is affecting your other
> processes.
>
> band aid solutions might b
On Thu, Oct 27, 2011 at 6:29 PM, Samuel Gendler
wrote:
>
> On Thu, Oct 27, 2011 at 2:15 PM, Samuel Gendler
> wrote:
>>
>> There are definitely no bloated tables. The large tables are all
>> insert-only, and old data is aggregated up and then removed by dropping
>> whole partitions. There should
On 10/28/2011 12:26 PM, Tomas Vondra wrote:
For example the Intel 710 SSD has a sequential write speed of 210MB/s,
while a simple SATA 7.2k drive can write about 50-100 MB/s for less than
1/10 of the 710 price.
Bulk data transfer rates mean almost nothing in the context of a database
(unless you
On Fri, Oct 28, 2011 at 12:28 PM, Marcus Engene wrote:
> Hi list,
>
> Every now and then I have write peaks which causes annoying delay on my
> website. No particular reason it seems, just that laws of probability
> dictates that there will be peaks every now and then.
>
> Anyway, thinking of ways
On 28 Říjen 2011, 20:40, Merlin Moncure wrote:
> sure, but then you have to have a more complicated setup with a
> drive(s) designated for WAL, another for storage, etc. Also, your
> argument falls away if the WAL is shared with another drive. The era
> of the SSD is here. All new systems I plan w
Hi,
On 28 Říjen 2011, 17:28, Marcus Engene wrote:
> Hi list,
>
> Every now and then I have write peaks which causes annoying delay on my
> website. No particular reason it seems, just that laws of probability
> dictates that there will be peaks every now and then.
>
> Anyway, thinking of ways to m
On Tue, Oct 11, 2011 at 2:20 PM, Anibal David Acosta wrote:
> Do you know if check_postgresql.pl can run on windows (with perl installed)?
>
> Because our postgres installation is running on a Windows 2008 R2 server but
> can't find any tool like this for windows :(
>
> Thanks!
It's written in Pe
On Fri, Oct 28, 2011 at 1:26 PM, Tomas Vondra wrote:
> On 28 Říjen 2011, 18:11, Merlin Moncure wrote:
>> On Fri, Oct 28, 2011 at 10:28 AM, Marcus Engene wrote:
>>> Hi list,
>>>
>>> Every now and then I have write peaks which causes annoying delay on my
>>> website. No particular reason it seems,
On 28 Říjen 2011, 18:11, Merlin Moncure wrote:
> On Fri, Oct 28, 2011 at 10:28 AM, Marcus Engene wrote:
>> Hi list,
>>
>> Every now and then I have write peaks which causes annoying delay on my
>> website. No particular reason it seems, just that laws of probability
>> dictates that there will be
Hi,
On 28 Říjen 2011, 19:27, Sorbara, Giorgio (CIOK) wrote:
> Dear all,
>
> I am new to PG but I have a solid background on tuning in Oracle and
> MSSQL.
> I have a query coming out from a piece of software from our SW-Stack (I
> can't change it) and of course it takes a large amount of time.
>
>
Dear all,
I am new to PG but I have a solid background on tuning in Oracle and MSSQL.
I have a query coming out from a piece of software from our SW-Stack (I can't
change it) and of course it takes a large amount of time.
The table I am query are inherited (partitioned) and the query is the foll
On Fri, Oct 28, 2011 at 10:28 AM, Marcus Engene wrote:
> Hi list,
>
> Every now and then I have write peaks which causes annoying delay on my
> website. No particular reason it seems, just that laws of probability
> dictates that there will be peaks every now and then.
>
> Anyway, thinking of ways
On 28 October 2011 09:02, Mohamed Hashim wrote:
> EXPLAIN select * from stk_source ;
> QUERY
> PLAN
> -
> Result (cost=0.00..6575755.39 rows=163132513 width=42)
> -> Appen
Marcus Engene wrote:
> Every now and then I have write peaks which causes annoying delay
> on my website
> Does anyone here have any recommendations here?
For our largest machines we put WAL on a RAID1 drive pair dedicated
to that task, on its own controller with battery-backed cache
configu
Hi list,
Every now and then I have write peaks which causes annoying delay on my
website. No particular reason it seems, just that laws of probability
dictates that there will be peaks every now and then.
Anyway, thinking of ways to make the peaks more bareable, I saw the new
9.1 feature to
On 10/27/2011 11:10 PM, Tom Lane wrote:
CS DBA writes:
I have code that drops a table, re-create's it (based on a long set of
joins) and then re-creates the indexes.
It runs via psql in about 10 seconds. I took the code and simply
wrapped it into a plpgsql function and the function version tak
On 10/28/2011 12:40 AM, Amitabh Kant wrote:
Sadly, 710 is not that easily available around here at the moment.
All three sizes are in stock at newegg.com, if you have a way to export
from the US to your location.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.o
We selected a 30MB bytea with psql connected with
"-h localhost" and found that it makes a huge
difference whether we have SSL encryption on or off.
Without SSL the SELECT finished in about a second,
with SSL it took over 23 seconds (measured with
\timing in psql).
During that time, the CPU is 100
Actually we are using various views and functions to get the info for
reporting purpose in that views or functions we have used or joined the
above table mentioned.
I thought of will get reply from any one from the lists so only i put anyway
i will continue with only pgsql-performance mailing list
what sort of queries you are running against it ? the select * from..
is not really (hopefully) a query you are running from your php app.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-p
I have Quadcore server with 8GB RAM
vendor_id : GenuineIntel
cpu family : 6
model : 44
model name : Intel(R) Xeon(R) CPU E5607 @ 2.27GHz
stepping: 2
cpu MHz : 1197.000
cache size : 8192 KB
MemTotal:8148636 kB
MemFree: 4989
22 matches
Mail list logo
