Re: [SQL] how to control the execution plan ?

On Mon, Jul 7, 2008 at 3:14 AM, Sabin Coanda <[EMAIL PROTECTED]> wrote: > Hi there, > > I try to execute the following statement: > > SELECT * > FROM ( >SELECT "MY_FUNCTION_A"(bp."COL_A", NULL::boolean) AS ALIAS_A >FROM "TABLE_A" bp >JOIN "TABLE_B" pn ON bp."COL_B" = pn."PK_ID" >

[SQL] how to control the execution plan ?

Hi there, I try to execute the following statement: SELECT * FROM ( SELECT "MY_FUNCTION_A"(bp."COL_A", NULL::boolean) AS ALIAS_A FROM "TABLE_A" bp JOIN "TABLE_B" pn ON bp."COL_B" = pn."PK_ID" JOIN "TABLE_C" vbo ON bp."COL_C" = vbo."PK_ID" WHERE pn."Editor"::text ~~ 'So

Re: [SQL] How to find space occupied by postgres on harddisk

dipesh wrote: Hello, Myself Dipesh Mistry from Ahmedabad India. I want to know that if i dump the 5GB sql file then how many space does postgres occupy on harddisk. Do you mean a 5GB database? If that's what you meant, then the size of the resulting dump depends on the dump format, the FILLF

[SQL] How to find space occupied by postgres on harddisk

Hello, Myself Dipesh Mistry from Ahmedabad India. I want to know that if i dump the 5GB sql file then how many space does postgres occupy on harddisk. Is there any calculation is available? Or any postgres command can give us this type of information? Thank you. -- With Warm Regards, Dipesh Mi