Re: [SQL] Update is very slow on a bigger table
Tom, Yes. it looks like there was some locking condition in the database. in the meantime it disappeared and the updates run quickly. thanks for your help. this is the first time i'm working with PostgreSQL and wasn't sure where to look for possible causes of the problem. thanks, dimitar On Thu, 2004-04-15 at 18:51, Tom Lane wrote: > Dimitar Georgievski <[EMAIL PROTECTED]> writes: > > the process under which the update is running reports among the usual > > process data "UPDATE waiting". > > I don't think the UPDATE is doing anything at all --- that ps output > implies that it's waiting for some other backend to release an exclusive > lock on the table, or an update lock on one of the rows to be updated. > > The pg_locks view might help you determine who's the culprit. > > regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[SQL] Querying two databases
Hi, I am new to postgres and I need to do a query which joins two tables from different databases. Can you please advice me on how to achieve this in postgres. Thanks! Pallav ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [SQL] Querying two databases
hi, its not possible to join cross database tables . you may keep tables in different schemas instead of databases. you may also try contrib/dblink to use tables from different database. Regds mallah. Pallav Kalva wrote: Hi, I am new to postgres and I need to do a query which joins two tables from different databases. Can you please advice me on how to achieve this in postgres. Thanks! Pallav ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [SQL] Update is very slow on a bigger table
Hi guys, I would like to create a trigger that execute some programs, is there a way to create a plpgsql function that execute shell command or any other way to run a program? Thanks for your help. Yudie ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[SQL] run application from trigger?
Hi guys, I would like to create a trigger that execute some applications, is there a way to create a plpgsql function that execute shell command or any other way to run an application? Thanks for your help. Yudie ---(end of broadcast)--- TIP 8: explain analyze is your friend
