[rt-users] Slow ticket creation with postgres?

[Mat]

the database is about 400,000 tickets (which works out to be a little under
4 million rows across all tables)

Yep vacuum analyzed it, (its a new import, shouldn't be alot for it to do.)

my memory setups are as follows

shared_buffers = 30400
max_fsm_relations = 500
max_fsm_pages = 10000
sort_mem = 32168
fsync = false

for most pages is it comparable to mysql, however for the create new ticket
page, its about 10 times slower. I've checked the indexing, and it _seems_
fine.

Mat

> -----Original Message-----
> From: Vivek Khera [mailto:khera at kcilink.com]
> Sent: Friday, 18 October 2002 11:51 PM
> To: Matthew Watson
> Cc: rt-users at lists.fsck.com
> Subject: Re: [rt-users] Slow ticket creation with postgres?
>
>
> >>>>> "MW" == Matthew Watson <mwatson at netspace.net.au> writes:
>
>
> MW>  Any hints as to how to speed this up?
>
> How big is your DB?  How much SHM did you allow Postgres to use?  Did
> you "vacuum analyze" your tables recently (or frequently)?
>
> It is plenty fast for us.
>
> I just need to get around to purging the dead tickets... laziness
> keeps me from doing it.
>
> ---
>
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.394 / Virus Database: 224 - Release Date: 3/10/2002
>
---

Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.394 / Virus Database: 224 - Release Date: 3/10/2002