Postgres Pro
Downloads
Home   >   mailing lists

Thread: view performance

view performance

From
Loïc TREGOUËT
Date:
Hello ,

    I use a database to store log files . I have 2 Million rows by year
.
I want the maximum of performance when i access them from my web site so
i've started to make one table by year :
log2000 : contain all the log information of the year 2000
log 1999 : ..

I think now it's a bad idea because when i want to select on two table i
have :
column x is ambiguous !

But if i use only one table , it will be a huge table i will lose
performance . Isn't it ?

If i use view , i will not increase the performance because it's just a
view and not a table properly . Isn't it ?

            Please help me   , thanks


loic@ext.cri74.org

RE: view performance

From
Michael Ansley
Date:

If your tables are indexed on date, among other things, the performance should be as good as it is now.

MikeA

>>   -----Original Message-----
>>   From: Loïc TREGOUËT [mailto:loic@ext.cri74.org]
>>   Sent: 14 June 2000 13:26
>>   To: pgsql-admin@postgresql.org
>>   Subject: [ADMIN] view performance
>>  
>>  
>>   Hello ,
>>  
>>       I use a database to store log files . I have 2 Million
>>   rows by year
>>   .
>>   I want the maximum of performance when i access them from
>>   my web site so
>>   i've started to make one table by year :
>>   log2000 : contain all the log information of the year 2000
>>   log 1999 : ..
>>  
>>   I think now it's a bad idea because when i want to select
>>   on two table i
>>   have :
>>   column x is ambiguous !
>>  
>>   But if i use only one table , it will be a huge table i will lose
>>   performance . Isn't it ?
>>  
>>   If i use view , i will not increase the performance
>>   because it's just a
>>   view and not a table properly . Isn't it ?
>>  
>>               Please help me   , thanks
>>  
>>  
>>   loic@ext.cri74.org
>>  

RE: view performance

From
Mario Amado Alves
Date:
> If your tables are indexed on date, among other things, the performance
> should be as good as it is now.

Nop. My experience with Postgres views has shown that the views must
themselves be indexed.

>
> >>   -----Original Message-----
> >>   From: Lo�c TREGOU�T [mailto:loic@ext.cri74.org]
> >>   Sent: 14 June 2000 13:26
> >>   To: pgsql-admin@postgresql.org
> >>   Subject: [ADMIN] view performance
> >>
> >>
> >>   Hello ,
> >>
> >>       I use a database to store log files . I have 2 Million
> >>   rows by year
> >>   .
> >>   I want the maximum of performance when i access them from
> >>   my web site so
> >>   i've started to make one table by year :
> >>   log2000 : contain all the log information of the year 2000
> >>   log 1999 : ..
> >>
> >>   I think now it's a bad idea because when i want to select
> >>   on two table i
> >>   have :
> >>   column x is ambiguous !
> >>
> >>   But if i use only one table , it will be a huge table i will lose
> >>   performance . Isn't it ?
> >>
> >>   If i use view , i will not increase the performance
> >>   because it's just a
> >>   view and not a table properly . Isn't it ?
> >>
> >>               Please help me   , thanks
> >>
> >>
> >>   loic@ext.cri74.org
> >>
>

| |,| | | |RuaFranciscoTaborda24RcD 2815-249CharnecaCaparica 351+939354002
|M|A|R|I|O|
|A|M|A|D|O|DepartmentoDeInformaticaFCT/UNL 2825-114 Caparica 351+212958536
|A|L|V|E|S|                                                  fax 212948541
| | | | | |                 maa@di.fct.unl.pt                FCT 212948300