On Wed, Apr 06, 2005 at 06:28:26PM -0400, Tom Lane wrote:
> It's too big a change to consider back-patching into 8.0, unfortunately.
I'll happily settle for 8.1 over nothing... :)
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distri
Robert Fielding <[EMAIL PROTECTED]> writes:
> strace shows:
> semop(19529737, 0xbfffe020, 1
Can you attach to a few of the stuck processes with gdb and get stack
traces? Are they all doing exactly the same query when they hang?
regards, tom lane
-
Hi,
I'm afraid information is a little sketchy with this one, but I'll
present to you quickly what's going on as best as I can. Your
assistance is appreciated:
platform: Linux 2.4.20 #19 SMP RedHat 9 base, PG 7.4.5 (also 7.4.2)
problem: postgres backends waiting forever
strace shows:
semop(19529
Can integer datetimes support be added to the PGDG
distributed RPMS for Fedora at the next version
requiring an initdb. I've attached a diff to the
specfile for 8.0.1.
Thanks, Murthy
--- /usr/src/redhat/SPECS/postgresql-8.0.1-2PGDG.spec
2005-02-22 18:04:50.0 -0500
+++
/usr/src/redhat/SPE
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Hmm... it would be pretty handy if there was a way to make triggers show
> up in explain somehow, maybe as a pseudo query node.
Been there, done that ...
2005-03-25 16:57 tgl
* doc/src/sgml/perform.sgml, src/backend/catalog/pg_constraint.c,
Are you going to do an explain analyze at some point?
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you g
On Wed, Apr 06, 2005 at 02:15:39PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Well, neither of those should take very long at all. What's EXPLAIN
> > ANALYZE show?
>
> Indeed ... now I'm wondering about foreign key checks. Are there any
> tables with foreign keys link
Yes. I saw. Thanks. But the both explanations takes a lot of time.
- Original Message -
From: "Bruno Wolff III" <[EMAIL PROTECTED]>
To: "Ricardo Valença de Assis" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>;
Sent: Wednesday, April 06, 2005 3:51 PM
Subject: Re: delete to slow
On Wed, Apr 06, 2005 at 15:23:57 -0300,
Ricardo Valença de Assis <[EMAIL PROTECTED]> wrote:
> My question was: Can I use INNER JOIN with DELETE? If yes how?
I gave you an example of how.
---(end of broadcast)---
TIP 9: the planner will ignore your
My question was: Can I use INNER JOIN with DELETE? If yes how?
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Ricardo Valença de Assis" <[EMAIL PROTECTED]>
Cc: "Bruno Wolff III" <[EMAIL PROTECTED]>;
Sent: Wednesday, April 06, 2005 2:57 PM
Subject: Re: [ADMIN] delete to sl
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Well, neither of those should take very long at all. What's EXPLAIN
> ANALYZE show?
Indeed ... now I'm wondering about foreign key checks. Are there any
tables with foreign keys linking to usuario? If so, the problem is
likely unindexed foreign key co
On Wed, Apr 06, 2005 at 02:59:18PM -0300, Ricardo Valen?a de Assis wrote:
> DATABASE=# explain delete from usuario where
> usua_cd_usuario=backup.usua_cd_usuario;
> QUERY PLAN
>
> Hash Join (cost=5.7
DATABASE=# explain delete from usuario where
usua_cd_usuario=backup.usua_cd_usuario;
QUERY PLAN
Hash Join (cost=5.71..644.15 rows=298 width=6)
Hash Cond: ("outer".usua_cd_usuario = "inner".usua_cd
=?iso-8859-1?Q?Ricardo_Valen=E7a_de_Assis?= <[EMAIL PROTECTED]> writes:
> I´ve tried... It takes the same time. I used explain and I saw it... Exactly
> the same time.
Uh ... what I was asking for was for you to *show* us the EXPLAIN
output. You didn't answer the question about PG version either.
Hi Folks,
Is there a way to list all opened cursors?
Thanks.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Wed, Apr 06, 2005 at 02:32:55PM -0300, Ricardo Valen?a de Assis wrote:
> I?ve tried... It takes the same time. I used explain and I saw it... Exactly
> the same time.
And what does explain show? Are statistics up to date?
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Gi
I´ve tried... It takes the same time. I used explain and I saw it... Exactly
the same time.
- Original Message -
From: "Bruno Wolff III" <[EMAIL PROTECTED]>
To: "Ricardo Valença de Assis" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, April 06, 2005 2:31 PM
Subject: Re: delete to slow
> On We
=?iso-8859-1?Q?Ricardo_Valen=E7a_de_Assis?= <[EMAIL PROTECTED]> writes:
> DELETE FROM table1 WHERE column1 IN (SELECT column2 FROM table2);
What PG version is this, and what does EXPLAIN say about that query?
> Is there a way to use DELETE with INNER JOIN in PostGreSQL?
You could do "DEL
On Wed, Apr 06, 2005 at 13:45:13 -0300,
Ricardo Valença de Assis <[EMAIL PROTECTED]> wrote:
> Hello Everybody!
>
> I´m trying to use delete to remove data from one table based on another.
> The query is this:
>
> DELETE FROM table1 WHERE column1 IN (SELECT column2 FROM table2);
>
>
Hello Everybody!
I´m trying to use delete to
remove data from one table based on another. The query is this:
DELETE FROM table1 WHERE column1
IN (SELECT column2 FROM table2);
but my table is big, so it takes
a lot o time...
Is there a way to use DELETE
with INNER JOIN i
Only thing I heard was turn off hyper threading.
Joel Fradkin
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305
[EMAIL PROTECTED]
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All r
> Hello.
>
> I am not in front of my NT 4.0 machine right now so I won't
> be able to give any specifics messages or anything at this
> point. In any case, it seems PostgreSQL can't be installed
> (via the Windows install package) on Windows NT 4.0 machines,
> giving an error about missing fun
Hello.
I am not in front of my NT 4.0 machine right now so I won't be able to
give any specifics messages or anything at this point. In any case, it
seems PostgreSQL can't be installed (via the Windows install package) on
Windows NT 4.0 machines, giving an error about missing functions or
somet
Hi,
I posted this message earlier but i didnt get any responses, i am
posting here again. We are migrating to a new server with more memory
and also from postgres 7.4 to postgres 8.0.1 version.
Here are my settings on the current 7.4 version:
OS : RedHat 9
CPUS: 2 hyperthreaded
Memory: 4gig
sh
Ok I now I understand what you say, I have set /usr/lib/postgresql/bin to my
path but it does not help? some other suggestion.
I assume that I have done error in seting the data PGDATA2=/database_image or
some thing ?
or have I done some other thing error when i try to say
initlocation PGDATA2
25 matches
Mail list logo