> dbnasg403-12a:/vol/dodpupdbtst03 on /ORA/dbs03/PUPDBTST type nfs (rw,
> actimeo=0,hard,nointr,rsize=65536,wsize=65536,tcp,timeo=600)
> dbnasg401-12a:/vol/dodpupdbtst02 on /ORA/dbs02/PUPDBTST type nfs (rw,
> actimeo=0,hard,nointr,rsize=65536,wsize=65536,tcp,timeo=600)
>
> to
>
> dbnasg403-12a:/v
schema. It happens at about 5hours interval. Is there a way to avoid this ?
Should I ask to the master db dba to try to have a more active autovacuum
policy?
Thank you,
Ruben
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
191755874 | | 5/3099716 | 54422 | t
transactionid | | ExclusiveLock
| 191755883 | | 21/2767248 | 13044 | t
(95 rows)
Jus to comment that we are running a DBaaS, we don't know much about the apps
running on our servers.
Thank you,
Rube
disks (they have a flash cache of 512GB,
this is why we get this average).
Thank you,
Ruben
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Hi,
I need to implement a Load Balancing solution in the PostgresSQL
database. Actually we are working with postgres 8.1 but postgres 8.2 is
planified to be upgrade in short.
I read about it, and would like to know any experience with this.
Did you ever need Load Balancing?
What did you implem
t is
> at?
backends arround 50 -100 I don't use pgBouncer yet.
Sysstat reports veeery low io.
Right now Im checking out fsm parameter, as Scott recomended. Seems
there is the problem.
>
> On 9/11/07, Ruben Rubio <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I having the sa
Decibel! escribió:
> On Tue, Sep 11, 2007 at 09:49:37AM +0200, Ruben Rubio wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> [EMAIL PROTECTED] escribi?:
>>>> Last time I had this problem i solved it stopping website, restarting
>>>
H21zIhvdvPcmVQG71owiCye96xwCcDPe0
o/aArJF0JjUnTIFd1sMYD+Y=
=6zyY
-END PGP SIGNATURE-
begin:vcard
fn:Ruben Rubio
n:Rubio;Ruben
org:Rentalia Holidays S.L
adr;quoted-printable:;;Gran v=C3=ADa 31, 9=C2=BA-1=C2=BA;Madrid;;;Spain
email;internet:[EMAIL PROTECTED]
tel;wor
SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFG5jbLIo1XmbAXRboRArcpAJ0YvoCT6KWv2fafVAtapu6nwFmKoACcD0uA
zFTx9Wq+2NSxijIf/R8E5f8=
=u0k5
-END PGP SIGNATURE-
begin:vcard
fn:Ruben Rubio
n:Rubio;Ruben
org:Rentalia Holidays
fine? Maybe database should need
a restart? I really don't know.
Does someone had a similar problem?
Thanks in advance,
Ruben Rubio
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozde
Bill Moran escribió:
> In response to Chris Mair <[EMAIL PROTECTED]>:
>
>>> Hi,
>>>
>>> Note: I have already vacumm full. It does not solve the problem.
>
> To jump in here in Chris' defense, regular vacuum is not at all the same
> as vacuum full. Periodic vacuum is _much_ preferable to an occas
SO: CentOS release 4.3 (Final) (kernel: 2.6.9-34.0.1.ELsmp)
Postgres: 8.1.3
I had some problems before with autovacuum. So, Each day I crontab execute:
vacuumdb -f -v --analyze
reindex database vacadb
I saw logs (the output of vacuum and reindex) and there is no errors.
If u need more info, I
it?
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFG0rh5Io1XmbAXRboRAuaTAJ4tDVHUMN5YRBdWxT//kPAfBvYqRACgvLst
rJF3dmxzWHDOWB8yQwTyvpw=
=2ic9
-END PGP SIGNATURE-
begin:vcard
fn:Ruben Rubio
n:Rubio;Ruben
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
>
> You don't have vacuum_cost_delay set, do you? How long does normal
> vacuum run?
vacuum_cost_delay = 100
No idea how long will take normal vacuum. I ll try tonight when there is
not too much load.
>
> The manual suggests dropping all indexes be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Vacuum full is very slow for me . I dont know how to speed it up. It
takes between 60 and 90 minutes.
I have set up autovacuum but I also run vacuum full once per week.
The slowest parts in the vacuum full output are :
INFO: "a": moved 14076 r
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
>> so, imo alexander is correct:
>> contacto varchar(255)
Why do we have limits on this, for example?
contacto varchar(255)
1) First of all, this is a web application. People use to enter really
strange thinks there, and a lot of rubbish. So, as s
this
AND EXISTS (SELECT 1 FROM ficha vf WHERE idestado IN ('3', '4') AND
vf.idficha = c.idfile);
it is really fast.
Thanks to everybody.
Regards,
Ruben Rubio
Heikki Linnakangas escribió:
> You could try rewriting the query like this:
>
> SELECT MAX(idcomment)
&
-Original Message-
> From: [EMAIL PROTECTED] on behalf of Ruben Rubio
> Sent: Tue 10/17/2006 2:05 AM
> To: pgsql-performance@postgresql.org
> Cc:
> Subject: [PERFORM] Optimization of this SQL sentence
>
> This SQL sentence is very simple. I need to get better
haps you could post the details
> of the tables (columns, indexes),and some info on what version of postgres
> you are using.
>
> Are the tables recently analyzed ? How many rows in them ?
>
> Greg Williamson
> DBA
> GlobeXplorer LLC
>
>
> -Original Message-
tual
time=141.004..141.004 rows=6282 loops=1)
-> Seq Scan on ficha vf (cost=0.00..1403.00 rows=178
width=4) (actual time=0.071..97.885 rows=6282 loops=1)
Filter: (((idestado)::text = '3'::text) OR
((idestado)::text = '4'::text))
Total runtime: 188.809 ms
T
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
If subquerys are not working I think you should try to create a view
with the subquery.
Maybe it will work.
Patrice Beliveau wrote:
> Tom Lane wrote:
>> Patrice Beliveau <[EMAIL PROTECTED]> writes:
>>
> SELECT * FROM TABLE
> WHERE TABLE.COL
ce.
Christopher Browne wrote:
> Quoth [EMAIL PROTECTED] (Ruben Rubio):
>> Hi, I have a question with shared_buffer.
>>
>> Ok, I have a server with 4GB of RAM
>> -
>> # cat /proc/meminfo
>> MemTotal: 4086484 kB
>> [...]
>> -
>>
&g
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, I have a question with shared_buffer.
Ok, I have a server with 4GB of RAM
- -
# cat /proc/meminfo
MemTotal: 4086484 kB
[...]
- -
So, if I want to, for example, shared_buffer to take 3 GB of RAM then
shared_buffer would be 393216 (3 *
Seems autovacumm is working fine. Logs are reporting that is being useful.
But server load is high. Is out there any way to stop "autovacumm" if
server load is very high?
Thanks everyone!!!
---(end of broadcast)---
TIP 3: Have you checked our e
Guido Neitzer wrote:
On 13.06.2006, at 8:44 Uhr, Ruben Rubio Rey wrote:
Tonight database has been vacumm full and reindex (all nights
database do it)
Now its working fine. Speed is as spected. I ll be watching that sql
...
Maybe the problem exists when database is busy, or maybe its
Tonight database has been vacumm full and reindex (all nights database
do it)
Now its working fine. Speed is as spected. I ll be watching that sql ...
Maybe the problem exists when database is busy, or maybe its solved ...
---(end of broadcast)---
Jim C. Nasby wrote:
On Mon, Jun 12, 2006 at 09:05:06AM -0600, Michael Fuhr wrote:
On Mon, Jun 12, 2006 at 04:38:57PM +0200, Ruben Rubio Rey wrote:
I have two similar servers, one in production and another for testing
purposes.
Databases are equal (with a difference of some hours)
In
Jim C. Nasby wrote:
On Mon, Jun 12, 2006 at 04:58:49PM +0200, Ruben Rubio Rey wrote:
$DIREC/vacuumdb -f -v --analyze vacadb 2>&1 | $LOGBIN
$DIRLOGS/%Y-%m-%d_limpieza.log
echo "reindex database vacadb;" | $DIREC/psql vacadb 2>&1 | $LOGBIN
$DIRLOGS/%Y-%m-%d_limp
Jonah H. Harris wrote:
On 6/12/06, Ruben Rubio Rey <[EMAIL PROTECTED]> wrote:
I have two similar servers, one in production and another
for testing purposes. In testing server ~1sec ... in
production ~50 secs
What ver of PostgreSQL?
Version 8.1.3
Same ver on both systems?
Gábriel Ákos wrote:
Ruben Rubio Rey wrote:
Hi,
Im having a problem with postgres 8.1.3 on a Fedora Core 3 (kernel
2.6.9-1.667smp)
I have two similar servers, one in production and another for testing
purposes.
Databases are equal (with a difference of some hours)
In the testing server
Hi,
Im having a problem with postgres 8.1.3 on a Fedora Core 3 (kernel
2.6.9-1.667smp)
I have two similar servers, one in production and another for testing
purposes.
Databases are equal (with a difference of some hours)
In the testing server, an sql sentence takes arround 1 sec.
In produc
[EMAIL PROTECTED] wrote:
On 17 May 2006, at 16:21, Ruben Rubio Rey wrote:
I have a web page, that executes several SQLs.
So, I would like to know witch one of those SQLs consumes more CPU.
For example,
I have SQL1 that is executed in 1.2 secs and a SQL2 that is executed
in 200 ms.
But
Hi,
I have a web page, that executes several SQLs.
So, I would like to know witch one of those SQLs consumes more CPU.
For example,
I have SQL1 that is executed in 1.2 secs and a SQL2 that is executed in
200 ms.
But SQL2 is executed 25 times and SQL1 is executed 1 time, so really
SQL2 consum
Did you tried to index the expression?
Did it work?
Doron Baranes wrote:
Ok. But that means I need a trigger on the original column to update the
new column on each insert/update and that overhead.
-Original Message-
From: Ruben Rubio Rey [mailto:[EMAIL PROTECTED]
Sent: Thursday
I think that the problem is the GROUP BY (datetime) that is
date_trunc('hour'::text, i.entry_time)
You should create an indexe with this expression (if its possible).
http://www.postgresql.org/docs/7.4/interactive/indexes-expressional.html
If is not possible, I would create a column with value
Greg Quinn wrote:
The query is,
select * from users
which returns 4 varchar fields, there is no where clause
Yes, I am running the default postgres config. Basically I have been a
MySQL user and thought I would like to check out PostGreSql. So I did
a quick performance test. The performance
Tom Lane wrote:
Ruben Rubio Rey <[EMAIL PROTECTED]> writes:
SELECT (array[20]+array[21]+ ... +array[50]+array[51]) as total
FROM table
WHERE
(array[20]+array[21]+ ... +array[50]+array[51])<5000
AND array[20]<>0
AND array[21]<>0
...
AND array[50]<>0
AND array[51])&
Jim C. Nasby wrote:
On Fri, Mar 24, 2006 at 01:41:50PM +0100, Ruben Rubio Rey wrote:
Hi,
I have a select like
SELECT (array[20]+array[21]+ ... +array[50]+array[51]) as total
FROM table
WHERE
(array[20]+array[21]+ ... +array[50]+array[51])<5000
http://www.varlena.com/GeneralBits/
Hi,
I have a select like
SELECT (array[20]+array[21]+ ... +array[50]+array[51]) as total
FROM table
WHERE
(array[20]+array[21]+ ... +array[50]+array[51])<5000
AND array[20]<>0
AND array[21]<>0
...
AND array[50]<>0
AND array[51])<>0
Any ideas to make this query faster?
-
Richard Huxton wrote:
Ruben Rubio Rey wrote:
Hi,
I think im specting problems with a 7.4.8 postgres database.
Sometimes some big query takes between 5 to 15 seconds. It happens
sometimes all the day it does not depend if database is busy.
I have measured that sentence in 15 - 70 ms in
Michael Fuhr wrote:
On Fri, Mar 10, 2006 at 11:05:57AM +0100, Ruben Rubio Rey wrote:
Sometimes some big query takes between 5 to 15 seconds. It happens
sometimes all the day it does not depend if database is busy.
I have measured that sentence in 15 - 70 ms in normal circunstances
thana, Rao (IE10) wrote:
USUALLY POSTGRES DATABASE TAKES MORE TIME, COMPARED TO OTHER DATABASES.
HOWEVER U CAN FINETUNE THE PERFORMANCE OF POSTGRESQL.
IF U HAVE AN OPTION GO FOR SQLITE, MYSQL OR FIREBIRD.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
much time?
How can I fix it?
Is a postgres version problem, database problem or query problem?
Any ideas will be apreciatted.
Ruben Rubio
---(end of broadcast)---
TIP 6: explain analyze is your friend
capacity or capacity and prices
I have no experience working with arrays on a table. Is it fast?
Witch one do u think will have better performance?
Any good idea?
I hope this is enouth information.
Thanks in advance,
Ruben Rubio Rey
---(end of broadcast
44 matches
Mail list logo
