Le Tue, 31 Dec 2002 14:47:42 +0530
"Somasekhar Bangalore" <[EMAIL PROTECTED]> me disait que :
> Hi,
>
> I have a postgres database running linux platform.The database has been
> enabled for multibyte support -works fine for Japanese,Spanish,German. But
> when it comes to French..i am able to inse
Hello all,
I've a hard working pgsql db running on 7/7x365 server. Each night (when
activity is less intensive) I run vacuum and vacuum analyze on tables where
principal activity is performed.
Tables are cleaned (files sizes are decreasing), but indices files keeps on
growing in si
Hello all,
I've a hard working pgsql db running on 7/7x365 server. Each night
(when
activity is less intensive) I run vacuum and vacuum analyze on tables where
principal activity is performed.
Tables are cleaned (files sizes are decreasing), but indices files
keeps on
growing in
Hi all,
I'm in front of a real problem (from my point of view). I have some tables
with a lot of update insert and delete (24/7). These tables have multiples
indexes. Major part of Insert commands are performed as bulk at 00:00:00. I'm
doing Vaccum and then a vacuum analyze to clean tables
Hello all.
I've a performance problem on specific requests :
When I use timestamps + interval in where clauses, query performance is
slowed down by a factor of 20 or 30 For exemple :
select timestamp,value
from measure
where timestamp(now() - '1 hour'::interval)
Hello all.
I've a performance problem on specific requests :
When I use timestamps + interval in where clauses, query performance is slowed
down by a factor of 20 or 30 For exemple :
select timestamp,value
from measure
where timestamp(now() - '1 hour'::interval)
Le Wed, 10 Apr 2002 09:27:09 -0400
"Dan Langille" <[EMAIL PROTECTED]> me disait que :
> On 10 Apr 2002 at 9:13, JX wrote:
>
> > Le Wed, 10 Apr 2002 09:06:55 -0400
> > "Dan Langille" <[EMAIL PROTECTED]> me disait que :
> &g
Hello all.
I've a performance problem on specific requests :
When I use timestamps + interval in where clauses, query performance is
slowed down by a factor of 20 or 30 For exemple :
select timestamp,value
from measure
where timestamp(now() - '1 hour'::interval
Hi all pg admins,
here is the problem we're encountering now. We've got a pgsql database server,
logging informations (such as alarms, week-events and so on) for a measure system.
This database is mainly fed by a collect daemon which inserts/update values in tables
and generate
