Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: PostgreSQL performance issues
- From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
- To: Willo van der Merwe <willo(at)studentvillage(dot)co(dot)za>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: PostgreSQL performance issues
- Date: Tue, 29 Aug 2006 07:51:50 -0700
4 1/2 seconds for a count(*) ? This seems a bit rough - is there anything else I can try to optimize my Database? You can imagine that slightly more complex queries goes out the roof.
Well a couple of things. 1. You put all your money in the wrong place.. 1 hard drive!!??!! 2. What is your maintenance regimen? Vacuum, Analyze???? Joshua D. Drake
Any help appreciated Regards Willo van der Merwe
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
- References:
- PostgreSQL performance issues
- From: Willo van der Merwe
- PostgreSQL performance issues
- Prev by Date: Re: PostgreSQL performance issues
- Next by Date: Re: slow i/o
- Previous by thread: Re: PostgreSQL performance issues
- Next by thread: Re: PostgreSQL performance issues
- Indexes: