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

Re: Serious performance problem

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Serious performance problem
Date: 2001-10-31 05:41:56
Message-ID: 4.2.0.58.20011031064030.00d91620@pop.freesurf.fr (view raw or flat)
Thread:
Lists: pgsql-hackers
>Why not create an extra "statistics" table which is updated automatically
>through triggers in your original table? That way, you will always get
>up-to-date INSTANT query results no matter how huge your original table is.
>
>And, don't forget that the only way MS SQL can achieve the better performance
>here is through mercilessly hogging ressources. In a complex database
>environment with even larger tables, the performance gain in MS SQL would be
>minimal (my guess).

Definitely. This is a design optimization problem not an index problem.

In response to

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2001-10-31 05:58:46
Subject: Re: timetz regression test is showing several DST-related
Previous:From: Horst HerbDate: 2001-10-31 03:37:29
Subject: Re: Serious performance problem

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