I have to say I've been really impressed with the quality and diversity
of tools here to increase performance for PostgreSQL. But I keep seeing
a lot of the same basic things repeated again and again. Has anyone
looked into a smart or auto-adjusting resource manager for postgres?
Consider
Hello All,
I've inherited a postgresql database that I would like to refactor. It
was origionally designed for Postgres 7.0 on a PIII 500Mhz and some
design decisions were made that don't make sense any more. Here's the
problem:
1) The database is very large, the largest table has 40
On Fri, 2004-02-06 at 02:43, Hannu Krosing wrote:
Orion Henry kirjutas N, 05.02.2004 kell 07:16:
I've done some testing of 7.3.4 vs 7.4.1 and found 7.4.1 to be 20%-30%
slower than 7.3.4. Is this common knowledge or am I just unlucky with
my query/data selection?
Things of note
On Wed, 2004-02-04 at 21:27, Josh Berkus wrote:
Orion,
I've done some testing of 7.3.4 vs 7.4.1 and found 7.4.1 to be 20%-30%
slower than 7.3.4. Is this common knowledge or am I just unlucky with
my query/data selection?
No, it's not common knowledge. It should be the other way around.
Quick Question,
The full query listed in pg_stat_activity is getting truncated. Does
anyone know how I can see the full query in progress?
--
Orion Henry [EMAIL PROTECTED]
signature.asc
Description: This is a digitally signed message part
for me to raise my ANALYZE value and how would
I go about doing this?
Thanks for the help.
--
Orion Henry [EMAIL PROTECTED]
signature.asc
Description: This is a digitally signed message part