Skip site navigation (1) Skip section navigation (2)

RE: view performance

From: Mario Amado Alves <maa(at)di(dot)fct(dot)unl(dot)pt>
To: Michael Ansley <Michael(dot)Ansley(at)intecsystems(dot)co(dot)uk>
Cc: "=??Q?'Lo=EFc_TREGOU=CBT'?=" <loic(at)ext(dot)cri74(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: RE: view performance
Date: 2000-06-15 15:03:44
Message-ID: Pine.LNX.4.10.10006151601560.18157-100000@lexis.di.fct.unl.pt (view raw or flat)
Thread:
Lists: pgsql-admin
> 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


In response to

pgsql-admin by date

Next:From: dialFree administrationDate: 2000-06-15 15:19:05
Subject: Web based Administration?
Previous:From: Bruce MomjianDate: 2000-06-14 14:42:39
Subject: Re: copy command and indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group