RE: view performance

> 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: Loc TREGOUT [mailto:loic(at)ext(dot)cri74(dot)org]
> >> Sent: 14 June 2000 13:26
> >> To: pgsql-admin(at)postgresql(dot)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(at)ext(dot)cri74(dot)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(at)di(dot)fct(dot)unl(dot)pt FCT 212948300