Mike Broers wrote:
> Hello performance, I need help explaining the performance of a
> particular query
You provided some of the information needed, but you should review
this page and post a bit more:
http://wiki.postgresql.org/wiki/SlowQueryQuestions
In particular, post the result of EXPL
And the risks are rather asymmetric. I don't know of any problem from
too large a buffer until it starts crowding out shared_buffers, while
under-sizing leads to the rather drastic performance consequences of
AdvanceXLInsertBuffer having to wait on the WALWriteLock while holding
the WALInsertLo
Hello performance, I need help explaining the performance of a particular
query:
select * from messages where ((messages.topic = E'/x') AND
(messages.processed = 'f')) ORDER BY messages.created_at ASC limit 10;
Table Structure:
Column |Type |
Modifiers
+
On Wed, Jan 5, 2011 at 12:43 PM, Josh Berkus wrote:
> All,
>
> One of my coworkers just pointed this out:
>
> "The amount of memory used in shared memory for WAL data. The default is
> 64 kilobytes (64kB). The setting need only be large enough to hold the
> amount of WAL data generated by one typi
All,
One of my coworkers just pointed this out:
"The amount of memory used in shared memory for WAL data. The default is
64 kilobytes (64kB). The setting need only be large enough to hold the
amount of WAL data generated by one typical transaction, since the data
is written out to disk at every t
