pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
(no subject) 2+ messages / 2 participants [nested] [flat]
* (no subject) @ 2006-04-09 10:47 Doron Baranes <doron.baranes@dbnet.co.il> 0 siblings, 1 reply; 2+ messages in thread From: Doron Baranes @ 2006-04-09 10:47 UTC (permalink / raw) To: pgsql-performance Hi I am new at postgres and I'm having performance issues. I am running on postgres 7.4.6 on a pineapp with 512MB RAM. I did a database vacuum analyze and rebuild my indexes. When I perform queries on tables of 2M-10M of rows it takes several minutes and I see at sar and top that the cpu and memory is heavily used. I would be glad for guidance on server parameters or other configurations which would help. 10x. Doron. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: @ 2006-04-09 11:10 Ragnar <gnari@hive.is> parent: Doron Baranes <doron.baranes@dbnet.co.il> 0 siblings, 0 replies; 2+ messages in thread From: Ragnar @ 2006-04-09 11:10 UTC (permalink / raw) To: Doron Baranes <doron.baranes@dbnet.co.il>; +Cc: pgsql-performance On sun, 2006-04-09 at 12:47 +0200, Doron Baranes wrote: > Hi > > I am running on postgres 7.4.6 on a pineapp with 512MB RAM. > > I did a database vacuum analyze and rebuild my indexes. If you have previously done a lot of deletes or updates without regular vacuums, you may have to do a VACUUM FULL ANALYZE once to get the table into normal state. After this, regular normal VACUUM ANALYZE should be enough. > When I perform queries on tables of 2M-10M of rows it takes several > minutes and We would need to see the output of EXPLAIN ANALYZE for your query, along with some information about the schema of the tables involved, such as what indexes have been created. Also, let us know about any non-default configuration. gnari ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-04-09 11:10 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-04-09 10:47 Doron Baranes <doron.baranes@dbnet.co.il> 2006-04-09 11:10 ` Re: Ragnar <gnari@hive.is>
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