Re: [HACKERS] Foreign key wierdness

2003-01-23 Thread Hannu Krosing
Tom Lane kirjutas K, 22.01.2003 kell 22:30: Didier Moens [EMAIL PROTECTED] writes: I did some extensive testing using PostgreSQL 7.3.1 (logs and results available upon request), and the massive slowdown is NOT related to qualified tablename syntax or (lack of) VACUUM ANALYZE, but to the

Re: [HACKERS] Foreign key wierdness

2003-01-23 Thread Didier Moens
Dear Tom, Dave, Tom Lane wrote: Ah-hah, and I'll bet that the column being linked to this one by the foreign key constraint is still an integer? It sure is ; being a PostgreSQL novice (BTW : many thanks to the whole of the PG development team for such an excellent product), I got on this

Re: [HACKERS] Foreign key wierdness

2003-01-23 Thread Didier Moens
Hi all, Dave Page wrote: If you really think the schema qualification has something to do with it, try issuing the ADD FOREIGN KEY command manually in psql, with and without schema name. Well to be honest I'm having a hard time believing it, but having looked at this in some depth, it's

Re: [HACKERS] Foreign key wierdness

2003-01-23 Thread Didier Moens
Dave Page wrote: From what Tom has said in his reponse, I think the answer for you Didier is to remap your integer columns to int8 instead of int4 and see what happens. When I get a couple of minutes I will look at putting a Serials as... Option in the type map. Thanks Dave, for all of your

Re: [HACKERS] Foreign key wierdness

2003-01-22 Thread Tom Lane
Didier Moens [EMAIL PROTECTED] writes: I did some extensive testing using PostgreSQL 7.3.1 (logs and results available upon request), and the massive slowdown is NOT related to qualified tablename syntax or (lack of) VACUUM ANALYZE, but to the following change : pgAdminII 1.4.2 :

Re: [HACKERS] Foreign key wierdness

2003-01-22 Thread Dave Page
-Original Message- From: Didier Moens [mailto:[EMAIL PROTECTED]] Sent: 22 January 2003 16:05 To: Dave Page Cc: Tom Lane; PostgreSQL Hackers Mailing List Subject: Re: [HACKERS] Foreign key wierdness I did some extensive testing using PostgreSQL 7.3.1 (logs and results

Re: [HACKERS] Foreign key wierdness

2003-01-22 Thread Dave Page
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 22 January 2003 20:30 To: Didier Moens Cc: Dave Page; PostgreSQL Hackers Mailing List Subject: Re: [HACKERS] Foreign key wierdness With two tables each containing some 20.000 entries, the fk creation time

Re: [HACKERS] Foreign key wierdness

2003-01-21 Thread Dave Page
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 21:28 To: Didier Moens Cc: Dave Page; PostgreSQL Hackers Mailing List Subject: Re: [HACKERS] Foreign key wierdness Didier Moens [EMAIL PROTECTED] writes: I just formally tested on PostgreSQL

[HACKERS] Foreign key wierdness

2003-01-20 Thread Dave Page
Hi all, A pgAdmin user has noticed that Foreign Keys take significantly longer to create when migrating a database in pgAdmin in v1.4.12 than in v1.4.2. The only difference in the migration code between these releases, is that pgAdmin now qualifies tables names with the schema name. The

Re: [HACKERS] Foreign key wierdness

2003-01-20 Thread Tom Lane
Dave Page [EMAIL PROTECTED] writes: A pgAdmin user has noticed that Foreign Keys take significantly longer to create when migrating a database in pgAdmin in v1.4.12 than in v1.4.2. The only reason ADD FOREIGN KEY would take a long time is if (a) it has to wait awhile to get exclusive lock on

Re: [HACKERS] Foreign key wierdness

2003-01-20 Thread Dave Page
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 15:28 To: Dave Page Cc: PostgreSQL Hackers Mailing List; Didier Moens Subject: Re: [HACKERS] Foreign key wierdness Dave Page [EMAIL PROTECTED] writes: A pgAdmin user has noticed that Foreign

Re: [HACKERS] Foreign key wierdness

2003-01-20 Thread Tom Lane
Dave Page [EMAIL PROTECTED] writes: Thing is Tom, this issue can be reproduced *every* time, without fail. And have you vacuumed or analyzed yet? Or possibly you are short an index or two (you really need indexes on both the referencing and referenced columns). I've been looking at his for

Re: [HACKERS] Foreign key wierdness

2003-01-20 Thread Hannu Krosing
On Mon, 2003-01-20 at 15:47, Dave Page wrote: -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 15:28 To: Dave Page Cc: PostgreSQL Hackers Mailing List; Didier Moens Subject: Re: [HACKERS] Foreign key wierdness Dave Page [EMAIL

Re: [HACKERS] Foreign key wierdness

2003-01-20 Thread Dave Page
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 16:08 To: Dave Page Cc: PostgreSQL Hackers Mailing List; Didier Moens Subject: Re: [HACKERS] Foreign key wierdness Dave Page [EMAIL PROTECTED] writes: Thing is Tom, this issue can

Re: [HACKERS] Foreign key wierdness

2003-01-20 Thread Dave Page
-Original Message- From: Hannu Krosing [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 18:05 To: Dave Page Cc: Tom Lane; PostgreSQL Hackers Mailing List; Didier Moens Subject: Re: [HACKERS] Foreign key wierdness I've been looking at his for some time now (couple of weeks

Re: [HACKERS] Foreign key wierdness

2003-01-20 Thread Tom Lane
Didier Moens [EMAIL PROTECTED] writes: I just formally tested on PostgreSQL 7.2.2 (logs sent to Dave), and the results are perfectly inline with those from 7.2.3 : a massive slowdown when upgrading from pgadminII 1.4.2 to 1.4.12. I thought the complaint involved PG 7.3? There is no schema