Re: [ADMIN] Trying to use initlocation

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

[ADMIN] Postgresql settings help for 8.0.1

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

[ADMIN] Windows NT 4.0 installation.

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

Re: [ADMIN] Windows NT 4.0 installation.

> 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

Re: [ADMIN] Postgresql settings help for 8.0.1

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

[ADMIN] delete to slow

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

Re: [ADMIN] delete to slow

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); > >

Re: [ADMIN] delete to slow

=?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

Re: [ADMIN] delete to slow

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

Re: [ADMIN] delete to slow

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

[ADMIN] Opened Cursors

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

Re: [ADMIN] delete to slow

=?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.

Re: [ADMIN] delete to slow

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

Re: [ADMIN] delete to slow

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

Re: [ADMIN] delete to slow

"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

Re: [ADMIN] delete to slow

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

Re: [ADMIN] 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

Re: [ADMIN] delete to slow

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

Re: [ADMIN] delete to slow

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

Re: [ADMIN] delete to slow

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

Re: [ADMIN] delete to slow

"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,

[ADMIN] PGDG RPMS and integer-datetimes support

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

[ADMIN] Hang in semop() in 'waiting' backends

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

Re: [ADMIN] Hang in semop() in 'waiting' backends

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 -

Re: [ADMIN] delete to slow

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