I'm running 9.0.3, and recently started getting temp files being created. This
is a problem because it's making a bunch of dirty buffers that have to be
flushed to disk and my poor little disk isn't up to the task. I'm not sure why
though, because this is the explain verbose for the queries that are creating
them:
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=0.00..15180.05 rows=4000 width=109) (actual time=159.462..174.694
rows=4000 loops=1)
-> Index Scan using pending_replication_items on replication_queue
(cost=0.00..37247114.20 rows=9814757 width=109) (actual time=159.459..169.061
rows=4000 loops=1)
Total runtime: 177.437 ms
(3 rows)
My understanding with temp files is that they are generated when sorts need to
happen. But given that the index is doing all the sorting for me, I'm at a
loss. Why else might I get temp files?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
