Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
Yep the problem of original posting could be replicated on
disabling hash aggregates. On disabling i could get the repeated rows.
Okay. What I suspect is happening is that there are entries in the
column th
Please unsubscribe my email id from ur database as I dont get time to answer the question provided by different students.
Thanking you,
RanjanLee Wu <[EMAIL PROTECTED]> wrote:
Hi Tom,
I saw your post:
http://archives.postgresql.org/pgsql-general/2004-02/msg00194.php
We have same error when
Hi Tom,
I saw your post:
http://archives.postgresql.org/pgsql-general/2004-02/msg00194.php
We have same error when I do pg_restore under PG version
7.3.2.
Can this patch apply to 7.3.2?
Where can I find the patch? What’s the procedure to
apply it?
Thanks Tom!
> The problem here isn't pg_autovacuum, but too small of settings for
> fsm. I've run multi-day tests where autovacuum kept the size of the
> database pretty much the same with 200+ updates a second going on.
Hi Scott,
Could you explain the fsm a little more? I have done _no_ tuning on
my d
On Thu, 2004-06-17 at 00:46, Olivier Hubaut wrote:
> On Wed, 16 Jun 2004 09:37:58 -0500 (CDT), C. Bensend
> <[EMAIL PROTECTED]> wrote:
>
> >
> >> You might want to look into the autovacuum daemon, and / or increasing
> >> fsm settings to be large enough to hold all the spare tuples released by
>
Hello,
I have two servers running postgres 7.3 (Server Jupiter), and 7.4.3 (Sever
Saturn), in my office. I have a master database in Jupiter, that contains
a DB with images, OIDs (lo type).
I'm trying to backup the database from Jupiter and restore it in Saturn.
I do this, from Saturno:
pg_dump
> By the way, be carefull. The pg_autovacuum is not good enough for being
> using as the only way for cleaning the database, especially if you have a
> lot of update and delete on the same tables.
For right now, I'm just vacuuming more often to see how things go. I
didn't think I was even genera
Title: Performance 7.3.4
Hello,
try to understand differences in "Explain analyze
your_query" in 7.2 compared to 7.3
Luc Jouneau
- Original Message -
From:
Alessandro
Meneguelli Coutinho
To: [EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 3:59
PM
Title: Performance 7.3.4
We are trying to upgrade postgres 7.2 to postgres 7.3.4. We are having problems with some reports that have an excellent performance in 7.2 and now, in 7.3.4 the performance is too bad. Did someone have this problem? What should we do?
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> Yep the problem of original posting could be replicated on
> disabling hash aggregates. On disabling i could get the repeated rows.
Okay. What I suspect is happening is that there are entries in the
column that are equal according to the datatype'
Hi all,
After a severe HD crash and the impossibility to read old DAT with our
new DAT drive, I've been able to copy $PGDATA/base/mabase on a new HD.
I've found all the tables data, and even the java intranet based on it
is working fine.
My problem is that when I tried to make a dump of the cop
Hello list.
I am stucked. I want to start the postmaster automatically at the start of
the system.
I have tried everything I can think of including
su - postgres
sudo -u postgres
but everything fails with
no permission
command not found
no access to PG_VERSION
Has anybody succeeded to do thi
Hello,
I think pg_stat_activity table may show me what I need.
However, even though I have 'stats_command_string = true' property in
postgresql.conf (and I restarted postmaster), I do not see the
'current_query' in pg_stat_activity table:
simpydb=> select * from pg_stat_activity ;
datid | datna
On Wed, 16 Jun 2004 09:37:58 -0500 (CDT), C. Bensend
<[EMAIL PROTECTED]> wrote:
You might want to look into the autovacuum daemon, and / or increasing
fsm settings to be large enough to hold all the spare tuples released by
vacuuming.
IIRC, the autovacuum stuff was added in 7.4, which I'm not r
14 matches
Mail list logo
