Re: [GENERAL] 5 minutes to pg_dump nothing

2007-09-24 Thread Nikita The Spider The Spider
On 9/23/07, Tom Lane <[EMAIL PROTECTED]> wrote: > I wrote: > > "Nikita The Spider The Spider" <[EMAIL PROTECTED]> writes: > >> Thanks for your help! Given that this problem seems to be triggered by > >> a sort of edge case and the fix is non-trivial, I guess I should not > >> expect a new version o

Re: [GENERAL] 5 minutes to pg_dump nothing

2007-09-23 Thread Tom Lane
I wrote: > "Nikita The Spider The Spider" <[EMAIL PROTECTED]> writes: >> Thanks for your help! Given that this problem seems to be triggered by >> a sort of edge case and the fix is non-trivial, I guess I should not >> expect a new version of pg_dump soon? > We might look into fixing it for 8.3, b

Re: [GENERAL] 5 minutes to pg_dump nothing

2007-09-23 Thread Tom Lane
"Nikita The Spider The Spider" <[EMAIL PROTECTED]> writes: > I think I found the problem. getTypes() calls findFuncByOid() twice > for each item it sees. A comment at the top of findFuncByOid() says, > "should hash this, but just do linear search for now". So that funtion > is O(n)/2 where n = the

Re: [GENERAL] 5 minutes to pg_dump nothing

2007-09-23 Thread Nikita The Spider The Spider
On 9/21/07, Nikita The Spider The Spider <[EMAIL PROTECTED]> wrote: > On 9/21/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > "Nikita The Spider The Spider" <[EMAIL PROTECTED]> writes: > > > I'm seeing a problem where pg_dump takes at least 5 minutes to execute > > > no matter what I ask it to dump --

Re: [GENERAL] 5 minutes to pg_dump nothing

2007-09-21 Thread Nikita The Spider The Spider
On 9/21/07, Tom Lane <[EMAIL PROTECTED]> wrote: > "Nikita The Spider The Spider" <[EMAIL PROTECTED]> writes: > > I'm seeing a problem where pg_dump takes at least 5 minutes to execute > > no matter what I ask it to dump -- even a non-existent or empty table. > > One possible red flag is that pg_typ

Re: [GENERAL] 5 minutes to pg_dump nothing

2007-09-21 Thread Tom Lane
"Nikita The Spider The Spider" <[EMAIL PROTECTED]> writes: > I'm seeing a problem where pg_dump takes at least 5 minutes to execute > no matter what I ask it to dump -- even a non-existent or empty table. > One possible red flag is that pg_type contains 56508 rows. This > doesn't seem excessive to

[GENERAL] 5 minutes to pg_dump nothing

2007-09-21 Thread Nikita The Spider The Spider
Hi all, I'm seeing a problem where pg_dump takes at least 5 minutes to execute no matter what I ask it to dump -- even a non-existent or empty table. One possible red flag is that pg_type contains 56508 rows. This doesn't seem excessive to me, but perhaps it should. I've looked through the source c