hi jeff thanks by your answer, when you say "database objects" you
talking about the tables?, because i have 1782 tables in my database.
Umm, my boottleneck not is on CPU because the top don´t show something
about that, the memory is used 30%, and the IO not have problem, because
the Fiber ch
2013/5/21 Jeison Bedoya
> Hi people, i have a database with 400GB running in a server with 128Gb
> RAM, and 32 cores, and storage over SAN with fiberchannel, the problem is
> when i go to do a backup whit pg_dumpall take a lot of 5 hours, next i do a
> restore and take a lot of 17 hours, that is
On Tue, May 21, 2013 at 05:28:31PM +0400, Evgeny Shishkin wrote:
>
> On May 21, 2013, at 5:18 PM, Jeison Bedoya wrote:
>
> > Hi people, i have a database with 400GB running in a server with 128Gb RAM,
> > and 32 cores, and storage over SAN with fiberchannel, the problem is when i
> > go to do
On 05/21/2013 06:18 AM, Jeison Bedoya wrote:
Hi people, i have a database with 400GB running in a server with 128Gb
RAM, and 32 cores, and storage over SAN with fiberchannel, the problem
is when i go to do a backup whit pg_dumpall take a lot of 5 hours,
next i do a restore and take a lot of 17
On May 21, 2013, at 5:18 PM, Jeison Bedoya wrote:
> Hi people, i have a database with 400GB running in a server with 128Gb RAM,
> and 32 cores, and storage over SAN with fiberchannel, the problem is when i
> go to do a backup whit pg_dumpall take a lot of 5 hours, next i do a restore
> and ta
Hi people, i have a database with 400GB running in a server with 128Gb
RAM, and 32 cores, and storage over SAN with fiberchannel, the problem
is when i go to do a backup whit pg_dumpall take a lot of 5 hours, next
i do a restore and take a lot of 17 hours, that is a normal time for
that process
