[GENERAL] finding out actual tuple size

column and find the length of each value and sum it up? I am out of ideas.. if someone knows how please shine some light on my situation.. thanks Linh Luong ---(end of broadcast)--- TIP 9: the planner will ignore

[GENERAL] Diabling constraints

Hi, I am wondering is there any way of disabling constraints that was created after the table itself was created. I know I can drop the trigger that the constraint creates. However, I need to make this change in several postgres database and it seems like the the tgname that is required to remo

[GENERAL] Postgres CPU usage

? Thanks -- Linh Luong Computalog Ltd. Software Developer Phone: (780) 464-6686 (ext 325) Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

[GENERAL] Column name

the join for TRR and SOC they both contain a fields name ABC. How can I rename this field in the sql statement or how can I make it so the sql statement know that they are different. Please help.. .thanks -- Linh Luong Computalog Ltd. Software Developer Phone: (780) 464-6686 (ext 325) Email

[GENERAL] Postgres performance issue

Hi Everyone, I am running Postgres 7.1 and php 4.0. I have a question: Why does postmaster use 80% of the CPU on a simple sql query? I have a form that displays a list of customers based on a criteria they enter. If the user doesn't enter in a criteria it will display all the customer in th

[GENERAL] question

Hi all, I am running postgres7.1 and php4.0. When I do top while running my query via browser I notice that the postmaster process takes up almost 100% of the CPU and this is just for one user. What would happen if multiple users does the same search at the same time would the postmaster die?