thanks for the advice..
Regards
On Sun, Oct 13, 2013 at 6:10 PM, Sergey Konoplev wrote:
> On Sun, Oct 13, 2013 at 2:40 PM, akp geek wrote:
> > thank you all. We will upgrade to 64bit postgres 9.2.5 and take all your
> > suggestions for that. Mean while will run the pg_reorg or pg_repack to
On Sun, Oct 13, 2013 at 2:40 PM, akp geek wrote:
> thank you all. We will upgrade to 64bit postgres 9.2.5 and take all your
> suggestions for that. Mean while will run the pg_reorg or pg_repack to take
> the bloat of the DB. Also pg_repack not installing on the solaris . I will
> try pg_reorg.
W
thank you all. We will upgrade to 64bit postgres 9.2.5 and take all your
suggestions for that. Mean while will run the pg_reorg or pg_repack to
take the bloat of the DB. Also pg_repack not installing on the solaris . I
will try pg_reorg.
Regards
On Sun, Oct 13, 2013 at 4:58 PM, John R Pierce w
On 10/13/2013 1:45 PM, Sergey Konoplev wrote:
On Sun, Oct 13, 2013 at 8:35 AM, akp geek wrote:
>thanks for the advice. One question I have is if I increase the
>shared_buffers to 16GB, then it won't restart because for the 32 bit version
>of postgres , we can't have shared buffers more than 3.2
On Sun, Oct 13, 2013 at 8:35 AM, akp geek wrote:
> thanks for the advice. One question I have is if I increase the
> shared_buffers to 16GB, then it won't restart because for the 32 bit version
> of postgres , we can't have shared buffers more than 3.2 GB right ? ( this
> from various blogs that I
On 10/13/2013 8:35 AM, akp geek wrote:
thanks for the advice. One question I have is if I increase the
shared_buffers to 16GB, then it won't restart because for the 32 bit
version of postgres , we can't have shared buffers more than 3.2 GB
right ? ( this from various blogs that I have read )
thanks for the advice. One question I have is if I increase the
shared_buffers to 16GB, then it won't restart because for the 32 bit
version of postgres , we can't have shared buffers more than 3.2 GB right ?
( this from various blogs that I have read )
Thanks again for helping me out
On Fri, Oc
Hello
Why? There are no multilevels structures in pg. Variables should be joined
with schemas or extensions. Other levels are messy.
-
"M Better"
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgres-9-0-4-configuration-and-performance-issue-tp5774309p577436
On Fri, Oct 11, 2013 at 10:08 AM, akp geek wrote:
> We have 4 applications ( 2 transactional , 2 ( transactional + reporting ))
> on postgres 32 bit 9.0.4
>
> Some of the queries are extreemly taking time ( 10 seconds). I can the
> explain for that also.
>
> I just want to get your thoughts on the
We have 4 applications ( 2 transactional , 2 ( transactional + reporting ))
on postgres 32 bit 9.0.4
Some of the queries are extreemly taking time ( 10 seconds). I can the
explain for that also.
I just want to get your thoughts on the conf file values we have are good.
Really appreciate your help
10 matches
Mail list logo
