Re: [PERFORM] select count(*) performance

2007-08-11 Thread Kevin Grittner
>>> On Fri, Aug 10, 2007 at 8:08 AM, in message <[EMAIL PROTECTED]>, Brian Hurt <[EMAIL PROTECTED]> wrote: > runic wrote: > >>I have a table with ca. 1.250.000 Records. When I execute >>a "select count (*) from table" (with pgAdmin III) it takes about 40 >>secs. >>I think that takes much to lon

Re: [PERFORM] Performance on writable views

2007-08-11 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Heikki Linnakangas wrote: > Enrico Weigelt wrote: >> I'm often using writable views as interfaces to clients, so >> they only see "virtual" objects and never have to cope with >> the actual storage, ie. to give some client an totally >> denormalized

Re: [PERFORM] Performance on writable views

2007-08-11 Thread Heikki Linnakangas
Enrico Weigelt wrote: > I'm often using writable views as interfaces to clients, so > they only see "virtual" objects and never have to cope with > the actual storage, ie. to give some client an totally > denormalized view of certain things, containing only those > information required for certa