22 MB
>.
>
> In the data directory the base directory`s size is 240G. I have 16G
> of ram in my machine.
>
> Waiting for help, thanks.
You didn't say but if I can assume you're doing this work in a
transaction...
You understand that space is *not* free
from/to?
The system was last started back in November. Running 9.3.15.
Not aware of any host system libs or whatever change recently but will
investigate.
>
> --
> Peter Geoghegan
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consult...@comcast.net
p: 312.241.780
t don't go crazy, it's per sort, so can
>>> multiply fast on a busy server)
>>
>>
>> We are already up at 400MB, and this query was using memory in the low KB
>> levels because it is very small (1 - 20 rows of data per temp table, and no
>> expensive sele
(kbytes, -s) 10240
>> cpu time (seconds, -t) unlimited
>> max user processes (-u) 16384
>> virtual memory (kbytes, -v) unlimited
>> file locks (-x) unlimited
>>
>>
>> Thanks
>> Prabhjot
&g
://sqlfiddle.com/#!15/d4846/2
>
> Nice, thanks!
>
>>
>> Btw: your row_number() usage wouldn't return the "latest" row either.
>> It would return the "oldest" row.
>
> Oh, right. I forgot the DESC in the window.
>
>
> --
>
gt;
> --
> Andreas Joseph Krogh
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andr...@visena.com
> www.visena.com
> [cid]
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consult...@comcast.net
p: 312.241.7800
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
2 and apply it to
> 9.0, or can I?
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Incredibly-slow-restore-times-after-9-0-9-2-upgrade-tp5824701p5825052.html
> Sent from the PostgreSQL - performance mailing list archive at Nabbl
s
> written in SQL, like this, for instance:
See the timeofday() func which returns the actual time and is not
frozen in the current transaction. You'll need to cast it to
timestamp or other if wishing to do time arithmetic deltas on it.
HTH
--
--
le? Assume needs to be aggressive
due to how fast this problem crops up.
Any help appreciated
Thank you
--
-------
Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant
305 321-1144 (mob
