Hello,
I forgot to add - all those 'out of memory' errors happen when backup db
is trying to create index. Every 'CREATE INDEX' operation is followed by
'out of memory' error.
Thanks!
Marcin
Marcin Citowicki wrote:
Hello,
We have a bit of a problem with the
Hello,
We have a bit of a problem with the daily db backup. At the moment the
backup db size is half of the main db, and we have the following errors
in the log file:
ERROR: out of memory
DETAIL: Failed on request of size 536870912
(There's a bunch of those.)
There were some 'permission den
rhaps there is a process that is
running periodically which is slowing the db down.
I'll need to take a look at this.
Thank you for your help!
Marcin
hubert depesz lubaczewski wrote:
On Tue, Jun 03, 2008 at 09:57:15AM +0200, Marcin Citowicki wrote:
I'm not a dba so I'm not sure
Hello,
I have a table (transactions) containing 61 414 503 rows. The basic
count query (select count(transid) from transactions) takes 138226
milliseconds.
This is the query analysis output:
Aggregate (cost=2523970.79..2523970.80 rows=1 width=8) (actual
time=268964.088..268964.090 rows=1 lo
