Re: [PERFORM] upgraded to pgsql 8.2.4, getting worse performance then 7.4.x

2007-06-05 Thread Hanu Kurubar
Find the attached Postgres.conf file. I am using 8.1 Version in Lab. I haven't done any changes to this conf file to improve the performance. What are the attributes needs to be modified in the conf file to improve the performance? I am looking forward for your assistance. Regards, Hanu

Re: [PERFORM] Append table

2007-06-02 Thread Hanu Kurubar
e FROM tabelB; And then you can use the view as if it was a normal table (altough inserts are not possible without applying rules to them, see the manual for that). SELECT * FROM tabelC WHERE EmpId = 1; Best regards, Arjen On 2-6-2007 17:52 Hanu Kurubar wrote: > Any luck on appending two

Re: [PERFORM] Append table

2007-06-02 Thread Hanu Kurubar
/30/07, Hanu Kurubar <[EMAIL PROTECTED]> wrote: Can you help me appending two table values into single table without performing INSERT? Note that these tables are of same schema. Is there any sql command is supported? Thanks, Hanu On 5/29/07, Alvaro Herrera <[EMAIL PROTECTE

Re: [PERFORM] Append table

2007-05-30 Thread Hanu Kurubar
Can you help me appending two table values into single table without performing INSERT? Note that these tables are of same schema. Is there any sql command is supported? Thanks, Hanu On 5/29/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: Michal Szymanski wrote: > There is another strange thin