[GENERAL] Sequences question problem

to get 'sequence name' by its 'table name' ? Name of sequence and table are not related (we can't assume some prefix in name, because table was renamed) Will this pg_class reference cost many CPU ? Thank you, Best regards, Lada 'Ray' Lostak Unreal64 Develop group http://www.orcave.com http

Re: [GENERAL] Sequences question problem

Thank you.. I didn't know about race condition.. Shame on me :) If you're using PostgreSQL 8.0 or later then you can get the sequence name with the pg_get_serial_sequence() function: Is there any way how to do that (or add this function) in 7.3.x ? Best regards, Lada 'Ray' Lostak Unreal64

Re: [GENERAL] Sql performace - why soo long ?

:) Please, do you know if exists some 'up-to-date' doc about curret state of planner ? I didn't found something like that. Best regards, Lada 'Ray' Lostak Unreal64 Develop group http://www.orcave.com http://www.unreal64.net

Re: [GENERAL] Online system transactions

datas together) and within various database connections. Thx Best regards, Lada 'Ray' Lostak Unreal64 Develop group http://www.orcave.com http://www.unreal64.net -- In the 1960s you needed the power of two C64s to get a rocket

Re: [GENERAL] Online update races

developers, I would like to ask other about opinions... Have a nice day, Best regards, Lada 'Ray' Lostak Unreal64 Develop group http://www.orcave.com http://www.unreal64.net -- In the 1960s you needed the power of two C64s

[GENERAL] Online system transactions

' somehow on server, and next time, instead of begin new transaction return to stored one. Transactions solves all these problems, but they don't work across various/multiple connections Any ideas/references please ? Thank you, Best regards, Lada 'Ray' Lostak Unreal64 Develop group http

[GENERAL] Online update races

, Best regards, Lada 'Ray' Lostak Unreal64 Develop group http://www.orcave.com http://www.unreal64.net -- In the 1960s you needed the power of two C64s to get a rocket to the moon. Now you need a machine which is a vast number

[GENERAL] Large objects [BLOB] again - general howto

storing. I hope this email belong to general discussion. If no, I am sorry and let me know - I will repost. Best regards, Lada 'Ray' Lostak Unreal64 Develop group http://www.orcave.com http://www.unreal64.net -- In the 1960s you

[GENERAL] Performace question

added 'log' - part of pgsql log coresponding to above SQL. Feel free to have any Q about sysconfig/programs config. And sorry again if I miss something. Thank you ! Best regards, Lada 'Ray' Lostak Unreal64 Develop group http://www.orcave.com http://www.unreal64.net

Re: [GENERAL] Performace question

this topic ?) speed up PgSql ? I really think, half second for selecting ~100 rows from ~600 rows table it pretty slow. Commodore 64 (1 mHz 6510) will do it faster :) Any hints ? Thanks, Best regards, Lada 'Ray' Lostak Unreal64 Develop group http://www.orcave.com http://www.unreal64.net