pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPerformance Problems
4+ messages / 3 participants
[nested] [flat]
* Performance Problems
@ 2002-12-12 12:56 Héctor Iturre <hhiturre@yahoo.com.ar>
0 siblings, 1 reply; 4+ messages in thread
From: Héctor Iturre @ 2002-12-12 12:56 UTC (permalink / raw)
To: pgsql-sql
Hi,
I have performance problems with a huge database
(there a 2 tables with 40 millions of records) and
many users doing updates and queries on it. I 've
perform severals VACUMM on the database with poor
results.
Each table have an unique index and I added other
indexes to improve the performance. But when there are
inserts (not too many) the performance fall.
What can I do to improve the performace? I hear any
opinion.
Hector Iturre
Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/sms.html
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Performance Problems
@ 2002-12-12 14:09 Philip Warner <pjw@rhyme.com.au>
parent: Héctor Iturre <hhiturre@yahoo.com.ar>
0 siblings, 0 replies; 4+ messages in thread
From: Philip Warner @ 2002-12-12 14:09 UTC (permalink / raw)
To: Héctor Iturre <hhiturre@yahoo.com.ar>; pgsql-sql
At 09:56 AM 12/12/2002 -0300, Héctor Iturre wrote:
> I 've
>perform severals VACUMM on the database with poor
>results.
Have you done an ANALYZE?
Which version of PG are you using?
Can you send output from VACUUM VERBOSE ?
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Performance Problems
@ 2002-12-12 14:29 Christoph Haller <ch@rodos.fzk.de>
0 siblings, 0 replies; 4+ messages in thread
From: Christoph Haller @ 2002-12-12 14:29 UTC (permalink / raw)
To: hhiturre@yahoo.com.ar; +Cc: pgsql-sql
>
> I have performance problems with a huge database
> (there a 2 tables with 40 millions of records) and
> many users doing updates and queries on it. I 've
> perform severals VACUMM on the database with poor
> results.
> Each table have an unique index and I added other
> indexes to improve the performance. But when there are
> inserts (not too many) the performance fall.
> What can I do to improve the performace? I hear any
> opinion.
>
Bear in mind, every index has to be updated when records
are inserted. An unique one makes it even worse, because
a search for duplicates must be performed.
You may give the idea some thought, if this index really
has to be unique. I sometimes use a 'timestamp-insert'
column to allow duplicates and retrieve unique entries by
a SELECT DISTINCT ON construct.
Regards, Christoph
^ permalink raw reply [nested|flat] 4+ messages in thread
* Performance Problems
@ 2002-12-12 15:08 Héctor Iturre <hhiturre@yahoo.com.ar>
0 siblings, 0 replies; 4+ messages in thread
From: Héctor Iturre @ 2002-12-12 15:08 UTC (permalink / raw)
To: pgsql-sql
Hi,
Thanks, i fix the problem, it was the linux configuration.
Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/sms.html
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2002-12-12 15:08 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-12-12 12:56 Performance Problems Héctor Iturre <hhiturre@yahoo.com.ar>
2002-12-12 14:09 ` Philip Warner <pjw@rhyme.com.au>
2002-12-12 14:29 Re: Performance Problems Christoph Haller <ch@rodos.fzk.de>
2002-12-12 15:08 Performance Problems Héctor Iturre <hhiturre@yahoo.com.ar>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox