I have a problem where by an insert on a large table will sometimes
take longer than usual.
Usually the inserts are quick then from time to time they will take a
long time sometimes as much as 10seconds or longer. (But usually under
500ms which is when I start logging them)
The queries are slow
2008/10/3 Peter Eisentraut [EMAIL PROTECTED]:
Peter Childs wrote:
I have a problem where by an insert on a large table will sometimes
take longer than usual.
I think the problem might have something to do with checkpoints,
Then show us your checkpointing-related parameters. Or try to set
Peter,
(please take this with a pinch of salt as I am no expert)
Here is a possible scenario:
Each of your checkpoints takes 90 seconds or more (you told it so with the
checkpoint_completion_target).
If your insert fills 3 checkpoint segments (48 megs ) in less than 90 seconds
then a new
Peter Childs [EMAIL PROTECTED] writes:
2008/10/3 Peter Eisentraut [EMAIL PROTECTED]:
Then show us your checkpointing-related parameters.
I've currently got them set to
checkpoint_segments = 3
checkpoint_timeout = 180s
checkpoint_completion_target = 0.5
after reading that doing more
Hi,
we have a log table on one server with 1.9 million records.
One column event (type text) in that table is a string that (currently)
takes a small number of distinct values (~43) (hmm that could have been
normalised better).
We noted on querying for events of a specific type, that the
Simon Waters wrote:
The best advice is to upgrade at your earliest convenience with
performance questions and 7.4 - you're missing a *lot* of improvements.
You say you're planning to anyway, and I'd recommend putting effort into
the upgrade rather than waste effort on tuning a system you're
Hi,
Maybe you can try this syntax. I'm not sure, but it eventually perform better:
delete from company_alias USING comprm
where company_alias.company_id =comprm.id
Cheers,
Marc
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your